superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "1829.882", MNG_AGENCY = 468 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 1 ✖
MNG_AGENCY 1
- Santa Clara Valley Open Space Authority · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14772 | 14772 | 14771 | {"type": "Polygon", "coordinates": [[[-121.72757, 37.22352], [-121.71451, 37.23235], [-121.71451, 37.23237], [-121.7172, 37.23464], [-121.70907, 37.23466], [-121.70896, 37.22767], [-121.68349, 37.20613], [-121.66781, 37.20618], [-121.67335, 37.20336], [-121.67909, 37.20242], [-121.67911, 37.20067], [-121.69238, 37.20067], [-121.70295, 37.20346], [-121.70715, 37.20748], [-121.71486, 37.20753], [-121.71586, 37.20847], [-121.71755, 37.20724], [-121.71888, 37.2083], [-121.72, 37.20859], [-121.72022, 37.20878], [-121.71982, 37.20963], [-121.71971, 37.21025], [-121.71957, 37.21069], [-121.71982, 37.21106], [-121.71977, 37.21155], [-121.71979, 37.21168], [-121.71983, 37.21181], [-121.7199, 37.21193], [-121.71999, 37.21205], [-121.72039, 37.21246], [-121.72062, 37.21273], [-121.72078, 37.21297], [-121.72108, 37.21354], [-121.72124, 37.21377], [-121.72235, 37.2151], [-121.72259, 37.21534], [-121.72293, 37.21562], [-121.7233, 37.21586], [-121.72358, 37.216], [-121.72322, 37.21628], [-121.72303, 37.21652], [-121.72234, 37.21764], [-121.72235, 37.21797], [-121.72757, 37.22352]]]} | No Public Access 3 | Coyote Ridge Open Space Preserve | http://www.openspaceauthority.org/ | 31566 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 1829.882 | Coyote Ridge OSP | 2015 |
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]);