Calls For Service (2012-2015)
City of Tempe
@usgov.city_of_tempe_calls_for_service_2012_2015
City of Tempe
@usgov.city_of_tempe_calls_for_service_2012_2015
CREATE TABLE table_1 (
"x" BIGINT,
"y" BIGINT,
"objectid" BIGINT,
"primarykey" VARCHAR,
"occurrencedatetime" TIMESTAMP,
"occurrenceyear" BIGINT,
"occurrencemonth" BIGINT,
"occurrencehour" BIGINT,
"occurrenceweek" BIGINT,
"occurrencedatepart" BIGINT,
"occurrenceweekday" VARCHAR,
"obfuscatedaddress" VARCHAR,
"xcoordinate" BIGINT,
"ycoordinate" BIGINT,
"disclaimer" VARCHAR,
"placename" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"characterarea" VARCHAR,
"reportdistrict" VARCHAR,
"reportbeat" VARCHAR,
"postalcode" DOUBLE,
"censustractid" DOUBLE
);
Anyone who has the link will be able to view this.