superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where AGNCY_WEB = "http://www.icpds.com/?pid=1048" and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7886 | 7886 | 7885 | {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} | Open Access 1 | Palo Verde County Park | 23359 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 13.919 | Palo Verde County Park | ||
11812 | 11812 | 11811 | {"type": "Polygon", "coordinates": [[[-116.01947, 32.74748], [-116.01802, 32.74819], [-116.01696, 32.74871], [-116.01696, 32.74748], [-116.01947, 32.74748]]]} | Open Access 1 | Ocotillo Community Park | 28449 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 3.973 | Ocotillo Community Park | 2007 | |
14005 | 14005 | 14004 | {"type": "Polygon", "coordinates": [[[-115.69029, 32.78595], [-115.68677, 32.78484], [-115.68075, 32.78206], [-115.68075, 32.78136], [-115.68028, 32.78091], [-115.67977, 32.7807], [-115.67682, 32.77663], [-115.67557, 32.77482], [-115.67435, 32.77444], [-115.67435, 32.77433], [-115.67607, 32.77424], [-115.67688, 32.77433], [-115.67741, 32.77427], [-115.68059, 32.77846], [-115.68065, 32.77892], [-115.68081, 32.77894], [-115.6808, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-115.69029, 32.78595]], [[-115.68079, 32.78029], [-115.68077, 32.78029], [-115.68076, 32.78077], [-115.68078, 32.78079], [-115.68079, 32.78029]]]} | Open Access 1 | Sunbeam Lake Park | https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam | 32576 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 154.407 | Sunbeam Lake Park | |
14006 | 14006 | 14005 | {"type": "Polygon", "coordinates": [[[-115.69473, 32.7933], [-115.69278, 32.7933], [-115.69278, 32.79285], [-115.6934, 32.79284], [-115.69339, 32.79247], [-115.69472, 32.79247], [-115.69473, 32.7933]]]} | Open Access 1 | Robert Bates Memorial Park | http://www.seeleywaterdistrict.com/updates/robert-bates-memorial-park-upgrades | 32577 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 3.527 | Robert Bates Memorial Park | |
14406 | 14406 | 14405 | {"type": "MultiPolygon", "coordinates": [[[[-114.72351, 33.36382], [-114.72351, 33.36382], [-114.72214, 33.36582], [-114.7221, 33.36382], [-114.72351, 33.36382]]], [[[-114.73058, 33.37111], [-114.72656, 33.37111], [-114.7265, 33.36719], [-114.72216, 33.36718], [-114.72215, 33.36635], [-114.72389, 33.36382], [-114.73052, 33.36382], [-114.73058, 33.37111]]], [[[-114.73064, 33.37842], [-114.72848, 33.37842], [-114.72845, 33.3749], [-114.73062, 33.3749], [-114.73064, 33.37842]]], [[[-114.74359, 33.38218], [-114.74357, 33.38602], [-114.73924, 33.38605], [-114.73926, 33.38223], [-114.74359, 33.38218]]], [[[-114.75277, 33.39501], [-114.75277, 33.39725], [-114.75115, 33.39723], [-114.75113, 33.39677], [-114.74792, 33.39672], [-114.74793, 33.39445], [-114.7506, 33.39452], [-114.75062, 33.39407], [-114.75223, 33.39411], [-114.75224, 33.39499], [-114.75277, 33.39501]]]]} | Open Access 1 | Unnamed Site - Imperial, County of | 33710 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 202.853 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);