311 City Service Requests In 2023
District of Columbia
@usgov.district_of_columbia_311_city_service_requests_in_2023
District of Columbia
@usgov.district_of_columbia_311_city_service_requests_in_2023
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"servicerequestid" VARCHAR,
"streetaddress" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zipcode" DOUBLE,
"ward" VARCHAR,
"servicecode" VARCHAR,
"servicecodedescription" VARCHAR,
"servicetypecodedescription" VARCHAR,
"organizationacronym" VARCHAR,
"servicecallcount" BIGINT,
"adddate" TIMESTAMP,
"resolutiondate" TIMESTAMP,
"serviceduedate" TIMESTAMP,
"serviceorderdate" TIMESTAMP,
"inspectionflag" VARCHAR,
"inspectiondate" VARCHAR,
"inspectorname" VARCHAR,
"serviceorderstatus" VARCHAR,
"status_code" VARCHAR,
"details" VARCHAR,
"priority" VARCHAR,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"maraddressrepositoryid" BIGINT,
"gis_id" VARCHAR,
"globalid" VARCHAR,
"created" VARCHAR,
"edited" VARCHAR,
"gdb_from_date" TIMESTAMP,
"gdb_to_date" VARCHAR,
"gdb_archive_oid" BIGINT,
"se_anno_cad_data" VARCHAR,
"objectid" BIGINT
);
Anyone who has the link will be able to view this.