superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 1, MNG_AGENCY = 58 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1152 | 1152 | 1151 | {"type": "Polygon", "coordinates": [[[-122.44991, 37.66066], [-122.44807, 37.66234], [-122.4475, 37.66015], [-122.44783, 37.65984], [-122.44694, 37.65923], [-122.44733, 37.65888], [-122.44744, 37.65894], [-122.44991, 37.66066]]]} | Open Access 1 | Alta Loma Park | 15415 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 9.816 | Alta Loma Park | ||
1677 | 1677 | 1676 | {"type": "MultiPolygon", "coordinates": [[[[-122.4357, 37.64138], [-122.43492, 37.64176], [-122.43465, 37.64187], [-122.43415, 37.64152], [-122.4342, 37.64132], [-122.43419, 37.64112], [-122.43532, 37.64093], [-122.43563, 37.64078], [-122.4357, 37.64138]]], [[[-122.43587, 37.64316], [-122.43586, 37.64319], [-122.43584, 37.64321], [-122.43484, 37.64375], [-122.43477, 37.64373], [-122.43458, 37.64348], [-122.4354, 37.6431], [-122.43528, 37.64292], [-122.43557, 37.64278], [-122.43587, 37.64316]]]]} | Open Access 1 | Avalon Park | http://www.ssf.net/377/Parks-Recreation | 15720 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 3.591 | Avalon 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 | ||
2232 | 2232 | 2231 | {"type": "Polygon", "coordinates": [[[-122.43455, 37.63576], [-122.43382, 37.63627], [-122.43337, 37.63686], [-122.43296, 37.6372], [-122.43285, 37.63739], [-122.43301, 37.63752], [-122.43285, 37.6377], [-122.43275, 37.63791], [-122.43271, 37.63793], [-122.43265, 37.63791], [-122.43251, 37.6377], [-122.43245, 37.63741], [-122.43268, 37.63738], [-122.43274, 37.63721], [-122.43271, 37.63703], [-122.43338, 37.63633], [-122.43345, 37.63615], [-122.43346, 37.63594], [-122.43333, 37.63581], [-122.43407, 37.63532], [-122.43455, 37.63576]]]} | Open Access 1 | Brentwood Park | 16360 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 3.039 | Brentwood Park | ||
2363 | 2363 | 2362 | {"type": "Polygon", "coordinates": [[[-122.44262, 37.65196], [-122.44152, 37.65257], [-122.44172, 37.65284], [-122.44153, 37.65298], [-122.44106, 37.65264], [-122.44116, 37.65242], [-122.44118, 37.6519], [-122.44114, 37.65167], [-122.44187, 37.6505], [-122.44201, 37.65058], [-122.44199, 37.65088], [-122.44225, 37.65137], [-122.44262, 37.65196]]]} | Open Access 1 | Buri Buri Park | 16519 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 4.453 | Buri Buri 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);