units_with_maps_view (view)
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2739 | {"type": "Polygon", "coordinates": [[[-121.82582, 36.6117], [-121.8252, 36.61169], [-121.8252, 36.61165], [-121.82581, 36.61166], [-121.82582, 36.6117]]]} | 1 | 18402 | park access 2 | 23424 | 1330 | 115 | 2 | 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | 2 | 1330 | 112 | 2 | 2 | 14 | 0.063 | park access 2 | 226 | |||
3741 | {"type": "Polygon", "coordinates": [[[-117.25665, 33.25608], [-117.25376, 33.25609], [-117.24955, 33.25549], [-117.24981, 33.25449], [-117.25017, 33.25456], [-117.25354, 33.25499], [-117.25356, 33.25494], [-117.25383, 33.25496], [-117.25409, 33.25496], [-117.25448, 33.25494], [-117.25623, 33.25464], [-117.25665, 33.25608]]]} | 4 | 44862 | Zwierstra Mitigation Site | 27873 | 205 | 283 | 5 | 5 | http://www.dot.ca.gov/ | 5 | 205 | 279 | 5 | 5 | 4 | 19.59 | Zwierstra Mitigation Site | 0 | 104 | 4 | |
12875 | {"type": "Polygon", "coordinates": [[[-117.99859, 33.80404], [-117.99817, 33.80405], [-117.99816, 33.8035], [-117.99859, 33.80349], [-117.99859, 33.80404]]]} | 1 | 30339 | Zuniga Park | 27872 | 1342 | 745 | 2 | 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | 2 | 1342 | 731 | 2 | 2 | 3 | 0.588 | Zuniga Park | 0 | 2 | 4 | |
420 | {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} | 1 | 1297 | Zumwalt Park | 27871 | 1398 | 163 | 2 | 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | 2 | 1398 | 159 | 2 | 2 | 29 | 2.969 | Zumwalt Park | 0 | 2 | 4 | |
14405 | {"type": "Polygon", "coordinates": [[[-121.14296, 37.7305], [-121.14279, 37.73057], [-121.14273, 37.73044], [-121.14271, 37.73031], [-121.14278, 37.73023], [-121.14295, 37.73023], [-121.14296, 37.7305]]]} | 1 | 44515 | Zumstein Park | 27870 | 1277 | 534 | 2 | 2 | http://www.cityofripon.org/ | 2 | 1277 | 527 | 2 | 2 | 39 | 0.158 | Zumstein Park | 0 | 2 | 4 | |
9313 | {"type": "MultiPolygon", "coordinates": [[[[-118.86327, 34.05264], [-118.86323, 34.05625], [-118.85886, 34.05629], [-118.85887, 34.05271], [-118.86327, 34.05264]]], [[[-118.79964, 34.05968], [-118.79937, 34.05947], [-118.79914, 34.05921], [-118.79898, 34.05894], [-118.79888, 34.05867], [-118.79883, 34.0584], [-118.79867, 34.05643], [-118.79964, 34.05644], [-118.79964, 34.05968]]], [[[-118.79854, 34.06723], [-118.79799, 34.07086], [-118.79304, 34.07086], [-118.7932, 34.06724], [-118.79854, 34.06723]]], [[[-118.86765, 34.08914], [-118.86325, 34.08915], [-118.86225, 34.08914], [-118.86101, 34.08916], [-118.85558, 34.08917], [-118.85555, 34.0875], [-118.85375, 34.08749], [-118.85375, 34.08653], [-118.85449, 34.08638], [-118.85449, 34.08559], [-118.85451, 34.0819], [-118.85453, 34.07474], [-118.85452, 34.07473], [-118.85009, 34.07478], [-118.84569, 34.07472], [-118.84567, 34.07687], [-118.84572, 34.08193], [-118.85011, 34.08194], [-118.85011, 34.08556], [-118.85228, 34.08557], [-118.85228, 34.08649], [-118.85013, 34.08651], [-118.8501, 34.08556], [-118.84572, 34.08554], [-118.84571, 34.08193], [-118.84129, 34.0819], [-118.84133, 34.08917], [-118.83252, 34.08917], [-118.83248, 34.08551], [-118.82813, 34.08559], [-118.82369, 34.08562], [-118.82369, 34.08195], [-118.81933, 34.08199], [-118.81938, 34.08024], [-118.81909, 34.07977], [-118.81887, 34.07951], [-118.81863, 34.07925], [-118.81837, 34.07905], [-118.81776, 34.07875], [-118.81737, 34.07863], [-118.81679, 34.07849], [-118.81627, 34.07829], [-118.8149, 34.07829], [-118.81489, 34.07625], [-118.81492, 34.07448], [-118.81934, 34.07446], [-118.81947, 34.06721], [-118.81947, 34.06719], [-118.81943, 34.06719], [-118.81946, 34.06543], [-118.8197, 34.05281], [-118.82392, 34.05276], [-118.82801, 34.05278], [-118.83254, 34.05278], [-118.8411, 34.05286], [-118.84551, 34.05284], [-118.85015, 34.05284], [-118.85015, 34.05637], [-118.84559, 34.0564], [-118.84561, 34.05285], [-118.84551, 34.05284], [-118.84556, 34.05996], [-118.85014, 34.05995], [-118.85014, 34.05815], [-118.85453, 34.05812], [-118.85455, 34.05994], [-118.85893, 34.05992], [-118.85885, 34.06366], [-118.85886, 34.0747], [-118.85891, 34.08191], [-118.86323, 34.0819], [-118.86321, 34.08545], [-118.86758, 34.08551], [-118.86765, 34.08914]], [[-118.82375, 34.07829], [-118.82376, 34.07827], [-118.82375, 34.07826], [-118.823, 34.07828], [-118.82375, 34.07829]], [[-118.82808, 34.07447], [-118.82807, 34.07446], [-118.82376, 34.07447], [-118.82375, 34.07533], [-118.82376, 34.07534], [-118.82807, 34.07533], [-118.82808, 34.07447]], [[-118.82375, 34.07444], [-118.82374, 34.07443], [-118.82263, 34.07446], [-118.82374, 34.07447], [-118.82375, 34.07444]], [[-118.83239, 34.07446], [-118.8368, 34.07455], [-118.83681, 34.07454], [-118.8368, 34.07275], [-118.83463, 34.0727], [-118.83459, 34.07088], [-118.83039, 34.07083], [-118.82812, 34.07084], [-118.82808, 34.07446], [-118.83239, 34.07446]], [[-118.83462, 34.07088], [-118.83463, 34.07087], [-118.83462, 34.07033], [-118.8346, 34.07087], [-118.83462, 34.07088]], [[-118.84118, 34.07097], [-118.84124, 34.07098], [-118.84125, 34.07097], [-118.84116, 34.06935], [-118.84118, 34.07097]]]]} | 1 | 15529 | Zuma/Trancas Canyons | 14311 | 108 | 102 | 1 | 1 | http://www.nps.gov/ | 12 | 108 | 59 | 1 | 1 | http://www.nps.gov/samo/planyourvisit/zumatrancascanyons.htm | 6 | 3111.527 | Zuma/Trancas Canyons | 0 | 54 | 3 |
6950 | {"type": "MultiPolygon", "coordinates": [[[[-118.81739, 34.01633], [-118.81698, 34.01691], [-118.81678, 34.01699], [-118.81673, 34.01699], [-118.81667, 34.01696], [-118.81668, 34.01687], [-118.81673, 34.01681], [-118.81739, 34.01633]]], [[[-118.84301, 34.02905], [-118.84223, 34.02992], [-118.8422, 34.02991], [-118.84178, 34.0296], [-118.83882, 34.02766], [-118.8382, 34.0272], [-118.83711, 34.02621], [-118.83632, 34.02562], [-118.83557, 34.02516], [-118.83435, 34.0245], [-118.83433, 34.02451], [-118.83416, 34.02442], [-118.83417, 34.02439], [-118.8339, 34.02424], [-118.83387, 34.02427], [-118.83353, 34.02407], [-118.83354, 34.02404], [-118.83323, 34.02387], [-118.8332, 34.02389], [-118.83303, 34.02379], [-118.83303, 34.02377], [-118.83133, 34.02282], [-118.83077, 34.02246], [-118.83024, 34.02206], [-118.82523, 34.01785], [-118.82464, 34.01743], [-118.82425, 34.0172], [-118.82385, 34.017], [-118.82354, 34.01686], [-118.82321, 34.01674], [-118.82273, 34.01659], [-118.82239, 34.0165], [-118.82204, 34.01642], [-118.82147, 34.01634], [-118.82064, 34.01628], [-118.82005, 34.0163], [-118.81958, 34.01634], [-118.81913, 34.01641], [-118.81799, 34.01664], [-118.81708, 34.01689], [-118.81756, 34.01621], [-118.81832, 34.01566], [-118.81848, 34.01551], [-118.81939, 34.01403], [-118.81945, 34.01385], [-118.81945, 34.0137], [-118.81941, 34.01357], [-118.81934, 34.01344], [-118.81896, 34.01299], [-118.81678, 34.01091], [-118.81723, 34.01059], [-118.81798, 34.01133], [-118.81932, 34.01229], [-118.81964, 34.01249], [-118.81986, 34.01262], [-118.81995, 34.01256], [-118.82003, 34.01262], [-118.82023, 34.01281], [-118.82052, 34.01312], [-118.82082, 34.01338], [-118.82163, 34.014], [-118.82296, 34.01508], [-118.82369, 34.01571], [-118.82442, 34.01629], [-118.82554, 34.01713], [-118.82587, 34.01735], [-118.82694, 34.01812], [-118.82722, 34.0183], [-118.82747, 34.01849], [-118.82771, 34.01864], [-118.82795, 34.01883], [-118.82824, 34.01901], [-118.82883, 34.01943], [-118.82889, 34.01949], [-118.83118, 34.02108], [-118.83231, 34.02194], [-118.83312, 34.02252], [-118.83367, 34.02288], [-118.83506, 34.0239], [-118.83519, 34.02399], [-118.83567, 34.02436], [-118.83684, 34.02511], [-118.83778, 34.02579], [-118.83951, 34.02691], [-118.84068, 34.02763], [-118.84102, 34.02786], [-118.84181, 34.02836], [-118.84271, 34.02889], [-118.84301, 34.02905]]]]} | 1 | 5854 | Zuma County Beach | 27869 | 305 | 16 | 3 | 3 | http://parks.lacounty.gov | 3 | 305 | 16 | 3 | 3 | http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/zuma+beach+1 | 6 | 97.148 | Zuma County Beach | 0 | 2 | 4 |
8153 | {"type": "Polygon", "coordinates": [[[-121.85116, 37.34628], [-121.85095, 37.34628], [-121.85074, 37.34634], [-121.85008, 37.34674], [-121.85002, 37.34676], [-121.84993, 37.34675], [-121.84958, 37.34642], [-121.85074, 37.3457], [-121.85079, 37.34575], [-121.85071, 37.34581], [-121.85116, 37.34628]]]} | 1 | 13752 | Zolezzi Park | 27868 | 1303 | 33 | 2 | 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | 2 | 1303 | 32 | 2 | 2 | 19 | 1.715 | Zolezzi Park | 2007 | 2 | 4 | |
9296 | {"type": "Polygon", "coordinates": [[[-118.10221, 33.74239], [-118.10162, 33.7432], [-118.10041, 33.74259], [-118.10094, 33.74186], [-118.10181, 33.7423], [-118.10187, 33.74222], [-118.10221, 33.74239]]]} | 1 | 15520 | Zoeter Field | 27867 | 1329 | 3 | 2 | 2 | http://www.sealbeachca.gov/living/community/facilities/ | 2 | 1329 | 3 | 2 | 2 | 3 | 3.137 | Zoeter Field | 0 | 3 | 4 | |
6470 | {"type": "Polygon", "coordinates": [[[-121.80995, 36.84696], [-121.80802, 36.84901], [-121.807, 36.84902], [-121.80701, 36.84903], [-121.80797, 36.84904], [-121.80762, 36.85072], [-121.80748, 36.85114], [-121.80717, 36.85168], [-121.80607, 36.85276], [-121.80579, 36.85276], [-121.80607, 36.85233], [-121.80618, 36.85208], [-121.80627, 36.85183], [-121.8063, 36.85165], [-121.80633, 36.85139], [-121.80632, 36.85113], [-121.80628, 36.85087], [-121.80621, 36.85062], [-121.80563, 36.84902], [-121.80574, 36.84902], [-121.80575, 36.84901], [-121.8041, 36.84483], [-121.80391, 36.84416], [-121.80381, 36.84305], [-121.80239, 36.83805], [-121.80217, 36.83804], [-121.802, 36.83747], [-121.8018, 36.83697], [-121.80165, 36.83668], [-121.80108, 36.83567], [-121.80078, 36.83509], [-121.80051, 36.83449], [-121.79915, 36.83117], [-121.79906, 36.83101], [-121.79894, 36.83087], [-121.79879, 36.83073], [-121.79866, 36.83064], [-121.79852, 36.83046], [-121.7982, 36.83001], [-121.79794, 36.82953], [-121.7977, 36.82894], [-121.79752, 36.82829], [-121.79738, 36.82796], [-121.79722, 36.82771], [-121.79585, 36.82631], [-121.79878, 36.82628], [-121.80178, 36.83247], [-121.80493, 36.83804], [-121.80578, 36.8402], [-121.80995, 36.84696]]]} | 1 | 2013 | Zmudowski State Beach | 1793 | 204 | 48 | 5 | 5 | http://www.parks.ca.gov/ | 9 | 204 | 47 | 5 | 5 | http://www.parks.ca.gov/?page_id=572 | 14 | 177.898 | Zmudowski SB | 1950 | 15 | 4 |
6468 | {"type": "Polygon", "coordinates": [[[-122.44202, 38.4864], [-122.44169, 38.48664], [-122.44097, 38.48604], [-122.44129, 38.48579], [-122.44202, 38.4864]]]} | 1 | 2363 | Zinfandel Park | 27866 | 1290 | 422 | 2 | 2 | http://cityofsthelena.org/parks-recreation | 2 | 1290 | 416 | 2 | 2 | 11 | 0.889 | Zinfandel Park | 0 | 2 | 4 | |
11765 | {"type": "Polygon", "coordinates": [[[-121.40978, 38.42718], [-121.40877, 38.42737], [-121.40846, 38.42737], [-121.40744, 38.42639], [-121.40714, 38.42634], [-121.40819, 38.42567], [-121.40978, 38.42718]]]} | 1 | 24058 | Zimbelman Park | 27865 | 2194 | 567 | 4 | 19 | http://www.yourcsd.com/parks/parks_list.asp | 4 | 2194 | 559 | 4 | 17 | 41 | 4.892 | Zimbelman Park | 0 | 2 | 4 | |
14347 | {"type": "Polygon", "coordinates": [[[-118.70897, 34.15007], [-118.70896, 34.15454], [-118.70252, 34.15455], [-118.70249, 34.15313], [-118.69819, 34.15314], [-118.69761, 34.15316], [-118.69748, 34.15272], [-118.69743, 34.15242], [-118.69741, 34.15208], [-118.69743, 34.15178], [-118.69747, 34.15155], [-118.69789, 34.15166], [-118.6981, 34.15115], [-118.69763, 34.15101], [-118.69802, 34.15008], [-118.69819, 34.14996], [-118.69825, 34.14961], [-118.69841, 34.14944], [-118.69878, 34.14891], [-118.69851, 34.14829], [-118.699, 34.14777], [-118.6994, 34.14746], [-118.69953, 34.14721], [-118.69967, 34.14707], [-118.70143, 34.14568], [-118.70188, 34.14553], [-118.70215, 34.14535], [-118.70228, 34.14507], [-118.70303, 34.14461], [-118.70413, 34.14399], [-118.70442, 34.14388], [-118.70549, 34.14323], [-118.70552, 34.15008], [-118.70897, 34.15007]]]} | 1 | 44386 | Zev Yaroslavsky Las Virgenes Highlands Park | 27864 | 2088 | 27 | 4 | 6 | http://www.mrca.ca.gov/ | 4 | 2088 | 27 | 4 | 6 | 6 | 192.192 | Zev Yaroslavsky Las Virgenes Highlands Park | 0 | 2 | 4 | |
3749 | {"type": "Polygon", "coordinates": [[[-120.94386, 37.73879], [-120.94314, 37.73885], [-120.94287, 37.73891], [-120.94263, 37.73902], [-120.94225, 37.73926], [-120.94216, 37.7393], [-120.94209, 37.73937], [-120.94207, 37.73943], [-120.94207, 37.73949], [-120.94211, 37.73957], [-120.94271, 37.74155], [-120.94263, 37.74162], [-120.94258, 37.74163], [-120.94248, 37.74161], [-120.94226, 37.74155], [-120.94204, 37.74153], [-120.94254, 37.74144], [-120.94254, 37.74143], [-120.94211, 37.73997], [-120.94189, 37.73997], [-120.94169, 37.7393], [-120.94138, 37.7393], [-120.9411, 37.73836], [-120.94174, 37.73838], [-120.94238, 37.73837], [-120.94323, 37.73832], [-120.94379, 37.73826], [-120.94386, 37.73879]]]} | 1 | 310 | Zerillo Park | 27863 | 1278 | 41 | 2 | 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | 2 | 1278 | 40 | 2 | 2 | 2 | 5.721 | Zerillo Park | 0 | 2 | 4 | |
5774 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | 1 | 5 | Zena Mini-Park | 27862 | 1297 | 4 | 2 | 2 | http://www.sandiego.gov/park-and-recreation/ | 2 | 1297 | 4 | 2 | 2 | 4 | 0.067 | Zena Mini-Park | 0 | 2 | 4 | |
9308 | {"type": "Polygon", "coordinates": [[[-118.52574, 34.28307], [-118.52532, 34.28336], [-118.5247, 34.28385], [-118.52397, 34.28304], [-118.52299, 34.28249], [-118.52309, 34.28228], [-118.52327, 34.28207], [-118.52344, 34.28194], [-118.52411, 34.28154], [-118.52433, 34.28135], [-118.52467, 34.28097], [-118.52474, 34.28095], [-118.52478, 34.28098], [-118.52495, 34.28132], [-118.5251, 34.28186], [-118.52519, 34.28208], [-118.52531, 34.28229], [-118.52559, 34.2827], [-118.52567, 34.28285], [-118.52574, 34.28307]]]} | 1 | 15517 | Zelzah Park | 27861 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 1188 | 24 | 2 | 2 | 6 | 9.729 | Zelzah Park | 0 | 2 | 4 | |
2148 | {"type": "Polygon", "coordinates": [[[-122.46161, 37.87736], [-122.46118, 37.87759], [-122.46109, 37.87757], [-122.46043, 37.87756], [-122.46026, 37.87689], [-122.46161, 37.87736]]]} | 1 | 16016 | Zelinksy Park | 27860 | 1348 | 486 | 2 | 2 | http://www.ci.tiburon.ca.us/ | 2 | 1348 | 477 | 2 | 2 | 23 | 1.209 | Zelinksy Park | 0 | 2 | 4 | |
7084 | {"type": "Polygon", "coordinates": [[[-118.33724, 33.911], [-118.33723, 33.91126], [-118.3372, 33.91128], [-118.33619, 33.91128], [-118.33619, 33.911], [-118.33724, 33.911]]]} | 1 | 6178 | Zela Davis Park | 27858 | 1130 | 299 | 2 | 2 | http://www.cityofhawthorne.com/ | 2 | 1130 | 295 | 2 | 2 | 6 | 0.738 | Zela Davis Park | 0 | 2 | 4 | |
5464 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | 808 | 4 | 14 | http://www.hawthorne.k12.ca.us/ | 4 | 1130 | 295 | 2 | 2 | 6 | 1.201 | Zela Davis Elementary School Park | 0 | 2 | 4 | |
12545 | {"type": "Polygon", "coordinates": [[[-121.45616, 38.42344], [-121.45539, 38.4233], [-121.45467, 38.4233], [-121.45467, 38.42339], [-121.45391, 38.42326], [-121.45311, 38.42314], [-121.45307, 38.42312], [-121.45306, 38.42308], [-121.45318, 38.4224], [-121.4532, 38.42195], [-121.45324, 38.42191], [-121.45503, 38.4219], [-121.45509, 38.42193], [-121.45522, 38.42193], [-121.45525, 38.42191], [-121.45602, 38.4222], [-121.45616, 38.42344]]]} | 1 | 29050 | Zehnder Park | 27857 | 2194 | 567 | 4 | 19 | http://www.yourcsd.com/parks/parks_list.asp | 4 | 2194 | 559 | 4 | 17 | 41 | 9.459 | Zehnder Park | 0 | 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW units_with_maps_view AS select id, AsGeoJSON(geometry) as 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 from CPAD_2020a_Units order by id;