superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 435 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8623 | 8623 | 8622 | {"type": "Polygon", "coordinates": [[[-121.64413, 39.16632], [-121.64419, 39.16629], [-121.64451, 39.16629], [-121.64484, 39.16633], [-121.64514, 39.16644], [-121.64532, 39.16654], [-121.64547, 39.16667], [-121.64559, 39.16681], [-121.64568, 39.16697], [-121.64574, 39.16714], [-121.64576, 39.16731], [-121.64574, 39.16749], [-121.64568, 39.16765], [-121.64559, 39.16781], [-121.64546, 39.16795], [-121.64531, 39.16808], [-121.64513, 39.16818], [-121.64493, 39.16826], [-121.64461, 39.16832], [-121.64417, 39.16833], [-121.64412, 39.16832], [-121.64406, 39.16826], [-121.64406, 39.16807], [-121.6441, 39.16805], [-121.6441, 39.16788], [-121.64412, 39.16782], [-121.64417, 39.16776], [-121.64426, 39.16771], [-121.64435, 39.16764], [-121.6444, 39.16755], [-121.64442, 39.16746], [-121.64438, 39.16731], [-121.64431, 39.16723], [-121.64417, 39.16712], [-121.64411, 39.16699], [-121.6441, 39.16637], [-121.64413, 39.16632]]]} | Open Access 1 | Regency Park | 24272 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 6.256 | Regency Park | ||
11016 | 11016 | 11015 | {"type": "Polygon", "coordinates": [[[-121.648, 39.12179], [-121.64799, 39.12316], [-121.64623, 39.12317], [-121.64624, 39.1218], [-121.648, 39.12179]]]} | Open Access 1 | Walton Park | 27249 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 5.739 | Walton Park | ||
4889 | 4889 | 4888 | {"type": "Polygon", "coordinates": [[[-121.64956, 39.10344], [-121.64952, 39.10348], [-121.64949, 39.10348], [-121.64721, 39.10349], [-121.64717, 39.10348], [-121.64714, 39.10343], [-121.64712, 39.10229], [-121.64715, 39.10226], [-121.64938, 39.10226], [-121.64942, 39.1023], [-121.64945, 39.10304], [-121.64956, 39.10344]]]} | Open Access 1 | Happy Park | 19657 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 6.765 | Happy 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]);