units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
687 rows where AGNCY_TYP = 3 and DES_TP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST
MNG_AGENCY >30
- Los Angeles, County of 88
- San Diego, County of 67
- Los Angeles - Department of Parks and Recreation, County of 42
- Orange, County of 41
- El Dorado, County of 40
- Santa Barbara, County of 39
- Kern, County of 37
- Santa Cruz, County of 33
- Stanislaus, County of 22
- San Luis Obispo, County of 20
- Placer, County of 19
- Riverside, County of 18
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 12
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Fresno, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Tehama, County of 6
- Mendocino, County of 6
- Lassen, County of 6
- Mariposa, County of 5
- Mono, County of 5
- Imperial, County of 4
- Yuba, County of 4
- …
MNG_AG_TYP 6
ACCESS_TYP 4
DES_TP 1
- Local Park · 687 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3654 | 3654 | 3653 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11707, 33.00365], [-117.11615, 33.00356], [-117.11606, 33.00392], [-117.11566, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 29594 | 4S Ranch Community Park | 29225 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 5.809 | 4S Ranch Community Park | 0 | Local Park 2 | 4 |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
15157 | 15157 | 15156 | {"type": "Polygon", "coordinates": [[[-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.0117], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151]]]} | Open Access 1 | 46006 | 4S Ranch Homestead Park | 29267 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | San Diego 4 | 1.801 | 4S Ranch Homestead Park | 0 | Local Park 2 | 4 |
15150 | 15150 | 15149 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11261, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 45993 | 4S Ranch Liberty Park | 29187 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 4.774 | 4S Ranch Liberty Park | 0 | Local Park 2 | 4 |
15156 | 15156 | 15155 | {"type": "Polygon", "coordinates": [[[-117.10945, 33.02613], [-117.1071, 33.02507], [-117.10729, 33.02431], [-117.10808, 33.02445], [-117.10808, 33.02453], [-117.10813, 33.02459], [-117.10823, 33.02463], [-117.10995, 33.02563], [-117.10997, 33.02568], [-117.10993, 33.02573], [-117.10955, 33.02601], [-117.10945, 33.02613]]]} | Open Access 1 | 46005 | 4S Ranch Patriot Park | 29266 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.762 | 4S Ranch Patriot Park | 0 | Local Park 2 | 4 |
9650 | 9650 | 9649 | {"type": "MultiPolygon", "coordinates": [[[[-119.3271, 35.23519], [-119.32338, 35.23601], [-119.32338, 35.23601], [-119.32338, 35.23584], [-119.32375, 35.23573], [-119.32462, 35.23517], [-119.3271, 35.23519]]], [[[-119.33225, 35.24252], [-119.32342, 35.24243], [-119.32339, 35.23627], [-119.32797, 35.23524], [-119.32799, 35.2355], [-119.32807, 35.23593], [-119.32811, 35.23606], [-119.32814, 35.23626], [-119.32815, 35.23644], [-119.32805, 35.23711], [-119.32806, 35.23749], [-119.32808, 35.23762], [-119.32819, 35.23794], [-119.32822, 35.2381], [-119.32822, 35.23837], [-119.32819, 35.23859], [-119.32812, 35.23877], [-119.32833, 35.23876], [-119.32839, 35.23862], [-119.32841, 35.23845], [-119.32841, 35.23804], [-119.32836, 35.2378], [-119.32825, 35.2375], [-119.32824, 35.23712], [-119.32827, 35.237], [-119.32834, 35.23645], [-119.32834, 35.23621], [-119.3282, 35.23556], [-119.32817, 35.23519], [-119.33068, 35.23462], [-119.33067, 35.23521], [-119.33113, 35.23521], [-119.33114, 35.23607], [-119.33218, 35.23608], [-119.33225, 35.24252]]]]} | Open Access 1 | 16269 | A. W. Noon Park | 15225 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 154.121 | A. W. Noon Park | 0 | Local Park 2 | 4 | |
4330 | 4330 | 4329 | {"type": "Polygon", "coordinates": [[[-118.20079, 34.47351], [-118.1974, 34.47353], [-118.19737, 34.47181], [-118.19937, 34.4718], [-118.19969, 34.47185], [-118.1999, 34.4719], [-118.20024, 34.47204], [-118.20055, 34.47224], [-118.20078, 34.47245], [-118.20079, 34.47351]]]} | Open Access 1 | 45479 | Acton Park | 32464 | 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/Acton_Park | Los Angeles 6 | 13.925 | Acton Park | 0 | Local Park 2 | 4 |
6180 | 6180 | 6179 | {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03776, 33.94222], [-118.03777, 33.94223]]]} | Open Access 1 | 1282 | Adventure Park | 15277 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 14.559 | Adventure Park | 0 | Local Park 2 | 4 | |
16318 | 16318 | 16317 | {"type": "Polygon", "coordinates": [[[-116.31206, 32.9622], [-116.31195, 32.96223], [-116.30382, 32.96232], [-116.29498, 32.9623], [-116.29506, 32.95855], [-116.28653, 32.95866], [-116.28678, 32.95114], [-116.29521, 32.951], [-116.29529, 32.94721], [-116.30306, 32.94726], [-116.31135, 32.94726], [-116.31206, 32.9622]]]} | Open Access 1 | 5247 | Agua Caliente Regional Park | 29024 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/AguaCaliente.html | San Diego 4 | 802.564 | Agua Caliente RP | 0 | Local Park 2 | 4 |
6135 | 6135 | 6134 | {"type": "Polygon", "coordinates": [[[-121.81009, 36.98721], [-121.80994, 36.98711], [-121.80897, 36.98712], [-121.80907, 36.98747], [-121.80915, 36.98801], [-121.80804, 36.98783], [-121.80804, 36.98741], [-121.80794, 36.98713], [-121.80693, 36.98714], [-121.80692, 36.98712], [-121.80828, 36.9871], [-121.8081, 36.98657], [-121.80874, 36.98643], [-121.80896, 36.98709], [-121.81004, 36.98708], [-121.81009, 36.98721]]]} | Open Access 1 | 1127 | Aldridge Lane Park | 15351 | 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 | 3.265 | Aldridge Lane Park | 0 | Local Park 2 | 4 | |
9462 | 9462 | 9461 | {"type": "MultiPolygon", "coordinates": [[[[-117.74571, 33.5005], [-117.74518, 33.50106], [-117.74514, 33.50106], [-117.74485, 33.50091], [-117.74481, 33.50074], [-117.74412, 33.50007], [-117.74386, 33.49969], [-117.7435, 33.49927], [-117.74351, 33.49913], [-117.74349, 33.49904], [-117.74345, 33.49895], [-117.74339, 33.49893], [-117.7433, 33.49884], [-117.74307, 33.49878], [-117.74292, 33.49866], [-117.74284, 33.49857], [-117.7427, 33.49868], [-117.74249, 33.49863], [-117.74215, 33.49859], [-117.74161, 33.49828], [-117.7411, 33.49784], [-117.74078, 33.49745], [-117.7407, 33.49706], [-117.74067, 33.49704], [-117.74064, 33.49695], [-117.74062, 33.49684], [-117.74057, 33.49666], [-117.7405, 33.49662], [-117.7404, 33.49647], [-117.74038, 33.49641], [-117.74009, 33.49624], [-117.73991, 33.49625], [-117.73944, 33.49564], [-117.73923, 33.49529], [-117.7391, 33.4947], [-117.73927, 33.49442], [-117.73917, 33.4941], [-117.7398, 33.49355], [-117.7398, 33.4936], [-117.73988, 33.49366], [-117.73988, 33.49377], [-117.73981, 33.49388], [-117.73962, 33.49414], [-117.7396, 33.49427], [-117.73966, 33.4944], [-117.73968, 33.49451], [-117.73982, 33.49466], [-117.7399, 33.4948], [-117.73992, 33.49489], [-117.73997, 33.49495], [-117.74019, 33.4951], [-117.74024, 33.4952], [-117.74028, 33.49532], [-117.74029, 33.49544], [-117.74032, 33.49552], [-117.74047, 33.49575], [-117.7409, 33.49587], [-117.74107, 33.49585], [-117.74114, 33.49589], [-117.74121, 33.49598], [-117.74119, 33.49611], [-117.74106, 33.4963], [-117.74106, 33.49657], [-117.7411, 33.4967], [-117.74121, 33.49697], [-117.74125, 33.49703], [-117.74137, 33.4971], [-117.74167, 33.49735], [-117.742, 33.49752], [-117.74226, 33.49769], [-117.74235, 33.49778], [-117.74246, 33.4978], [-117.74252, 33.49786], [-117.7427, 33.49797], [-117.74289, 33.49803], [-117.74306, 33.49812], [-117.74318, 33.49821], [-117.74336, 33.49824], [-117.7435, 33.49806], [-117.74359, 33.49803], [-117.7437, 33.49795], [-117.74379, 33.49795], [-117.74383, 33.49803], [-117.7438, 33.49809], [-117.74365, 33.4982], [-117.74361, 33.49827], [-117.74364, 33.49831], [-117.74379, 33.49835], [-117.74393, 33.49845], [-117.7441, 33.49841], [-117.74421, 33.49843], [-117.74428, 33.49846], [-117.74424, 33.49855], [-117.74418, 33.49865], [-117.74415, 33.49879], [-117.74423, 33.49891], [-117.74425, 33.49898], [-117.74426, 33.49919], [-117.74453, 33.49948], [-117.74474, 33.49963], [-117.74503, 33.4998], [-117.74519, 33.49993], [-117.74528, 33.50003], [-117.74542, 33.5001], [-117.74547, 33.50016], [-117.74549, 33.50025], [-117.74558, 33.50032], [-117.74566, 33.50048], [-117.74571, 33.5005]]], [[[-117.74679, 33.50232], [-117.74662, 33.5025], [-117.74653, 33.50254], [-117.74643, 33.50256], [-117.74628, 33.50236], [-117.74632, 33.50231], [-117.74634, 33.50223], [-117.74628, 33.50198], [-117.74607, 33.50188], [-117.74596, 33.50173], [-117.74592, 33.50157], [-117.74593, 33.50147], [-117.74607, 33.50138], [-117.74615, 33.50145], [-117.74615, 33.50151], [-117.74641, 33.50162], [-117.74654, 33.50154], [-117.74666, 33.50154], [-117.74669, 33.50163], [-117.7467, 33.50176], [-117.74666, 33.50191], [-117.74666, 33.502], [-117.74673, 33.50211], [-117.74675, 33.50222], [-117.74679, 33.50232]]], [[[-117.75133, 33.50794], [-117.75119, 33.50797], [-117.75105, 33.50804], [-117.75095, 33.50794], [-117.75085, 33.50768], [-117.75078, 33.50756], [-117.75069, 33.50724], [-117.75045, 33.50702], [-117.75017, 33.50705], [-117.74972, 33.50692], [-117.74954, 33.50672], [-117.74923, 33.50647], [-117.74899, 33.50617], [-117.74885, 33.50594], [-117.74865, 33.50579], [-117.74834, 33.50551], [-117.748, 33.50525], [-117.74786, 33.50474], [-117.74764, 33.50458], [-117.74744, 33.50427], [-117.7473, 33.50414], [-117.74726, 33.5038], [-117.74684, 33.50356], [-117.74705, 33.50331], [-117.74744, 33.50365], [-117.74756, 33.50389], [-117.74759, 33.504], [-117.74765, 33.50406], [-117.74776, 33.50414], [-117.74796, 33.50422], [-117.74809, 33.50436], [-117.74819, 33.5045], [-117.74827, 33.50466], [-117.7483, 33.5048], [-117.74838, 33.5049], [-117.74849, 33.50493], [-117.74865, 33.5051], [-117.74887, 33.50529], [-117.74889, 33.50538], [-117.74893, 33.50548], [-117.74898, 33.50555], [-117.74906, 33.50559], [-117.74931, 33.50586], [-117.74947, 33.50598], [-117.74964, 33.50608], [-117.74984, 33.50633], [-117.74988, 33.50641], [-117.7502, 33.50658], [-117.75036, 33.50673], [-117.75045, 33.50677], [-117.75055, 33.50678], [-117.75067, 33.50673], [-117.75078, 33.50667], [-117.75093, 33.50663], [-117.75107, 33.50665], [-117.75114, 33.50673], [-117.75118, 33.50689], [-117.75117, 33.50707], [-117.75126, 33.50722], [-117.75122, 33.50729], [-117.75124, 33.5077], [-117.75133, 33.50794]]], [[[-117.75269, 33.51143], [-117.75257, 33.51156], [-117.75251, 33.51167], [-117.75246, 33.51185], [-117.75247, 33.51199], [-117.75245, 33.5121], [-117.75238, 33.51226], [-117.75219, 33.51236], [-117.75198, 33.51242], [-117.74989, 33.51241], [-117.74968, 33.51243], [-117.74962, 33.51202], [-117.74932, 33.51168], [-117.74996, 33.51147], [-117.7502, 33.51164], [-117.75062, 33.51162], [-117.75087, 33.51145], [-117.75107, 33.51119], [-117.7512, 33.51111], [-117.75127, 33.5112], [-117.75133, 33.51136], [-117.75139, 33.51142], [-117.75146, 33.51145], [-117.75159, 33.51145], [-117.75204, 33.51131], [-117.75212, 33.51127], [-117.75222, 33.51118], [-117.75225, 33.51117], [-117.75253, 33.5113], [-117.75269, 33.51143]]], [[[-117.75603, 33.51286], [-117.75547, 33.51286], [-117.75541, 33.51285], [-117.75535, 33.51276], [-117.75531, 33.51274], [-117.75524, 33.51266], [-117.75502, 33.51258], [-117.75489, 33.51238], [-117.75449, 33.51197], [-117.75426, 33.51178], [-117.754, 33.51162], [-117.75374, 33.51189], [-117.75372, 33.51187], [-117.75397, 33.5116], [-117.75351, 33.51121], [-117.7529, 33.51086], [-117.75295, 33.51076], [-117.75302, 33.5107], [-117.75302, 33.51058], [-117.75308, 33.5105], [-117.75312, 33.51038], [-117.75318, 33.51028], [-117.75327, 33.51019], [-117.75332, 33.51016], [-117.75342, 33.51017], [-117.75361, 33.51037], [-117.75379, 33.51045], [-117.75409, 33.51076], [-117.75428, 33.51091], [-117.75446, 33.51112], [-117.75493, 33.5116], [-117.75532, 33.51215], [-117.75572, 33.51257], [-117.75586, 33.51275], [-117.75603, 33.51286]]]]} | Open Access 1 | 15813 | Aliso Beach Park | 32092 | 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 | http://www.ocparks.com/beaches/aliso/ | Orange 3 | 39.83 | Aliso Beach Park | 0 | Local Park 2 | 4 |
11312 | 11312 | 11311 | {"type": "Polygon", "coordinates": [[[-117.73018, 33.55145], [-117.73007, 33.55132], [-117.72978, 33.55133], [-117.72939, 33.55053], [-117.72916, 33.55018], [-117.72897, 33.54996], [-117.72876, 33.54976], [-117.72853, 33.54958], [-117.72827, 33.54942], [-117.72799, 33.54928], [-117.72755, 33.54911], [-117.72752, 33.54904], [-117.72746, 33.54902], [-117.72745, 33.54903], [-117.72738, 33.54901], [-117.72731, 33.54903], [-117.72704, 33.54898], [-117.72655, 33.54894], [-117.72607, 33.54895], [-117.72575, 33.549], [-117.72543, 33.54907], [-117.72512, 33.54917], [-117.72468, 33.54936], [-117.72441, 33.54952], [-117.72416, 33.54971], [-117.72393, 33.54991], [-117.72373, 33.55013], [-117.72359, 33.55033], [-117.7234, 33.55064], [-117.72207, 33.55341], [-117.72199, 33.55343], [-117.72127, 33.55319], [-117.72092, 33.55312], [-117.72067, 33.5531], [-117.72063, 33.55307], [-117.7206, 33.55302], [-117.72044, 33.55301], [-117.72053, 33.55288], [-117.72059, 33.55272], [-117.72067, 33.55258], [-117.72097, 33.55223], [-117.72098, 33.55213], [-117.72095, 33.55209], [-117.7209, 33.55205], [-117.72162, 33.55112], [-117.72088, 33.55051], [-117.72113, 33.55036], [-117.72217, 33.55008], [-117.72278, 33.54928], [-117.72298, 33.54867], [-117.72267, 33.548], [-117.72316, 33.54718], [-117.72349, 33.54598], [-117.7245, 33.54554], [-117.72578, 33.54423], [-117.72935, 33.54504], [-117.7294, 33.54846], [-117.72929, 33.54921], [-117.72978, 33.54978], [-117.73, 33.55017], [-117.72998, 33.55076], [-117.73018, 33.55145]]]} | Open Access 1 | 22037 | Aliso Canyon Community Park | 15369 | 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 | http://www.cityofalisoviejo.com/location/aliso-canyon-community-park/ | Orange 3 | 90.084 | Aliso Canyon Community Park | 0 | Local Park 2 | 4 |
2194 | 2194 | 2193 | {"type": "Polygon", "coordinates": [[[-117.96354, 34.0398], [-117.96255, 34.04072], [-117.96092, 34.03957], [-117.96193, 34.03862], [-117.96354, 34.0398]]]} | Open Access 1 | 16435 | Allen J Martin Park | 15378 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.797 | Allen J Martin Park | 0 | Local Park 2 | 4 | |
14402 | 14402 | 14401 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88725], [-118.34029, 33.88725], [-118.34013, 33.88558], [-118.34366, 33.88545], [-118.34366, 33.88725]]]} | Open Access 1 | 44524 | Alondra Community Regional Park | 15402 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 15.215 | Alondra Community RP | 0 | Local Park 2 | 4 | |
252 | 252 | 251 | {"type": "Polygon", "coordinates": [[[-119.48844, 35.88958], [-119.48844, 35.89083], [-119.48736, 35.89082], [-119.48736, 35.88959], [-119.48844, 35.88958]]]} | Open Access 1 | 702 | Alpaugh Park | 15404 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 3.313 | Alpaugh Park | 0 | Local Park 2 | 4 | |
3098 | 3098 | 3097 | {"type": "Polygon", "coordinates": [[[-122.80164, 39.09403], [-122.80152, 39.09441], [-122.80067, 39.09487], [-122.79979, 39.09391], [-122.80015, 39.09374], [-122.80017, 39.09381], [-122.80021, 39.09387], [-122.80034, 39.09397], [-122.80057, 39.09394], [-122.80068, 39.09403], [-122.80164, 39.09403]]]} | Open Access 1 | 25217 | Alpine County Park | 15406 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 2.313 | Alpine County Park | 0 | Local Park 2 | 4 | |
9757 | 9757 | 9756 | {"type": "Polygon", "coordinates": [[[-118.13253, 34.18988], [-118.13208, 34.1899], [-118.13157, 34.19001], [-118.1315, 34.18999], [-118.13147, 34.18994], [-118.13148, 34.18975], [-118.13166, 34.18963], [-118.13189, 34.1897], [-118.13207, 34.18969], [-118.13216, 34.18976], [-118.13253, 34.18988]]]} | Open Access 1 | 47869 | Altadena Triangle Park | 32467 | 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/altadena-triangle-park/ | Los Angeles 6 | 0.524 | Altadena Triangle Park | 0 | Local Park 2 | 4 |
6847 | 6847 | 6846 | {"type": "Polygon", "coordinates": [[[-118.70661, 34.02967], [-118.70628, 34.02966], [-118.70561, 34.02975], [-118.70525, 34.02983], [-118.70503, 34.03003], [-118.70481, 34.03012], [-118.70419, 34.03031], [-118.70382, 34.03037], [-118.70373, 34.03036], [-118.70346, 34.03042], [-118.70316, 34.03054], [-118.70299, 34.0305], [-118.70275, 34.03058], [-118.70225, 34.03072], [-118.70199, 34.03075], [-118.70161, 34.03085], [-118.70144, 34.03079], [-118.70127, 34.03077], [-118.70101, 34.0309], [-118.7003, 34.03111], [-118.70019, 34.03118], [-118.69989, 34.03128], [-118.69943, 34.03147], [-118.69944, 34.03155], [-118.69921, 34.0316], [-118.69917, 34.03149], [-118.69885, 34.03153], [-118.69884, 34.03154], [-118.69891, 34.03167], [-118.69846, 34.03179], [-118.69838, 34.03173], [-118.69825, 34.03179], [-118.69825, 34.03188], [-118.69792, 34.03201], [-118.69769, 34.03212], [-118.69763, 34.03207], [-118.69732, 34.03223], [-118.69721, 34.03217], [-118.69697, 34.03227], [-118.69681, 34.03228], [-118.69627, 34.0325], [-118.69582, 34.03263], [-118.69571, 34.03238], [-118.69614, 34.03228], [-118.69686, 34.03216], [-118.69835, 34.0316], [-118.69939, 34.03133], [-118.69992, 34.0311], [-118.70058, 34.03087], [-118.70138, 34.03063], [-118.70161, 34.0306], [-118.70178, 34.03062], [-118.70228, 34.03055], [-118.70288, 34.03032], [-118.70426, 34.03001], [-118.70525, 34.02965], [-118.70588, 34.0295], [-118.70651, 34.02923], [-118.70661, 34.02967]]]} | Open Access 1 | 5475 | Amarillo Beach | 15438 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.778 | Amarillo Beach | 0 | Local Park 2 | 4 | |
9948 | 9948 | 9947 | {"type": "Polygon", "coordinates": [[[-118.05172, 33.93163], [-118.05126, 33.93164], [-118.05124, 33.93161], [-118.0496, 33.93161], [-118.04959, 33.92815], [-118.05097, 33.92917], [-118.05171, 33.92968], [-118.05172, 33.93163]]]} | Open Access 1 | 17115 | Amelia Mayberry Park | 15446 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 14.437 | Amelia Mayberry Park | 0 | Local Park 2 | 4 | |
11682 | 11682 | 11681 | {"type": "MultiPolygon", "coordinates": [[[[-121.51094, 38.60405], [-121.5106, 38.60425], [-121.51027, 38.60446], [-121.50982, 38.60483], [-121.50931, 38.60524], [-121.50896, 38.60548], [-121.50836, 38.60585], [-121.50815, 38.60596], [-121.50791, 38.60606], [-121.50747, 38.6062], [-121.50675, 38.60635], [-121.5053, 38.60676], [-121.50183, 38.60755], [-121.501, 38.60771], [-121.50003, 38.60784], [-121.49221, 38.60846], [-121.49169, 38.60849], [-121.49111, 38.60848], [-121.49106, 38.60848], [-121.49105, 38.60845], [-121.49086, 38.60844], [-121.49079, 38.60645], [-121.49076, 38.60584], [-121.49055, 38.60484], [-121.48962, 38.60369], [-121.48936, 38.60362], [-121.48882, 38.60314], [-121.48878, 38.60289], [-121.48945, 38.60288], [-121.49042, 38.60303], [-121.49253, 38.6032], [-121.49398, 38.60318], [-121.49463, 38.60311], [-121.49673, 38.60306], [-121.49721, 38.60314], [-121.49758, 38.60311], [-121.49796, 38.60314], [-121.49831, 38.60305], [-121.49879, 38.60306], [-121.4991, 38.60293], [-121.49947, 38.60287], [-121.49987, 38.60268], [-121.50035, 38.60255], [-121.50076, 38.60238], [-121.50115, 38.60236], [-121.50133, 38.6023], [-121.50162, 38.60225], [-121.50177, 38.60219], [-121.50203, 38.60214], [-121.50227, 38.60204], [-121.50287, 38.6019], [-121.50309, 38.60179], [-121.50347, 38.60171], [-121.50381, 38.60158], [-121.50409, 38.60153], [-121.50431, 38.6014], [-121.50462, 38.60126], [-121.50475, 38.60119], [-121.50494, 38.60113], [-121.50505, 38.60106], [-121.50588, 38.60082], [-121.5062, 38.60064], [-121.50647, 38.60031], [-121.50665, 38.60018], [-121.51094, 38.60405]]], [[[-121.51419, 38.60293], [-121.51377, 38.60304], [-121.51376, 38.6037], [-121.51311, 38.6036], [-121.51273, 38.60359], [-121.51236, 38.60361], [-121.51204, 38.60366], [-121.51168, 38.60375], [-121.51143, 38.60384], [-121.51107, 38.60399], [-121.50675, 38.6001], [-121.50695, 38.6], [-121.50742, 38.59953], [-121.50811, 38.59915], [-121.50865, 38.59889], [-121.50897, 38.59886], [-121.50902, 38.59867], [-121.50911, 38.5994], [-121.51017, 38.6007], [-121.51023, 38.60064], [-121.51119, 38.6014], [-121.51186, 38.60189], [-121.51268, 38.60228], [-121.51419, 38.60293]]]]} | Open Access 1 | 23977 | American River Parkway - Discovery Park | 9959 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/Pages/DiscoveryPark.aspx | Sacramento 41 | 272.747 | American River Parkway - Discovery 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]);