units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
90 rows where ACCESS_TYP = 1, AGNCY_TYP = 3 and DES_TP = 3 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY 27
- Santa Barbara, County of 16
- Los Angeles, County of 14
- San Diego, County of 6
- Los Angeles - Department of Parks and Recreation, County of 6
- Sacramento, County of 6
- Santa Cruz, County of 5
- Riverside, County of 5
- San Luis Obispo, County of 3
- Monterey, County of 3
- Orange, County of 3
- Ventura, County of 2
- Placer, County of 2
- Fresno, County of 2
- Kern, County of 2
- San Joaquin, County of 2
- Yolo, County of 2
- Valley-Wide Recreation and Park District 1
- Cerritos, City of 1
- Lake, County of 1
- Desert Recreation District 1
- Long Beach, City of 1
- San Bernardino, County of 1
- Stanislaus, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Amador, County of 1
- Sutter, County of 1
MNG_AG_TYP 4
DES_TP 1
- Local Recreation Area · 90 ✖
ACCESS_TYP 1
- Open Access · 90 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
1479 | 1479 | 1478 | {"type": "Polygon", "coordinates": [[[-121.62993, 36.69624], [-121.62762, 36.69442], [-121.62979, 36.69262], [-121.63183, 36.6944], [-121.63188, 36.69446], [-121.63189, 36.69452], [-121.63188, 36.69459], [-121.63186, 36.69463], [-121.62993, 36.69624]]]} | Open Access 1 | 10118 | Constitution Soccer Complex | 17603 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 19.339 | Constitution Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-119.73275, 34.45416], [-119.73256, 34.45495], [-119.73033, 34.45569], [-119.73131, 34.45385], [-119.73248, 34.45385], [-119.73275, 34.45416]]]} | Open Access 1 | 17293 | Lauro Canyon Reservoir | 33319 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 6.232 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2694 | 2694 | 2693 | {"type": "Polygon", "coordinates": [[[-120.62642, 35.1044], [-120.62597, 35.10496], [-120.62525, 35.10457], [-120.6257, 35.10401], [-120.62642, 35.1044]]]} | Open Access 1 | 18257 | Oceano Memorial Campground | 23064 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.456 | Oceano Memorial Campground | 0 | Local Recreation Area 3 | 4 | |
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | 1923 | Winchester I Open Space | 27618 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.191 | Winchester I OS | 0 | Local Recreation Area 3 | 4 | |
3211 | 3211 | 3210 | {"type": "Polygon", "coordinates": [[[-122.63748, 41.70784], [-122.63684, 41.70871], [-122.63636, 41.70858], [-122.63561, 41.70825], [-122.63577, 41.70803], [-122.63593, 41.70785], [-122.63621, 41.70776], [-122.63657, 41.70768], [-122.63678, 41.70769], [-122.63748, 41.70784]]]} | Open Access 1 | 28144 | Hibbard Field | 19892 | 365 | Siskiyou, County of 596 | County 3 | County Agency 3 | http://www.co.siskiyou.ca.us/ | County 3 | 365 | Siskiyou, County of 586 | County 3 | County Agency 3 | Siskiyou 28 | 2.667 | Hibbard Field | 0 | Local Recreation Area 3 | 4 | |
3643 | 3643 | 3642 | {"type": "Polygon", "coordinates": [[[-117.05646, 34.07589], [-117.05605, 34.07592], [-117.05567, 34.07597], [-117.05538, 34.07542], [-117.05514, 34.07532], [-117.05489, 34.07538], [-117.05484, 34.07531], [-117.0549, 34.07522], [-117.05473, 34.07516], [-117.05384, 34.07497], [-117.05337, 34.07475], [-117.05234, 34.07447], [-117.0519, 34.0745], [-117.05123, 34.07449], [-117.05063, 34.07436], [-117.04996, 34.0743], [-117.0496, 34.07422], [-117.04925, 34.07419], [-117.04869, 34.0742], [-117.04823, 34.07398], [-117.04784, 34.07399], [-117.04771, 34.06692], [-117.04942, 34.06795], [-117.05016, 34.06761], [-117.05061, 34.06565], [-117.04902, 34.06452], [-117.04766, 34.06428], [-117.04763, 34.06268], [-117.05203, 34.06257], [-117.05221, 34.06978], [-117.05643, 34.06979], [-117.05646, 34.07589]]]} | Open Access 1 | 29520 | Crafton Reservoir | 17750 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | San Bernardino 22 | 168.476 | Crafton Reservoir | 0 | Local Recreation Area 3 | 4 | |
3673 | 3673 | 3672 | {"type": "Polygon", "coordinates": [[[-121.764, 38.67997], [-121.76378, 38.68], [-121.76291, 38.68027], [-121.7627, 38.68031], [-121.75975, 38.68029], [-121.75975, 38.67976], [-121.7603, 38.67977], [-121.7603, 38.67979], [-121.76059, 38.67981], [-121.76213, 38.67983], [-121.76214, 38.67974], [-121.76325, 38.67977], [-121.76325, 38.67994], [-121.764, 38.67997]]]} | Open Access 1 | 29720 | Gonzales Park Soccer Field | 19399 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 4.348 | Gonzales Park Soccer Field | 0 | Local Recreation Area 3 | 4 | |
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-119.79655, 34.42798], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79655, 34.42798]]]} | Open Access 1 | 35233 | Rhoads Open Space | 28548 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.01 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
4220 | 4220 | 4219 | {"type": "Polygon", "coordinates": [[[-119.22967, 34.44042], [-119.22934, 34.44104], [-119.22896, 34.44199], [-119.22891, 34.4424], [-119.2287, 34.44271], [-119.2267, 34.44309], [-119.22634, 34.44335], [-119.22505, 34.44413], [-119.22493, 34.44422], [-119.22486, 34.44385], [-119.22446, 34.44408], [-119.22421, 34.44417], [-119.22364, 34.44429], [-119.22324, 34.44458], [-119.22283, 34.44477], [-119.22248, 34.44279], [-119.22792, 34.44213], [-119.22748, 34.43959], [-119.22936, 34.43921], [-119.22967, 34.44042]]]} | Open Access 1 | 44996 | Soule Recreation Area | 25633 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 30.851 | Soule Rec. Area | 0 | Local Recreation Area 3 | 4 | |
4991 | 4991 | 4990 | {"type": "Polygon", "coordinates": [[[-116.11014, 32.64478], [-116.108, 32.64477], [-116.10711, 32.64478], [-116.10763, 32.64374], [-116.10765, 32.64374], [-116.11013, 32.64378], [-116.11014, 32.64478]]]} | Open Access 1 | 793 | In-Ko-Pah County Open Space | 20184 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 7.223 | In-Ko-Pah County OS | 0 | Local Recreation Area 3 | 4 | |
5200 | 5200 | 5199 | {"type": "MultiPolygon", "coordinates": [[[[-117.67339, 33.63513], [-117.67274, 33.63562], [-117.67252, 33.63583], [-117.67227, 33.63618], [-117.67222, 33.63633], [-117.67221, 33.63656], [-117.67246, 33.63654], [-117.67268, 33.63669], [-117.67244, 33.63722], [-117.6725, 33.63728], [-117.67219, 33.6375], [-117.67205, 33.63786], [-117.67164, 33.63811], [-117.67151, 33.63824], [-117.67119, 33.63911], [-117.67077, 33.63963], [-117.67087, 33.6397], [-117.67099, 33.6397], [-117.67073, 33.63992], [-117.67073, 33.63982], [-117.67051, 33.63964], [-117.67033, 33.63966], [-117.66992, 33.64057], [-117.66954, 33.64096], [-117.66945, 33.64111], [-117.66885, 33.64158], [-117.66848, 33.64251], [-117.66832, 33.64266], [-117.66798, 33.64287], [-117.66827, 33.64325], [-117.66818, 33.64358], [-117.66789, 33.64361], [-117.66762, 33.64368], [-117.66672, 33.64404], [-117.66673, 33.64407], [-117.66671, 33.64409], [-117.66663, 33.64436], [-117.66654, 33.64454], [-117.66653, 33.64478], [-117.66671, 33.64513], [-117.66644, 33.64529], [-117.66621, 33.6455], [-117.66576, 33.64614], [-117.66609, 33.64631], [-117.66561, 33.64698], [-117.66528, 33.64684], [-117.665, 33.64719], [-117.6645, 33.64762], [-117.6641, 33.64793], [-117.66394, 33.64812], [-117.66366, 33.64852], [-117.66336, 33.64919], [-117.66328, 33.64947], [-117.66326, 33.64975], [-117.66333, 33.65004], [-117.66269, 33.6505], [-117.66179, 33.65181], [-117.66136, 33.65233], [-117.66137, 33.65234], [-117.66167, 33.65252], [-117.66134, 33.6529], [-117.66134, 33.65292], [-117.66102, 33.65276], [-117.66085, 33.65298], [-117.66065, 33.65342], [-117.66055, 33.65389], [-117.66055, 33.65437], [-117.66061, 33.6548], [-117.66, 33.65484], [-117.65976, 33.65482], [-117.65968, 33.65519], [-117.65928, 33.65561], [-117.65938, 33.65626], [-117.65867, 33.65672], [-117.65831, 33.6571], [-117.65831, 33.65768], [-117.65798, 33.65901], [-117.6576, 33.65927], [-117.65734, 33.65879], [-117.65697, 33.65874], [-117.657, 33.65856], [-117.6572, 33.65837], [-117.65731, 33.65822], [-117.65742, 33.65803], [-117.65754, 33.65771], [-117.65792, 33.65713], [-117.65795, 33.65704], [-117.65875, 33.65555], [-117.65935, 33.65425], [-117.6601, 33.65256], [-117.66033, 33.65196], [-117.66043, 33.65158], [-117.66057, 33.65085], [-117.66076, 33.65005], [-117.66086, 33.64976], [-117.66102, 33.64943], [-117.66128, 33.64905], [-117.66152, 33.64873], [-117.66183, 33.6484], [-117.66393, 33.64652], [-117.66437, 33.64608], [-117.66523, 33.64506], [-117.66547, 33.64484], [-117.66577, 33.64461], [-117.66577, 33.64459], [-117.66548, 33.64438], [-117.66545, 33.64438], [-117.66567, 33.6442], [-117.66566, 33.64374], [-117.66572, 33.64358], [-117.66587, 33.64342], [-117.66625, 33.6431], [-117.6666, 33.64292], [-117.66687, 33.64298], [-117.66717, 33.64284], [-117.66729, 33.64269], [-117.66785, 33.64256], [-117.66798, 33.64247], [-117.66821, 33.64209], [-117.66812, 33.64196], [-117.66796, 33.64192], [-117.66805, 33.64171], [-117.66802, 33.64162], [-117.66807, 33.64159], [-117.66811, 33.64152], [-117.66814, 33.64135], [-117.66831, 33.64116], [-117.66842, 33.6411], [-117.66876, 33.64094], [-117.66886, 33.64086], [-117.66935, 33.64026], [-117.66943, 33.64], [-117.66943, 33.6396], [-117.6695, 33.63936], [-117.66957, 33.63925], [-117.66977, 33.63906], [-117.66982, 33.63904], [-117.66988, 33.63904], [-117.67001, 33.63894], [-117.67, 33.63892], [-117.66998, 33.63894], [-117.66997, 33.63892], [-117.66999, 33.63889], [-117.67037, 33.63855], [-117.67046, 33.63843], [-117.67051, 33.63831], [-117.67053, 33.63818], [-117.67052, 33.63791], [-117.67054, 33.6378], [-117.67058, 33.6377], [-117.67066, 33.63759], [-117.67085, 33.6374], [-117.67092, 33.63729], [-117.671, 33.6371], [-117.67106, 33.63699], [-117.6712, 33.63685], [-117.67138, 33.63672], [-117.67148, 33.63663], [-117.67155, 33.63652], [-117.67161, 33.63639], [-117.67164, 33.63626], [-117.67164, 33.63614], [-117.67158, 33.63589], [-117.67158, 33.63579], [-117.67161, 33.63567], [-117.67173, 33.63547], [-117.67182, 33.63538], [-117.67193, 33.63531], [-117.67206, 33.63526], [-117.67235, 33.63519], [-117.6725, 33.63512], [-117.67257, 33.63507], [-117.6726, 33.635], [-117.67261, 33.63493], [-117.6726, 33.63486], [-117.67254, 33.63481], [-117.67278, 33.63461], [-117.67339, 33.63513]]], [[[-117.65995, 33.65983], [-117.65924, 33.66003], [-117.65848, 33.66011], [-117.65819, 33.66003], [-117.65767, 33.65947], [-117.65796, 33.65928], [-117.65824, 33.65925], [-117.65828, 33.65934], [-117.65852, 33.65956], [-117.65987, 33.65959], [-117.65995, 33.65983]]], [[[-117.65959, 33.65875], [-117.65959, 33.65888], [-117.65889, 33.65885], [-117.65891, 33.65877], [-117.65895, 33.65874], [-117.65959, 33.65875]]], [[[-117.68678, 33.6252], [-117.68659, 33.62536], [-117.68659, 33.62543], [-117.68657, 33.62543], [-117.6865, 33.62548], [-117.68648, 33.62556], [-117.68633, 33.62556], [-117.68596, 33.62587], [-117.68596, 33.62595], [-117.68587, 33.62599], [-117.68582, 33.62606], [-117.68573, 33.62605], [-117.68526, 33.62643], [-117.68532, 33.62649], [-117.6852, 33.62658], [-117.6852, 33.62666], [-117.68522, 33.6267], [-117.68503, 33.62686], [-117.68514, 33.62696], [-117.68497, 33.62711], [-117.68497, 33.62718], [-117.68491, 33.62718], [-117.68483, 33.62723], [-117.68481, 33.62727], [-117.68481, 33.62734], [-117.68486, 33.6274], [-117.68446, 33.62773], [-117.68449, 33.62782], [-117.6844, 33.62787], [-117.68438, 33.62792], [-117.68439, 33.628], [-117.68436, 33.62801], [-117.68428, 33.62816], [-117.68412, 33.62838], [-117.68425, 33.62864], [-117.68444, 33.62881], [-117.6843, 33.62881], [-117.68415, 33.62878], [-117.68372, 33.62864], [-117.6836, 33.62862], [-117.68339, 33.62862], [-117.68323, 33.62865], [-117.68151, 33.62911], [-117.68136, 33.62913], [-117.68106, 33.62924], [-117.67999, 33.63011], [-117.67993, 33.63022], [-117.67988, 33.63034], [-117.67987, 33.63061], [-117.67992, 33.63077], [-117.68004, 33.63097], [-117.67952, 33.63048], [-117.67922, 33.63072], [-117.67927, 33.6308], [-117.67924, 33.63082], [-117.67922, 33.63086], [-117.67908, 33.63084], [-117.67885, 33.63102], [-117.67886, 33.63105], [-117.67863, 33.63124], [-117.67868, 33.63134], [-117.67862, 33.63138], [-117.67861, 33.63143], [-117.67849, 33.63141], [-117.67825, 33.63159], [-117.67834, 33.63168], [-117.67811, 33.63188], [-117.67811, 33.63192], [-117.67802, 33.63196], [-117.678, 33.63201], [-117.67792, 33.632], [-117.67767, 33.63219], [-117.6777, 33.63223], [-117.67752, 33.6324], [-117.67757, 33.63256], [-117.67752, 33.63258], [-117.67747, 33.63264], [-117.67747, 33.63268], [-117.67753, 33.63274], [-117.67752, 33.63277], [-117.67754, 33.63279], [-117.67746, 33.63292], [-117.67756, 33.63303], [-117.67736, 33.63326], [-117.67738, 33.63333], [-117.67733, 33.63335], [-117.67728, 33.63341], [-117.67728, 33.63347], [-117.67732, 33.63351], [-117.67726, 33.63356], [-117.67694, 33.63395], [-117.67628, 33.63376], [-117.67616, 33.63382], [-117.67608, 33.63378], [-117.67598, 33.63378], [-117.6759, 33.63385], [-117.6758, 33.63381], [-117.67533, 33.63387], [-117.67534, 33.63383], [-117.67638, 33.633], [-117.67634, 33.63293], [-117.67668, 33.63278], [-117.67654, 33.63259], [-117.67676, 33.63247], [-117.67682, 33.63237], [-117.67692, 33.63222], [-117.67707, 33.63206], [-117.67732, 33.63185], [-117.67736, 33.63187], [-117.67755, 33.63172], [-117.67752, 33.63169], [-117.67758, 33.63163], [-117.67741, 33.6315], [-117.67752, 33.6313], [-117.67762, 33.631], [-117.67774, 33.63077], [-117.67784, 33.63066], [-117.67822, 33.63049], [-117.67843, 33.63045], [-117.67858, 33.63041], [-117.67873, 33.63033], [-117.67922, 33.62995], [-117.67936, 33.62983], [-117.67953, 33.62966], [-117.67974, 33.62941], [-117.67996, 33.6291], [-117.68007, 33.62885], [-117.68026, 33.62851], [-117.68036, 33.6284], [-117.68043, 33.6283], [-117.68046, 33.62814], [-117.68045, 33.62796], [-117.68041, 33.62781], [-117.68036, 33.62767], [-117.68023, 33.6275], [-117.68052, 33.62727], [-117.68196, 33.62851], [-117.68348, 33.62728], [-117.68366, 33.62698], [-117.68422, 33.62639], [-117.68449, 33.62599], [-117.68467, 33.62614], [-117.68476, 33.62613], [-117.68482, 33.62606], [-117.68492, 33.62614], [-117.6866, 33.62477], [-117.68678, 33.6252]]], [[[-117.68005, 33.63097], [-117.68008, 33.631], [-117.68008, 33.63101], [-117.68008, 33.63101], [-117.68005, 33.63097]]], [[[-117.6958, 33.61292], [-117.69566, 33.61315], [-117.69531, 33.6131], [-117.69534, 33.61303], [-117.69537, 33.61282], [-117.69535, 33.6126], [-117.69529, 33.6124], [-117.69517, 33.6122], [-117.695, 33.61203], [-117.69481, 33.61188], [-117.69458, 33.61178], [-117.69392, 33.61163], [-117.69373, 33.61158], [-117.69351, 33.61149], [-117.69334, 33.6114], [-117.6932, 33.61128], [-117.69295, 33.61101], [-117.69265, 33.61115], [-117.69293, 33.611], [-117.69283, 33.61082], [-117.69273, 33.61049], [-117.69274, 33.61034], [-117.69272, 33.60982], [-117.69276, 33.60956], [-117.69286, 33.60933], [-117.69371, 33.60809], [-117.69478, 33.60647], [-117.69406, 33.60611], [-117.69396, 33.60604], [-117.69397, 33.60564], [-117.69405, 33.6057], [-117.69417, 33.60568], [-117.6942, 33.60573], [-117.69427, 33.60577], [-117.69435, 33.60577], [-117.69441, 33.60573], [-117.69449, 33.60587], [-117.69489, 33.60609], [-117.69498, 33.60608], [-117.69501, 33.60616], [-117.69508, 33.6062], [-117.69518, 33.6062], [-117.6952, 33.60618], [-117.69553, 33.60618], [-117.69519, 33.60656], [-117.69537, 33.60666], [-117.6946, 33.60724], [-117.69315, 33.60938], [-117.69309, 33.60949], [-117.69303, 33.60965], [-117.69301, 33.60987], [-117.69302, 33.61041], [-117.69306, 33.61064], [-117.69316, 33.61084], [-117.6933, 33.61103], [-117.69349, 33.61119], [-117.6937, 33.61131], [-117.69395, 33.6114], [-117.69456, 33.61153], [-117.69472, 33.61159], [-117.69488, 33.61165], [-117.69503, 33.61174], [-117.69525, 33.6119], [-117.69539, 33.61206], [-117.69554, 33.61229], [-117.69562, 33.61252], [-117.69566, 33.61279], [-117.6958, 33.61292]]], [[[-117.69774, 33.60765], [-117.6977, 33.60775], [-117.69716, 33.60756], [-117.69725, 33.60735], [-117.69747, 33.6071], [-117.6976, 33.60676], [-117.69762, 33.60675], [-117.69765, 33.60675], [-117.69772, 33.60697], [-117.69768, 33.60698], [-117.69764, 33.60702], [-117.69761, 33.60709], [-117.69752, 33.60709], [-117.6973, 33.60734], [-117.69774, 33.60765]]], [[[-117.70033, 33.60529], [-117.6999, 33.60538], [-117.69965, 33.60541], [-117.69945, 33.60555], [-117.69944, 33.60551], [-117.69969, 33.60533], [-117.69981, 33.6053], [-117.69995, 33.60531], [-117.69999, 33.6053], [-117.70005, 33.60525], [-117.70006, 33.60516], [-117.70033, 33.60529]]], [[[-117.71085, 33.59544], [-117.71082, 33.59549], [-117.71058, 33.59556], [-117.71037, 33.59593], [-117.71035, 33.59601], [-117.71028, 33.5976], [-117.71024, 33.59776], [-117.71014, 33.59793], [-117.70997, 33.5981], [-117.70937, 33.5984], [-117.70891, 33.5987], [-117.70874, 33.59888], [-117.70816, 33.59962], [-117.70764, 33.60037], [-117.70749, 33.60051], [-117.70706, 33.60056], [-117.70696, 33.6006], [-117.70696, 33.60061], [-117.70704, 33.60069], [-117.70466, 33.60241], [-117.70299, 33.60304], [-117.70259, 33.60311], [-117.70246, 33.60262], [-117.70286, 33.60255], [-117.70332, 33.60226], [-117.70443, 33.60183], [-117.70473, 33.60156], [-117.70501, 33.6009], [-117.70616, 33.60032], [-117.70682, 33.60018], [-117.70777, 33.59954], [-117.70807, 33.59917], [-117.70852, 33.59842], [-117.70868, 33.5984], [-117.70907, 33.59813], [-117.70966, 33.59784], [-117.70974, 33.59778], [-117.70981, 33.59767], [-117.70985, 33.59756], [-117.70993, 33.59575], [-117.71015, 33.59517], [-117.71085, 33.59544]]]]} | Open Access 1 | 15865 | Aliso Creek Greenbelt | 15372 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 138.055 | Aliso Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
5230 | 5230 | 5229 | {"type": "Polygon", "coordinates": [[[-121.37955, 38.98549], [-121.37751, 38.9855], [-121.37751, 38.98534], [-121.37737, 38.98468], [-121.37954, 38.98467], [-121.37955, 38.98549]]]} | Open Access 1 | 22194 | Sheridan Recreation Park | 25395 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 4.093 | Sheridan Rec. Park | 0 | Local Recreation Area 3 | 4 | |
5504 | 5504 | 5503 | {"type": "Polygon", "coordinates": [[[-120.44562, 34.87516], [-120.4456, 34.87591], [-120.44401, 34.87591], [-120.44401, 34.87511], [-120.44418, 34.87512], [-120.44458, 34.87515], [-120.44562, 34.87516]]]} | Open Access 1 | 1135 | Stonebrook Open Space | 25882 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.08 | Stonebrook OS | 0 | Local Recreation Area 3 | 4 | |
6125 | 6125 | 6124 | {"type": "MultiPolygon", "coordinates": [[[[-121.9654, 36.95968], [-121.96527, 36.95978], [-121.96488, 36.96008], [-121.96489, 36.9599], [-121.96496, 36.95985], [-121.96516, 36.95981], [-121.96528, 36.95971], [-121.96532, 36.95963], [-121.96534, 36.95945], [-121.9654, 36.95935], [-121.9654, 36.95968]]], [[[-121.96554, 36.96051], [-121.96499, 36.96051], [-121.96499, 36.96023], [-121.96554, 36.9598], [-121.96554, 36.96051]]]]} | Open Access 1 | 1336 | The Hook Beach Access | 26285 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.827 | The Hook Beach Access | 0 | Local Recreation Area 3 | 4 | |
6333 | 6333 | 6332 | {"type": "MultiPolygon", "coordinates": [[[[-119.81783, 34.44343], [-119.81777, 34.44362], [-119.81759, 34.44372], [-119.81675, 34.44373], [-119.81574, 34.44462], [-119.81576, 34.44491], [-119.81593, 34.4456], [-119.81594, 34.44587], [-119.81525, 34.44586], [-119.81511, 34.44584], [-119.81508, 34.44583], [-119.81506, 34.44578], [-119.81514, 34.44535], [-119.81518, 34.44473], [-119.8152, 34.44462], [-119.81527, 34.44446], [-119.81546, 34.44422], [-119.81556, 34.44403], [-119.81563, 34.4438], [-119.81568, 34.44357], [-119.81735, 34.44366], [-119.81742, 34.44341], [-119.81783, 34.44343]]], [[[-119.81606, 34.4464], [-119.81623, 34.44693], [-119.81622, 34.44703], [-119.81614, 34.44723], [-119.81604, 34.44766], [-119.81591, 34.4481], [-119.8159, 34.44838], [-119.816, 34.44868], [-119.81541, 34.44868], [-119.81543, 34.44863], [-119.81542, 34.44862], [-119.81444, 34.44862], [-119.81443, 34.44848], [-119.81445, 34.44835], [-119.81449, 34.44821], [-119.81456, 34.44809], [-119.81464, 34.44798], [-119.81475, 34.44789], [-119.815, 34.44774], [-119.8151, 34.44766], [-119.81521, 34.44752], [-119.81527, 34.44736], [-119.81529, 34.44719], [-119.81525, 34.44681], [-119.81518, 34.44658], [-119.81504, 34.44629], [-119.81501, 34.44616], [-119.81502, 34.44603], [-119.81506, 34.44601], [-119.81526, 34.44603], [-119.81573, 34.44602], [-119.81573, 34.4463], [-119.816, 34.44635], [-119.81606, 34.4464]]]]} | Open Access 1 | 1578 | University Circle Open Space | 26673 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.722 | University Circle OS | 0 | Local Recreation Area 3 | 4 | |
6543 | 6543 | 6542 | {"type": "MultiPolygon", "coordinates": [[[[-116.91618, 32.84986], [-116.9158, 32.84995], [-116.91515, 32.85059], [-116.91472, 32.8507], [-116.91484, 32.85107], [-116.91525, 32.85324], [-116.914, 32.85341], [-116.91334, 32.84972], [-116.91177, 32.85009], [-116.91176, 32.8484], [-116.91061, 32.84865], [-116.91064, 32.84184], [-116.91071, 32.84181], [-116.91116, 32.84154], [-116.91129, 32.84149], [-116.91356, 32.84095], [-116.91405, 32.84103], [-116.91448, 32.84114], [-116.91479, 32.84146], [-116.915, 32.84173], [-116.91513, 32.84194], [-116.91535, 32.84238], [-116.91387, 32.84275], [-116.91387, 32.8431], [-116.91389, 32.84327], [-116.91385, 32.84344], [-116.91387, 32.84357], [-116.91404, 32.84404], [-116.91344, 32.84419], [-116.91364, 32.84485], [-116.91326, 32.84494], [-116.91351, 32.84573], [-116.9139, 32.84565], [-116.91406, 32.84614], [-116.91209, 32.84661], [-116.91189, 32.84834], [-116.9119, 32.84835], [-116.91259, 32.8482], [-116.91322, 32.84866], [-116.91397, 32.84868], [-116.91489, 32.84935], [-116.91522, 32.84928], [-116.91542, 32.84981], [-116.91562, 32.84978], [-116.91611, 32.84965], [-116.91618, 32.84986]]], [[[-116.91703, 32.84504], [-116.91654, 32.84516], [-116.91648, 32.845], [-116.91697, 32.84488], [-116.91703, 32.84504]]], [[[-116.92242, 32.84101], [-116.92235, 32.84257], [-116.92092, 32.84275], [-116.92092, 32.84281], [-116.9208, 32.84282], [-116.92081, 32.84283], [-116.92096, 32.84286], [-116.91974, 32.84281], [-116.9197, 32.84288], [-116.91955, 32.84329], [-116.91951, 32.84385], [-116.91966, 32.84457], [-116.92002, 32.84461], [-116.92028, 32.84451], [-116.92094, 32.84452], [-116.92115, 32.84448], [-116.92125, 32.84507], [-116.92138, 32.84613], [-116.91821, 32.84687], [-116.91757, 32.84492], [-116.91719, 32.845], [-116.91704, 32.84458], [-116.91742, 32.84449], [-116.91717, 32.8437], [-116.91815, 32.84346], [-116.918, 32.84236], [-116.92076, 32.84171], [-116.92055, 32.84013], [-116.9205, 32.83964], [-116.92053, 32.83965], [-116.92219, 32.83949], [-116.92242, 32.84101]]]]} | Open Access 1 | 5015 | Lakeside Archipelago Open Space | 20975 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 122.828 | Lakeside Archipelago OS | 0 | Local Recreation Area 3 | 4 | |
6739 | 6739 | 6738 | {"type": "Polygon", "coordinates": [[[-116.1145, 32.65367], [-116.10581, 32.65366], [-116.10581, 32.64737], [-116.10624, 32.6465], [-116.11446, 32.64653], [-116.1145, 32.65367]]]} | Open Access 1 | 5151 | County Open Space | 29240 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 158.984 | County OS | 0 | Local Recreation Area 3 | 4 | |
7171 | 7171 | 7170 | {"type": "Polygon", "coordinates": [[[-118.35661, 33.997], [-118.35664, 33.99732], [-118.3566, 33.99764], [-118.35649, 33.99812], [-118.35562, 33.99999], [-118.35552, 34.0001], [-118.35507, 33.99981], [-118.35523, 33.99961], [-118.35538, 33.99937], [-118.35616, 33.99787], [-118.35624, 33.99763], [-118.35627, 33.99744], [-118.35627, 33.99713], [-118.35625, 33.99705], [-118.35661, 33.997]]]} | Open Access 1 | 6300 | Ruben Ingold Parkway | 32500 | 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 | 3.496 | Ruben Ingold Parkway | 0 | Local Recreation Area 3 | 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]);