superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where ACCESS_TYP = 1 and MNG_AGENCY = 391 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 37
MNG_AGENCY 1
- Redwood City, City of · 37 ✖
ACCESS_TYP 1
- Open Access · 37 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6538 | 6538 | 6537 | {"type": "Polygon", "coordinates": [[[-122.22487, 37.48152], [-122.22446, 37.48126], [-122.2246, 37.48107], [-122.2246, 37.48107], [-122.22487, 37.48152]]]} | Open Access 1 | Main Street Park | 21693 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.14 | Main Street Park | 1940 | |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-122.21235, 37.47671], [-122.21207, 37.47697], [-122.21157, 37.47664], [-122.21202, 37.47668], [-122.21235, 37.47671]]]} | Open Access 1 | Fair Oaks Community Cente | 18784 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.275 | Fair Oaks Community Cente | 1961 | |
5488 | 5488 | 5487 | {"type": "Polygon", "coordinates": [[[-122.22233, 37.48195], [-122.22209, 37.48228], [-122.22181, 37.48214], [-122.22181, 37.48212], [-122.22203, 37.48181], [-122.22233, 37.48195]]]} | Open Access 1 | Jardin de Ninos Park | 20365 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.314 | Jardin de Ninos Park | 1981 | |
9570 | 9570 | 9569 | {"type": "Polygon", "coordinates": [[[-122.24632, 37.46136], [-122.24605, 37.46147], [-122.24591, 37.46152], [-122.24588, 37.4615], [-122.24578, 37.46136], [-122.24567, 37.46123], [-122.24595, 37.46103], [-122.24632, 37.46136]]]} | Open Access 1 | Westwood Park | 27442 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.403 | Westwood Park | 1961 | |
6219 | 6219 | 6218 | {"type": "Polygon", "coordinates": [[[-122.21919, 37.47246], [-122.21905, 37.47264], [-122.21812, 37.47272], [-122.2181, 37.47267], [-122.2181, 37.47261], [-122.21814, 37.47255], [-122.21919, 37.47246]]]} | Open Access 1 | Linden Park | 21292 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.406 | Linden Park | 1986 | |
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 | |
3689 | 3689 | 3688 | {"type": "Polygon", "coordinates": [[[-122.25411, 37.47894], [-122.25351, 37.47941], [-122.25343, 37.47934], [-122.25337, 37.47924], [-122.25335, 37.4791], [-122.25338, 37.47896], [-122.25347, 37.47885], [-122.25363, 37.47875], [-122.25376, 37.47872], [-122.25392, 37.47871], [-122.2539, 37.47884], [-122.25402, 37.47888], [-122.25411, 37.47894]]]} | Open Access 1 | Dove Beeger Park | 18249 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.721 | Dove Beeger Park | 1963 | |
4248 | 4248 | 4247 | {"type": "Polygon", "coordinates": [[[-122.2214, 37.47243], [-122.22103, 37.47246], [-122.2208, 37.47275], [-122.22046, 37.47258], [-122.2209, 37.47202], [-122.22124, 37.47218], [-122.22117, 37.47229], [-122.2214, 37.47243]]]} | Open Access 1 | Fleishman Park | 18942 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.728 | Fleishman Park | 1939 | |
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 | |
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 | |
6506 | 6506 | 6505 | {"type": "Polygon", "coordinates": [[[-122.2363, 37.4575], [-122.23548, 37.45765], [-122.23547, 37.45761], [-122.2356, 37.45723], [-122.23544, 37.45712], [-122.23542, 37.45698], [-122.23558, 37.45711], [-122.23592, 37.45706], [-122.23602, 37.45706], [-122.23616, 37.45702], [-122.2363, 37.4575]]]} | Open Access 1 | Maddux Park | 21646 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.892 | Maddux Park | 2000 | |
7873 | 7873 | 7872 | {"type": "Polygon", "coordinates": [[[-122.22752, 37.47069], [-122.22725, 37.4709], [-122.22736, 37.47102], [-122.22714, 37.4712], [-122.22645, 37.47104], [-122.22721, 37.47044], [-122.22752, 37.47069]]]} | Open Access 1 | Palm Park | 23345 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.955 | Palm Park | 1979 | |
8185 | 8185 | 8184 | {"type": "Polygon", "coordinates": [[[-122.23169, 37.54244], [-122.23158, 37.54252], [-122.23125, 37.5428], [-122.23063, 37.54236], [-122.2304, 37.54226], [-122.23016, 37.5422], [-122.22984, 37.54218], [-122.22955, 37.54221], [-122.22927, 37.5423], [-122.22901, 37.54244], [-122.22963, 37.54196], [-122.23157, 37.54247], [-122.23163, 37.54247], [-122.23169, 37.54244]]]} | Open Access 1 | Shores Dog Park | 25429 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.086 | Shores Dog Park | 1984 | |
3463 | 3463 | 3462 | {"type": "Polygon", "coordinates": [[[-122.24791, 37.53233], [-122.24681, 37.53332], [-122.24683, 37.53337], [-122.24596, 37.53411], [-122.24595, 37.53416], [-122.24589, 37.53417], [-122.24573, 37.53405], [-122.24777, 37.53226], [-122.24781, 37.53226], [-122.24791, 37.53233]]]} | Open Access 1 | Davit Lane | 17956 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.163 | Davit Lane | 1974 | |
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 | |
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-122.22766, 37.48359], [-122.22718, 37.48409], [-122.22707, 37.48402], [-122.22692, 37.48377], [-122.2268, 37.4835], [-122.22668, 37.48328], [-122.22659, 37.48302], [-122.22652, 37.48287], [-122.22766, 37.48359]]]} | Open Access 1 | John S. Roselli Memorial | 20468 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.258 | John S. Roselli Memorial | 1940 | |
2575 | 2575 | 2574 | {"type": "Polygon", "coordinates": [[[-122.23003, 37.48738], [-122.22934, 37.48741], [-122.22928, 37.48659], [-122.22997, 37.48656], [-122.23003, 37.48738]]]} | Open Access 1 | Courthouse Square | 17720 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.374 | Courthouse Square | 1940 | |
6965 | 6965 | 6964 | {"type": "Polygon", "coordinates": [[[-122.23677, 37.49175], [-122.23601, 37.4923], [-122.23554, 37.49189], [-122.23629, 37.49134], [-122.23677, 37.49175]]]} | Open Access 1 | Mezes Park | 22193 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.393 | Mezes Park | 1905 | |
9503 | 9503 | 9502 | {"type": "Polygon", "coordinates": [[[-122.24341, 37.48993], [-122.2436, 37.48993], [-122.24374, 37.48997], [-122.24383, 37.49003], [-122.24389, 37.49014], [-122.2439, 37.49021], [-122.24386, 37.49036], [-122.24376, 37.4905], [-122.24353, 37.49066], [-122.24346, 37.4907], [-122.24333, 37.49072], [-122.24324, 37.49072], [-122.24314, 37.49069], [-122.24304, 37.49064], [-122.24294, 37.49054], [-122.24291, 37.49042], [-122.24294, 37.49029], [-122.24301, 37.49019], [-122.24317, 37.49004], [-122.24324, 37.49], [-122.24341, 37.48993]]]} | Open Access 1 | Wellesley Park | 27341 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.397 | Wellesley Park | 1940 | |
9895 | 9895 | 9894 | {"type": "Polygon", "coordinates": [[[-122.24815, 37.48203], [-122.24752, 37.48253], [-122.24685, 37.482], [-122.24749, 37.48149], [-122.24815, 37.48203]]]} | Open Access 1 | Stafford Park | 25775 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.644 | Stafford Park | 1946 |
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]);