austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z
Icon for Socrata external plugin

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

Read the installation docs.

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.