superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "6.773" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8334 | 8334 | 8333 | {"type": "Polygon", "coordinates": [[[-118.09479, 34.04329], [-118.0943, 34.04412], [-118.09333, 34.04555], [-118.09247, 34.04517], [-118.09386, 34.04287], [-118.09445, 34.04311], [-118.09479, 34.04329]]]} | Open Access 1 | Potrero Heights Park | 23924 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 6.773 | Potrero Heights Park | ||
10168 | 10168 | 10167 | {"type": "Polygon", "coordinates": [[[-121.41932, 38.54467], [-121.41929, 38.54649], [-121.41847, 38.54648], [-121.41702, 38.54466], [-121.41932, 38.54467]]]} | Open Access 1 | Tahoe Tallac Park | 26168 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.773 | Tahoe Tallac Park | ||
11497 | 11497 | 11496 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91927, 34.1209], [-117.91984, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | Zacatecas Park | 27850 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 6.773 | Zacatecas 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]);