units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where AGNCY_LEV = 2, MNG_AGENCY = 403 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 6
- Local Park 14
- Local Recreation Area 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 19 ✖
MNG_AGENCY 1
- Pacifica, City of · 19 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1693 | 1693 | 1692 | {"type": "Polygon", "coordinates": [[[-122.49248, 37.63035], [-122.49247, 37.63053], [-122.49221, 37.63053], [-122.49218, 37.63034], [-122.49248, 37.63035]]]} | Open Access 1 | 14655 | Palmetto Mini Park | 23354 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.124 | Palmetto MP | 0 | Local Park 2 | 4 | |
2771 | 2771 | 2770 | {"type": "Polygon", "coordinates": [[[-122.46746, 37.58568], [-122.46682, 37.58703], [-122.46548, 37.5881], [-122.46587, 37.58833], [-122.46498, 37.58832], [-122.46384, 37.58843], [-122.46356, 37.58842], [-122.46248, 37.58827], [-122.4622, 37.58821], [-122.46167, 37.58804], [-122.46003, 37.58769], [-122.45809, 37.58706], [-122.45803, 37.58698], [-122.4658, 37.58332], [-122.46672, 37.58456], [-122.46656, 37.58464], [-122.46645, 37.58476], [-122.46641, 37.58486], [-122.46629, 37.58528], [-122.46626, 37.58531], [-122.46621, 37.58532], [-122.46618, 37.58545], [-122.46746, 37.58568]]]} | Open Access 1 | 18507 | Frontierland Park | 19135 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 61.615 | Frontierland Park | 0 | Local Park 2 | 4 | |
3164 | 3164 | 3163 | {"type": "Polygon", "coordinates": [[[-122.49502, 37.62961], [-122.49505, 37.63001], [-122.49505, 37.63036], [-122.49496, 37.63119], [-122.49471, 37.63598], [-122.4946, 37.63603], [-122.49456, 37.63632], [-122.49446, 37.63656], [-122.49438, 37.63681], [-122.49433, 37.63719], [-122.49406, 37.637], [-122.49407, 37.63665], [-122.49406, 37.63599], [-122.49411, 37.63561], [-122.4941, 37.63519], [-122.49414, 37.63485], [-122.4942, 37.63386], [-122.49415, 37.63353], [-122.49413, 37.63313], [-122.49407, 37.63272], [-122.49383, 37.63194], [-122.4937, 37.63164], [-122.49368, 37.63123], [-122.49372, 37.63078], [-122.49369, 37.63035], [-122.49376, 37.63008], [-122.49401, 37.63002], [-122.49434, 37.63], [-122.49458, 37.62988], [-122.49502, 37.62961]]]} | Open Access 1 | 21950 | Sharp Park Beach | 25364 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 14.338 | Sharp Park Beach | 0 | Local Park 2 | 4 | |
3800 | 3800 | 3799 | {"type": "Polygon", "coordinates": [[[-122.49357, 37.64899], [-122.4935, 37.65064], [-122.49285, 37.65056], [-122.49308, 37.64929], [-122.4932, 37.6491], [-122.49325, 37.64896], [-122.49357, 37.64899]]]} | Open Access 1 | 35108 | Pacifica Esplanade | 23308 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 2.083 | Pacifica Esplanade | None 318 | |||
4292 | 4292 | 4291 | {"type": "Polygon", "coordinates": [[[-122.47915, 37.65481], [-122.47904, 37.65494], [-122.47891, 37.65513], [-122.4788, 37.65535], [-122.47874, 37.65553], [-122.4787, 37.65572], [-122.47868, 37.65593], [-122.47873, 37.65638], [-122.47847, 37.6564], [-122.47839, 37.65644], [-122.47835, 37.6565], [-122.47835, 37.65658], [-122.47844, 37.65679], [-122.4785, 37.65723], [-122.47845, 37.65724], [-122.47845, 37.65751], [-122.4784, 37.65751], [-122.47841, 37.65737], [-122.47837, 37.65722], [-122.47829, 37.657], [-122.47819, 37.6568], [-122.47642, 37.65406], [-122.47623, 37.65399], [-122.47603, 37.65407], [-122.47569, 37.65354], [-122.47566, 37.65343], [-122.47545, 37.65311], [-122.47401, 37.65226], [-122.4739, 37.65226], [-122.47331, 37.65141], [-122.47338, 37.65139], [-122.4742, 37.65218], [-122.4743, 37.65227], [-122.47444, 37.65235], [-122.47592, 37.65297], [-122.47625, 37.65306], [-122.47657, 37.65309], [-122.47655, 37.65355], [-122.47718, 37.65405], [-122.47732, 37.65412], [-122.47749, 37.65416], [-122.47765, 37.65418], [-122.47784, 37.65417], [-122.47785, 37.65422], [-122.47819, 37.65419], [-122.47822, 37.6543], [-122.47831, 37.65438], [-122.47834, 37.65456], [-122.47867, 37.65453], [-122.4787, 37.65467], [-122.47887, 37.65465], [-122.47915, 37.65481]]]} | Open Access 1 | 14647 | Imperial Park | 20181 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 12.743 | Imperial Park | 0 | Local Park 2 | 4 | |
4943 | 4943 | 4942 | {"type": "Polygon", "coordinates": [[[-122.48335, 37.63599], [-122.48332, 37.63609], [-122.48205, 37.63607], [-122.48206, 37.63561], [-122.48335, 37.63599]]]} | Open Access 1 | 14653 | Pomo Park | 23880 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.887 | Pomo Park | 0 | Local Park 2 | 4 | |
5451 | 5451 | 5450 | {"type": "Polygon", "coordinates": [[[-122.48486, 37.59659], [-122.48406, 37.59704], [-122.48453, 37.59732], [-122.48449, 37.59789], [-122.48301, 37.59801], [-122.48292, 37.59739], [-122.48256, 37.59742], [-122.48254, 37.59721], [-122.48289, 37.59717], [-122.48281, 37.59655], [-122.48276, 37.59639], [-122.4827, 37.59624], [-122.48261, 37.59609], [-122.48276, 37.59602], [-122.48227, 37.59522], [-122.4815, 37.59455], [-122.48154, 37.59436], [-122.48227, 37.59377], [-122.48316, 37.5953], [-122.48318, 37.5953], [-122.4832, 37.59514], [-122.48356, 37.59517], [-122.48363, 37.59536], [-122.48402, 37.59563], [-122.48415, 37.59604], [-122.48486, 37.59659]]]} | Open Access 1 | 24966 | Fassler Park | 18850 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 13.442 | Fassler Park | 0 | Local Park 2 | 4 | |
5621 | 5621 | 5620 | {"type": "Polygon", "coordinates": [[[-122.48191, 37.65869], [-122.48022, 37.65948], [-122.47994, 37.65915], [-122.48007, 37.65887], [-122.48018, 37.65857], [-122.47985, 37.6585], [-122.47988, 37.65839], [-122.48022, 37.65845], [-122.4803, 37.65811], [-122.48035, 37.65773], [-122.48033, 37.65762], [-122.4802, 37.65732], [-122.48097, 37.65705], [-122.48191, 37.65869]]]} | Open Access 1 | 14644 | Fairmont Park | 18806 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 6.458 | Fairmont Park | 0 | Local Park 2 | 4 | |
5622 | 5622 | 5621 | {"type": "Polygon", "coordinates": [[[-122.48783, 37.65343], [-122.48751, 37.65378], [-122.48743, 37.65376], [-122.48732, 37.65381], [-122.48696, 37.65377], [-122.48679, 37.65385], [-122.48662, 37.65364], [-122.4866, 37.65358], [-122.48666, 37.65328], [-122.48738, 37.65336], [-122.48762, 37.6533], [-122.48783, 37.65343]]]} | Open Access 1 | 14650 | Edgemar Park | 18436 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 1.18 | Edgemar Park | 0 | Local Park 2 | 4 | |
7824 | 7824 | 7823 | {"type": "Polygon", "coordinates": [[[-122.48429, 37.59997], [-122.48425, 37.601], [-122.48421, 37.60101], [-122.4842, 37.60205], [-122.48412, 37.602], [-122.48403, 37.60201], [-122.48397, 37.60205], [-122.48394, 37.60211], [-122.48396, 37.60216], [-122.48402, 37.60223], [-122.48411, 37.60228], [-122.4842, 37.6023], [-122.48415, 37.60367], [-122.48402, 37.60963], [-122.48335, 37.60962], [-122.48332, 37.61013], [-122.48313, 37.61014], [-122.4831, 37.6103], [-122.48256, 37.6103], [-122.48249, 37.6119], [-122.48246, 37.6119], [-122.48238, 37.61232], [-122.48272, 37.61233], [-122.48273, 37.61229], [-122.48315, 37.61229], [-122.48314, 37.61277], [-122.48303, 37.61278], [-122.48252, 37.61276], [-122.48199, 37.61266], [-122.48134, 37.61243], [-122.48126, 37.61234], [-122.48116, 37.61227], [-122.48103, 37.61221], [-122.48089, 37.61218], [-122.48074, 37.61218], [-122.48061, 37.61219], [-122.48047, 37.61224], [-122.48036, 37.61231], [-122.47961, 37.6123], [-122.47909, 37.6122], [-122.47875, 37.61208], [-122.47859, 37.6119], [-122.47827, 37.6117], [-122.47848, 37.6108], [-122.4789, 37.61085], [-122.4794, 37.60871], [-122.47855, 37.60858], [-122.47861, 37.60831], [-122.47826, 37.60826], [-122.47819, 37.60853], [-122.47751, 37.60844], [-122.47713, 37.61021], [-122.47686, 37.61018], [-122.47657, 37.61147], [-122.47641, 37.61149], [-122.47635, 37.61155], [-122.47618, 37.61162], [-122.47618, 37.61166], [-122.47533, 37.61154], [-122.47481, 37.61139], [-122.47418, 37.6113], [-122.47403, 37.61126], [-122.47349, 37.61072], [-122.47378, 37.61056], [-122.47373, 37.61048], [-122.47355, 37.60974], [-122.47356, 37.60954], [-122.47386, 37.60909], [-122.47364, 37.60881], [-122.47337, 37.60872], [-122.47302, 37.60882], [-122.47276, 37.60919], [-122.47259, 37.60927], [-122.47174, 37.60903], [-122.47143, 37.60916], [-122.47171, 37.60937], [-122.47166, 37.60941], [-122.4714, 37.60922], [-122.47045, 37.60878], [-122.47613, 37.59749], [-122.47623, 37.59759], [-122.47619, 37.59761], [-122.4766, 37.59832], [-122.4769, 37.59821], [-122.4777, 37.59904], [-122.47843, 37.59869], [-122.478, 37.59788], [-122.47832, 37.59775], [-122.47897, 37.59755], [-122.47939, 37.59738], [-122.48018, 37.59787], [-122.48024, 37.5982], [-122.48026, 37.59853], [-122.47991, 37.59846], [-122.47966, 37.59844], [-122.47941, 37.59848], [-122.47918, 37.59856], [-122.47898, 37.59869], [-122.47859, 37.5992], [-122.47859, 37.59922], [-122.47939, 37.59952], [-122.47966, 37.59916], [-122.48033, 37.59932], [-122.4805, 37.59928], [-122.48076, 37.59944], [-122.48085, 37.59934], [-122.48093, 37.59923], [-122.48122, 37.59929], [-122.48122, 37.59937], [-122.48191, 37.59934], [-122.4822, 37.59946], [-122.48364, 37.59971], [-122.48359, 37.59995], [-122.48429, 37.59997]]]} | Open Access 1 | 9277 | Sweeney Ridge | 8294 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/parksbeaches/beach_and_park_info_and_rules/sweeny/default.asp | San Mateo 15 | 327.796 | Sweeney Ridge | None 652 | ||
8926 | 8926 | 8925 | {"type": "Polygon", "coordinates": [[[-122.48978, 37.5917], [-122.48929, 37.59194], [-122.48923, 37.59194], [-122.48925, 37.5922], [-122.48876, 37.59225], [-122.48864, 37.59229], [-122.48851, 37.59236], [-122.48839, 37.59225], [-122.48576, 37.59164], [-122.48526, 37.59119], [-122.48495, 37.59195], [-122.48479, 37.59275], [-122.48475, 37.59276], [-122.4849, 37.59197], [-122.48398, 37.59171], [-122.48465, 37.59015], [-122.4847, 37.59006], [-122.48477, 37.58998], [-122.48486, 37.58994], [-122.48503, 37.5899], [-122.48546, 37.58985], [-122.48594, 37.58991], [-122.48718, 37.58976], [-122.48723, 37.58977], [-122.48805, 37.5902], [-122.48817, 37.59104], [-122.48939, 37.59187], [-122.48977, 37.59168], [-122.48978, 37.5917]]]} | Open Access 1 | 14662 | Oddstad Park | 23070 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 19.937 | Oddstad Park | 0 | Local Park 2 | 4 | |
8928 | 8928 | 8927 | {"type": "Polygon", "coordinates": [[[-122.48438, 37.66358], [-122.4839, 37.66357], [-122.48388, 37.66343], [-122.48379, 37.6633], [-122.48372, 37.66324], [-122.48361, 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 | 14669 | Edgewood Park | 18442 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 7.393 | Edgewood Park | 2000 | Local Park 2 | 4 | |
8929 | 8929 | 8928 | {"type": "Polygon", "coordinates": [[[-122.48269, 37.61961], [-122.48258, 37.61968], [-122.48252, 37.61978], [-122.48247, 37.62111], [-122.4811, 37.62108], [-122.48108, 37.62134], [-122.48104, 37.62134], [-122.48105, 37.62108], [-122.48039, 37.62106], [-122.48039, 37.62092], [-122.48052, 37.62051], [-122.48091, 37.61992], [-122.48252, 37.61922], [-122.48269, 37.61961]]]} | Open Access 1 | 14672 | Fairway Park Baseball Fields | 18826 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 6.945 | Fairway Park Baseball Fields | 0 | Local Recreation Area 3 | 4 | |
8934 | 8934 | 8933 | {"type": "Polygon", "coordinates": [[[-122.49868, 37.59281], [-122.49843, 37.59295], [-122.49823, 37.59278], [-122.49854, 37.59259], [-122.49868, 37.59281]]]} | Open Access 1 | 14667 | Portola Mini Park | 23908 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.206 | Portola MP | 0 | Local Park 2 | 4 | |
9655 | 9655 | 9654 | {"type": "Polygon", "coordinates": [[[-122.48686, 37.66026], [-122.48678, 37.66038], [-122.48669, 37.66045], [-122.4858, 37.66077], [-122.48564, 37.6605], [-122.48545, 37.66028], [-122.48524, 37.66012], [-122.48494, 37.65994], [-122.4847, 37.65967], [-122.48446, 37.65954], [-122.48451, 37.65941], [-122.48458, 37.65945], [-122.48478, 37.65901], [-122.48486, 37.65891], [-122.48507, 37.65871], [-122.48531, 37.65854], [-122.48529, 37.65909], [-122.48534, 37.65925], [-122.48546, 37.65938], [-122.48579, 37.65922], [-122.48647, 37.65925], [-122.4865, 37.65929], [-122.4865, 37.65963], [-122.48655, 37.65984], [-122.48667, 37.66006], [-122.48686, 37.66026]]]} | Open Access 1 | 16284 | Fairmont West Park | 18810 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 5.88 | Fairmont West Park | 0 | Local Park 2 | 4 | |
10437 | 10437 | 10436 | {"type": "Polygon", "coordinates": [[[-122.52097, 37.59402], [-122.52099, 37.59408], [-122.52099, 37.59428], [-122.52093, 37.59439], [-122.52074, 37.59442], [-122.52061, 37.59443], [-122.52058, 37.59449], [-122.5205, 37.59453], [-122.52033, 37.59455], [-122.52025, 37.5946], [-122.52017, 37.59463], [-122.51975, 37.59464], [-122.51958, 37.59469], [-122.51917, 37.5947], [-122.51892, 37.59484], [-122.5185, 37.59485], [-122.51834, 37.5949], [-122.51828, 37.59497], [-122.51819, 37.59501], [-122.51778, 37.59502], [-122.51761, 37.59507], [-122.5172, 37.59508], [-122.51701, 37.59512], [-122.5165, 37.59512], [-122.51626, 37.59515], [-122.51597, 37.59524], [-122.51588, 37.59529], [-122.51571, 37.59531], [-122.51551, 37.59536], [-122.51537, 37.59549], [-122.51529, 37.59554], [-122.51512, 37.59554], [-122.51347, 37.5945], [-122.51307, 37.59399], [-122.51275, 37.59381], [-122.51286, 37.59367], [-122.51259, 37.59352], [-122.51246, 37.59366], [-122.51204, 37.59343], [-122.51179, 37.5931], [-122.51141, 37.59296], [-122.51096, 37.5922], [-122.51093, 37.59187], [-122.51242, 37.59017], [-122.51143, 37.5896], [-122.5106, 37.59054], [-122.50989, 37.59015], [-122.50851, 37.59172], [-122.50851, 37.59173], [-122.50923, 37.59212], [-122.50899, 37.5924], [-122.50912, 37.59248], [-122.50907, 37.59254], [-122.5089, 37.59244], [-122.50899, 37.59235], [-122.50899, 37.59233], [-122.50527, 37.59026], [-122.50488, 37.59071], [-122.50595, 37.59129], [-122.50626, 37.59184], [-122.50652, 37.59183], [-122.5066, 37.59185], [-122.50666, 37.59189], [-122.50673, 37.59199], [-122.50671, 37.59213], [-122.50673, 37.59224], [-122.50679, 37.59234], [-122.50687, 37.59241], [-122.5066, 37.59296], [-122.50602, 37.59278], [-122.50591, 37.59294], [-122.5053, 37.59136], [-122.5043, 37.5909], [-122.50421, 37.59074], [-122.50415, 37.59057], [-122.50414, 37.59037], [-122.50418, 37.59018], [-122.50428, 37.58995], [-122.50441, 37.58976], [-122.50463, 37.58956], [-122.50567, 37.58884], [-122.50567, 37.58774], [-122.50485, 37.58713], [-122.50475, 37.58703], [-122.50464, 37.58689], [-122.50455, 37.5867], [-122.5045, 37.58648], [-122.50452, 37.58628], [-122.50459, 37.58606], [-122.50469, 37.5859], [-122.50485, 37.58574], [-122.50504, 37.5856], [-122.50526, 37.5855], [-122.50551, 37.58544], [-122.50715, 37.58515], [-122.50722, 37.58527], [-122.50759, 37.58522], [-122.50801, 37.58521], [-122.50802, 37.58514], [-122.50851, 37.58519], [-122.50903, 37.58529], [-122.5102, 37.58561], [-122.51049, 37.58565], [-122.51078, 37.58567], [-122.51721, 37.58515], [-122.51708, 37.58537], [-122.51708, 37.58545], [-122.51701, 37.58552], [-122.51696, 37.58562], [-122.517, 37.58572], [-122.51692, 37.58581], [-122.51691, 37.58593], [-122.51688, 37.586], [-122.51689, 37.58611], [-122.51688, 37.58625], [-122.51688, 37.58632], [-122.51694, 37.58652], [-122.51691, 37.58657], [-122.5169, 37.58663], [-122.51692, 37.58697], [-122.51697, 37.58714], [-122.51697, 37.5872], [-122.51701, 37.58738], [-122.51702, 37.5875], [-122.51706, 37.58756], [-122.51708, 37.58761], [-122.51709, 37.58791], [-122.51712, 37.58797], [-122.51713, 37.58803], [-122.5171, 37.58821], [-122.51708, 37.58827], [-122.51707, 37.58845], [-122.51703, 37.58857], [-122.51704, 37.58868], [-122.517, 37.5888], [-122.51702, 37.58904], [-122.51698, 37.5891], [-122.51697, 37.58916], [-122.517, 37.58945], [-122.51696, 37.58958], [-122.51694, 37.5897], [-122.517, 37.58982], [-122.517, 37.58994], [-122.51698, 37.59006], [-122.51702, 37.59017], [-122.51705, 37.59065], [-122.51712, 37.59077], [-122.51717, 37.59088], [-122.51717, 37.59094], [-122.51723, 37.591], [-122.51731, 37.59112], [-122.51739, 37.59117], [-122.5174, 37.59123], [-122.51747, 37.59125], [-122.51756, 37.5913], [-122.51758, 37.59136], [-122.51771, 37.59147], [-122.51787, 37.59143], [-122.51794, 37.59144], [-122.51799, 37.59156], [-122.51814, 37.59154], [-122.51822, 37.59157], [-122.5182, 37.59168], [-122.51826, 37.59174], [-122.51827, 37.5918], [-122.51849, 37.59195], [-122.51864, 37.59202], [-122.51887, 37.59216], [-122.51892, 37.59222], [-122.51919, 37.59238], [-122.51931, 37.59251], [-122.51932, 37.59264], [-122.51948, 37.59273], [-122.51965, 37.59273], [-122.51972, 37.59279], [-122.5198, 37.59285], [-122.51982, 37.59291], [-122.51991, 37.59304], [-122.52011, 37.59324], [-122.52015, 37.5933], [-122.52032, 37.59337], [-122.5204, 37.59342], [-122.52047, 37.59348], [-122.52052, 37.59361], [-122.52061, 37.59367], [-122.52066, 37.59373], [-122.52074, 37.59377], [-122.52086, 37.5939], [-122.52088, 37.59396], [-122.52097, 37.59402]], [[-122.51472, 37.59234], [-122.51471, 37.59235], [-122.51473, 37.59276], [-122.51516, 37.59274], [-122.51515, 37.59234], [-122.51472, 37.59234]]]} | No Public Access 3 | 18442 | Pedro Point Headlands | 23562 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 237.836 | Pedro Point Headlands | None 911 | |||
11586 | 11586 | 11585 | {"type": "Polygon", "coordinates": [[[-122.48853, 37.58277], [-122.48701, 37.58454], [-122.48674, 37.58438], [-122.48648, 37.58417], [-122.48626, 37.58395], [-122.48597, 37.5836], [-122.48578, 37.58345], [-122.48697, 37.58208], [-122.48761, 37.58223], [-122.48809, 37.58168], [-122.48813, 37.58169], [-122.48776, 37.58215], [-122.48853, 37.58277]]]} | Open Access 1 | 23681 | Sanchez Park | 25008 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 8.902 | Sanchez Park | 0 | Local Park 2 | 4 | |
13157 | 13157 | 13156 | {"type": "MultiPolygon", "coordinates": [[[[-122.50554, 37.59598], [-122.50508, 37.59614], [-122.50486, 37.59625], [-122.50464, 37.59638], [-122.50451, 37.59625], [-122.50495, 37.59601], [-122.50546, 37.59582], [-122.50554, 37.59598]]], [[[-122.50577, 37.59605], [-122.50554, 37.59627], [-122.50546, 37.59647], [-122.50531, 37.59657], [-122.50484, 37.59631], [-122.5054, 37.59615], [-122.50538, 37.59608], [-122.50549, 37.59605], [-122.50553, 37.59612], [-122.50577, 37.59605]]]]} | Open Access 1 | 35107 | City of Pacifica | 17326 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.889 | City of Pacifica | None 1140 | |||
14858 | 14858 | 14857 | {"type": "Polygon", "coordinates": [[[-122.48077, 37.61419], [-122.4807, 37.61426], [-122.48046, 37.61418], [-122.48031, 37.61418], [-122.48019, 37.61413], [-122.47989, 37.61388], [-122.47915, 37.61355], [-122.47867, 37.61305], [-122.47857, 37.61298], [-122.47823, 37.61288], [-122.47784, 37.6128], [-122.4771, 37.61251], [-122.47688, 37.61246], [-122.47665, 37.61243], [-122.47606, 37.61242], [-122.47567, 37.61248], [-122.47526, 37.61255], [-122.47472, 37.61239], [-122.47457, 37.61231], [-122.47441, 37.61222], [-122.47428, 37.6121], [-122.47417, 37.61197], [-122.4741, 37.61183], [-122.47409, 37.61161], [-122.47406, 37.61145], [-122.4741, 37.61143], [-122.47415, 37.61147], [-122.47415, 37.61164], [-122.47417, 37.61176], [-122.47422, 37.61188], [-122.4743, 37.61199], [-122.47448, 37.61212], [-122.47483, 37.61228], [-122.47524, 37.61235], [-122.47599, 37.6123], [-122.47673, 37.61228], [-122.47694, 37.61229], [-122.47725, 37.61237], [-122.47751, 37.61248], [-122.47795, 37.61269], [-122.47814, 37.61274], [-122.47851, 37.6128], [-122.47877, 37.6129], [-122.47893, 37.61301], [-122.47919, 37.61324], [-122.47953, 37.61362], [-122.47986, 37.61376], [-122.4802, 37.61396], [-122.48048, 37.614], [-122.48077, 37.61419]]]} | Open Access 1 | 45385 | Calera Creek Park | 27898 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 2.784 | Calera Creek Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);