superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 736
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11731 | 11731 | 11730 | {"type": "Polygon", "coordinates": [[[-121.05053, 40.29888], [-121.05041, 40.29896], [-121.05002, 40.29909], [-121.04992, 40.29928], [-121.04993, 40.3001], [-121.04991, 40.30054], [-121.04995, 40.30076], [-121.05009, 40.3012], [-121.05036, 40.3026], [-121.05035, 40.30285], [-121.05022, 40.30338], [-121.04992, 40.30358], [-121.04899, 40.30369], [-121.04872, 40.30348], [-121.04859, 40.30305], [-121.04872, 40.30279], [-121.04882, 40.3025], [-121.04853, 40.30131], [-121.04835, 40.30045], [-121.04823, 40.29965], [-121.04858, 40.29925], [-121.05, 40.29859], [-121.05053, 40.29888]]]} | Open Access 1 | Clear Creek Park | 28335 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 17.372 | Clear Creek Park | ||
11772 | 11772 | 11771 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | Lake Forest Park | 28418 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 0.17 | Lake Forest Park | ||
11785 | 11785 | 11784 | {"type": "Polygon", "coordinates": [[[-120.52341, 40.29987], [-120.52322, 40.30012], [-120.52303, 40.30027], [-120.52307, 40.30052], [-120.52318, 40.3009], [-120.52313, 40.30104], [-120.52303, 40.3011], [-120.52292, 40.30119], [-120.52286, 40.30126], [-120.52242, 40.30161], [-120.52148, 40.30112], [-120.52143, 40.30107], [-120.52173, 40.3007], [-120.52205, 40.30035], [-120.52233, 40.29995], [-120.5226, 40.29976], [-120.5227, 40.29966], [-120.5231, 40.29967], [-120.52341, 40.29987]]]} | Open Access 1 | Janesville Park | 28404 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 4.809 | Janesville Park | ||
11794 | 11794 | 11793 | {"type": "Polygon", "coordinates": [[[-120.52303, 40.3739], [-120.52281, 40.37423], [-120.52276, 40.37436], [-120.52276, 40.37472], [-120.5228, 40.37498], [-120.52221, 40.37504], [-120.52204, 40.37449], [-120.52192, 40.37367], [-120.52292, 40.37384], [-120.52292, 40.37388], [-120.52303, 40.3739]]]} | Open Access 1 | Leavitt Lake Park | 28422 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 2.293 | Leavitt Lake Park |
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]);