superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 661 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2883 | 2883 | 2882 | {"type": "Polygon", "coordinates": [[[-124.20362, 41.75891], [-124.20165, 41.7589], [-124.20165, 41.75859], [-124.20151, 41.75858], [-124.20151, 41.75823], [-124.20234, 41.75823], [-124.20182, 41.75767], [-124.20212, 41.75756], [-124.20212, 41.75755], [-124.20205, 41.75746], [-124.2025, 41.7572], [-124.20347, 41.75822], [-124.2035, 41.75824], [-124.20362, 41.75824], [-124.20362, 41.75891]]]} | Open Access 1 | Pyke Field | 32981 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 5.197 | Pyke Field | ||
4274 | 4274 | 4273 | {"type": "Polygon", "coordinates": [[[-124.15163, 41.80908], [-124.15102, 41.809], [-124.15049, 41.80888], [-124.1496, 41.80854], [-124.14788, 41.80801], [-124.14838, 41.80521], [-124.15153, 41.80524], [-124.15163, 41.80908]]]} | Open Access 1 | Florence Keller Park | 18961 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 26.848 | Florence Keller Park | ||
5652 | 5652 | 5651 | {"type": "Polygon", "coordinates": [[[-124.20572, 41.97312], [-124.20571, 41.97334], [-124.20565, 41.97363], [-124.20569, 41.97397], [-124.20568, 41.97417], [-124.20317, 41.97415], [-124.20314, 41.9731], [-124.20572, 41.97312]]]} | Open Access 1 | Kamph Memorial Park | 20548 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 6.048 | Kamph Memorial Park | ||
5687 | 5687 | 5686 | {"type": "Polygon", "coordinates": [[[-124.21314, 41.8682], [-124.213, 41.86893], [-124.21297, 41.86902], [-124.21287, 41.86916], [-124.21219, 41.86918], [-124.21116, 41.86925], [-124.21155, 41.8682], [-124.21314, 41.86807], [-124.21314, 41.8682]]]} | Unknown Access 4 | Kellogg Beach | 20579 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 4.007 | Kellogg Beach | ||
11714 | 11714 | 11713 | {"type": "Polygon", "coordinates": [[[-124.15565, 41.74626], [-124.15565, 41.74659], [-124.15543, 41.7466], [-124.15543, 41.74692], [-124.15471, 41.74692], [-124.15467, 41.74626], [-124.15565, 41.74626]]]} | Open Access 1 | Bertsch Tract Park | 28317 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 1.282 | Bertsch Tract 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]);