superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, MNG_AGENCY = 391 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3333 | 3333 | 3332 | {"type": "Polygon", "coordinates": [[[-122.24787, 37.52556], [-122.24764, 37.52556], [-122.24737, 37.52561], [-122.24712, 37.52573], [-122.24692, 37.52589], [-122.24683, 37.526], [-122.24678, 37.5261], [-122.24609, 37.52759], [-122.24642, 37.52771], [-122.24643, 37.52775], [-122.246, 37.52784], [-122.24583, 37.52772], [-122.246, 37.5275], [-122.24612, 37.52732], [-122.24622, 37.52709], [-122.24632, 37.52674], [-122.2464, 37.52653], [-122.24692, 37.52562], [-122.24707, 37.52552], [-122.24725, 37.52548], [-122.2478, 37.52546], [-122.24787, 37.52556]]]} | Open Access 1 | Cringle Park | 17821 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.21 | Cringle Park | 1973 | |
3806 | 3806 | 3805 | {"type": "Polygon", "coordinates": [[[-122.27117, 37.45741], [-122.27093, 37.45788], [-122.2699, 37.45761], [-122.26964, 37.45805], [-122.26951, 37.458], [-122.2692, 37.45781], [-122.26859, 37.45752], [-122.26856, 37.45745], [-122.26881, 37.45705], [-122.26888, 37.45692], [-122.26896, 37.45657], [-122.26895, 37.45638], [-122.27054, 37.45589], [-122.27063, 37.45594], [-122.27091, 37.45618], [-122.27094, 37.45622], [-122.27101, 37.4568], [-122.271, 37.45689], [-122.27096, 37.45703], [-122.27095, 37.45711], [-122.27099, 37.45722], [-122.27117, 37.45741]]]} | Open Access 1 | Easter Bowl | 18390 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 8.866 | Easter Bowl | 1973 | |
8330 | 8330 | 8329 | {"type": "Polygon", "coordinates": [[[-122.25555, 37.52901], [-122.25518, 37.52934], [-122.2546, 37.52891], [-122.25483, 37.52871], [-122.25485, 37.52865], [-122.25506, 37.52866], [-122.25555, 37.52901]]]} | Open Access 1 | Portside Park | 23914 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.831 | Portside Park | 1973 | |
8441 | 8441 | 8440 | {"type": "Polygon", "coordinates": [[[-122.25491, 37.52957], [-122.25453, 37.52991], [-122.25419, 37.52966], [-122.25424, 37.52957], [-122.25423, 37.52947], [-122.25447, 37.52926], [-122.25491, 37.52957]]]} | Open Access 1 | Starboard Park | 25803 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.619 | Starboard Park | 1973 | |
9270 | 9270 | 9269 | {"type": "Polygon", "coordinates": [[[-122.25293, 37.53131], [-122.2526, 37.5316], [-122.25233, 37.53161], [-122.25197, 37.53135], [-122.25228, 37.53108], [-122.25237, 37.53112], [-122.25244, 37.53112], [-122.25252, 37.5311], [-122.25259, 37.53106], [-122.25293, 37.53131]]]} | Open Access 1 | Sandpiper Point Park | 25021 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.783 | Sandpiper Point Park | 1973 |
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]);