austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z

  • 20131024-084
  • aaqol
  • aarc
  • asia
  • asian
  • + 15

Query the Data Delivery Network

Query the DDN

The easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire procotol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.

For example, you can query the final_report_of_the_asian_american_quality_of_life table in this repository, by referencing it like:

"austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z:latest"."final_report_of_the_asian_american_quality_of_life"

or in a full query, like:

SELECT 
    ":id", -- Socrata column ID
    "council_dist", -- Section 7: Question 7. Do you know which council district you are in?
    "eng_class", -- Section 7: Question 7. Do you know that there are free English learning classes?
    "free_pc_wifi", -- Section 7: Question 7: Do you know that public libraries offer free access to computers and WiFi?
    "h_insurance", -- Section 3:  Question 12. Are you currently covered by any healthcare insurance?
    "ems_class", -- Section 7:  Question 7.  Do you know that Emergency Medical Services (EMS) offers a variety of free Injury prevention classes (e.g., child passenger and infant safety education, CPR training, etc.)?
    "heard_aarc", -- Section 7: Question 4. Have you heard about the Asian American Resource Center (AARC) on Cameron Road? 
    "id", -- Identification of a single survey 
    "airport", -- Section 7: Question 3. Austin-Bergstrom International Airport
    "smoking", -- Section 3: Question 5. Are you currently using tobacco products? 
    "website_cb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "fs1", -- Section 6: Question 3. My family members respect one another.
    "ppl_ncb_eth", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "heart_dis", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "n6", -- Section 6: Question 2. How many friends do you feel close to such that you could call on them for help?
    "access_comp_int", -- Section 7: Question 17. Do you have access to a computer and the Internet? 
    "place_safety", -- Section 7: Question 2. Safety in the City of Austin
    "place_sml_bus", -- Section 7: Question 2. The City of Austin as a place to build small business 
    "place_retire", -- Section 7: Question 2. The City of Austin as a place to retire
    "place_work", -- Section 7: Question 2. The City of Austin as a place to work
    "self_full", -- Question 9. What is your current employment status? (Check all that apply)
    "ethnicity", -- Section 1: Question 3. What is your ethnic origin? (Check all that apply)
    "cancer", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "unemployed", -- Question 9. What is your current employment status? (Check all that apply)
    "car_share", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "drinking", -- Section 3: Question 6. Has anyone ever told you that you have a drinking problem?
    "coh4", -- Section 6: Question 6. People in my ethnic community generally get along with each other.
    "coh2", -- Section 6: Question 6. People in my ethnic community are willing to help each other
    "rel_att4", -- Section 6: Question 4. How often do you attend religious services?
    "ride", -- Section 3: Question 16. For your medical visit, do you need someone who can provide a ride for you? 
    "grandchild", -- Section 1: Question 7. Who lives with you? (Check all that apply) 
    "den_check", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months. 
    "fs8", -- Section 6: Question 3. My family members like to spend free time with each other.
    "age", -- Section 1: Question 1. What is your age?
    "eng_inter", -- Section 2: Question 5. How much does your English speaking ability interfere with daily life?
    "fs5", -- Section 6: Question 3. My family members feel loyal to the family. 
    "fs4", -- Section 6: Question 3. We really do trust and confide in each other.
    "n3", -- Section 6:  Question 1. How many family/relatives do you feel close to such that you could call on them for help?
    "ad_nursing", -- Section 5:  Question 8. It is not right to place a family member with Alzheimer’s disease in a nursing home. 
    "heard_advdir", -- Section 5: Question 9. Have you heard about advance directives? 
    "aus_energy", -- Section 7: Question 3. Electric utility service by Austin Energy 
    "fgd_city", -- Section 7: Question 20. Participated in a survey or focus groups (online or in-person) conducted by the City
    "phy_check", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months. 
    "free_fire_alarm", -- Section 7: Question 7. Do you know that Fire Department provides free smoke detection alarms for your home? 
    "pc_training", -- Section 7: Question 7: Do you know that there are free public computer training programs? 
    "children", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "ad_concern1", -- Section 5: Question 3. How concerned are you that YOU may have Alzheimer’s disease someday?
    "vote", -- Section 7: Question 20. Voted in a City election (in the past 18 to 24 months) 
    "ad_know", -- Section 5: Question 1. How much do you know about Alzheimer’s disease?
    "no_one", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "d_danger", -- Section 4: Question 8. Do you think people with mental problems are dangerous to others? 
    "d_disappoint", -- Section 4: Question 8. Do you think if you have depression, your family would be disappointed with you? 
    "d_weakness", -- Section 4: Question 8. Do you think depression is a sign of personal weakness? 
    "mhs3", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health. 
    "swl_2", -- Section 4: Question 2. I am satisfied with my life. 
    "public_trans", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "marital", -- Section 1: Question 4. What is your current relationship status?
    "heal_website", -- Section 3: Question 21. Where do you get health-related information? 
    "ad_cure", -- Section 5: Question 8. Scientists will find cure for Alzheimer’s disease soon. 
    "ol_communities", -- Section 3: Question 21. Where do you get health-related information? 
    "paper_cb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "coh1", -- Section 6: Question 6. My ethnic community is a close-knit community.
    "city_effort", -- Section 7: Question 22. In general, how satisfied are you with City government efforts to keep you informed about City services, issues, events, and programs? 
    "ad_concern2", -- Section 5: Question 3. How concerned are you that you may someday have to provide care for someone with Alzheimer’s disease?
    "trans_oth", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "hs_sat_users", -- Section 3: Question 20. How satisfied are you with the healthcare services you received in the past 12 months? 
    "disabled", -- Question 9. What is your current employment status? (Check all that apply)
    "users",
    "ad_have", -- Section 5: Question 2. Do any of your family members or friends have Alzheimer’s disease?
    "place_traffic", -- Section 7: Question 2. Traffic in the City of Austin
    "scl_ntwking_sites", -- Section 3: Question 21. Where do you get health-related information? 
    "fs6", -- Section 6: Question 3. We are proud of our family. 
    "gender", -- Section 1: Question 2. What is your gender?
    "fs7", -- Section 6: Question 3. We can express our feelings with our family.
    "d_everrecc", -- Section 4: Question 8. Have you ever received psychological counseling or treatment? 
    "mhs2", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health. 
    "d_nocure", -- Section 4: Question 8. Do you think people with mental problems will never recover? 
    "mhs1", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health. 
    "sns_cb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "satisf_housing", -- Question 10. How much are you satisfied with your current housing condition?
    "smk_detect", -- Section 7: Question 12. Do you have smoke detection alarms in your home? 
    "nursing_home", -- Section 7: Question 11. Are you willing to use a nursing home in the future? 
    "d_concordance", -- Section 4: Question 8. If you use counseling, would you prefer a counselor of your own ethnic group? 
    "mobile_apps", -- Section 3: Question 21. Where do you get health-related information? 
    "oth_way", -- Section 3: Question 21. Where do you get health-related information? 
    "own_home", -- Section 7: Question 9. Do you (and your family) own your home, rent it, or what? 
    "paper_ncb_eth", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "svc_911", -- Section 7:  Question 7. Do you know what 911 service is? 
    "swl_1", -- Section 4: Question 2. In most ways my life is close to my ideal.
    "rel_imp", -- Section 6:  Question 5. How important is religion in your life? 
    "howlongus", -- Section 2: Question 2. How long have you lived in the United States? __________ years 
    "urgentcare", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months. 
    "place_live", -- Section 7: Question 2. The City of Austin as a place to live 
    "d_willingc", -- Section 4: Question 8. If you have depression, would you be willing to use counseling?
    "housing_cate", -- Section 7: Question 8. What kind of housing do you live in? 
    "acquaintances", -- Section 3: Question 21. Where do you get health-related information? 
    "sb_assist", -- Section 7: Question 7. Do you know that the City offers small business assistance services? 
    "oth_ncb_gen", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "close_friend", -- Section 3: Question 21. Where do you get health-related information? 
    "fam_mem", -- Section 3: Question 21. Where do you get health-related information? 
    "other_rel", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "medical_home", -- Section 3:  Question 11. Is there a place that you usually go to when you get sick?
    "concordance", -- Section 3: Question 19. If you could choose, would you prefer to be treated by a doctor of your own ethnic group? 
    "unmet_d_need", -- Section 3: Question 15. Was there a time in the past 12 months when you needed dental care but couldn’t get it? 
    "ad_concern3", -- Section 5:  Question 3. How important do you think it is to plan for the possibility of getting Alzheimer’s disease in the future? 
    "com_prob", -- Section 3: Question 18. Have you had an experience that you could not understand what the doctor/nurse said? 
    "court", -- Section 7: Question 3. Municipal court services (i.e. traffic, fine collection) 
    "unmet_h_need", -- Section 3: Question 14. Was there a time in the past 12 months when you needed medical care but couldn’t get it? 
    "folkmedicine", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months.  Folk medicine provider (e.g., herbalist, acupuncturist, etc.)
    "copd", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "oth_ncb_eth", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "hepatitis", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "arthritis", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "healthydiet", -- Section 3: Question 8. Do you maintain a healthy diet? 
    "hypertension", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "sroh", -- Section 3: Question 3. How would you rate your dental/oral health at the present time? 
    "encul", -- Section 2: Question 7.  How would you rate your level of familiarity with the culture and custom of your ethnic origin? 
    "identity", -- Section 2: Question 8. How closely do you identify with people of your ethnic origin?
    "us_born", -- Section 2: Question 1. Were you born in the United States? 
    "homemaker", -- Question 9. What is your current employment status? (Check all that apply)
    "student", -- Question 9. What is your current employment status? (Check all that apply)
    "self_part", -- Question 9. What is your current employment status? (Check all that apply)
    "part", -- Section 1: Question 9. What is your current employment status? (Check all that apply)
    "religion", -- Question 8. What is your religious affiliation? 
    "grandparent", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "friends", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "parent", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "edu", -- Section 1: Question 5. Please circle the highest year of school completed.
    "housing_cate_oth", -- Section 7: Question 8. What kind of housing do you live in? 
    "trans_oth_dscrp", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "lib", -- Section 7: Question 3. Libraries 
    "park_rec", -- Section 7: Question 3. Parks and recreational services 
    "coh3", -- Section 6: Question 6. People in my ethnic community share the same values. 
    "regexercise", -- Section 3: Question 7. Do you exercise regularly? 
    "tv_radio_cb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "oth_ncb_gen_dscrb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "diabetes", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "stroke", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "emp_oth_dscrb", -- Question 9. What is your current employment status? (Check all that apply)
    "asthma", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "unmet_f_need", -- Question 12. Thinking of your household’s total monthly income, would you say that your household is able to make ends meet? 
    "income", -- Question 11. How much was your household income (before tax) for the past year?
    "rel_oth", -- Section 1: Question 8. What is your religious affiliation? 
    "eng_spk", -- Section 2: Question 4. How well do you speak English? 
    "ppl_cb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "kidney_prob", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions? 
    "ad_service", -- Section 5: Question 6. Do you know any local services and programs for Alzheimer’s disease patients and family? 
    "actlimit", -- Section 3: Question 4. Do you need help with daily activities like bathing, dressing, eating, or using the toilet?
    "interpretation", -- Section 3: Question 17. For your medical visit, do you need someone who can do interpretation for you? 
    "ad_avoidance", -- Section 5: Question 8. Social interactions with an Alzheimer’s disease patient should be avoided. 
    "full", -- Question 9. What is your current employment status? (Check all that apply)
    "prefered_type", -- Section 7: Question 24. What is your most preferred type of communication for City-related information? 
    "d_insurance", -- Section 3: Question 13. Do you have dental insurance? 
    "heal_pro", -- Section 3: Question 21. Where do you get health-related information? 
    "spouse", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "ppl_ncb_gen", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "oth_ncb_eth_dscrb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "language", -- Question 3. What is your ethnic origin? (Check all that apply)
    "culturalbelif", -- Section 5: Question 11. How much do you agree with the following statement?: “One should avoid speaking about bad things (e.g., disease and death) because it might cause them to happen.”
    "qol", -- Section 4: Question 1. How would you rate your overall quality of life? 
    "oth_cb_dscrb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "d_disclosure", -- Section 4: Question 8. Do you think keeping emotional troubles to oneself is a virtue? 
    "n5", -- Section 6: Question 2. How many friends do you feel at ease with that you can talk about private matters?
    "d_addictive", -- Section 4: Question 8. Do you think antidepressant medicines are addictive? 
    "ad_plan", -- Section 5: Question 4. Have you made plans for the possibility of you or your family getting Alzheimer’s disease? 
    "occupation", -- Question 10.  IF YOU ARE EMPLOYED, what kind of work do you do? 
    "srh", -- Section 3: Question 1. How would you rate your overall health at the present time? 
    "ad_eduprg", -- Section 5: Question 5. Do you know any educational programs on Alzheimer’s disease? 
    "ad_embarassing", -- Section 5: Question 8. It is embarrassing to have a family member with Alzheimer’s disease.
    "website_ncb_eth", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "info_interest", -- Section 7: Question 21. How interested are you in keeping informed about City events and City government? 
    "ad_normalaging", -- Section 5: Question 8. Alzheimer’s disease is a normal process of aging. 
    "public_meeting", -- Section 7: Question 20. Attended a City hosted public meeting 
    "belonging", -- Section 2: Question 9. How much do you feel that you belong to the community of your ethnic origin? 
    "n1", -- Section 6: Question 1. How many family/relatives do you see or hear from at least once a month?
    "home_phone", -- Section 7: Question 19. Do you have a home phone line (wired, landline)? 
    "n2", -- Section 6: Question 1. How many family/relatives do you feel at ease with that you can talk about private matters?
    "personal_car", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "fs9", -- Section 6: Question 3. My family members feel very close to each other.
    "compost", -- Section 7: Question 14. Do you compost? 
    "srmh", -- Section 3: Question 2. How would you rate your mental/emotional health at the present time? 
    "fs10", -- Section 6: Question 3. Family togetherness is very important to our family.
    "howlong_aus", -- Section 7: Question 1. How long have you lived in Austin area? __________ years
    "place_qol", -- Section 7: Question 2. Quality of life in the City of Austin 
    "visit_aarc_freq", -- Section 7: Question 5. How often do you visit AARC? 
    "parti_act_freq", -- Section 7: Question 6. How often do you participate in Asian-specific activities and events in Austin? 
    "social_health_svcs", -- Section 7: Question 3. Social services/ public health services provided by the City 
    "have_advdir", -- Section 5: Question 10. An advance directive is a type of legal document that designates someone who can make medical decisions in the event that you are unable to do so. Do you have such a document? 
    "place_qosvcs", -- Section 7: Question 2. Quality of services provided by the City of Austin 
    "mhs4", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health. 
    "fs3", -- Section 6: Question 3. Things work well for us as a family.
    "heal_info_othr", -- Section 3: Question 21. Where do you get health-related information? 
    "carpooling", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "discrim", -- Section 2: Question 10. Have you ever been treated unfairly because of your race or ethnic origin? 
    "emp_oth", -- Question 9. What is your current employment status? (Check all that apply)
    "public_safety", -- Section 7: Question 2. Public safety services (i.e. police, fire, and ambulance) 
    "coh5", -- Section 6: Question 6. People in my ethnic community can be trusted. 
    "contact_city", -- Section 7: Question 20. E-mailed or phoned a City official or staff person
    "council_meeting", -- Section 7: Question 20. Attended a City Council meeting 
    "acc", -- Section 2: Question 6. How would you rate your level of familiarity with the culture and custom of mainstream America?
    "place_arts_culture", -- Section 7: Question 2. The City of Austin as a place to enjoy arts and culture 
    "hsize", -- Section 1: Question 6. Including yourself, how many people live in your household?
    "citizenship_class", -- Section 7: Question 7. Do you know that public libraries provide free citizenship classes?
    "bro_sis", -- Section 1: Question 7. Who lives with you? (Check all that apply)
    "fs2", -- Section 6: Question 3. We share similar values and beliefs as a family.
    "own_home_oth", -- Section 7: Question 9. Do you (and your family) own your home, rent it, or what? 
    "concerns", -- Section 7: Question 25. Please describe any concerns you may have as an Austin Resident. 
    "ad_fate", -- Section 5: Question 8. Alzheimer’s disease is a cause of fate. 
    "walking", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "bicycling", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis? 
    "svc_311", -- Section 7: Question 7. Do you know what 311 service is? 
    "asian_lang_mag", -- Section 7: Question 7. Do you know that public libraries have newspapers, books and magazines in Asian languages? 
    "apd_lang", -- Section 7: Question 7. Do you know that Austin Police Department provides services in any language? 
    "ad_langauge", -- Section 5: Question 7. Do you think your language and/or culture would interfere with your participation in such programs? 
    "d_shame", -- Section 4: Question 8. Do you think having a depressed family member brings a shame to the whole family? 
    "liv_oth_dscrb", -- Section 1: Question 7. Who lives with you? (Check all that apply) 
    "email", -- Section 3: Question 21. Where do you get health-related information? 
    "sns_ncb_gen", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "recycle", -- Section 7: Question 13. Do you recycle/reuse in your household? 
    "website_ncb_gen", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "tv_radio_ncb_gen", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "tv_radio_ncb_eth", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "paper_ncb_gen", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "sns_ncb_eth", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "place_raise_child", -- Section 7: Question 2. The City of Austin as a place to raise children 
    "eng_prim", -- Section 2: Question 3. Is English your primary language? 
    "occ_oth", -- Question 10. IF YOU ARE EMPLOYED, what kind of work do you do? 
    "oth_cb", -- Section 7: Question 23.  Please indicate the types of communication that you rely on to stay informed about the City of Austin. 
    "n4", -- Section 6: Question 2. How many of your friends do you see or hear from at least once a month?
    "liv_oth", -- Section 1: Question 7. Who lives with you? (Check all that apply) 
    "retired", -- Question 9. What is your current employment status? (Check all that apply)
    "mobile_devices" -- Section 7: Question 18. Do you use a cellphone, smartphone, or other mobile devices?
