Government Community Support Services

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "gis_object_id" BIGINT,
  "anchor_name" VARCHAR,
  "address" VARCHAR,
  "building_number" BIGINT,
  "street_pre_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "street_post_direction" VARCHAR,
  "city" VARCHAR,
  "state_abbreviation" VARCHAR,
  "zip_code" BIGINT,
  "zip_plus_4" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "institution_category_coded" BIGINT,
  "broadband_service" VARCHAR,
  "public_wifi" VARCHAR,
  "url" VARCHAR,
  "technology_of_transmission_coded" BIGINT,
  "download_speed_coded" VARCHAR,
  "upload_speed_coded" VARCHAR,
  "full_fips_id" BIGINT,
  "cai_id" DOUBLE,
  "priority" BIGINT,
  "btop_participant" VARCHAR,
  "source" VARCHAR,
  "sub_category" BIGINT,
  "county" VARCHAR,
  "comments" VARCHAR,
  "cai_type" VARCHAR,
  "last_update" VARCHAR,
  "update_comment" VARCHAR,
  "auto_id" BIGINT,
  "public_computer_available" VARCHAR,
  "number_of_public_computers" VARCHAR,
  "institution_category" VARCHAR,
  "technology_of_transmission" VARCHAR,
  "download_speed" VARCHAR,
  "upload_speed" VARCHAR,
  "common_name" VARCHAR,
  "wifi_type" VARCHAR,
  "suite_number" VARCHAR,
  "census_feature_class_code" VARCHAR,
  "census_functional_status" VARCHAR,
  "state_fips_code" BIGINT,
  "county_fips" BIGINT,
  "census_tract_id" BIGINT,
  "census_block_id" BIGINT
);