311 Service Requests For 2006

CREATE TABLE table_1 (
  "unique_key" BIGINT,
  "created_date" VARCHAR,
  "closed_date" VARCHAR,
  "agency" VARCHAR,
  "agency_name" VARCHAR,
  "complaint_type" VARCHAR,
  "descriptor" VARCHAR,
  "location_type" VARCHAR,
  "incident_zip" VARCHAR,
  "incident_address" VARCHAR,
  "street_name" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "intersection_street_1" VARCHAR,
  "intersection_street_2" VARCHAR,
  "address_type" VARCHAR,
  "city" VARCHAR,
  "landmark" VARCHAR,
  "facility_type" VARCHAR,
  "status" VARCHAR,
  "due_date" VARCHAR,
  "resolution_action_updated_date" VARCHAR,
  "community_board" VARCHAR,
  "borough" VARCHAR,
  "x_coordinate_state_plane" DOUBLE,
  "y_coordinate_state_plane" DOUBLE,
  "park_facility_name" VARCHAR,
  "park_borough" VARCHAR,
  "school_name" VARCHAR,
  "school_number" VARCHAR,
  "school_region" VARCHAR,
  "school_code" VARCHAR,
  "school_phone_number" VARCHAR,
  "school_address" VARCHAR,
  "school_city" VARCHAR,
  "school_state" VARCHAR,
  "school_zip" VARCHAR,
  "school_not_found" VARCHAR,
  "school_or_citywide_complaint" VARCHAR,
  "vehicle_type" VARCHAR,
  "taxi_company_borough" VARCHAR,
  "taxi_pick_up_location" VARCHAR,
  "bridge_highway_name" VARCHAR,
  "bridge_highway_direction" VARCHAR,
  "road_ramp" VARCHAR,
  "bridge_highway_segment" VARCHAR,
  "garage_lot_name" VARCHAR,
  "ferry_direction" VARCHAR,
  "ferry_terminal_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);