Query the Data Delivery Network
Query the DDNThe 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 feed_the_future_uganda_interim_survey_in_the_zone table in this repository, by referencing it like:
"usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj:latest"."feed_the_future_uganda_interim_survey_in_the_zone"or in a full query, like:
SELECT
":id", -- Socrata column ID
"j316", -- Have you been trained in when to use and how to apply herbicides for coffee trees?
"j217_z", -- At which times did you apply fertilizer to the beans? SELECT ALL THAT APPLY C - Other (specify)
"j118_a", -- What type of fertilizer did you use? SELECT ALL THAT APPLY A - Organic
"j319_e", -- How did you dry the coffee? SELECT ALL THAT APPLY E - Drying Yard
"d14b", -- Who is the person in your household who made most of the decisions about cultivating coffee in the past one year?
"j214_b", -- Some farmers plant bean seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the bean seeds? SELECT ALL THAT APPLY B - Randomly broadcast
"j127_z", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY Z - Other (specify)
"survey", -- These data were collected in the 2015 Interim Zone of Influence Survey.
"j236_d", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY D - Other constructed stores
"j136_d", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY D - Other constructed stores
"j233_d", -- How did you shell the beans? SELECT ALL THAT APPLY D - Did not shell
"mdj1comp", -- ENTER MODULE J Maize RESULT CODE
"j136_x", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY X - None did not store any maize
"j218_b", -- What type of fertilizer did you use? SELECT ALL THAT APPLY B - Inorganic
"j136_z", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY Z - Other (specify)
"j131", -- Did you dry any of your maize harvest before sale or use?
"j224", -- How many times did you control weeds among your bean crops in the past year?
"j227_f", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY F - Row planting
"j221", -- Did you use chemicals to control insect, rodent or disease attacks on the beans?
"j125_e", -- How did you control the weeds among your maize crops? SELECT ALL THAT APPLY E - Slashing
"j321", -- What type of storage bag did you use for the coffee?
"j323", -- Was your coffee attacked by insects, rodents or disease while in storage?
"j111", -- Why did you purchase maize seed from a friend or relative?
"j112_b", -- What type of maize seed did you plant in the past year? SELECT ALL THAT APPLY B - Hybrid
"j202_b", -- What kind of land preparation did you use for the beans you planted in the past year? SELECT ALL THAT APPLY B - Zero tillage
"j136_b", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY B - Cribs
"j235", -- What type of storage bag did you use for the beans?
"country", -- These data were collected in the Feed the Future Zone of Influence in Uganda.
"j312", -- Was the use of chemicals preventive, or was it in response to an insect, rodent or disease attack?
"j214_a", -- Some farmers plant bean seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the bean seeds? SELECT ALL THAT APPLY A - In rows
"j136_f", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY F - Storage silos
"j317_c", -- Are your coffee trees planted using any of the following techniques to take account of soil and moisture conservation? SELECT ALL THAT APPLY C - Intercropping
"j317_z", -- Are your coffee trees planted using any of the following techniques to take account of soil and moisture conservation? SELECT ALL THAT APPLY Z - Other
"j202_a", -- What kind of land preparation did you use for the beans you planted in the past year? SELECT ALL THAT APPLY A - None
"hh_wt", -- This is the household weight, merged from the HOUSEHOLD file.
"j128", -- Besides rainfall, did you use any additional irrigation methods for the maize?
"j228", -- Besides rainfall, did you use any irrigation for the beans?
"j308_z", -- What type of fertilizer did you use? SELECT ALL THAT APPLY Z - Other (specify)
"j116", -- Did you apply fertilizer to the maize in the past year?
"j304b", -- Why did you purchase coffee seedlings from a friend or relative?
"j322_b", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY B - Storage Unit In Home Lot
"j231", -- Did you dry any of your bean harvest before sale or use?
"j232_z", -- What did you dry the beans on? SELECT ALL THAT APPLY Z - Other (specify)
"d13b", -- Who is the person in your household who made most of the decisions about cultivating beans in the past one year?
"j319_h", -- How did you dry the coffee? SELECT ALL THAT APPLY H - Mechanized Dryers
"j317_a", -- Are your coffee trees planted using any of the following techniques to take account of soil and moisture conservation? SELECT ALL THAT APPLY A - Contouring
"j124", -- How many times did you control weeds among your maize crops in the past year?
"j227_a", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY A - Terracing
"stratum", -- Administrative variable for identifying the sampling strata.
"j222", -- Was the use of chemicals preventive, or was it in response to an insect, rodent or disease attack?
"j204_c", -- What kind of zero tillage system did you use for the beans? SELECT ALL THAT APPLY C - Herbicide and plant
"j313", -- Have you been trained in when to use and how to apply pesticides for coffee trees?
"j233_z", -- How did you shell the beans? SELECT ALL THAT APPLY Z - Other (specify)
"j206_z", -- What did you use for ploughing for the beans? SELECT ALL THAT APPLY Z - Other (specify)
"j206_c", -- What did you use for ploughing for the beans? SELECT ALL THAT APPLY C - Tractor
"region", -- Region
"j233_b", -- How did you shell the beans? SELECT ALL THAT APPLY B - By sticks
"j102_z", -- What kind of land preparation did you use for the maize you planted in the past year? SELECT ALL THAT APPLY Z - Other (specify)
"j132_b", -- What did you dry the maize on? SELECT ALL THAT APPLY B - Ground plastered with cow dung
"j229_c", -- What type of irrigation did you use? SELECT ALL THAT APPLY C - Permanent hose
"j204_b", -- What kind of zero tillage system did you use for the beans? SELECT ALL THAT APPLY B - Burn and plant
"j115", -- Over the past two planting seasons did you rotate maize with other crop(s) in the same plot area?
"j305", -- Was the coffee grown for household consumption, or was it grown to be sold or traded in the market?
"j136_a", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY A - Residential House
"j113", -- Was the maize crop grown to provide food for the household, or was it grown to be sold or traded in the market?
"j227_d", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY D - Intercropping
"j310", -- Did you have any insect, rodent or disease attacks on your coffee trees in the past year?
"j215", -- Over the past two planting seasons did you rotate beans with other crop(s) in the same plot area?
"j206_a", -- What did you use for ploughing for the beans? SELECT ALL THAT APPLY A - Hand tillage (hoe)
"j322_d", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY D - Warehouses
"d14a", -- Did anyone in your household cultivate coffee in the past one year?
"j104_b", -- What kind of zero tillage system did you use for the maize? SELECT ALL THAT APPLY B - Burn and plant
"j322_z", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY Z - Other
"j236_z", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY Z - Other (specify)
"j102_b", -- What kind of land preparation did you use for the maize you planted in the past year? SELECT ALL THAT APPLY B - Zero tillage
"j319_a", -- How did you dry the coffee? SELECT ALL THAT APPLY A - Bare Ground
"j132_g", -- What did you dry the maize on? SELECT ALL THAT APPLY G - Drying racks
"j230", -- How did you harvest the beans?
"j214_z", -- Some farmers plant bean seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the bean seeds? SELECT ALL THAT APPLY Z - Other (specify)
"j319_f", -- How did you dry the coffee? SELECT ALL THAT APPLY F - Drying Racks
"j127_e", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY E - Crop rotation
"j102_c", -- What kind of land preparation did you use for the maize you planted in the past year? SELECT ALL THAT APPLY C - Ploughing
"j130", -- How did you harvest the maize?
"j219", -- Inorganic fertilizer is a man-made fertilizer that you can buy in a bag at the shop. Have you been trained in how to use and apply inorganic fertilizer for beans?
"pbs_id", -- Administrative variable for identifying households
"j132_e", -- What did you dry the maize on? SELECT ALL THAT APPLY E - Tarpaulins
"d11", -- Did you or anyone in your household cultivate any crops in the past one year?
"j308_a", -- What type of fertilizer did you use? SELECT ALL THAT APPLY A - Organic
"j319_b", -- How did you dry the coffee? SELECT ALL THAT APPLY B - Ground Plastered With Cow Dung
"j125_f", -- How did you control the weeds among your maize crops? SELECT ALL THAT APPLY F - Pull by hand
"j232_a", -- What did you dry the beans on? SELECT ALL THAT APPLY A - Bare ground
"j315_d", -- How did you control the weeds among your coffee trees? SELECT ALL THAT APPLY D - Intercropping
"j315_e", -- How did you control the weeds among your coffee trees? SELECT ALL THAT APPLY E - Slashing
"d12a", -- Did anyone in your household cultivate maize in the past one year?
"j127_c", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY C - Soil bands trenches
"j112_x", -- What type of maize seed did you plant in the past year? SELECT ALL THAT APPLY X - Don t know
"j125_b", -- How did you control the weeds among your maize crops? SELECT ALL THAT APPLY B - Herbicide
"d13a", -- Did anyone in your household cultivate beans in the past one year?
"j214_c", -- Some farmers plant bean seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the bean seeds? SELECT ALL THAT APPLY C - Planted within other crops growing in the plot
"j126", -- Have you been trained in when to use and how to apply herbicides for maize?
"j106_c", -- What did you use for ploughing for the maize? SELECT ALL THAT APPLY C - Tractor
"j132_i", -- What did you dry the maize on? SELECT ALL THAT APPLY I - Mechanized dryers
"j218_c", -- What type of fertilizer did you use? SELECT ALL THAT APPLY C - Foliar feeds
"j236_e", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY E - Warehouses
"j229_d", -- What type of irrigation did you use? SELECT ALL THAT APPLY D - Pumps
"j216", -- Did you apply fertilizer to the beans in the past year?
"j129_b", -- What type of irrigation did you use? SELECT ALL THAT APPLY B - Canals
"j122", -- Was the use of chemicals preventive, or was it in response to an insect, rodent or disease attack?
"j225_c", -- How did you control the weeds among your bean crops? SELECT ALL THAT APPLY C - Mulching
"j319_g", -- How did you dry the coffee? SELECT ALL THAT APPLY G - Solar Dryers
"j233_c", -- How did you shell the beans? SELECT ALL THAT APPLY C - With a shelling machine
"j118_z", -- What type of fertilizer did you use? SELECT ALL THAT APPLY Z - Other (specify)
"j232_g", -- What did you dry the beans on? SELECT ALL THAT APPLY G - Solar dryers
"j127_a", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY A - Terracing
"j112_a", -- What type of maize seed did you plant in the past year? SELECT ALL THAT APPLY A - Open pollinated varieties (OPVs)
"j118_c", -- What type of fertilizer did you use? SELECT ALL THAT APPLY C - Foliar feeds
"today", -- Survey Date
"j232_b", -- What did you dry the beans on? SELECT ALL THAT APPLY B - Ground plastered with cow dung
"j123", -- Have you been trained in when to use and how to apply pesticides for maize?
"j318", -- Did you dry your coffee harvest before sale or use?
"j137", -- Was your maize attacked by insects, rodents or disease while in storage?
"j136_e", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY E - Warehouses
"j129_d", -- What type of irrigation did you use? SELECT ALL THAT APPLY D - Pumps
"j127_b", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY B - Mulching
"j132_z", -- What did you dry the maize on? SELECT ALL THAT APPLY Z - Other (specify)
"j106_b", -- What did you use for ploughing for the maize? SELECT ALL THAT APPLY B - Animal traction
"j322_a", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY A - Residential House
"j132_a", -- What did you dry the maize on? SELECT ALL THAT APPLY A - Bare ground
"j229_b", -- What type of irrigation did you use? SELECT ALL THAT APPLY B - Canals
"j102_a", -- What kind of land preparation did you use for the maize you planted in the past year? SELECT ALL THAT APPLY A - None
"j308_c", -- What type of fertilizer did you use? SELECT ALL THAT APPLY C - Foliar feeds
"j232_h", -- What did you dry the beans on? SELECT ALL THAT APPLY H - Mechanized dryers
"j237", -- Were your beans attacked by insects, rodents or disease while in storage?
"j114_c", -- Some farmers plant maize seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the maize seeds? SELECT ALL THAT APPLY C - Planted with other crops growing in the plot
"j236_c", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY C - Granaries
"j236_x", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY X - None did not store any beans
"j218_a", -- What type of fertilizer did you use? SELECT ALL THAT APPLY A - Organic
"j303b", -- Was the nursery where you purchased the coffee seedlings a registered or certified nursery?
"j227_b", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY B - Mulching
"j117_a", -- At which times did you apply fertilizer to the maize? SELECT ALL THAT APPLY A - Planting
"j133_z", -- How did you shell the maize? SELECT ALL THAT APPLY Z - Other (specify)
"j204_z", -- What kind of zero tillage system did you use for the beans? SELECT ALL THAT APPLY D - Other (specify)
"j322_c", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY C - Other Constructed Stores
"j132_d", -- What did you dry the maize on? SELECT ALL THAT APPLY D - Left to dry on plant in field
"j114_z", -- Some farmers plant maize seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the maize seeds? SELECT ALL THAT APPLY Z - Other (specify)
"j315_c", -- How did you control the weeds among your coffee trees? SELECT ALL THAT APPLY C - Mulching
"j309", -- Have you been trained in how to use and apply fertilizer for coffee trees?
"j322_e", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY E - Storage Silos
"j132_c", -- What did you dry the maize on? SELECT ALL THAT APPLY C - Ground covered with straw
"j227_c", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY C - Soil bands trenches
"j133_d", -- How did you shell the maize? SELECT ALL THAT APPLY D - Did not shell
"j125_a", -- How did you control the weeds among your maize crops? SELECT ALL THAT APPLY A - Hoe
"j117_z", -- At which times did you apply fertilizer to the maize? SELECT ALL THAT APPLY Z - Other (specify)
"j315_a", -- How did you control the weeds among your coffee trees? SELECT ALL THAT APPLY A - Hoe
"j134", -- Did you put the maize in bags after harvest for storage or transport?
"j225_f", -- How did you control the weeds among your bean crops? SELECT ALL THAT APPLY F - Pull by hand
"j315_f", -- How did you control the weeds among your coffee trees? SELECT ALL THAT APPLY F - Pull by hand
"j220", -- Did you have any insect, rodent or disease attacks on your beans in the past year?
"cluster", -- Cluster number
"j104_z", -- What kind of zero tillage system did you use for the maize? SELECT ALL THAT APPLY Z - Other (specify)
"j319_d", -- How did you dry the coffee? SELECT ALL THAT APPLY D - Tarpaulins
"j129_z", -- What type of irrigation did you use? SELECT ALL THAT APPLY Z - Other (specify)
"j234", -- Did you put the beans in bags after harvest for storage or transport?
"j133_b", -- How did you shell the maize? SELECT ALL THAT APPLY B - By sticks
"j319_z", -- How did you dry the coffee? SELECT ALL THAT APPLY Z - Other
"j104_c", -- What kind of zero tillage system did you use for the maize? SELECT ALL THAT APPLY C - Herbicide and plant
"j320", -- Did you put the coffee in bags after harvest for storage?
"j232_c", -- What did you dry the beans on? SELECT ALL THAT APPLY C - Left to dry on plant in field
"j104_a", -- What kind of zero tillage system did you use for the maize? SELECT ALL THAT APPLY A - Slash and plant
"j225_d", -- How did you control the weeds among your bean crops? SELECT ALL THAT APPLY D - Intercropping
"j132_h", -- What did you dry the maize on? SELECT ALL THAT APPLY H - Solar dryers
"j211", -- Why did you purchase bean seed from a friend or relative?
"j227_x", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY X - None
"j232_d", -- What did you dry the beans on? SELECT ALL THAT APPLY D - Tarpaulins
"j127_d", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY D - Intercropping
"j319_c", -- How did you dry the coffee? SELECT ALL THAT APPLY C - Left To Dry On Plant In Field
"j227_e", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY E - Crop rotation
"urbrur", -- Location type (urban rural)
"j311", -- Did you use chemicals to control insect, rodent or disease attacks on your coffee trees?
"j117_b", -- At which times did you apply fertilizer to the maize? SELECT ALL THAT APPLY B - Mid-crop
"j114_a", -- Some farmers plant maize seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the maize seeds? SELECT ALL THAT APPLY A - In rows
"j223", -- Have you been trained in when to use and how to apply pesticides for beans?
"j227_z", -- In the past year, did you use any of the following techniques to manage soil and water for your bean crop? SELECT ALL THAT APPLY Z - Other (specify)
"j204_a", -- What kind of zero tillage system did you use for the beans? SELECT ALL THAT APPLY A - Slash and plant
"j218_z", -- What type of fertilizer did you use? SELECT ALL THAT APPLY Z - Other (specify)
"j229_z", -- What type of irrigation did you use? SELECT ALL THAT APPLY Z - Other (specify)
"j202_z", -- What kind of land preparation did you use for the beans you planted in the past year? SELECT ALL THAT APPLY Z - Other (specify)
"j120", -- Did you have any insect, rodent or disease attacks on your maize in the past year?
"j314", -- How many times did you control weeds among your coffee trees in the past year?
"j322_x", -- Did you use any of the following storage locations to store the coffee? SELECT ALL THAT APPLY X - None Did Not Store Any Coffee
"j136_c", -- Did you use any of the following storage locations to store the maize? SELECT ALL THAT APPLY C - Granaries
"j127_x", -- In the past year, did you use any of the following techniques to manage soil and water for your maize crop? SELECT ALL THAT APPLY X - None
"j114_b", -- Some farmers plant maize seeds in rows, or randomly broadcast, or plant with other crops growing in the plot. How did you plant the maize seeds? SELECT ALL THAT APPLY B - Randomly broadcast
"j121", -- Did you use chemicals to control insect, rodent or disease attacks on the maize?
"j125_c", -- How did you control the weeds among your maize crops? SELECT ALL THAT APPLY C - Mulching
"j232_f", -- What did you dry the beans on? SELECT ALL THAT APPLY F - Drying racks
"j125_d", -- How did you control the weeds among your maize crops? SELECT ALL THAT APPLY D - Intercropping
"j201a", -- How many varieties of beans did you cultivate?
"j202_c", -- What kind of land preparation did you use for the beans you planted in the past year? SELECT ALL THAT APPLY C - Ploughing
"j236_b", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY B - Cribs
"d12b", -- Who is the person in your household who made most of the decisions about cultivating maize in the past one year?
"j225_b", -- How did you control the weeds among your bean crops? SELECT ALL THAT APPLY B - Herbicide
"j103", -- Did the respondent use zero tillage to prepare the land?
"j107", -- What was your main source of maize seed?
"j236_a", -- Did you use any of the following storage locations to store the beans? SELECT ALL THAT APPLY A - Residential House
"j106_a", -- What did you use for ploughing for the maize? SELECT ALL THAT APPLY A - Hand tillage (hoe)
"mdj2comp", -- ENTER MODULE J Beans RESULT CODE
"j133_c", -- How did you shell the maize? SELECT ALL THAT APPLY C - With a shelling machine
"j135", -- What type of storage bag did you use for the maize?
"j315_b", -- How did you control the weeds among your coffee trees? SELECT ALL THAT APPLY B - Herbicide
"j217_a", -- At which times did you apply fertilizer to the beans? SELECT ALL THAT APPLY A - Planting
"j212_x", -- What type of bean seed did you plant in the past year? SELECT ALL THAT APPLY X - Don t know
"j129_a", -- What type of irrigation did you use? SELECT ALL THAT APPLY A - By hand (watering can, hose, etc.)
"j317_x", -- Are your coffee trees planted using any of the following techniques to take account of soil and moisture conservation? SELECT ALL THAT APPLY X - None
"j213", -- Was the bean crop grown to provide food for the household, or was it grown to be sold or traded in the market?
"j106_z", -- What did you use for ploughing for the maize? SELECT ALL THAT APPLY Z - Other (specify)
"j207", -- What was your main source of bean seed?
"j132_f", -- What did you dry the maize on? SELECT ALL THAT APPLY F - Drying yard
"j226", -- Have you been trained in when to use and how to apply herbicides for beans?
"j119", -- Inorganic fertilizer is a man-made fertilizer that you can buy in a bag at the shop. Have you been trained in how to use and apply inorganic fertilizer for maize?
"j133_a", -- How did you shell the maize? SELECT ALL THAT APPLY A - By hand only
"j217_b", -- At which times did you apply fertilizer to the beans? SELECT ALL THAT APPLY B - Mid-crop
"j302", -- What was your main source of coffee seedlings?
"j212_b", -- What type of bean seed did you plant in the past year? SELECT ALL THAT APPLY B - Hybrid
"j317_b", -- Are your coffee trees planted using any of the following techniques to take account of soil and moisture conservation? SELECT ALL THAT APPLY B - Mulching
"mdj3comp", -- ENTER MODULE J Coffee RESULT CODE
"j225_a", -- How did you control the weeds among your bean crops? SELECT ALL THAT APPLY A - Hoe
"j229_a", -- What type of irrigation did you use? SELECT ALL THAT APPLY A - By hand (watering can, hose, etc.)
"j306", -- Did you apply fertilizer to the coffee?
"j232_e", -- What did you dry the beans on? SELECT ALL THAT APPLY E - Drying yard
"j225_e", -- How did you control the weeds among your bean crops? SELECT ALL THAT APPLY E - Slashing
"j308_b", -- What type of fertilizer did you use? SELECT ALL THAT APPLY B - Inorganic
"j129_c", -- What type of irrigation did you use? SELECT ALL THAT APPLY C - Permanent hose
"j206_b", -- What did you use for ploughing for the beans? SELECT ALL THAT APPLY B - Animal traction
"j118_b", -- What type of fertilizer did you use? SELECT ALL THAT APPLY B - Inorganic
"j212_a", -- What type of bean seed did you plant in the past year? SELECT ALL THAT APPLY A - Open pollinated varieties (OPVs)
"j233_a" -- How did you shell the beans? SELECT ALL THAT APPLY A - By hand only
FROM
"usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj:latest"."feed_the_future_uganda_interim_survey_in_the_zone"
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 usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj with SQL in under 60 seconds.
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, 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 (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cjCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj:latestThis will download all the objects for the latest tag of usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
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, usaid-gov/feed-the-future-uganda-interim-survey-in-the-zone-9tq6-t4cj is just another Postgres schema.