units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
206 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 7 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 24
MNG_AGENCY 7
- Los Angeles - Department of Parks and Recreation, County of 57
- Sonoma County Regional Parks Dept., County of 47
- Santa Clara County Parks and Recreation Dept., County of 40
- Marin County Parks Department, County of 32
- San Mateo County Parks and Recreation Dept., County of 24
- Del Norte County Parks, County of 5
- Yolo County Parks, County of 1
LAYER 6 ✖
MNG_AG_TYP 1
- County Agency - Parks · 206 ✖
ACCESS_TYP 1
- Open Access · 206 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
436 | 436 | 435 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | 840 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.255 | Black Point Boat Launch | None 45 | |||
2827 | 2827 | 2826 | {"type": "Polygon", "coordinates": [[[-123.35157, 38.74579], [-123.34595, 38.75146], [-123.34467, 38.75147], [-123.34463, 38.75104], [-123.34467, 38.75081], [-123.34467, 38.75048], [-123.3446, 38.74979], [-123.34462, 38.74965], [-123.34469, 38.74948], [-123.3448, 38.74935], [-123.34489, 38.74928], [-123.34501, 38.74924], [-123.34538, 38.74919], [-123.34563, 38.74912], [-123.34655, 38.74867], [-123.34697, 38.74845], [-123.34716, 38.74831], [-123.34759, 38.74796], [-123.34798, 38.74758], [-123.34816, 38.74738], [-123.34831, 38.74715], [-123.34849, 38.74679], [-123.34856, 38.74646], [-123.34856, 38.74625], [-123.34862, 38.74602], [-123.34891, 38.74524], [-123.34929, 38.74454], [-123.34942, 38.74438], [-123.34971, 38.74414], [-123.34987, 38.74391], [-123.34991, 38.74379], [-123.34994, 38.74357], [-123.34999, 38.74332], [-123.35017, 38.74288], [-123.35041, 38.74316], [-123.35054, 38.74344], [-123.35061, 38.74351], [-123.35068, 38.74355], [-123.35115, 38.74372], [-123.35137, 38.74388], [-123.35177, 38.74439], [-123.35189, 38.7446], [-123.35193, 38.74474], [-123.3519, 38.74493], [-123.35179, 38.74512], [-123.35157, 38.74535], [-123.35157, 38.74579]]]} | Open Access 1 | 950 | Soda Springs | 25589 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 43.51 | Soda Springs | None 234 | |||
3251 | 3251 | 3250 | {"type": "Polygon", "coordinates": [[[-118.29179, 33.95328], [-118.2918, 33.95365], [-118.29183, 33.9538], [-118.29183, 33.9539], [-118.29183, 33.95646], [-118.29181, 33.95682], [-118.29178, 33.957], [-118.29171, 33.95701], [-118.29167, 33.95699], [-118.29163, 33.95683], [-118.29164, 33.95301], [-118.29179, 33.95328]]]} | Open Access 1 | 48155 | Vermont Median | 32692 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/vermont-median/ | Los Angeles 6 | 1.804 | Vermont Median | None 267 | ||
3601 | 3601 | 3600 | {"type": "MultiPolygon", "coordinates": [[[[-121.85226, 37.38638], [-121.8517, 37.38678], [-121.84999, 37.38813], [-121.84975, 37.38828], [-121.84945, 37.38842], [-121.84944, 37.38838], [-121.85006, 37.38798], [-121.85006, 37.38796], [-121.84987, 37.38783], [-121.85011, 37.38763], [-121.85023, 37.38778], [-121.85081, 37.38712], [-121.8512, 37.38685], [-121.85151, 37.38647], [-121.85171, 37.38635], [-121.85226, 37.38638]]], [[[-121.8717, 37.37057], [-121.87117, 37.37057], [-121.87095, 37.37043], [-121.87064, 37.37051], [-121.86992, 37.37065], [-121.86924, 37.37057], [-121.8692, 37.3705], [-121.86676, 37.37021], [-121.86657, 37.3702], [-121.86634, 37.37021], [-121.86595, 37.37028], [-121.86565, 37.37039], [-121.86544, 37.37049], [-121.86287, 37.37227], [-121.86274, 37.37237], [-121.86252, 37.3726], [-121.86243, 37.37272], [-121.86232, 37.37295], [-121.86225, 37.37319], [-121.8622, 37.37382], [-121.86203, 37.37448], [-121.86205, 37.37456], [-121.8621, 37.37463], [-121.86223, 37.3747], [-121.86221, 37.37506], [-121.86222, 37.37604], [-121.86227, 37.3762], [-121.86235, 37.37636], [-121.86312, 37.37716], [-121.86253, 37.3777], [-121.86248, 37.37771], [-121.86245, 37.37771], [-121.86128, 37.37648], [-121.86152, 37.37246], [-121.86147, 37.37241], [-121.86171, 37.37224], [-121.86176, 37.37229], [-121.86466, 37.37034], [-121.86466, 37.37032], [-121.8645, 37.37036], [-121.86575, 37.36952], [-121.86589, 37.36949], [-121.86599, 37.36949], [-121.86606, 37.3695], [-121.86615, 37.36954], [-121.86782, 37.3697], [-121.86789, 37.36974], [-121.86791, 37.36972], [-121.86851, 37.36982], [-121.86876, 37.36991], [-121.86895, 37.36995], [-121.86908, 37.37003], [-121.8692, 37.37008], [-121.8693, 37.37008], [-121.8694, 37.37001], [-121.87017, 37.37015], [-121.87028, 37.37018], [-121.87029, 37.37016], [-121.87117, 37.3698], [-121.8717, 37.37057]]]]} | Open Access 1 | 29198 | Penitencia Creek Park Chain | 23583 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 27.686 | Penitencia Creek Park Chain | None 301 | |||
6115 | 6115 | 6114 | {"type": "MultiPolygon", "coordinates": [[[[-123.05884, 38.33058], [-123.05777, 38.33077], [-123.05767, 38.33053], [-123.05616, 38.33055], [-123.05556, 38.32857], [-123.05646, 38.32713], [-123.05652, 38.32695], [-123.05688, 38.32692], [-123.05712, 38.32695], [-123.05735, 38.32701], [-123.05769, 38.32718], [-123.05788, 38.32732], [-123.05816, 38.32762], [-123.05867, 38.32831], [-123.05872, 38.32849], [-123.05872, 38.32869], [-123.05868, 38.32897], [-123.05856, 38.32941], [-123.05863, 38.32979], [-123.05884, 38.33058]]], [[[-123.05969, 38.3286], [-123.05952, 38.32868], [-123.0593, 38.32867], [-123.05925, 38.32877], [-123.05911, 38.32884], [-123.05908, 38.32846], [-123.05891, 38.32808], [-123.05881, 38.32789], [-123.05853, 38.32758], [-123.05825, 38.32737], [-123.05806, 38.32705], [-123.05785, 38.3269], [-123.05747, 38.32679], [-123.05731, 38.32677], [-123.05729, 38.3265], [-123.05746, 38.32646], [-123.0581, 38.32675], [-123.05864, 38.32714], [-123.05969, 38.3286]]]]} | Open Access 1 | 1082 | Spud Pt Marina | 25754 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 24.565 | Spud Pt Marina | None 492 | |||
6818 | 6818 | 6817 | {"type": "MultiPolygon", "coordinates": [[[[-123.02044, 38.30739], [-123.02032, 38.30759], [-123.01898, 38.30678], [-123.01775, 38.30775], [-123.01734, 38.30784], [-123.01842, 38.30689], [-123.01802, 38.30655], [-123.01746, 38.30633], [-123.01739, 38.30606], [-123.01702, 38.30591], [-123.0167, 38.30553], [-123.01626, 38.30557], [-123.01569, 38.30569], [-123.01531, 38.30565], [-123.01508, 38.30559], [-123.01512, 38.30537], [-123.01498, 38.30531], [-123.01487, 38.3052], [-123.0148, 38.30502], [-123.01479, 38.30481], [-123.01452, 38.30454], [-123.0139, 38.30439], [-123.01392, 38.30419], [-123.01392, 38.30401], [-123.01383, 38.30389], [-123.01358, 38.30383], [-123.01338, 38.30382], [-123.01323, 38.30374], [-123.01305, 38.30358], [-123.01339, 38.30321], [-123.01434, 38.30362], [-123.01488, 38.30407], [-123.01517, 38.30465], [-123.01575, 38.30478], [-123.01764, 38.3054], [-123.01844, 38.3063], [-123.01939, 38.30691], [-123.02044, 38.30739]]], [[[-123.01475, 38.31344], [-123.01439, 38.3134], [-123.01424, 38.31289], [-123.01432, 38.31273], [-123.01441, 38.31278], [-123.01465, 38.31281], [-123.01475, 38.31344]]]]} | Open Access 1 | 5390 | Pinnacle Gulch | 23699 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 12.038 | Pinnacle Gulch | None 554 | |||
7831 | 7831 | 7830 | {"type": "Polygon", "coordinates": [[[-122.51046, 37.51201], [-122.51023, 37.51234], [-122.50987, 37.51294], [-122.50983, 37.51292], [-122.50706, 37.51697], [-122.50076, 37.5116], [-122.50136, 37.51061], [-122.50087, 37.51021], [-122.50163, 37.50897], [-122.50091, 37.50795], [-122.50104, 37.50785], [-122.50038, 37.50695], [-122.50001, 37.50719], [-122.49898, 37.50631], [-122.49883, 37.50653], [-122.49817, 37.50681], [-122.49557, 37.50574], [-122.4949, 37.50607], [-122.49505, 37.50582], [-122.49492, 37.50576], [-122.4946, 37.5047], [-122.494, 37.5042], [-122.49436, 37.5036], [-122.49452, 37.50365], [-122.49471, 37.50331], [-122.49457, 37.50324], [-122.49472, 37.50299], [-122.49465, 37.50191], [-122.49398, 37.50143], [-122.49432, 37.50124], [-122.49578, 37.50023], [-122.49585, 37.50037], [-122.49593, 37.50051], [-122.49634, 37.50095], [-122.49652, 37.50132], [-122.49654, 37.50142], [-122.49664, 37.50204], [-122.49673, 37.50251], [-122.49673, 37.50345], [-122.4967, 37.5036], [-122.49666, 37.50368], [-122.49674, 37.50378], [-122.49841, 37.50458], [-122.49871, 37.50239], [-122.49742, 37.50097], [-122.4972, 37.49987], [-122.4983, 37.49966], [-122.49979, 37.49844], [-122.49984, 37.49849], [-122.49978, 37.49862], [-122.49996, 37.49876], [-122.50002, 37.49897], [-122.49996, 37.49897], [-122.49914, 37.49951], [-122.49909, 37.4997], [-122.49903, 37.50002], [-122.49892, 37.50017], [-122.49884, 37.50042], [-122.49887, 37.50077], [-122.49902, 37.50115], [-122.49912, 37.50132], [-122.49954, 37.50174], [-122.49966, 37.50174], [-122.49981, 37.50193], [-122.49974, 37.50204], [-122.49974, 37.50223], [-122.49983, 37.50247], [-122.50002, 37.50288], [-122.50028, 37.50332], [-122.50044, 37.50343], [-122.50067, 37.50356], [-122.5011, 37.50398], [-122.50167, 37.50469], [-122.5019, 37.50487], [-122.50202, 37.50501], [-122.50209, 37.50507], [-122.50219, 37.50512], [-122.50229, 37.50513], [-122.50238, 37.50519], [-122.50258, 37.50522], [-122.50271, 37.50536], [-122.5029, 37.50543], [-122.50306, 37.50554], [-122.50325, 37.50562], [-122.50351, 37.50578], [-122.50374, 37.50595], [-122.50383, 37.506], [-122.50403, 37.50606], [-122.50419, 37.50617], [-122.5043, 37.50616], [-122.50462, 37.5062], [-122.50481, 37.50628], [-122.50487, 37.50634], [-122.50492, 37.50641], [-122.50515, 37.5066], [-122.50542, 37.50688], [-122.5056, 37.50697], [-122.50566, 37.50704], [-122.50581, 37.50716], [-122.50591, 37.50731], [-122.50598, 37.50738], [-122.5061, 37.50752], [-122.50625, 37.50776], [-122.50632, 37.50783], [-122.50638, 37.508], [-122.50646, 37.50806], [-122.50657, 37.5082], [-122.50664, 37.50827], [-122.50674, 37.50843], [-122.50687, 37.50857], [-122.507, 37.5088], [-122.50738, 37.50922], [-122.50761, 37.5094], [-122.5077, 37.50956], [-122.5078, 37.50965], [-122.50804, 37.50923], [-122.50827, 37.50949], [-122.5092, 37.51101], [-122.51046, 37.51201]], [[-122.49897, 37.5063], [-122.49912, 37.50606], [-122.49883, 37.50595], [-122.49869, 37.50619], [-122.49897, 37.5063]]]} | Open Access 1 | 9314 | Pillar Point Bluff | 23670 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 226.452 | Pillar Point Bluff | None 655 | |||
9580 | 9580 | 9579 | {"type": "Polygon", "coordinates": [[[-123.01417, 38.82042], [-123.0134, 38.82108], [-123.01282, 38.82135], [-123.01202, 38.8195], [-123.01148, 38.82068], [-123.0119, 38.82141], [-123.01075, 38.82218], [-123.01038, 38.82201], [-123.01106, 38.81947], [-123.01124, 38.81872], [-123.01154, 38.81652], [-123.01282, 38.81658], [-123.01291, 38.81682], [-123.01369, 38.81915], [-123.0138, 38.81913], [-123.01417, 38.82042]]]} | Open Access 1 | 16110 | Andersen | 15475 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 26.026 | Andersen | None 803 | |||
9743 | 9743 | 9742 | {"type": "Polygon", "coordinates": [[[-122.92217, 38.20098], [-122.92176, 38.20118], [-122.921, 38.20137], [-122.92095, 38.20128], [-122.92092, 38.2012], [-122.92095, 38.20094], [-122.92095, 38.20081], [-122.92091, 38.20059], [-122.92068, 38.19975], [-122.92049, 38.19943], [-122.92169, 38.1991], [-122.92204, 38.19964], [-122.92217, 38.20098]]]} | Open Access 1 | 17903 | Miller Park Boat Launch | 22247 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 6.084 | Miller Park Boat Launch | None 841 | |||
9844 | 9844 | 9843 | {"type": "MultiPolygon", "coordinates": [[[[-123.51798, 38.7595], [-123.51777, 38.75999], [-123.51747, 38.76173], [-123.51724, 38.76379], [-123.517, 38.76481], [-123.5147, 38.7628], [-123.51459, 38.76223], [-123.51383, 38.76176], [-123.51422, 38.76094], [-123.51445, 38.76072], [-123.51467, 38.76053], [-123.51426, 38.76014], [-123.51464, 38.75949], [-123.51546, 38.75936], [-123.51537, 38.75886], [-123.51594, 38.75748], [-123.51587, 38.75739], [-123.51588, 38.75718], [-123.51595, 38.75706], [-123.51595, 38.75661], [-123.51613, 38.75754], [-123.5162, 38.75775], [-123.51634, 38.75802], [-123.51687, 38.75867], [-123.5173, 38.75905], [-123.51798, 38.7595]]], [[[-123.5159, 38.75641], [-123.5158, 38.75602], [-123.51568, 38.75584], [-123.51553, 38.75569], [-123.51552, 38.7554], [-123.51572, 38.75534], [-123.5159, 38.75641]]], [[[-123.53373, 38.76863], [-123.53304, 38.7685], [-123.53278, 38.76806], [-123.53176, 38.76687], [-123.53125, 38.76681], [-123.5298, 38.76521], [-123.52981, 38.7649], [-123.53001, 38.76457], [-123.52888, 38.76395], [-123.52854, 38.76395], [-123.52816, 38.7637], [-123.52777, 38.76328], [-123.52718, 38.76296], [-123.5268, 38.76258], [-123.52597, 38.76196], [-123.52541, 38.76123], [-123.52518, 38.76096], [-123.52359, 38.76001], [-123.52273, 38.75955], [-123.52194, 38.75881], [-123.52116, 38.75828], [-123.52033, 38.75798], [-123.51937, 38.75801], [-123.51884, 38.7583], [-123.51823, 38.75894], [-123.51804, 38.75936], [-123.51742, 38.75895], [-123.51701, 38.75858], [-123.5165, 38.75795], [-123.51637, 38.75771], [-123.5163, 38.75751], [-123.51587, 38.75524], [-123.51813, 38.75639], [-123.52225, 38.75787], [-123.52301, 38.75834], [-123.52387, 38.75916], [-123.52716, 38.75726], [-123.52723, 38.75729], [-123.52791, 38.75735], [-123.52818, 38.75732], [-123.52819, 38.75748], [-123.52893, 38.7578], [-123.52971, 38.75809], [-123.52966, 38.75821], [-123.53001, 38.75846], [-123.53025, 38.75845], [-123.53054, 38.75838], [-123.53055, 38.75859], [-123.53073, 38.75863], [-123.53062, 38.75878], [-123.53109, 38.75902], [-123.53166, 38.75904], [-123.53195, 38.75889], [-123.53207, 38.75901], [-123.53207, 38.75912], [-123.53231, 38.75919], [-123.53252, 38.75951], [-123.53235, 38.75947], [-123.53214, 38.75952], [-123.53196, 38.75947], [-123.5314, 38.75951], [-123.53108, 38.75974], [-123.5309, 38.76118], [-123.53091, 38.76311], [-123.53143, 38.76484], [-123.53254, 38.76689], [-123.53367, 38.76845], [-123.53373, 38.76863]]]]} | Open Access 1 | 16826 | Gualala Point | 19560 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 162.326 | Gualala Point | None 853 | |||
11130 | 11130 | 11129 | {"type": "Polygon", "coordinates": [[[-123.01186, 38.8227], [-123.01104, 38.82375], [-123.01087, 38.82436], [-123.0084, 38.8241], [-123.00953, 38.82308], [-123.01013, 38.82257], [-123.01052, 38.82207], [-123.01186, 38.8227]]]} | Open Access 1 | 21961 | Treadwell | 26516 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 9.353 | Treadwell | None 971 | |||
11447 | 11447 | 11446 | {"type": "Polygon", "coordinates": [[[-117.92427, 33.98937], [-117.92229, 33.98922], [-117.92235, 33.98879], [-117.92237, 33.98878], [-117.9235, 33.98886], [-117.92365, 33.98889], [-117.92386, 33.98897], [-117.92404, 33.98909], [-117.92417, 33.98922], [-117.92427, 33.98937]]]} | Open Access 1 | 48140 | Albatross Road Rest Area | 32670 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/albatross-road-rest-area/ | Los Angeles 6 | 1.94 | Albatross Road Rest Area | None 1016 | ||
12684 | 12684 | 12683 | {"type": "MultiPolygon", "coordinates": [[[[-124.23966, 41.77097], [-124.23864, 41.77117], [-124.23847, 41.77079], [-124.23837, 41.77061], [-124.2383, 41.77053], [-124.23809, 41.77029], [-124.23778, 41.76998], [-124.23727, 41.76955], [-124.22932, 41.76403], [-124.23032, 41.76399], [-124.2313, 41.7646], [-124.23231, 41.76529], [-124.23319, 41.76587], [-124.23412, 41.76635], [-124.2342, 41.76637], [-124.23494, 41.76685], [-124.23562, 41.76742], [-124.236, 41.76782], [-124.23687, 41.76861], [-124.23692, 41.7687], [-124.2371, 41.76889], [-124.2383, 41.77003], [-124.23917, 41.77076], [-124.23952, 41.7709], [-124.23966, 41.77097]]], [[[-124.25357, 41.78535], [-124.2531, 41.78529], [-124.25267, 41.78538], [-124.25246, 41.7854], [-124.25172, 41.78564], [-124.25108, 41.78595], [-124.25085, 41.78611], [-124.25074, 41.78616], [-124.25049, 41.78634], [-124.24986, 41.78696], [-124.24973, 41.78716], [-124.24952, 41.78732], [-124.2494, 41.78752], [-124.24871, 41.78753], [-124.24443, 41.78444], [-124.24436, 41.78221], [-124.24399, 41.77305], [-124.24457, 41.77304], [-124.24459, 41.77204], [-124.24479, 41.77198], [-124.24507, 41.77183], [-124.24528, 41.7716], [-124.2457, 41.77092], [-124.24621, 41.77072], [-124.24689, 41.77071], [-124.2469, 41.77073], [-124.24706, 41.77073], [-124.24772, 41.77089], [-124.24788, 41.77103], [-124.24788, 41.77115], [-124.24811, 41.77166], [-124.24833, 41.7718], [-124.24836, 41.77244], [-124.24816, 41.77264], [-124.24818, 41.77302], [-124.24825, 41.77336], [-124.24824, 41.77358], [-124.2483, 41.77389], [-124.2485, 41.77414], [-124.24875, 41.77441], [-124.24879, 41.77451], [-124.24899, 41.77468], [-124.24914, 41.77488], [-124.24932, 41.77485], [-124.24943, 41.77486], [-124.24979, 41.7748], [-124.24995, 41.7747], [-124.25017, 41.77466], [-124.25035, 41.77471], [-124.25073, 41.77472], [-124.25085, 41.77478], [-124.25094, 41.77496], [-124.25088, 41.77517], [-124.25097, 41.77524], [-124.251, 41.77532], [-124.25099, 41.77543], [-124.2509, 41.7755], [-124.25091, 41.77559], [-124.2508, 41.77563], [-124.2504, 41.77569], [-124.25012, 41.77588], [-124.2501, 41.77596], [-124.25024, 41.7763], [-124.25046, 41.77656], [-124.25068, 41.77671], [-124.25078, 41.77687], [-124.25111, 41.77717], [-124.25126, 41.77726], [-124.25139, 41.77729], [-124.25165, 41.77755], [-124.25177, 41.77759], [-124.25209, 41.77775], [-124.25226, 41.77793], [-124.25269, 41.77815], [-124.25297, 41.77831], [-124.25301, 41.7783], [-124.25344, 41.77855], [-124.25346, 41.7795], [-124.25344, 41.78037], [-124.25349, 41.7824], [-124.25189, 41.78253], [-124.25191, 41.78428], [-124.25247, 41.78431], [-124.25301, 41.78431], [-124.25302, 41.78446], [-124.25355, 41.78445], [-124.25357, 41.78535]]]]} | Open Access 1 | 29662 | Point St. George | 3081 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.visitredwoodcoast.com/content/point-st-george-heritage-area/ncoC5001D7E35E00EA39 | Del Norte 50 | 262.074 | Point St. George | None 1102 | ||
13184 | 13184 | 13183 | {"type": "Polygon", "coordinates": [[[-121.63003, 37.09382], [-121.62959, 37.09476], [-121.62429, 37.09699], [-121.62074, 37.09602], [-121.61842, 37.09695], [-121.61794, 37.09662], [-121.61745, 37.0962], [-121.61705, 37.09581], [-121.61665, 37.09534], [-121.61682, 37.09538], [-121.61766, 37.09533], [-121.61827, 37.09536], [-121.61953, 37.09527], [-121.6201, 37.09509], [-121.62004, 37.09495], [-121.62148, 37.09416], [-121.6231, 37.09378], [-121.6234, 37.09367], [-121.62425, 37.09432], [-121.62484, 37.09445], [-121.62657, 37.09444], [-121.62737, 37.09439], [-121.62902, 37.09414], [-121.62919, 37.09402], [-121.62931, 37.09387], [-121.62935, 37.09385], [-121.62971, 37.09387], [-121.63003, 37.09382]]]} | Open Access 1 | 35167 | Silveira | 25482 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 53.381 | Silveira | None 1149 | |||
14531 | 14531 | 14530 | {"type": "Polygon", "coordinates": [[[-122.52652, 37.87708], [-122.52628, 37.87758], [-122.52614, 37.87781], [-122.52606, 37.87788], [-122.52594, 37.87794], [-122.52584, 37.87793], [-122.52544, 37.87771], [-122.525, 37.87763], [-122.52478, 37.87769], [-122.5243, 37.87785], [-122.52414, 37.87787], [-122.52404, 37.87789], [-122.52378, 37.87805], [-122.52371, 37.87811], [-122.52362, 37.87824], [-122.52358, 37.87837], [-122.5236, 37.87853], [-122.5236, 37.87872], [-122.52357, 37.87889], [-122.5235, 37.87909], [-122.52339, 37.87925], [-122.52324, 37.87942], [-122.52355, 37.87957], [-122.52351, 37.87964], [-122.52329, 37.87952], [-122.52317, 37.87948], [-122.52315, 37.87958], [-122.52307, 37.87969], [-122.52284, 37.87971], [-122.52206, 37.88056], [-122.52193, 37.88066], [-122.5211, 37.88119], [-122.52, 37.88186], [-122.5199, 37.88191], [-122.51964, 37.88199], [-122.51908, 37.88231], [-122.51901, 37.88266], [-122.51887, 37.88256], [-122.51894, 37.88244], [-122.51895, 37.88233], [-122.51917, 37.88215], [-122.5212, 37.88106], [-122.52189, 37.88062], [-122.522, 37.88052], [-122.5228, 37.87966], [-122.52288, 37.87964], [-122.52302, 37.87964], [-122.52308, 37.87957], [-122.52307, 37.87954], [-122.52285, 37.87949], [-122.52289, 37.87943], [-122.52317, 37.87926], [-122.52336, 37.87909], [-122.52349, 37.87876], [-122.52351, 37.87863], [-122.52349, 37.87846], [-122.52338, 37.87825], [-122.52343, 37.87815], [-122.52349, 37.87808], [-122.52352, 37.87808], [-122.52379, 37.87783], [-122.52394, 37.87774], [-122.52433, 37.87777], [-122.52458, 37.87772], [-122.52487, 37.87761], [-122.52494, 37.8776], [-122.52546, 37.87767], [-122.52584, 37.87761], [-122.5261, 37.87748], [-122.52634, 37.87725], [-122.52647, 37.87704], [-122.52652, 37.87708]]]} | Open Access 1 | 47198 | Charles F. McGlashan Pathway | 30897 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.726 | Charles F. McGlashan Pathway | None 1237 | |||
15041 | 15041 | 15040 | {"type": "Polygon", "coordinates": [[[-117.79158, 34.70472], [-117.79153, 34.70476], [-117.77431, 34.7053], [-117.77425, 34.70526], [-117.77425, 34.69802], [-117.78289, 34.69778], [-117.78289, 34.69592], [-117.7873, 34.6958], [-117.78731, 34.69468], [-117.78841, 34.69465], [-117.78842, 34.69539], [-117.78952, 34.69536], [-117.78952, 34.69759], [-117.79156, 34.69753], [-117.79158, 34.70472]]]} | Open Access 1 | 45703 | Butte Valley Wildflower Sanctuary | 32690 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/butte-valley-wildflower-sanctuary/ | Los Angeles 6 | 350.624 | Butte Valley Wildflower Sanctuary | None 1300 | ||
16545 | 16545 | 16544 | {"type": "Polygon", "coordinates": [[[-118.47215, 34.37798], [-118.4698, 34.37797], [-118.46941, 34.37814], [-118.46787, 34.37869], [-118.46751, 34.37884], [-118.46721, 34.37901], [-118.46691, 34.37922], [-118.46662, 34.37947], [-118.46656, 34.37798], [-118.45784, 34.37806], [-118.44845, 34.37819], [-118.44591, 34.37819], [-118.44558, 34.37818], [-118.44434, 34.3781], [-118.44193, 34.37808], [-118.44195, 34.37454], [-118.43979, 34.37452], [-118.43984, 34.37077], [-118.43763, 34.37076], [-118.43768, 34.36702], [-118.44865, 34.36697], [-118.44855, 34.37077], [-118.44637, 34.37078], [-118.44628, 34.37455], [-118.44846, 34.37457], [-118.44846, 34.37502], [-118.44954, 34.37498], [-118.4508, 34.3763], [-118.45314, 34.37623], [-118.45315, 34.37668], [-118.45553, 34.37708], [-118.46218, 34.3768], [-118.46217, 34.37599], [-118.46648, 34.37589], [-118.46642, 34.37381], [-118.47113, 34.37386], [-118.47116, 34.37591], [-118.47212, 34.37593], [-118.47213, 34.37611], [-118.47187, 34.37622], [-118.4716, 34.37638], [-118.47142, 34.37651], [-118.47129, 34.37664], [-118.47121, 34.37659], [-118.47117, 34.37662], [-118.47118, 34.37709], [-118.47119, 34.37709], [-118.4715, 34.37681], [-118.47143, 34.37674], [-118.47158, 34.37661], [-118.47194, 34.37638], [-118.47213, 34.37629], [-118.47215, 34.37798]]]} | Open Access 1 | 12567 | Placerita Canyon State Park | 32485 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=622 | Los Angeles 6 | 359.799 | Placerita Canyon SP | None 1412 | ||
509 | 509 | 508 | {"type": "Polygon", "coordinates": [[[-123.01254, 38.82071], [-123.01186, 38.82152], [-123.01112, 38.82235], [-123.01076, 38.82218], [-123.0119, 38.82141], [-123.01148, 38.82068], [-123.01202, 38.81948], [-123.01254, 38.82071]]]} | Open Access 1 | 1700 | Cloverdale River Park | 17444 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 3.11 | Cloverdale River Park | 0 | Local Park 2 | 4 | |
881 | 881 | 880 | {"type": "MultiPolygon", "coordinates": [[[[-118.36105, 33.98786], [-118.35981, 33.98824], [-118.35975, 33.98824], [-118.3597, 33.98821], [-118.35964, 33.9879], [-118.35959, 33.98773], [-118.35831, 33.98481], [-118.35827, 33.98459], [-118.35827, 33.98439], [-118.35831, 33.98418], [-118.35836, 33.98403], [-118.35839, 33.98399], [-118.35847, 33.98397], [-118.35977, 33.98425], [-118.35986, 33.98504], [-118.35999, 33.98544], [-118.36105, 33.98786]]], [[[-118.35973, 33.98401], [-118.35883, 33.98382], [-118.35904, 33.98312], [-118.35965, 33.98323], [-118.35973, 33.98401]]]]} | Open Access 1 | 6296 | Ladera Park | 32637 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Ladera_Park | Los Angeles 6 | 15.808 | Ladera Park | 0 | Local Park 2 | 4 |
1102 | 1102 | 1101 | {"type": "Polygon", "coordinates": [[[-117.9216, 34.03221], [-117.92061, 34.0323], [-117.92052, 34.03227], [-117.92007, 34.03231], [-117.91957, 34.03233], [-117.91955, 34.03229], [-117.91964, 34.0311], [-117.91978, 34.03062], [-117.91984, 34.03031], [-117.9202, 34.03031], [-117.92158, 34.03021], [-117.92152, 34.03167], [-117.9216, 34.03221]]]} | Open Access 1 | 7055 | Rimgrove Park | 32498 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 9.626 | Rimgrove 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]);