UTILITIESCOMMUNICATION GrateInlet

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "ancillaryrole" BIGINT,
  "enabled" BIGINT,
  "drainage_id" BIGINT,
  "jtx_jobid" DOUBLE,
  "rotation" DOUBLE,
  "comments" VARCHAR,
  "date_built" VARCHAR,
  "year_built" DOUBLE,
  "year_source" VARCHAR,
  "year_abandoned" DOUBLE,
  "created_by" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "checked_by" VARCHAR,
  "watershed" VARCHAR,
  "map_index" VARCHAR,
  "mapsco" VARCHAR,
  "place_id" DOUBLE,
  "ownership" VARCHAR,
  "maintenance" VARCHAR,
  "dimen_source" VARCHAR,
  "elev_source" VARCHAR,
  "location_source" VARCHAR,
  "gps_x" DOUBLE,
  "gps_y" DOUBLE,
  "gps_source" VARCHAR,
  "gps_quality" VARCHAR,
  "top_elevation" DOUBLE,
  "surface_elevation" DOUBLE,
  "at_grade" VARCHAR,
  "material" VARCHAR,
  "sump" DOUBLE,
  "depressed" VARCHAR,
  "depression_a" DOUBLE,
  "st_length" DOUBLE,
  "st_width" DOUBLE,
  "inlet_loc" VARCHAR,
  "grate_length" DOUBLE,
  "grate_width" DOUBLE,
  "depth_to_bottom" DOUBLE,
  "grate_open_percent" DOUBLE,
  "inlet_type" VARCHAR,
  "marked" VARCHAR,
  "globalid" VARCHAR,
  "edit_status" VARCHAR,
  "fme_date" VARCHAR,
  "status" VARCHAR,
  "observation" DOUBLE,
  "modeled" VARCHAR,
  "collected_by" VARCHAR,
  "last_date_visited" VARCHAR,
  "measured_by" VARCHAR,
  "photolink" VARCHAR,
  "gps_pdop" DOUBLE,
  "gps_satqual" DOUBLE,
  "marked_date" VARCHAR,
  "catch_basket" DOUBLE,
  "gps_date" VARCHAR,
  "gps_time" VARCHAR,
  "unit" DOUBLE,
  "dem_calculated_sump" DOUBLE,
  "maximo_asset_number" DOUBLE,
  "maximo_site_id" VARCHAR
);