superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2 and LABEL_NAME = "Minton"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7028 | 7028 | 7027 | {"type": "Polygon", "coordinates": [[[-122.20851, 37.20799], [-122.19951, 37.20811], [-122.19945, 37.20114], [-122.20078, 37.20112], [-122.20302, 37.20112], [-122.20315, 37.20121], [-122.20326, 37.20133], [-122.20386, 37.20156], [-122.20393, 37.20167], [-122.20396, 37.20179], [-122.20389, 37.20192], [-122.20365, 37.2021], [-122.20328, 37.20232], [-122.20324, 37.2024], [-122.20329, 37.20246], [-122.20342, 37.2025], [-122.20429, 37.2026], [-122.2047, 37.20269], [-122.20484, 37.20279], [-122.20485, 37.20287], [-122.20482, 37.20295], [-122.20458, 37.20319], [-122.20444, 37.20343], [-122.20457, 37.20383], [-122.20451, 37.20394], [-122.2044, 37.20408], [-122.20434, 37.20426], [-122.20434, 37.20436], [-122.20446, 37.20473], [-122.20473, 37.20519], [-122.20481, 37.20526], [-122.2049, 37.2053], [-122.20533, 37.20541], [-122.20539, 37.20553], [-122.20543, 37.2057], [-122.20549, 37.20585], [-122.20569, 37.20598], [-122.20589, 37.20616], [-122.20594, 37.20623], [-122.20601, 37.2064], [-122.20612, 37.20652], [-122.2062, 37.20674], [-122.20625, 37.2068], [-122.20642, 37.20685], [-122.20662, 37.20686], [-122.20684, 37.20692], [-122.20695, 37.20697], [-122.20705, 37.20705], [-122.20713, 37.20711], [-122.20727, 37.20727], [-122.20735, 37.20733], [-122.20759, 37.20741], [-122.20789, 37.20746], [-122.20809, 37.20755], [-122.20844, 37.20777], [-122.2085, 37.20786], [-122.20851, 37.20799]]]} | Restricted Access 2 | Minton | 22271 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 95.84 | Minton |
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]);