superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, LABEL_NAME = "White Rock Preserve" and MNG_AGENCY = 241
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11184 | 11184 | 11183 | {"type": "Polygon", "coordinates": [[[-122.83574, 38.70857], [-122.83404, 38.71439], [-122.83246, 38.71428], [-122.83196, 38.71361], [-122.83141, 38.71316], [-122.83003, 38.71381], [-122.82919, 38.71302], [-122.82746, 38.71228], [-122.83039, 38.70765], [-122.83203, 38.70502], [-122.83218, 38.70502], [-122.83233, 38.70496], [-122.8323, 38.70537], [-122.83227, 38.70615], [-122.8323, 38.7063], [-122.83238, 38.70645], [-122.83246, 38.70654], [-122.83257, 38.70664], [-122.83314, 38.70693], [-122.83334, 38.70706], [-122.83352, 38.70722], [-122.83367, 38.70739], [-122.83381, 38.7076], [-122.83389, 38.70777], [-122.83393, 38.70793], [-122.83402, 38.7081], [-122.83426, 38.70838], [-122.83441, 38.7085], [-122.83459, 38.7086], [-122.83473, 38.70865], [-122.83492, 38.70869], [-122.83514, 38.70871], [-122.83533, 38.7087], [-122.83554, 38.70865], [-122.83574, 38.70857]]]} | No Public Access 3 | White Rock Preserve | 27465 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 96.6 | White Rock Preserve |
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]);