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 development_fees_data_2017
table in this repository, by referencing it like:
"orcities/development-fees-data-2017-twzh-bmv4:latest"."development_fees_data_2017"
or in a full query, like:
SELECT
":id", -- Socrata column ID
"application_modification_other_application_modification_fil_000",
"application_modification_other_application_modification_fil_001",
"comprehensive_plan_amendment_amendment_without_rezone_pricing_m",
"comprehensive_plan_amendment_amendment_with_rezone_addition_000",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__000",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__001",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__002",
"conditional_use_minor_modification_additional_notes",
"comprehensive_plan_amendment_amendment_with_rezone_addition_001",
"annexation_annexation_fee_definition_as_your_city_defines_it",
"adjustment_review_major_adjustment_fee_definition_as_your_city_",
"design_review_design_review_type_1_fee_definition_as_your_city_",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_000",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_001",
"conditional_use_planned_unit_development_additional_fee_1",
"conditional_use_new_conditional_use_additional_notes",
"conditional_use_minor_modification_base_fee_dollars",
"conditional_use_minor_modification_fee_definition_as_your_city_",
"comprehensive_plan_amendment_amendment_without_rezone_addit_000",
"comprehensive_plan_amendment_amendment_without_rezone_addit_001",
"appeals_appeals_to_planning_commission_additional_fee_2",
"appeals_appeals_to_planning_commission_base_fee_dollars",
"annexation_other_annexation_fee_fill_in_the_blank_text",
"annexation_annexation_pricing_method_i_e_base_fee_per_acre_per_",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_000",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_001",
"adjustment_review_minor_adjustment_additional_fee_1",
"adjustment_review_minor_adjustment_pricing_method_i_e_base_fee_",
"population",
"zone_change_annexation_non_discretionary_base_fee_dollars",
"historic_review_alterations_additional_fee_3",
"adjustment_review_minor_adjustment_additional_fee_2",
"variance",
"adjustment_review_minor_adjustment_fee_definition_as_your_city_",
"adjustment_review_minor_adjustment_additional_fee_3",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_002",
"comprehensive_plan_amendment_amendment_with_rezone_fee_definiti",
"site_plan_review_projects_value_between_12_500_25_000_addit_000",
"historic_review_new_construction_in_historic_distrcit_fee_defin",
"historic_review_removal_of_designation_additional_fee_1",
"historic_review_emergency_demolition_additional_fee_2",
"land_division_final_partition_additional_fee_1",
"land_division_preliminary_partition_additional_fee_1",
"land_division_final_partition_additional_fee_2",
"land_division_final_partition_additional_fee_3",
"standards_review_other_standards_review_fee_fill_in_the_bla_000",
"site_plan_review_pre_site_plan_approval_pricing_method_i_e_base",
"site_plan_review_projects_value_between_12_500_25_000_addit_001",
"site_plan_review_pre_site_plan_approval_additional_notes",
"standards_review_standards_review_additional_fee_2",
"standards_review_standards_review_additional_fee_3",
"variance_minor_variance_pricing_method_i_e_base_fee_per_acre_pe",
"standards_review_other_standards_review_fee_fill_in_the_bla_001",
"variance_minor_variance_additional_fee_3",
"zone_change_annexation_non_discretionary_fee_definition_as_your",
"zone_change_annexation_non_discretionary_additional_fee_3",
"zone_change_annexation_non_discretionary_additional_fee_1",
"region",
"appeals",
"comprehensive_plan_amendment",
"standards_review",
"design_review",
"marijuana_land_use",
"hearings",
"zone_change",
"site_plan_review",
"partitions",
"adjustment_review_major_adjustment_additional_fee_3",
"adjustment_review_major_adjustment_additional_fee_2",
"adjustment_review_major_adjustment_additional_notes",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_003",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_004",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_005",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_006",
"annexation_annexation_additional_fee_3",
"annexation_other_annexation_fee_fill_in_the_blank_additiona_000",
"appeals_appeals_to_city_council_additional_fee_2",
"appeals_appeals_to_city_council_additional_fee_3",
"appeals_appeals_to_planning_commission_additional_fee_3",
"appeals_minor_appeals_additional_fee_2",
"appeals_minor_appeals_additional_fee_3",
"appeals_minor_appeals_additional_fee_1",
"appeals_major_appeals_additional_fee_2",
"appeals_other_appeals_fee_fill_in_the_blank_additional_fee__000",
"appeals_other_appeals_fee_fill_in_the_blank_additional_fee__001",
"appeals_other_appeals_fee_fill_in_the_blank_additional_notes",
"appeals_other_appeals_fee_fill_in_the_blank_additional_fee__002",
"application_modification_application_modification_pricing_metho",
"application_modification_application_modification_additiona_000",
"application_modification_application_modification_additiona_001",
"application_modification_application_modification_additiona_002",
"design_review_design_compliance_letter_additional_notes",
"annexation_other_annexation_fee_fill_in_the_blank_additiona_001",
"appeals_appeals_to_city_council_base_fee_dollars",
"comprehensive_plan_amendment_amendment_with_rezone_base_fee_dol",
"comprehensive_plan_amendment_amendment_without_rezone_addit_002",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__003",
"conditional_use_major_modification_base_fee_dollars",
"design_review_design_review_type_2_additional_fee_2",
"design_review_other_design_review_fee_fill_in_the_blank_base_fe",
"historic_review_other_historic_review_fee_fill_in_the_blank_000",
"land_division_preliminary_subdivision_base_fee_dollars",
"marijuana_land_use_review_marijuana_land_use_review_pricing_met",
"site_plan_review_projects_valued_over_100_000_base_fee_dollars",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_000",
"variance_major_variance_additional_fee_1",
"zone_change_annexation_non_discretionary_pricing_method_i_e_bas",
"adjustment_review_minor_adjustment_base_fee_dollars",
"adjustment_review_major_adjustment_pricing_method_i_e_base_fee_",
"annexation_annexation_base_fee_dollars",
"annexation_annexation_additional_notes",
"appeals_other_appeals_fee_fill_in_the_blank_text",
"application_modification_application_modification_fee_definitio",
"application_modification_application_modification_base_fee_doll",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__004",
"conditional_use_major_modification_fee_definition_as_your_city_",
"conditional_use_minor_modification_additional_fee_1",
"conditional_use_new_conditional_use_pricing_method_i_e_base_fee",
"conditional_use_planned_unit_development_fee_definition_as_your",
"conditional_use_planned_unit_development_base_fee_dollars",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_002",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_003",
"design_review_design_review_type_2_base_fee_dollars",
"design_review_other_design_review_fee_fill_in_the_blank_fee_def",
"design_review_other_design_review_fee_fill_in_the_blank_text",
"land_division_preliminary_partition_base_fee_dollars",
"land_division_final_partition_base_fee_dollars",
"land_division_preliminary_subdivision_pricing_method_i_e_base_f",
"land_division_preliminary_subdivision_additional_notes",
"land_division_other_land_division_fee_fill_in_the_blank_text",
"partition_permanent_partition_base_fee_dollars",
"partition_other_partition_fee_fill_in_the_blank_text",
"site_plan_review_projects_valued_under_12_500_base_fee_dollars",
"site_plan_review_projects_value_between_12_500_25_000_fee_defin",
"site_plan_review_projects_value_between_25_000_50_00_fee_defini",
"site_plan_review_projects_valued_over_100_000_fee_definition_as",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_001",
"standards_review_standards_review_base_fee_dollars",
"variance_minor_variance_fee_definition_as_your_city_defines_it",
"variance_major_variance_fee_definition_as_your_city_defines_it",
"variance_major_variance_base_fee_dollars",
"variance_major_variance_additional_fee_2",
"variance_other_variance_fee_fill_in_the_blank_fee_definition_as",
"variance_other_variance_fee_fill_in_the_blank_text",
"zone_change_quasi_judicial_base_fee_dollars",
"conditional_use_new_conditional_use_additional_fee_2",
"conditional_use_planned_unit_development_additional_fee_3",
"design_review_design_compliance_letter_fee_definition_as_your_c",
"design_review_design_compliance_letter_pricing_method_i_e_base_",
"design_review_design_compliance_letter_base_fee_dollars",
"design_review_design_compliance_letter_additional_fee_2",
"design_review_design_review_type_1_pricing_method_i_e_base_fee_",
"design_review_design_review_type_2_fee_definition_as_your_city_",
"design_review_other_design_review_fee_fill_in_the_blank_pricing",
"design_review_other_design_review_fee_fill_in_the_blank_add_000",
"hearings_hearings_base_fee_dollars",
"hearings_hearings_additional_fee_1",
"hearings_other_hearings_fee_fill_in_the_blank_additional_fe_000",
"hearings_other_hearings_fee_fill_in_the_blank_pricing_method_i_",
"hearings_other_hearings_fee_fill_in_the_blank_base_fee_dollars",
"hearings_other_hearings_fee_fill_in_the_blank_fee_definition_as",
"hearings_hearings_additional_fee_3",
"historic_review_alterations_additional_fee_2",
"historic_review_alterations_additional_notes",
"historic_review_demolition_additional_fee_1",
"historic_review_demolition_pricing_method_i_e_base_fee_per_acre",
"historic_review_emergency_demolition_additional_notes",
"historic_review_new_construction_in_historic_distrcit_addit_000",
"historic_review_new_construction_in_historic_distrcit_addit_001",
"historic_review_removal_of_designation_additional_notes",
"historic_review_other_historic_review_fee_fill_in_the_blank_001",
"historic_review_removal_of_designation_pricing_method_i_e_base_",
"land_division_preliminary_partition_additional_fee_3",
"land_division_preliminary_partition_additional_notes",
"land_division_final_partition_additional_notes",
"land_division_final_partition_pricing_method_i_e_base_fee_per_a",
"land_division_preliminary_subdivision_additional_fee_3",
"land_division_final_subdivision_additional_fee_2",
"land_division_final_subdivision_additional_fee_3",
"land_division_replat_pricing_method_i_e_base_fee_per_acre_per_l",
"land_division_other_land_division_fee_fill_in_the_blank_base_fe",
"land_division_other_land_division_fee_fill_in_the_blank_add_000",
"marijuana_land_use_review_marijuana_land_use_review_additio_000",
"marijuana_land_use_review_other_marijuana_land_use_review_f_000",
"partition_tentative_partition_fee_definition_as_your_city_defin",
"partition_permanent_partition_additional_fee_1",
"partition_permanent_partition_additional_fee_2",
"partition_permanent_partition_additional_fee_3",
"partition_other_partition_fee_fill_in_the_blank_pricing_method_",
"partition_other_partition_fee_fill_in_the_blank_additional__000",
"site_plan_review_pre_site_plan_approval_additional_fee_1",
"site_plan_review_pre_site_plan_approval_base_fee_dollars",
"site_plan_review_pre_site_plan_approval_additional_fee_2",
"site_plan_review_projects_valued_under_12_500_fee_definition_as",
"site_plan_review_pre_site_plan_approval_additional_fee_3",
"site_plan_review_projects_valued_under_12_500_pricing_method_i_",
"site_plan_review_projects_valued_under_12_500_additional_fe_000",
"site_plan_review_projects_value_between_25_000_50_00_base_fee_d",
"site_plan_review_projects_value_between_12_500_25_000_addit_002",
"site_plan_review_projects_value_between_12_500_25_000_pricing_m",
"site_plan_review_projects_value_between_12_500_25_000_addit_003",
"site_plan_review_projects_value_between_25_000_50_00_additi_000",
"site_plan_review_projects_value_between_25_000_50_00_additi_001",
"site_plan_review_projects_value_between_50_000_100_000_addi_000",
"site_plan_review_projects_value_between_50_000_100_000_pricing_",
"site_plan_review_projects_value_between_50_000_100_000_addi_001",
"site_plan_review_projects_value_between_50_000_100_000_addi_002",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_002",
"site_plan_review_projects_valued_over_100_000_additional_notes",
"site_plan_review_projects_valued_over_100_000_additional_fe_000",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_003",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_004",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_005",
"standards_review_standards_review_additional_fee_1",
"standards_review_other_standards_review_fee_fill_in_the_bla_002",
"standards_review_other_standards_review_fee_fill_in_the_bla_003",
"standards_review_other_standards_review_fee_fill_in_the_bla_004",
"variance_major_variance_additional_fee_3",
"variance_other_variance_fee_fill_in_the_blank_additional_fe_000",
"variance_other_variance_fee_fill_in_the_blank_additional_notes",
"zone_change_quasi_judicial_additional_fee_1",
"zone_change_quasi_judicial_additional_notes",
"zone_change_annexation_discretionary_fee_definition_as_your_cit",
"zone_change_legislative_additional_fee_3",
"zone_change_annexation_discretionary_pricing_method_i_e_base_fe",
"zone_change_annexation_non_discretionary_additional_fee_2",
"zone_change_other_zone_change_fee_fill_in_the_blank_text",
"zone_change_other_zone_change_fee_fill_in_the_blank_additio_000",
"zone_change_other_zone_change_fee_fill_in_the_blank_additio_001",
"comprehensive_plan_amendment_amendment_without_rezone_base_fee_",
"comprehensive_plan_amendment_amendment_without_rezone_addit_003",
"application_modification_other_application_modification_fil_002",
"comprehensive_plan_amendment_amendment_with_rezone_addition_002",
"comprehensive_plan_amendment_amendment_with_rezone_pricing_meth",
"appeals_other_appeals_fee_fill_in_the_blank_fee_definition_as_y",
"appeals_major_appeals_pricing_method_i_e_base_fee_per_acre_per_",
"appeals_major_appeals_base_fee_dollars",
"application_modification_application_modification_additiona_003",
"application_modification_other_application_modification_fil_003",
"application_modification_other_application_modification_fil_004",
"application_modification_other_application_modification_fil_005",
"appeals_appeals_to_city_council_additional_fee_1",
"application_modification_other_application_modification_fil_006",
"appeals_minor_appeals_base_fee_dollars",
"appeals_major_appeals_fee_definition_as_your_city_defines_it",
"appeals_minor_appeals_fee_definition_as_your_city_defines_it",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_004",
"application_modification_other_application_modification_fil_007",
"appeals_major_appeals_additional_notes",
"appeals_major_appeals_additional_fee_1",
"appeals_other_appeals_fee_fill_in_the_blank_base_fee_dollars",
"conditional_use_major_modification_additional_fee_3",
"appeals_other_appeals_fee_fill_in_the_blank_pricing_method_i_e_",
"appeals_minor_appeals_additional_notes",
"appeals_appeals_to_planning_commission_additional_fee_1",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_005",
"appeals_appeals_to_planning_commission_pricing_method_i_e_base_",
"appeals_minor_appeals_pricing_method_i_e_base_fee_per_acre_per_",
"appeals_appeals_to_planning_commission_additional_notes",
"appeals_appeals_to_city_council_pricing_method_i_e_base_fee_per",
"appeals_appeals_to_city_council_fee_definition_as_your_city_def",
"appeals_appeals_to_city_council_additional_notes",
"appeals_appeals_to_planning_commission_fee_definition_as_your_c",
"design_review_design_compliance_letter_additional_fee_3",
"design_review_design_compliance_letter_additional_fee_1",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_006",
"conditional_use_planned_unit_development_additional_fee_2",
"conditional_use_planned_unit_development_additional_notes",
"conditional_use_other_conditional_use_fee_fill_in_the_blank_007",
"zone_change_annexation_discretionary_additional_notes",
"zone_change_quasi_judicial_additional_fee_2",
"zone_change_quasi_judicial_pricing_method_i_e_base_fee_per_acre",
"variance_major_variance_pricing_method_i_e_base_fee_per_acre_pe",
"standards_review_other_standards_review_fee_fill_in_the_bla_005",
"standards_review_other_standards_review_fee_fill_in_the_bla_006",
"standards_review_other_standards_review_fee_fill_in_the_bla_007",
"standards_review_standards_review_additional_notes",
"site_plan_review_projects_valued_over_100_000_additional_fe_001",
"site_plan_review_projects_value_between_50_000_100_000_addi_003",
"partition_permanent_partition_fee_definition_as_your_city_defin",
"marijuana_land_use_review_other_marijuana_land_use_review_f_001",
"marijuana_land_use_review_other_marijuana_land_use_review_f_002",
"marijuana_land_use_review_marijuana_land_use_review_base_fee_do",
"land_division_replat_additional_fee_3",
"land_division_replat_base_fee_dollars",
"historic_review_other_historic_review_fee_fill_in_the_blank_002",
"historic_review_removal_of_designation_fee_definition_as_your_c",
"historic_review_new_construction_in_historic_distrcit_addit_002",
"historic_review_new_construction_in_historic_distrcit_addit_003",
"historic_review_new_construction_in_historic_distrcit_pricing_m",
"historic_review_alterations_additional_fee_1",
"historic_review_alterations_pricing_method_i_e_base_fee_per_acr",
"design_review_other_design_review_fee_fill_in_the_blank_add_001",
"design_review_design_review_type_2_additional_fee_3",
"design_review_design_review_type_2_pricing_method_i_e_base_fee_",
"conditional_use_new_conditional_use_additional_fee_3",
"conditional_use_planned_unit_development_pricing_method_i_e_bas",
"conditional_use_new_conditional_use_fee_definition_as_your_city",
"conditional_use_new_conditional_use_additional_fee_1",
"conditional_use_minor_modification_additional_fee_3",
"conditional_use_major_modification_additional_notes",
"conditional_use_major_modification_additional_fee_2",
"conditional_use_major_modification_additional_fee_1",
"marijuana_land_use_review_other_marijuana_land_use_review_f_003",
"partition_tentative_partition_pricing_method_i_e_base_fee_per_a",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__005",
"adjustment_review_other_adjustment_review_fee_fill_in_the_b_007",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__006",
"annexation_annexation_additional_fee_1",
"annexation_other_annexation_fee_fill_in_the_blank_base_fee_doll",
"annexation_other_annexation_fee_fill_in_the_blank_pricing_metho",
"annexation_other_annexation_fee_fill_in_the_blank_fee_definitio",
"annexation_other_annexation_fee_fill_in_the_blank_additiona_002",
"annexation_other_annexation_fee_fill_in_the_blank_additiona_003",
"application_modification",
"adjustment_review",
"site_plan_review_projects_value_between_25_000_50_00_additi_002",
"annexation_annexation_additional_fee_2",
"adjustment_review_minor_adjustment_additional_notes",
"adjustment_review_major_adjustment_additional_fee_1",
"adjustment_review_major_adjustment_base_fee_dollars",
"qcode",
"historic_review",
"conditional_use",
"site_plan_review_projects_value_between_25_000_50_00_pricing_me",
"land_divisions",
"city",
"annexation",
"site_plan_review_projects_valued_under_12_500_additional_fe_001",
"site_plan_review_projects_value_between_50_000_100_000_base_fee",
"site_plan_review_projects_valued_under_12_500_additional_fe_002",
"site_plan_review_projects_value_between_25_000_50_00_additi_003",
"site_plan_review_projects_value_between_50_000_100_000_fee_defi",
"site_plan_review_projects_value_between_12_500_25_000_base_fee_",
"marijuana_land_use_review_other_marijuana_land_use_review_f_004",
"partition_tentative_partition_additional_fee_2",
"site_plan_review_projects_valued_under_12_500_additional_notes",
"site_plan_review_pre_site_plan_approval_fee_definition_as_your_",
"partition_other_partition_fee_fill_in_the_blank_base_fee_dollar",
"partition_tentative_partition_additional_fee_3",
"partition_permanent_partition_additional_notes",
"partition_other_partition_fee_fill_in_the_blank_fee_definition_",
"partition_other_partition_fee_fill_in_the_blank_additional__001",
"historic_review_demolition_additional_fee_2",
"historic_review_emergency_demolition_additional_fee_1",
"partition_other_partition_fee_fill_in_the_blank_additional__002",
"partition_other_partition_fee_fill_in_the_blank_additional__003",
"partition_permanent_partition_pricing_method_i_e_base_fee_per_a",
"partition_tentative_partition_additional_notes",
"marijuana_land_use_review_other_marijuana_land_use_review_f_005",
"historic_review_demolition_additional_notes",
"hearings_other_hearings_fee_fill_in_the_blank_additional_fe_001",
"historic_review_alterations_fee_definition_as_your_city_defines",
"partition_tentative_partition_additional_fee_1",
"partition_tentative_partition_base_fee_dollars",
"marijuana_land_use_review_marijuana_land_use_review_additio_001",
"marijuana_land_use_review_marijuana_land_use_review_additio_002",
"marijuana_land_use_review_marijuana_land_use_review_additio_003",
"marijuana_land_use_review_other_marijuana_land_use_review_f_006",
"marijuana_land_use_review_other_marijuana_land_use_review_f_007",
"site_plan_review_projects_valued_over_100_000_additional_fe_002",
"site_plan_review_projects_valued_over_100_000_pricing_method_i_",
"historic_review_emergency_demolition_additional_fee_3",
"historic_review_other_historic_review_fee_fill_in_the_blank_003",
"historic_review_new_construction_in_historic_distrcit_base_fee_",
"hearings_other_hearings_fee_fill_in_the_blank_text",
"hearings_hearings_additional_fee_2",
"design_review_design_review_type_1_additional_fee_3",
"hearings_hearings_additional_notes",
"design_review_other_design_review_fee_fill_in_the_blank_add_002",
"hearings_hearings_fee_definition_as_your_city_defines_it",
"design_review_design_review_type_1_base_fee_dollars",
"design_review_design_review_type_1_additional_fee_1",
"land_division_other_land_division_fee_fill_in_the_blank_add_001",
"design_review_design_review_type_1_additional_fee_2",
"marijuana_land_use_review_marijuana_land_use_review_fee_definit",
"land_division_replat_additional_notes",
"land_division_other_land_division_fee_fill_in_the_blank_add_002",
"land_division_replat_additional_fee_1",
"land_division_replat_additional_fee_2",
"land_division_other_land_division_fee_fill_in_the_blank_pricing",
"land_division_other_land_division_fee_fill_in_the_blank_fee_def",
"land_division_final_subdivision_base_fee_dollars",
"land_division_final_subdivision_additional_fee_1",
"land_division_final_subdivision_additional_notes",
"land_division_replat_fee_definition_as_your_city_defines_it",
"land_division_preliminary_subdivision_additional_fee_1",
"land_division_preliminary_subdivision_additional_fee_2",
"land_division_final_subdivision_fee_definition_as_your_city_def",
"land_division_final_subdivision_pricing_method_i_e_base_fee_per",
"historic_review_removal_of_designation_additional_fee_3",
"land_division_final_partition_fee_definition_as_your_city_defin",
"land_division_preliminary_subdivision_fee_definition_as_your_ci",
"land_division_preliminary_partition_pricing_method_i_e_base_fee",
"land_division_preliminary_partition_fee_definition_as_your_city",
"land_division_preliminary_partition_additional_fee_2",
"historic_review_other_historic_review_fee_fill_in_the_blank_004",
"historic_review_other_historic_review_fee_fill_in_the_blank_005",
"historic_review_other_historic_review_fee_fill_in_the_blank_006",
"historic_review_removal_of_designation_additional_fee_2",
"historic_review_other_historic_review_fee_fill_in_the_blank_007",
"historic_review_removal_of_designation_base_fee_dollars",
"zone_change_annexation_discretionary_additional_fee_2",
"zone_change_quasi_judicial_additional_fee_3",
"zone_change_legislative_additional_fee_2",
"variance_minor_variance_additional_fee_2",
"comprehensive_plan_amendment_other_comp_plan_amendment_fee__007",
"zone_change_other_zone_change_fee_fill_in_the_blank_base_fee_do",
"zone_change_other_zone_change_fee_fill_in_the_blank_additio_002",
"zone_change_other_zone_change_fee_fill_in_the_blank_fee_definit",
"zone_change_other_zone_change_fee_fill_in_the_blank_pricing_met",
"zone_change_other_zone_change_fee_fill_in_the_blank_additio_003",
"zone_change_annexation_non_discretionary_additional_notes",
"zone_change_legislative_additional_notes",
"zone_change_annexation_discretionary_additional_fee_3",
"zone_change_annexation_discretionary_base_fee_dollars",
"zone_change_annexation_discretionary_additional_fee_1",
"zone_change_legislative_fee_definition_as_your_city_defines_it",
"zone_change_legislative_additional_fee_1",
"zone_change_legislative_pricing_method_i_e_base_fee_per_acre_pe",
"zone_change_legislative_base_fee_dollars",
"variance_other_variance_fee_fill_in_the_blank_additional_fe_001",
"variance_other_variance_fee_fill_in_the_blank_base_fee_dollars",
"variance_other_variance_fee_fill_in_the_blank_additional_fe_002",
"variance_major_variance_additional_notes",
"variance_other_variance_fee_fill_in_the_blank_pricing_method_i_",
"variance_minor_variance_additional_notes",
"variance_minor_variance_additional_fee_1",
"variance_minor_variance_base_fee_dollars",
"standards_review_standards_review_pricing_method_i_e_base_fee_p",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_006",
"zone_change_quasi_judicial_fee_definition_as_your_city_defines_",
"appeals_major_appeals_additional_fee_3",
"comprehensive_plan_amendment_amendment_without_rezone_fee_defin",
"standards_review_standards_review_fee_definition_as_your_city_d",
"site_plan_review_other_site_plan_review_fee_fill_in_the_bla_007",
"comprehensive_plan_amendment_amendment_with_rezone_addition_003",
"conditional_use_new_conditional_use_base_fee_dollars",
"conditional_use_minor_modification_additional_fee_2",
"conditional_use_minor_modification_pricing_method_i_e_base_fee_",
"conditional_use_major_modification_pricing_method_i_e_base_fee_",
"historic_review_demolition_additional_fee_3",
"historic_review_emergency_demolition_fee_definition_as_your_cit",
"historic_review_emergency_demolition_base_fee_dollars",
"historic_review_emergency_demolition_pricing_method_i_e_base_fe",
"historic_review_alterations_base_fee_dollars",
"historic_review_demolition_base_fee_dollars",
"historic_review_demolition_fee_definition_as_your_city_defines_",
"hearings_other_hearings_fee_fill_in_the_blank_additional_fe_002",
"hearings_other_hearings_fee_fill_in_the_blank_additional_notes",
"hearings_hearings_pricing_method_i_e_base_fee_per_acre_per_lot_",
"design_review_other_design_review_fee_fill_in_the_blank_add_003",
"design_review_design_review_type_2_additional_notes",
"design_review_design_review_type_2_additional_fee_1",
"design_review_design_review_type_1_additional_notes",
"land_division_other_land_division_fee_fill_in_the_blank_add_003"
FROM
"orcities/development-fees-data-2017-twzh-bmv4:latest"."development_fees_data_2017"
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 orcities/development-fees-data-2017-twzh-bmv4
with SQL in under 60 seconds.
This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.orcities.org. When you queryorcities/development-fees-data-2017-twzh-bmv4: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
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; sgr
can 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 clone
and sgr checkout
.
Mounting Data
This repository is an external repository. It's not hosted by Splitgraph. It is hosted by data.orcities.org, 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 \
"orcities/development-fees-data-2017-twzh-bmv4" \
--handler-options '{
"domain": "data.orcities.org",
"tables": {
"development_fees_data_2017": "twzh-bmv4"
}
}'
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, orcities/development-fees-data-2017-twzh-bmv4
is just another Postgres schema.