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 escooters_december_2020_edmonton_insight_community table in this repository, by referencing it like:
"edmonton-ca/escooters-december-2020-edmonton-insight-community-9r7c-qftq:latest"."escooters_december_2020_edmonton_insight_community"or in a full query, like:
SELECT
":id", -- Socrata column ID
"d4b_mobility", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Mobility
"q3_other_please_specify", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Other (please specify) NB: Open text responses are not reported
"q16_word_of_mouth", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: Word of mouth
"q3_daily_commute", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Daily commute
"completiontime",
"completeddate",
"q22_1", -- All respondents were then asked, "Please rate your level of agreement for each statement" (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree): The City should do more to enforce how shared active vehicles, such as e-scooters, should be used.
"q21b", -- All respondents were asked, "Where would you like to see e-scooters parked?" Possible answers were: On roadway locations, On sidewalk locations, On private development facilities (please specify), Other (please specify) NB: Open text responses are not reported
"q14_4", -- All respondents were then asked, "How often did the following occur when you encountered an e-scooter as a sidewalk user?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Was unable to move out of the way to avoid a collision
"q14_1", -- All respondents were then asked, "How often did the following occur when you encountered an e-scooter as a sidewalk user?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Was cut off
"q14_0", -- All respondents were then asked, "How often did the following occur when you encountered an e-scooter as a sidewalk user?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): E-scooter was driven on the sidewalk
"q12_2", -- All respondents were then asked, "Rate your level of agreement with the following statements:" A Likert agreement scale was provided (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: e-scooters are enjoyable
"q12_1", -- All respondents were then asked, "Rate your level of agreement with the following statements:" A Likert agreement scale was provided (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: e-scooters help connect people to their city
"q10_0", -- For those who answered "Yes" in Q1, respondents were then asked, "To what extent do you agree or disagree with the following statements regarding your experience with e-scooters in 2020? A Likert agreement scale was presented (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: The e-scooters were cleaned regularly during the COVID-19 pandemic
"q8_6", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Park trails not maintained by the City
"q8_3", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Roads with a posted speed limit of 50km/h or less
"q8_2", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Shared streets
"q7_10", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Car stalls
"q7_7", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: In a bike lane, shared pathway, alley or loading area
"q7_5", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Parkland
"q4a", -- For those who answered "Yes" in Q1, respondents were then asked, "How often did you wear a helmet while riding an e-scooter?" Possible answers were: Always, Often, Sometimes, Never
"q4_on_shared_paths_can_be_used_for_walking_cycling_or_e_scooter", -- For those who answered "Yes" in Q1, they were then asked, "Where did you primarily ride the service?" Selecting all that apply: On shared paths - can be used for walking, cycling or e-scooters
"d2", -- Respondents were asked, ""Are you?"" Possible answers were Under 18 years old 18-24 years old 25-34 years old 35-44 years old 45-54 years old 55-64 years old 65 to 74 years old 75+ years old I prefer not to answer
"d1", -- Respondents were asked, "Which neighbourhood do you live in?" One selection was required with a drop down list of all 300+ neighbourhoods including Prefer not to answer, I don't know, and I don't live in Edmonton as options.
"browserversion",
"invitationdate",
"starteddate",
"responsedate",
"index",
"d4b_developmental", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Developmental
"q18_2", -- For those who answered "City of Edmonton website" in Q16, they were then asked, "To what extent do you agree or disagree with the following statements?" (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable): The information was easy to understand
"q18_1", -- For those who answered "City of Edmonton website" in Q16, they were then asked, "To what extent do you agree or disagree with the following statements?" (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable): The information met my needs or answered all my questions
"q18_0", -- For those who answered "City of Edmonton website" in Q16, they were then asked, "To what extent do you agree or disagree with the following statements?" (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable): It was easy to find the information I needed from the City’s website
"q16_city_of_edmonton_website", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: City of Edmonton website
"q11_was_not_comfortable_riding_the_e_scooters", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Was not comfortable riding the e-scooters
"parkingnotallowed",
"q11_not_available_in_my_area_of_the_city", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Not available in my area of the city
"q16_news_media", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: News media
"q11_did_not_know_how_to_use_e_scooters", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not know how to use e-scooters
"q21", -- For those who answered "No" in Q1 and "Yes" in Q20, they were then asked, "Do you think these designated parking spaces are placed appropriately within public space?" Possible answers were: Yes, No
"q16_independent_social_media_accounts_and_websites", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: Independent social media accounts and websites
"q11_other_please_specify", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Other (please specify) NB: Open text responses are not resported
"parkingallowed",
"q22_2", -- All respondents were then asked, "Please rate your level of agreement for each statement" (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree): The City should do more to educate the public, users and non-users, on safe e-scooter use and etiquette.
"q22_0", -- All respondents were then asked, "Please rate your level of agreement for each statement" (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree): In addition to e-scooters, the City should also encourage usage of shared bicycles and e-bikes.
"q19", -- All respondents were asked, "In 2020, the City allowed the service providers to increase the number of e-scooters available for users compared to 2019. Do you think in 2021..." Possible answers were: The number of e-scooters available should be increased further Should remain the same as 2020 Should be reduced compared to 2020 No opinion
"q15_3", -- All respondents were asked, "How often did the following occur when you encountered an e-scooter as a driver or cyclist?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Had to move out of the way to avoid a collision
"q15_2", -- All respondents were asked, "How often did the following occur when you encountered an e-scooter as a driver or cyclist?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Was cut off
"q14_5", -- All respondents were then asked, "How often did the following occur when you encountered an e-scooter as a sidewalk user?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Experienced a collision
"q13_3", -- All respondents were then asked, "How often did the following occur when you encountered parked e-scooters?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): E-scooters were parked in a way that obstructed emergency doorways or pathways, etc
"q12_3", -- All respondents were then asked, "Rate your level of agreement with the following statements:" A Likert agreement scale was provided (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: e-scooters are beneficial because they provide another way for people to get from point A to point B"
"q12_0", -- All respondents were then asked, "Rate your level of agreement with the following statements:" A Likert agreement scale was provided (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: e-scooters help connect people to each other
"q10_3", -- For those who answered "Yes" in Q1, respondents were then asked, "To what extent do you agree or disagree with the following statements regarding your experience with e-scooters in 2020? A Likert agreement scale was presented (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: The service provider (the e-scooter company) provided satisfactory responses when I asked questions.
"q10_2", -- For those who answered "Yes" in Q1, respondents were then asked, "To what extent do you agree or disagree with the following statements regarding your experience with e-scooters in 2020? A Likert agreement scale was presented (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: It was easy to find information on City regulations about using e-scooters
"q9", -- For those who answered "Yes" in Q1, respondents were asked, "Did you receive information about e-scooter use and safety from the e-scooter company after signing up, such as through emails, pop-ups, texts, or other forms of messaging?". Possible answers were: Yes, No
"q8_7", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Vehicle lanes designated for patio use
"q8_5", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Sidewalks
"q8_4", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Roads with a posted speed limit over 50 km/h
"q7_16", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Within a metre of a shrub bed, tree, or other vegetation aside from grass
"q7_15", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Within 5m of a fire hydrant or fire department connection
"q7_11", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: In doorways or emergency exits, on ramps, or next to handrails, bus benches or bus shelters
"q7_9", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Bike park areas at transit centres or rec centres
"q7_6", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Within a metre from a shared pathway or trail
"q7_3", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Parking lanes, when sidewalks are less than 1.8m
"q7_2", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Parking lanes, where available
"q7_1", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: On a sidewalk within 0.5m from curb and allows 1.8 of clearance for pedestrians
"q7_0", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Anywhere on a sidewalk
"q4_in_bike_lanes", -- For those who answered "Yes" in Q1, they were then asked, "Where did you primarily ride the service?" Selecting all that apply: In bike lanes
"q2", -- For those who answered "Yes" in Q1, respondents were asked, "How often did you use the service?"". Possible answers were: Often (multiple times per week) Sometimes (a few times per month) Rarely (one or two times per month)
"respondentsource_icm_power_surveys",
"pointsearned",
"q7_14", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: With 1.5m of benches, E-Park pay stations, transit signs, call boxes, crosswalk buttons, utility boxes or poles
"q7_13", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Onto a train during operating hours
"q4_on_streets_with_speed_limits_of_50_km_h_or_less", -- For those who answered "Yes" in Q1, they were then asked, "Where did you primarily ride the service?" Selecting all that apply: On streets with speed limits of 50 km/h or less
"ridingnotallowed",
"q4_on_sidewalks", -- For those who answered "Yes" in Q1, they were then asked, "Where did you primarily ride the service?" Selecting all that apply: On sidewalks
"q3_quick_alternative_mode_of_travel_in_congested_areas", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Quick alternative mode of travel in congested areas
"q3_just_wanted_to_try_it_out", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Just wanted to try it out
"q16_other_please_specify", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: Other (please specify) NB: Open text responses are not reported
"q16_city_of_edmonton_social_media_accounts", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: City of Edmonton social media accounts
"q16_311", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: 311
"q15_4", -- All respondents were asked, "How often did the following occur when you encountered an e-scooter as a driver or cyclist?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Was unable to move out of the way due to physical limitations (lack of space, other vehicles, etc.)
"q15_1", -- All respondents were asked, "How often did the following occur when you encountered an e-scooter as a driver or cyclist?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Did not give enough room to pass
"q13_2", -- All respondents were then asked, "How often did the following occur when you encountered parked e-scooters?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): E-scooters were blocking the travel path
"q13_0", -- All respondents were then asked, "How often did the following occur when you encountered parked e-scooters?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Too many e-scooters were parked in one location
"q11_i_was_worried_about_covid_19_transmission_risks", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: I was worried about COVID -19 transmission risks
"q11_did_not_want_to_agree_to_the_terms_of_licence_agreement", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not want to agree to the terms of licence agreement
"q11_did_not_feel_safe_using_it", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not feel safe using it
"q1", -- All respondents were asked, "Did you use an e-scooter service in Edmonton in 2020?" Possible answers were: Yes No
"invite_to_join",
"d4b_other_please_specify", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Other (please specify) NB: Open text responses are not reported
"d4b_agility", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Agility
"q11_did_not_have_access_to_did_not_use_a_credit_card_bank_card_", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not have access to/ did not use a credit card, bank card, or online banking account
"d4b_psychological_mental_health_such_as_anxiety_depression_etc", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Psychological (Mental Health such as Anxiety, Depression, etc.)
"q11_did_not_want_to_pay_for_the_service", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not want to pay for the service
"q11_did_not_have_access_to_mobile_phone_application", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not have access to mobile phone application
"q7_8", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: On a bridge or in a median island
"d4a", -- Respondents were provided a definition of disability and were asked, "Are you a person with a disability?" Possible answers were: Yes No I prefer not to answer
"browserexperience_javascript_enabled",
"browsertype",
"ostype",
"d4b_memory", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Memory
"d4b_pain", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Pain
"d4b_seeing", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Seeing
"d4b_chronic_illness", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Chronic illness
"q4_other_please_specify", -- For those who answered "Yes" in Q1, they were then asked, "Where did you primarily ride the service?" Selecting all that apply: Other (please specify) NB: Open text responses are not reported
"q11_did_not_have_access_to_chose_not_to_use_a_smartphone", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Did not have access to /chose not to use a smartphone
"q11_not_physically_able_to_use_it", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Not physically able to use it
"q11_could_not_afford_the_service", -- For those who answered "No" in Q1, they were then asked, "Why didn’t you access the services?" Selecting all that apply: Could not afford the service
"ridingallowed",
"q21a", -- For those who answered "Yes" in Q1 and "Yes" in Q20, respondents were asked, "Do you think these designated parking spaces are convenient for e-scooter users?" Possible answers were: Yes, No
"q15_5", -- All respondents were asked, "How often did the following occur when you encountered an e-scooter as a driver or cyclist?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Experienced a collision
"q15_0", -- All respondents were asked, "How often did the following occur when you encountered an e-scooter as a driver or cyclist?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Blocked my path
"q14_3", -- All respondents were then asked, "How often did the following occur when you encountered an e-scooter as a sidewalk user?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Had to move out of the way to avoid a collision
"q14_2", -- All respondents were then asked, "How often did the following occur when you encountered an e-scooter as a sidewalk user?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): Did not receive a proper advance warning by voice or ringing bell when being passed
"q13_4", -- All respondents were then asked, "How often did the following occur when you encountered parked e-scooters?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): E-scooters were parked in a zone designated only for vehicles"
"q13_1", -- All respondents were then asked, "How often did the following occur when you encountered parked e-scooters?" (5- Very often, 4, 3, 2, 1 - Rarely / Not at all): E-scooters were not parked in an upright position
"q10_1", -- For those who answered "Yes" in Q1, respondents were then asked, "To what extent do you agree or disagree with the following statements regarding your experience with e-scooters in 2020? A Likert agreement scale was presented (Strongly agree, Somewhat agree, Neither agree nor disagree, Somewhat disagree, Strongly disagree, Not applicable). Statement: There were adequate options for parking the e-scooters
"q9a", -- For those who answered "Yes" in Q1 and "Yes" in Q9, they were then asked, "Did the information help you learn more about e-scooter use and safety?" Possible answers were: Yes, No
"q7_12", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Inside a Transit Centre or rec centre, on a LRT platform, onto a bus
"q7_4", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where are e-scooters allowed to be parked?" A grid with "Yes" and "No" was presented with the selections: Parking spots set aside for E-Park, no parking zones, no stopping zones, disabled parking zones, loading zones
"q3_recreation", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Recreation
"version",
"activityid",
"plugintype_flash",
"d4b_learning", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Learning
"d4b_i_prefer_not_to_answer", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: I prefer not to answer [exclusive]
"d4b_speech", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Speech
"q4_on_streets_with_speed_limits_of_more_than_50_km_h", -- For those who answered "Yes" in Q1, they were then asked, "Where did you primarily ride the service?" Selecting all that apply: On streets with speed limits of more than 50 km/h
"d4b_hearing", -- For those who answered "Yes" in Q4a, they were asked, "What is the nature of your disability?" Selecting all that apply: Hearing
"q3_daily_errands", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Daily errands
"q3_filled_a_transportation_gap_in_my_travel_route", -- For those who answered "Yes" in Q1, respondents were asked, "What was your primary reason for using the service?" Selecting all that apply: Filled a transportation gap in my travel route
"q20", -- Two photos of escooter designated parking spaces were shown. All respondents were asked, "Did you notice any of these designated e-scooters parking spaces?" Possible answers were: Yes No
"q16_vendors_lime_bird_apps_websites_and_or_social_media_account", -- All respondents were asked, "Did you use any of the following sources to access information about e-scooters?" Selecting all that apply: Vendors (Lime, Bird) apps, websites, and/or social media accounts
"q8_1", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Shared pathways
"q8_0", -- For those who answered "Yes" in Q1, respondents were asked, "To the best of your knowledge of City regulations and guidelines, where can e-scooters be ridden?". A grid with "Yes" and "No" was presented with the following selections: Bike lanes
"browserexperience_user_agent",
"plugintype_no_detectable_plugin",
"devicetype",
"responsestatus",
"respondentlocale"
FROM
"edmonton-ca/escooters-december-2020-edmonton-insight-community-9r7c-qftq:latest"."escooters_december_2020_edmonton_insight_community"
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 edmonton-ca/escooters-december-2020-edmonton-insight-community-9r7c-qftq with SQL in under 60 seconds.
This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.edmonton.ca. When you queryedmonton-ca/escooters-december-2020-edmonton-insight-community-9r7c-qftq: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.edmonton.ca, 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 \
"edmonton-ca/escooters-december-2020-edmonton-insight-community-9r7c-qftq" \
--handler-options '{
"domain": "data.edmonton.ca",
"tables": {
"escooters_december_2020_edmonton_insight_community": "9r7c-qftq"
}
}'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, edmonton-ca/escooters-december-2020-edmonton-insight-community-9r7c-qftq is just another Postgres schema.