FROM
    "austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z:latest"."final_report_of_the_asian_american_quality_of_life"
LIMIT 100;

Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z with SQL in under 60 seconds.

This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.austintexas.gov. When you queryaustintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z:latest on the DDN, we "mount" the repository using the socrata mount handler. The mount handler proxies your SQL query to the upstream data source, translating it from SQL to the relevant language (in this case SoQL).

We also cache query responses on the DDN, but we run the DDN on multiple nodes so a CACHE_HIT is only guaranteed for subsequent queries that land on the same node.

Query Your Local Engine

Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"
 

Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.

It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.

There are a few ways to ingest data into the local engine.

For external repositories (like this repository), the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.

For hosted datasets, where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.

Mounting Data

This repository is an external repository. It's not hosted by Splitgraph. It is hosted by data.austintexas.gov, and Splitgraph indexes it. This means it is not an actual Splitgraph image, so you cannot use sgr clone to get the data. Instead, you can use the socrata adapter with the sgr mount command. Then, if you want, you can import the data and turn it into a Splitgraph image that others can clone.

First, install Splitgraph if you haven't already.

Mount the table with sgr mount

sgr mount socrata \
  "austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z" \
  --handler-options '{
    "domain": "data.austintexas.gov",
    "tables": {
        "final_report_of_the_asian_american_quality_of_life": "hc5t-p62z"
    }
}'

That's it! Now you can query the data in the mounted table like any other Postgres table.

Query the data with your existing tools

Once you've loaded the data into your local Splitgraph engine, you can query it with any of your existing tools. As far as they're concerned, austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z is just another Postgres schema.

Related Documentation: