superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1 and ACRES = "0.585"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9805 | 9805 | 9804 | {"type": "MultiPolygon", "coordinates": [[[[-121.8696, 36.60282], [-121.86947, 36.60286], [-121.86935, 36.60264], [-121.86947, 36.60259], [-121.8696, 36.60282]]], [[[-121.8699, 36.60337], [-121.86965, 36.60346], [-121.86953, 36.60324], [-121.86977, 36.60314], [-121.86965, 36.60292], [-121.86978, 36.60288], [-121.8699, 36.6031], [-121.86979, 36.60315], [-121.8699, 36.60337]]], [[[-121.8704, 36.60292], [-121.87028, 36.60297], [-121.87015, 36.60274], [-121.87027, 36.6027], [-121.8704, 36.60292]]], [[[-121.87059, 36.60246], [-121.87047, 36.6025], [-121.87034, 36.60228], [-121.87047, 36.60224], [-121.87059, 36.60246]]], [[[-121.87065, 36.60283], [-121.87052, 36.60288], [-121.8704, 36.60265], [-121.87052, 36.60261], [-121.87065, 36.60283]]]]} | Open Access 1 | South Monterey Dunes Beach | 25666 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 0.585 | South Monterey Dunes Beach | ||
12349 | 12349 | 12348 | {"type": "Polygon", "coordinates": [[[-122.38535, 40.56927], [-122.38533, 40.56997], [-122.38492, 40.56996], [-122.38492, 40.5699], [-122.38489, 40.56981], [-122.38488, 40.56971], [-122.3849, 40.56963], [-122.38493, 40.56955], [-122.38506, 40.56942], [-122.38522, 40.56933], [-122.38528, 40.56924], [-122.38535, 40.56927]]]} | Open Access 1 | Parkview Green | 32402 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.585 | Parkview Green | ||
12822 | 12822 | 12821 | {"type": "Polygon", "coordinates": [[[-122.49663, 37.69768], [-122.49659, 37.69771], [-122.4965, 37.69774], [-122.49643, 37.69775], [-122.49637, 37.69777], [-122.4963, 37.69797], [-122.49625, 37.69802], [-122.49611, 37.6981], [-122.49612, 37.69816], [-122.49609, 37.69823], [-122.49605, 37.69828], [-122.49599, 37.69832], [-122.49546, 37.69842], [-122.49538, 37.69822], [-122.49551, 37.6982], [-122.49565, 37.69816], [-122.49571, 37.698], [-122.49576, 37.69796], [-122.49589, 37.69795], [-122.49619, 37.69801], [-122.49627, 37.69797], [-122.49633, 37.6978], [-122.49637, 37.69775], [-122.49647, 37.69771], [-122.49653, 37.69765], [-122.49658, 37.69763], [-122.49662, 37.69764], [-122.49663, 37.69768]]]} | Open Access 1 | Thornton Beach Vista | 30037 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.585 | Thornton Beach Vista |
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]);