superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
MNG_AGENCY 30
- San Jose, City of 4
- San Francisco, City and County of 3
- Santa Rosa, City of 2
- Oakland, City of 2
- Walnut Creek, City of 2
- Pleasanton, City of 1
- South San Francisco, City of 1
- San Ramon, City of 1
- San Mateo, City of 1
- Petaluma, City of 1
- Vacaville, City of 1
- Dublin, City of 1
- Alameda, City of 1
- Palm Desert, City of 1
- Menlo Park, City of 1
- Benicia, City of 1
- Antioch, City of 1
- Martinez, City of 1
- Union City, City of 1
- Redwood City, City of 1
- Santa Clara, City of 1
- Pacifica, City of 1
- Sunnyvale, City of 1
- Novato, City of 1
- Los Altos, City of 1
- Palm Springs, City of 1
- Rancho Mirage, City of 1
- La Quinta, City of 1
- Brisbane, City of 1
- Suisun City, City of 1
MNG_AG_TYP 1
- City Agency · 38 ✖
ACCESS_TYP 1
- Open Access · 38 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
751 | 751 | 750 | {"type": "MultiPolygon", "coordinates": [[[[-122.44577, 37.77293], [-122.44108, 37.77352], [-122.44092, 37.77277], [-122.44562, 37.77218], [-122.44577, 37.77293]]], [[[-122.51084, 37.77123], [-122.51081, 37.77125], [-122.46524, 37.77333], [-122.46492, 37.77336], [-122.45479, 37.77465], [-122.45476, 37.77464], [-122.45474, 37.77462], [-122.45417, 37.77186], [-122.446, 37.7729], [-122.44585, 37.77215], [-122.45401, 37.77111], [-122.454, 37.7709], [-122.45398, 37.77089], [-122.45365, 37.76926], [-122.45362, 37.76924], [-122.45359, 37.76908], [-122.45361, 37.76904], [-122.45324, 37.7672], [-122.45358, 37.76716], [-122.45359, 37.76714], [-122.45351, 37.76676], [-122.45315, 37.76677], [-122.45308, 37.76646], [-122.45319, 37.76644], [-122.45324, 37.76659], [-122.454, 37.76656], [-122.45401, 37.76654], [-122.45397, 37.76634], [-122.45449, 37.76628], [-122.45455, 37.76653], [-122.45477, 37.76653], [-122.45473, 37.76625], [-122.45677, 37.76598], [-122.45701, 37.76598], [-122.45721, 37.76599], [-122.45745, 37.76603], [-122.45764, 37.76608], [-122.45768, 37.76644], [-122.45788, 37.76644], [-122.45859, 37.76637], [-122.46049, 37.76628], [-122.51017, 37.76409], [-122.51021, 37.7641], [-122.51024, 37.76413], [-122.51025, 37.7645], [-122.51017, 37.76568], [-122.51018, 37.76647], [-122.51024, 37.76719], [-122.51029, 37.76771], [-122.51033, 37.76774], [-122.51042, 37.76819], [-122.51042, 37.76835], [-122.51047, 37.76859], [-122.51052, 37.76864], [-122.51063, 37.76917], [-122.51078, 37.77029], [-122.51076, 37.77035], [-122.5107, 37.77037], [-122.51069, 37.77048], [-122.51077, 37.77052], [-122.5108, 37.77056], [-122.51083, 37.77082], [-122.5108, 37.77092], [-122.51084, 37.77123]], [[-122.45534, 37.76756], [-122.45501, 37.76749], [-122.45487, 37.76756], [-122.45488, 37.76807], [-122.45516, 37.76805], [-122.45565, 37.76794], [-122.45563, 37.76788], [-122.45534, 37.76756]], [[-122.4691, 37.7719], [-122.46926, 37.772], [-122.46978, 37.77162], [-122.46885, 37.77083], [-122.46791, 37.77153], [-122.4686, 37.7722], [-122.4691, 37.7719]]]]} | Open Access 1 | Golden Gate Park | http://sfrecpark.org/parks-open-spaces/golden-gate-park-guide/ | 10900 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1022.23 | Golden Gate Park | 2000 |
807 | 807 | 806 | {"type": "Polygon", "coordinates": [[[-121.8135, 37.98299], [-121.81214, 37.983], [-121.81196, 37.98264], [-121.81202, 37.9826], [-121.81187, 37.9813], [-121.81171, 37.98016], [-121.81189, 37.98005], [-121.81216, 37.97992], [-121.81257, 37.97994], [-121.81243, 37.9803], [-121.81247, 37.98053], [-121.81248, 37.98149], [-121.81255, 37.98215], [-121.81265, 37.98236], [-121.81281, 37.98254], [-121.813, 37.98269], [-121.8135, 37.98299]]]} | Open Access 1 | Antioch | 15520 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.226 | Antioch | 2000 | |
838 | 838 | 837 | {"type": "Polygon", "coordinates": [[[-122.01041, 38.35673], [-122.00892, 38.35725], [-122.00846, 38.35701], [-122.00814, 38.35671], [-122.00769, 38.35685], [-122.0075, 38.35677], [-122.00736, 38.35667], [-122.00728, 38.35618], [-122.00766, 38.35609], [-122.00751, 38.35562], [-122.00947, 38.35527], [-122.01041, 38.35673]]]} | Open Access 1 | Alamo Creek Park | 15317 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 9.434 | Alamo Creek Park | 2000 | |
1120 | 1120 | 1119 | {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} | Open Access 1 | Alamo Square | 15322 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 12.697 | Alamo Square | 2000 | |
1215 | 1215 | 1214 | {"type": "Polygon", "coordinates": [[[-121.91246, 37.72471], [-121.91244, 37.72476], [-121.91228, 37.72487], [-121.91216, 37.725], [-121.91208, 37.72511], [-121.91199, 37.72517], [-121.91154, 37.72512], [-121.91121, 37.72513], [-121.91087, 37.72517], [-121.90977, 37.72536], [-121.90971, 37.72531], [-121.90964, 37.72491], [-121.90963, 37.72473], [-121.90964, 37.72424], [-121.90969, 37.72396], [-121.90972, 37.72393], [-121.90977, 37.72391], [-121.91003, 37.72393], [-121.91017, 37.72391], [-121.91081, 37.72373], [-121.91134, 37.72367], [-121.91155, 37.72359], [-121.91245, 37.72467], [-121.91246, 37.72471]]]} | Open Access 1 | Alamo Creek Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Alamo-Creek-Park-2 | 32907 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 8.537 | Alamo Creek Park | 2000 |
1391 | 1391 | 1390 | {"type": "Polygon", "coordinates": [[[-121.79774, 37.31556], [-121.79746, 37.31561], [-121.79725, 37.31561], [-121.79713, 37.31564], [-121.79701, 37.31563], [-121.7968, 37.31557], [-121.79672, 37.31551], [-121.7966, 37.31539], [-121.79659, 37.31526], [-121.7967, 37.31504], [-121.79674, 37.315], [-121.79682, 37.31496], [-121.79681, 37.31491], [-121.79679, 37.31489], [-121.79665, 37.31485], [-121.79646, 37.31485], [-121.79638, 37.31484], [-121.79623, 37.31479], [-121.79599, 37.31458], [-121.79592, 37.31449], [-121.79585, 37.31445], [-121.79573, 37.31442], [-121.79558, 37.31434], [-121.7955, 37.31427], [-121.79544, 37.31418], [-121.79539, 37.31414], [-121.79533, 37.31412], [-121.79512, 37.3141], [-121.79508, 37.31409], [-121.79505, 37.31404], [-121.79506, 37.31394], [-121.79502, 37.31388], [-121.79496, 37.31382], [-121.7948, 37.31374], [-121.79475, 37.31367], [-121.79543, 37.31358], [-121.79546, 37.31378], [-121.79614, 37.31418], [-121.79694, 37.31401], [-121.79722, 37.31397], [-121.79711, 37.31413], [-121.79706, 37.31424], [-121.79703, 37.31441], [-121.79705, 37.31456], [-121.79709, 37.31465], [-121.79742, 37.31517], [-121.79763, 37.31546], [-121.79774, 37.31556]]]} | Open Access 1 | Aborn Park | 15237 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.604 | Aborn Park | 2000 | |
1950 | 1950 | 1949 | {"type": "Polygon", "coordinates": [[[-122.16146, 38.08789], [-122.16142, 38.08812], [-122.16113, 38.08875], [-122.16075, 38.08914], [-122.15994, 38.08931], [-122.15902, 38.08918], [-122.15851, 38.08897], [-122.15817, 38.08892], [-122.15769, 38.08893], [-122.15708, 38.08888], [-122.15659, 38.0884], [-122.1563, 38.08783], [-122.15735, 38.08635], [-122.15778, 38.08578], [-122.15762, 38.08522], [-122.15727, 38.08473], [-122.15865, 38.08398], [-122.15903, 38.08432], [-122.15847, 38.08498], [-122.15814, 38.08528], [-122.15817, 38.08585], [-122.1587, 38.08649], [-122.15939, 38.08674], [-122.1605, 38.08671], [-122.16132, 38.08696], [-122.1611, 38.08721], [-122.16126, 38.08762], [-122.16146, 38.08789]]]} | Open Access 1 | Benicia Community Park | 16010 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 31.668 | Benicia Community Park | 2000 | |
2618 | 2618 | 2617 | {"type": "Polygon", "coordinates": [[[-121.88586, 37.69157], [-121.88515, 37.69244], [-121.88287, 37.69077], [-121.88321, 37.69053], [-121.88397, 37.69108], [-121.88453, 37.69057], [-121.88586, 37.69157]]]} | Open Access 1 | Creekside Park | 17777 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 5.723 | Creekside Park | 2000 | |
3299 | 3299 | 3298 | {"type": "Polygon", "coordinates": [[[-122.54218, 38.04659], [-122.5421, 38.04696], [-122.54177, 38.04686], [-122.54203, 38.04666], [-122.54174, 38.0464], [-122.54122, 38.04642], [-122.54096, 38.04662], [-122.53947, 38.04637], [-122.53912, 38.04636], [-122.53866, 38.04642], [-122.5385, 38.04642], [-122.53837, 38.04638], [-122.53807, 38.0462], [-122.53782, 38.04612], [-122.53723, 38.04602], [-122.53704, 38.04601], [-122.53691, 38.04603], [-122.5369, 38.04589], [-122.53793, 38.04594], [-122.53834, 38.04628], [-122.54119, 38.04606], [-122.54191, 38.04624], [-122.54218, 38.04659]]]} | Open Access 1 | Creekside Park | 17775 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 3.216 | Creekside Park | 2000 | |
3691 | 3691 | 3690 | {"type": "Polygon", "coordinates": [[[-121.81025, 37.29897], [-121.80953, 37.29949], [-121.80862, 37.29863], [-121.80923, 37.29804], [-121.81025, 37.29897]]]} | Open Access 1 | Dovehill Park | 18251 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.739 | Dovehill Park | 2000 | |
3857 | 3857 | 3856 | {"type": "Polygon", "coordinates": [[[-122.48438, 37.66358], [-122.4839, 37.66357], [-122.48388, 37.66343], [-122.48379, 37.6633], [-122.48372, 37.66324], [-122.4836, 37.66318], [-122.48347, 37.66314], [-122.48336, 37.66314], [-122.48262, 37.66222], [-122.48276, 37.66179], [-122.48259, 37.66157], [-122.48264, 37.66105], [-122.48212, 37.6607], [-122.4824, 37.66037], [-122.48259, 37.65977], [-122.48304, 37.66045], [-122.48352, 37.66124], [-122.48359, 37.66156], [-122.4837, 37.66191], [-122.48438, 37.66358]]]} | Open Access 1 | Edgewood Park | 18442 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 7.397 | Edgewood Park | 2000 | |
4292 | 4292 | 4291 | {"type": "Polygon", "coordinates": [[[-122.09881, 37.96587], [-122.09858, 37.96595], [-122.09694, 37.96348], [-122.09736, 37.96373], [-122.09774, 37.96377], [-122.09788, 37.96445], [-122.09881, 37.96587]]]} | Open Access 1 | Foothills Park | 18983 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1.866 | Foothills Park | 2000 | |
4409 | 4409 | 4408 | {"type": "Polygon", "coordinates": [[[-122.18669, 37.44885], [-122.18632, 37.44929], [-122.18592, 37.44908], [-122.18628, 37.44864], [-122.18669, 37.44885]]]} | Open Access 1 | Fremont Park | 19099 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 0.623 | Fremont Park | 2000 | |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-121.95191, 37.35045], [-121.95084, 37.35083], [-121.95041, 37.35006], [-121.95102, 37.34985], [-121.95124, 37.35022], [-121.95169, 37.35007], [-121.95191, 37.35045]]]} | Open Access 1 | Fremont Park | 19101 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.88 | Fremont Park | 2000 | |
4412 | 4412 | 4411 | {"type": "Polygon", "coordinates": [[[-122.70955, 38.4434], [-122.70874, 38.44377], [-122.70831, 38.44322], [-122.70831, 38.44319], [-122.70912, 38.4428], [-122.70955, 38.4434]]]} | Open Access 1 | Fremont Park | 19102 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.548 | Fremont Park | 2000 | |
5048 | 5048 | 5047 | {"type": "Polygon", "coordinates": [[[-122.0369, 37.58934], [-122.03679, 37.58946], [-122.03652, 37.5893], [-122.0365, 37.58926], [-122.03659, 37.58916], [-122.0369, 37.58934]]]} | Open Access 1 | Heritage Oak Park | 19838 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.139 | Heritage Oak Park | 2000 | |
5050 | 5050 | 5049 | {"type": "Polygon", "coordinates": [[[-122.08727, 37.3596], [-122.08625, 37.35958], [-122.08624, 37.35771], [-122.08618, 37.35747], [-122.08608, 37.35729], [-122.08627, 37.35728], [-122.08635, 37.35738], [-122.08663, 37.35765], [-122.08692, 37.35782], [-122.08728, 37.3587], [-122.08734, 37.35889], [-122.08737, 37.35908], [-122.08736, 37.35928], [-122.08733, 37.35944], [-122.08727, 37.3596]]]} | Open Access 1 | Heritage Oaks Park | 19840 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 4.683 | Heritage Oaks Park | 2000 | |
5065 | 5065 | 5064 | {"type": "Polygon", "coordinates": [[[-122.02496, 38.24674], [-122.02492, 38.24958], [-122.02414, 38.2496], [-122.0235, 38.24955], [-122.02346, 38.24783], [-122.02373, 38.24775], [-122.02372, 38.2467], [-122.02496, 38.24674]]]} | Open Access 1 | Heritage Park | 19856 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 9.413 | Heritage Park | 2000 | |
5641 | 5641 | 5640 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | Junipero Serra Playground | 20533 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.547 | Junipero Serra Playground | 2000 | |
5785 | 5785 | 5784 | {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} | Open Access 1 | Krusi Park | 20727 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 7.491 | Krusi Park | 2000 |
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]);