superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 58 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 24
MNG_AGENCY 1
- South San Francisco, City of · 24 ✖
ACCESS_TYP 1
- Open Access 24
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11501 | 11501 | 11500 | {"type": "Polygon", "coordinates": [[[-122.43749, 37.6417], [-122.43708, 37.64219], [-122.43677, 37.64236], [-122.43671, 37.64168], [-122.43693, 37.64167], [-122.43694, 37.64171], [-122.43697, 37.64175], [-122.43706, 37.64178], [-122.43716, 37.64175], [-122.4372, 37.64168], [-122.43749, 37.6417]]]} | Open Access 1 | Zamora Playlot | 27853 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.712 | Zamora Playlot | ||
11339 | 11339 | 11338 | {"type": "Polygon", "coordinates": [[[-122.45497, 37.66843], [-122.45478, 37.66855], [-122.4547, 37.66847], [-122.45464, 37.66834], [-122.45454, 37.66839], [-122.45421, 37.6682], [-122.45421, 37.66809], [-122.45418, 37.668], [-122.45447, 37.66791], [-122.45403, 37.66686], [-122.45429, 37.6668], [-122.45497, 37.66843]]]} | Open Access 1 | Winston Manor Park | 27651 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1.486 | Winston Manor Park | ||
13127 | 13127 | 13126 | {"type": "Polygon", "coordinates": [[[-122.45903, 37.6453], [-122.45838, 37.64534], [-122.45836, 37.64531], [-122.45811, 37.64533], [-122.4581, 37.64537], [-122.45738, 37.64542], [-122.45736, 37.6454], [-122.45608, 37.64547], [-122.45658, 37.64439], [-122.45723, 37.64335], [-122.45728, 37.64333], [-122.4578, 37.64347], [-122.4581, 37.64353], [-122.45841, 37.64358], [-122.45886, 37.6436], [-122.45903, 37.6453]]]} | Open Access 1 | Westborough Recreation Park | http://www.ssf.net/departments/parks-recreation/recreation-division/rentals/westborough-recreation-building | 33382 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 10.787 | Westborough Rec. Park | 1988 |
10270 | 10270 | 10269 | {"type": "Polygon", "coordinates": [[[-122.41794, 37.66954], [-122.41782, 37.66978], [-122.41736, 37.66966], [-122.41732, 37.6697], [-122.41723, 37.66969], [-122.41714, 37.66987], [-122.41715, 37.66992], [-122.41649, 37.66992], [-122.41638, 37.66991], [-122.4161, 37.66983], [-122.41588, 37.66969], [-122.41577, 37.66958], [-122.41559, 37.66928], [-122.41543, 37.6691], [-122.41558, 37.6688], [-122.41725, 37.66927], [-122.41725, 37.66931], [-122.41728, 37.66934], [-122.41794, 37.66954]]]} | Open Access 1 | Terrabay Gymnasium | 26256 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 3.664 | Terrabay Gymnasium | ||
9703 | 9703 | 9702 | {"type": "Polygon", "coordinates": [[[-122.4258, 37.6531], [-122.42568, 37.65322], [-122.42534, 37.65307], [-122.42518, 37.65302], [-122.41793, 37.65142], [-122.41798, 37.65129], [-122.42502, 37.65284], [-122.42529, 37.65292], [-122.4258, 37.6531]]]} | Open Access 1 | Sister Cities Park | 25521 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 2.734 | Sister Cities Park | ||
9663 | 9663 | 9662 | {"type": "Polygon", "coordinates": [[[-122.42394, 37.66276], [-122.4236, 37.66382], [-122.42336, 37.66377], [-122.42279, 37.66405], [-122.42255, 37.66412], [-122.42234, 37.66415], [-122.42203, 37.66416], [-122.42176, 37.66413], [-122.42111, 37.66404], [-122.42093, 37.66398], [-122.42076, 37.66389], [-122.42013, 37.66344], [-122.42032, 37.66322], [-122.41986, 37.66289], [-122.41933, 37.66323], [-122.41925, 37.66378], [-122.41981, 37.66421], [-122.42033, 37.66421], [-122.42065, 37.66439], [-122.42201, 37.66456], [-122.42245, 37.66472], [-122.4232, 37.66619], [-122.42314, 37.66632], [-122.42194, 37.6658], [-122.42139, 37.66606], [-122.42127, 37.66604], [-122.42103, 37.66576], [-122.42049, 37.66579], [-122.42005, 37.66565], [-122.41941, 37.66631], [-122.41916, 37.66626], [-122.41897, 37.66616], [-122.41887, 37.66596], [-122.41889, 37.66506], [-122.4186, 37.66487], [-122.41821, 37.66499], [-122.41789, 37.66494], [-122.41762, 37.66451], [-122.4171, 37.66411], [-122.41695, 37.6639], [-122.41704, 37.66318], [-122.4169, 37.66317], [-122.41655, 37.66288], [-122.41637, 37.66301], [-122.41522, 37.66251], [-122.41543, 37.66213], [-122.41547, 37.66214], [-122.41563, 37.66192], [-122.41556, 37.66187], [-122.41575, 37.66148], [-122.41595, 37.66167], [-122.41627, 37.6619], [-122.4166, 37.66208], [-122.41767, 37.66246], [-122.4181, 37.66259], [-122.41845, 37.66262], [-122.41881, 37.66261], [-122.41949, 37.66252], [-122.41991, 37.66249], [-122.41994, 37.66265], [-122.42044, 37.66282], [-122.4209, 37.66294], [-122.42117, 37.66299], [-122.42156, 37.66305], [-122.42192, 37.66306], [-122.42213, 37.66303], [-122.42235, 37.66295], [-122.42255, 37.66283], [-122.4227, 37.6627], [-122.42283, 37.66251], [-122.42394, 37.66276]]]} | Open Access 1 | Sign Hill Park | 25475 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 41.274 | Sign Hill Park | ||
9489 | 9489 | 9488 | {"type": "Polygon", "coordinates": [[[-122.45012, 37.64323], [-122.44997, 37.64418], [-122.44975, 37.64424], [-122.44961, 37.64426], [-122.44944, 37.64425], [-122.44931, 37.64422], [-122.4482, 37.64366], [-122.44809, 37.64348], [-122.44752, 37.64319], [-122.44762, 37.64304], [-122.44753, 37.64223], [-122.44771, 37.64225], [-122.44796, 37.6423], [-122.44832, 37.64243], [-122.44865, 37.64259], [-122.44914, 37.64292], [-122.4494, 37.64305], [-122.44975, 37.64317], [-122.45012, 37.64323]]]} | Open Access 1 | Sellick Park | 25289 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 7.002 | Sellick Park | ||
9159 | 9159 | 9158 | {"type": "Polygon", "coordinates": [[[-122.37823, 37.65795], [-122.37809, 37.65808], [-122.37717, 37.65723], [-122.37692, 37.65689], [-122.37681, 37.65671], [-122.37658, 37.65623], [-122.37649, 37.65598], [-122.37644, 37.65557], [-122.37631, 37.65525], [-122.37613, 37.65507], [-122.37557, 37.65506], [-122.37555, 37.65493], [-122.3765, 37.65493], [-122.37663, 37.65527], [-122.37674, 37.65582], [-122.37692, 37.65629], [-122.37762, 37.65744], [-122.37776, 37.65752], [-122.37823, 37.65795]]]} | Open Access 1 | San Bruno Point Park | 24841 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 2.522 | San Bruno Point Park | ||
7938 | 7938 | 7937 | {"type": "MultiPolygon", "coordinates": [[[[-122.40937, 37.66368], [-122.40908, 37.66378], [-122.40907, 37.66385], [-122.4089, 37.66392], [-122.40863, 37.66349], [-122.40901, 37.66331], [-122.40937, 37.66368]]], [[[-122.41053, 37.66418], [-122.41017, 37.66467], [-122.40962, 37.66449], [-122.4094, 37.66437], [-122.40921, 37.6642], [-122.40953, 37.66398], [-122.4097, 37.66391], [-122.41053, 37.66418]]]]} | Open Access 1 | Paradise Valley Park | 23408 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1.924 | Paradise Valley Park | ||
7831 | 7831 | 7830 | {"type": "Polygon", "coordinates": [[[-122.38615, 37.66234], [-122.38604, 37.66244], [-122.38546, 37.66259], [-122.38531, 37.66261], [-122.38516, 37.6626], [-122.38494, 37.66253], [-122.3848, 37.66246], [-122.38461, 37.6623], [-122.38449, 37.66216], [-122.38418, 37.66178], [-122.38419, 37.66176], [-122.38414, 37.66171], [-122.384, 37.66158], [-122.38383, 37.66147], [-122.3836, 37.66136], [-122.38332, 37.66129], [-122.38303, 37.66126], [-122.38275, 37.66129], [-122.38275, 37.66088], [-122.38533, 37.66089], [-122.38529, 37.66104], [-122.38525, 37.66105], [-122.38525, 37.66107], [-122.38539, 37.6611], [-122.38535, 37.6613], [-122.38537, 37.6614], [-122.3854, 37.6615], [-122.38549, 37.6615], [-122.38569, 37.66183], [-122.38594, 37.66219], [-122.38615, 37.66234]]]} | Open Access 1 | Oyster Point Park | 23285 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 7.054 | Oyster Point Park | 2000 | |
7729 | 7729 | 7728 | {"type": "Polygon", "coordinates": [[[-122.42934, 37.65342], [-122.42888, 37.65473], [-122.42854, 37.65581], [-122.42848, 37.6558], [-122.4284, 37.65581], [-122.42728, 37.6556], [-122.42439, 37.65498], [-122.42698, 37.65216], [-122.42694, 37.6521], [-122.42697, 37.65207], [-122.42787, 37.65262], [-122.42934, 37.65342]]]} | Open Access 1 | Orange Memorial Park | 23177 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 25.117 | Orange Memorial Park | ||
4134 | 4134 | 4133 | {"type": "Polygon", "coordinates": [[[-122.42524, 37.66988], [-122.4246, 37.67055], [-122.42363, 37.67039], [-122.42299, 37.6698], [-122.42258, 37.6689], [-122.42434, 37.66836], [-122.42454, 37.6687], [-122.42437, 37.66886], [-122.42524, 37.66988]]]} | Open Access 1 | Hillside Athletic Field | 19979 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 8.295 | Hillside Athletic Field | ||
4495 | 4495 | 4494 | {"type": "Polygon", "coordinates": [[[-122.40018, 37.66434], [-122.40011, 37.66463], [-122.39923, 37.66446], [-122.39958, 37.66423], [-122.40018, 37.66434]]]} | Open Access 1 | Gardiner Lot | 19209 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.528 | Gardiner Lot | ||
4360 | 4360 | 4359 | {"type": "Polygon", "coordinates": [[[-122.42275, 37.64511], [-122.42239, 37.64563], [-122.42222, 37.64588], [-122.42208, 37.64571], [-122.4227, 37.64509], [-122.42275, 37.64511]]]} | Open Access 1 | Francisco Terrace Playlot | 19046 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.301 | Francisco Terrace Playlot | ||
13534 | 13534 | 13533 | {"type": "Polygon", "coordinates": [[[-122.45852, 37.65833], [-122.45843, 37.65862], [-122.45812, 37.65853], [-122.45806, 37.65848], [-122.45803, 37.65841], [-122.45827, 37.65833], [-122.45852, 37.65833]]]} | Open Access 1 | Dundee Playlot | 30939 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.223 | Dundee Playlot | ||
3387 | 3387 | 3386 | {"type": "Polygon", "coordinates": [[[-122.40699, 37.65869], [-122.40686, 37.65906], [-122.40654, 37.65898], [-122.40672, 37.65863], [-122.40699, 37.65869]]]} | Open Access 1 | Cypress and Pine Playlot | 17870 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.282 | Cypress and Pine Playlot | ||
3016 | 3016 | 3015 | {"type": "Polygon", "coordinates": [[[-122.46344, 37.66183], [-122.46339, 37.66197], [-122.46341, 37.6623], [-122.46328, 37.66235], [-122.46299, 37.6623], [-122.46288, 37.66226], [-122.46328, 37.66174], [-122.46344, 37.66183]]]} | Open Access 1 | Clay Avenue Park | 17396 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.473 | Clay Avenue Park | ||
2972 | 2972 | 2971 | {"type": "Polygon", "coordinates": [[[-122.41421, 37.65619], [-122.41393, 37.65698], [-122.41226, 37.65661], [-122.41254, 37.65582], [-122.41421, 37.65619]]]} | Open Access 1 | City Hall Tot Lot | 17299 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 3.438 | City Hall Tot Lot | ||
852 | 852 | 851 | {"type": "Polygon", "coordinates": [[[-122.432, 37.65457], [-122.43196, 37.65463], [-122.43035, 37.65375], [-122.42946, 37.65329], [-122.4296, 37.65316], [-122.43036, 37.65352], [-122.43142, 37.65407], [-122.43166, 37.65422], [-122.43183, 37.65436], [-122.43195, 37.65449], [-122.432, 37.65457]]]} | Open Access 1 | Centennial Dog Park | https://dogtrekker.com/yp/centennial-dog-park-South-San-Francisco-94080 | 33569 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1.344 | Centennial Dog Park | |
1804 | 1804 | 1803 | {"type": "Polygon", "coordinates": [[[-122.46786, 37.64523], [-122.46718, 37.64576], [-122.46656, 37.64621], [-122.46629, 37.64592], [-122.46629, 37.6459], [-122.46601, 37.64564], [-122.46625, 37.64548], [-122.46625, 37.64545], [-122.46632, 37.6454], [-122.46633, 37.64538], [-122.46687, 37.645], [-122.46726, 37.64511], [-122.46786, 37.64523]]]} | Open Access 1 | Callan Park | 16733 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 2.563 | Callan Park |
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]);