TEST Centroids For School District Maps
State of Washington
@usgov.state_of_washington_test_centroids_for_school_district_maps
State of Washington
@usgov.state_of_washington_test_centroids_for_school_district_maps
Matching file for applying coordinates to districts when crating boundary maps in Socrata. See first two columns for corrections to districts where calculated centroid is not within boundaries.
Organization: State of Washington
Last updated: 2020-11-10T17:20:45.438155
Tags: gis, map, school-district
CREATE TABLE table_1 (
"coord_change_bool" BIGINT,
"coordinate_notes" VARCHAR,
"aggregation" VARCHAR,
"ospi_code_ccddd" BIGINT -- OSPI Code (CCDDD),
"fid" BIGINT,
"name" VARCHAR,
"unsd" BIGINT,
"sdlea" BIGINT,
"lsad" DOUBLE,
"county" VARCHAR,
"esd" BIGINT,
"region" BIGINT,
"orgid" BIGINT,
"ccddd" BIGINT,
"cc" BIGINT,
"ddd" BIGINT,
"comments" VARCHAR,
"labels" VARCHAR,
"graderange" VARCHAR,
"lowgrade" VARCHAR,
"highgrade" BIGINT,
"website" VARCHAR,
"code" BIGINT,
"landarea" DOUBLE,
"shape_leng" DOUBLE,
"shape_area" DOUBLE,
"wkt_geom" VARCHAR,
"longtude" DOUBLE,
"original_long_centroid" DOUBLE,
"original_lat_centroid" DOUBLE,
"location_1" VARCHAR
);
Anyone who has the link will be able to view this.