units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV
MNG_AG_TYP >30
- City Agency 10,524
- County Agency 1,219
- Recreation/Parks District 1,162
- State Agency 1,141
- Non Profit - Land Trust 601
- Federal Agency 517
- Open Space District 428
- Water District 238
- County Agency - Parks 236
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 351
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Los Angeles, County of 175
- East Bay Regional Park District 167
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- San Diego, County of 123
- Oakland, City of 122
- United States Bureau of Land Management 121
- Santa Barbara, County of 119
- United States Forest Service 111
- Irvine, City of 101
- Fresno, City of 95
- Orange, County of 95
- Consumnes Community Services District 94
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 83
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- …
DES_TP >30
- Local Park 9,376
- Local Recreation Area 1,989
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 485
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Public Lands 75
- National Wildlife Refuge 75
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 14,510
- Restricted Access 1,203
- No Public Access 969
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2740 | 2740 | 2739 | {"type": "Polygon", "coordinates": [[[-121.82582, 36.6117], [-121.8252, 36.61169], [-121.8252, 36.61165], [-121.82581, 36.61166], [-121.82582, 36.6117]]]} | Open Access 1 | 18402 | park access 2 | 23424 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.063 | park access 2 | None 226 | |||
3742 | 3742 | 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]]]} | Unknown Access 4 | 44862 | Zwierstra Mitigation Site | 27873 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 19.59 | Zwierstra Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
12876 | 12876 | 12875 | {"type": "Polygon", "coordinates": [[[-117.99859, 33.80404], [-117.99817, 33.80405], [-117.99816, 33.8035], [-117.99859, 33.80349], [-117.99859, 33.80404]]]} | Open Access 1 | 30339 | Zuniga Park | 27872 | 1342 | Stanton, City of 745 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | Orange 3 | 0.588 | Zuniga Park | 0 | Local Park 2 | 4 | |
421 | 421 | 420 | {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} | Open Access 1 | 1297 | Zumwalt Park | 27871 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 2.969 | Zumwalt Park | 0 | Local Park 2 | 4 | |
14406 | 14406 | 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]]]} | Open Access 1 | 44515 | Zumstein Park | 27870 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.158 | Zumstein Park | 0 | Local Park 2 | 4 | |
9314 | 9314 | 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]]]]} | Open Access 1 | 15529 | Zuma/Trancas Canyons | 14311 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/zumatrancascanyons.htm | Los Angeles 6 | 3111.527 | Zuma/Trancas Canyons | 0 | National Recreation Area 54 | 3 |
6951 | 6951 | 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]]]]} | Open Access 1 | 5854 | Zuma County Beach | 27869 | 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 | http://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/zuma+beach+1 | Los Angeles 6 | 97.148 | Zuma County Beach | 0 | Local Park 2 | 4 |
8154 | 8154 | 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]]]} | Open Access 1 | 13752 | Zolezzi Park | 27868 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.715 | Zolezzi Park | 2007 | Local Park 2 | 4 | |
9297 | 9297 | 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]]]} | Open Access 1 | 15520 | Zoeter Field | 27867 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 3.137 | Zoeter Field | 0 | Local Recreation Area 3 | 4 | |
6471 | 6471 | 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]]]} | Open Access 1 | 2013 | Zmudowski State Beach | 1793 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=572 | Monterey 14 | 177.898 | Zmudowski SB | 1950 | State Park 15 | 4 |
6469 | 6469 | 6468 | {"type": "Polygon", "coordinates": [[[-122.44202, 38.4864], [-122.44169, 38.48664], [-122.44097, 38.48604], [-122.44129, 38.48579], [-122.44202, 38.4864]]]} | Open Access 1 | 2363 | Zinfandel Park | 27866 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 0.889 | Zinfandel Park | 0 | Local Park 2 | 4 | |
11766 | 11766 | 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]]]} | Open Access 1 | 24058 | Zimbelman Park | 27865 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.892 | Zimbelman Park | 0 | Local Park 2 | 4 | |
14348 | 14348 | 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]]]} | Open Access 1 | 44386 | Zev Yaroslavsky Las Virgenes Highlands Park | 27864 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 192.192 | Zev Yaroslavsky Las Virgenes Highlands Park | 0 | Local Park 2 | 4 | |
3750 | 3750 | 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]]]} | Open Access 1 | 310 | Zerillo Park | 27863 | 1278 | Riverbank, City of 41 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | Stanislaus 2 | 5.721 | Zerillo Park | 0 | Local Park 2 | 4 | |
5775 | 5775 | 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]]]} | Open Access 1 | 5 | Zena Mini-Park | 27862 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
9309 | 9309 | 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]]]} | Open Access 1 | 15517 | Zelzah Park | 27861 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.729 | Zelzah Park | 0 | Local Park 2 | 4 | |
2149 | 2149 | 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]]]} | Open Access 1 | 16016 | Zelinksy Park | 27860 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.209 | Zelinksy Park | 0 | Local Park 2 | 4 | |
7085 | 7085 | 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]]]} | Open Access 1 | 6178 | Zela Davis Park | 27858 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 0.738 | Zela Davis Park | 0 | Local Park 2 | 4 | |
5465 | 5465 | 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]]]} | Restricted Access 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | Hawthorne School District 808 | Special District 4 | School District 14 | http://www.hawthorne.k12.ca.us/ | Special District 4 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 1.201 | Zela Davis Elementary School Park | 0 | Local Park 2 | 4 | |
12546 | 12546 | 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]]]} | Open Access 1 | 29050 | Zehnder Park | 27857 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 9.459 | Zehnder 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]);