units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,522
- County Agency 1,217
- Recreation/Parks District 1,158
- State Agency 1,141
- Non Profit - Land Trust 600
- Federal Agency 517
- Open Space District 427
- County Agency - Parks 236
- Water District 236
- Home Owners Association 201
- Community Services District 198
- Non Profit - Conservation 147
- Flood District 108
- Cemetery District 62
- Irrigation District 48
- Non Profit - Other 44
- School District 38
- County Agency - Other 35
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- …
MNG_AGENCY >30
- San Diego, City of 532
- Los Angeles, City of 491
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 350
- 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 166
- 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 94
- 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,373
- Local Recreation Area 1,980
- Local Other or Unknown 1,190
- Private Conservation 626
- Local Conservation Area 485
- State Conservation Area 381
- Private Recreation or Education 265
- 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 38
- 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
- …
AGNCY_LEV 8 ✖
- City 10,394
- Special District 2,374
- County 1,454
- State 1,198
- Non Profit 774
- Federal 584
- Private 263
- Joint 7
ACCESS_TYP 4
- Open Access 14,495
- Restricted Access 1,199
- No Public Access 968
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16183 | 16183 | 16182 | {"type": "Polygon", "coordinates": [[[-116.96262, 32.66755], [-116.96258, 32.67203], [-116.9624, 32.67632], [-116.96061, 32.6763], [-116.96057, 32.67812], [-116.95842, 32.67809], [-116.95815, 32.68544], [-116.95389, 32.68549], [-116.9496, 32.68532], [-116.94952, 32.67935], [-116.94962, 32.66718], [-116.95173, 32.66721], [-116.95171, 32.67086], [-116.95136, 32.67085], [-116.95135, 32.67086], [-116.95145, 32.67118], [-116.9517, 32.67172], [-116.95188, 32.67188], [-116.95185, 32.67227], [-116.95191, 32.67262], [-116.9519, 32.67282], [-116.95177, 32.67289], [-116.95196, 32.6732], [-116.95169, 32.67409], [-116.95183, 32.67443], [-116.95208, 32.67451], [-116.95247, 32.67456], [-116.9524, 32.67497], [-116.95235, 32.67565], [-116.95234, 32.67634], [-116.95242, 32.67715], [-116.95232, 32.67769], [-116.95227, 32.67865], [-116.95263, 32.67895], [-116.9528, 32.67927], [-116.95272, 32.67965], [-116.95259, 32.68069], [-116.95268, 32.68104], [-116.95291, 32.68152], [-116.95313, 32.68161], [-116.95414, 32.68165], [-116.95455, 32.68221], [-116.95477, 32.68236], [-116.95507, 32.68269], [-116.95534, 32.68301], [-116.95553, 32.68311], [-116.95598, 32.68351], [-116.95623, 32.68353], [-116.95641, 32.6833], [-116.95648, 32.68294], [-116.95691, 32.6828], [-116.95718, 32.68259], [-116.95736, 32.68229], [-116.95749, 32.68199], [-116.95741, 32.68142], [-116.9572, 32.68091], [-116.95737, 32.68062], [-116.95743, 32.68033], [-116.95743, 32.68007], [-116.9575, 32.67979], [-116.95762, 32.67949], [-116.95764, 32.67923], [-116.95759, 32.67898], [-116.95759, 32.67872], [-116.95752, 32.67844], [-116.95757, 32.67783], [-116.95772, 32.67749], [-116.95798, 32.67702], [-116.95829, 32.67654], [-116.95842, 32.67622], [-116.95892, 32.67575], [-116.96005, 32.67517], [-116.96004, 32.67482], [-116.96017, 32.67458], [-116.96029, 32.67422], [-116.96058, 32.67373], [-116.96067, 32.6735], [-116.96068, 32.67316], [-116.96065, 32.67274], [-116.96045, 32.67188], [-116.96041, 32.67153], [-116.96048, 32.67116], [-116.96048, 32.67092], [-116.96103, 32.67029], [-116.9616, 32.66946], [-116.96178, 32.66878], [-116.96214, 32.66815], [-116.96242, 32.66771], [-116.96262, 32.66755]]]} | No Public Access 3 | 46836 | Mount Miguel Open Space | 30305 | 2401 | Otay Water District 1164 | Special District 4 | Water District 13 | http://www.otaywater.gov/ | Special District 4 | 2401 | Otay Water District 1106 | Special District 4 | Water District 13 | San Diego 4 | 231.148 | Mount Miguel OS | 0 | Local Recreation Area 3 | 4 | |
16115 | 16115 | 16114 | {"type": "Polygon", "coordinates": [[[-118.88101, 34.2362], [-118.87558, 34.23472], [-118.87557, 34.23259], [-118.87577, 34.23259], [-118.87594, 34.23263], [-118.87677, 34.23216], [-118.8773, 34.2319], [-118.87763, 34.23181], [-118.87829, 34.23157], [-118.87848, 34.23146], [-118.87875, 34.23127], [-118.87912, 34.2311], [-118.87943, 34.23093], [-118.87963, 34.23086], [-118.8798, 34.23082], [-118.87995, 34.23077], [-118.88029, 34.23061], [-118.88054, 34.23054], [-118.88085, 34.23036], [-118.881, 34.23019], [-118.88101, 34.2362]]]} | Open Access 1 | 49008 | Mount Clef Ridge Open Space - COSCA | 22524 | 3400 | California Lutheran University 1163 | Non Profit 6 | Non Profit - Education 34 | https://www.callutheran.edu/ | Non Governmental Organization 10 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/mt.-clef.html | Ventura 8 | 54.245 | Mount Clef Ridge OS - COSCA | None 1382 | ||
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
15695 | 15695 | 15694 | {"type": "Polygon", "coordinates": [[[-114.6039, 34.84393], [-114.60287, 34.84392], [-114.60287, 34.84339], [-114.6039, 34.84339], [-114.6039, 34.84393]]]} | Restricted Access 2 | 49074 | River's Edge Golf Course | 33774 | 2442 | Needles Unified School District 1161 | Special District 4 | School District 14 | https://www.needlesusd.org/ | Special District 4 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 1.368 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
15667 | 15667 | 15666 | {"type": "MultiPolygon", "coordinates": [[[[-117.78087, 34.13432], [-117.77956, 34.13623], [-117.77952, 34.13623], [-117.77668, 34.13961], [-117.77672, 34.13656], [-117.77842, 34.13656], [-117.77907, 34.13625], [-117.77907, 34.13623], [-117.77757, 34.13623], [-117.77816, 34.13544], [-117.78087, 34.13432]]], [[[-117.78553, 34.13746], [-117.7855, 34.13899], [-117.78448, 34.1382], [-117.78414, 34.13855], [-117.78324, 34.13797], [-117.78188, 34.13857], [-117.77931, 34.14076], [-117.77831, 34.14213], [-117.7783, 34.14331], [-117.77675, 34.14332], [-117.77677, 34.13975], [-117.77972, 34.13625], [-117.77971, 34.13623], [-117.78, 34.1358], [-117.78077, 34.1347], [-117.78082, 34.13473], [-117.78093, 34.13461], [-117.7812, 34.13438], [-117.78164, 34.13411], [-117.78274, 34.13355], [-117.78304, 34.13334], [-117.78316, 34.13323], [-117.78323, 34.1332], [-117.78327, 34.1332], [-117.78333, 34.13323], [-117.7842, 34.13378], [-117.78317, 34.13427], [-117.78294, 34.13488], [-117.78326, 34.13531], [-117.78441, 34.13592], [-117.78436, 34.13609], [-117.78435, 34.13626], [-117.78438, 34.13643], [-117.78449, 34.13664], [-117.78468, 34.13683], [-117.78553, 34.13746]], [[-117.78214, 34.13578], [-117.78214, 34.13579], [-117.78231, 34.13592], [-117.78253, 34.13571], [-117.78235, 34.13558], [-117.78214, 34.13578]]]]} | Restricted Access 2 | 6754 | San Dimas Canyon Golf Course | 33021 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1160 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1104 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 103.27 | San Dimas Canyon GC | 0 | Local Recreation Area 3 | 4 | ||
15558 | 15558 | 15557 | {"type": "MultiPolygon", "coordinates": [[[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]], [[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]]]} | Open Access 1 | 1247 | San Elijo Lagoon Ecological Reserve | 24880 | 3058 | Rancho Santa Fe Community Foundation 1159 | Non Profit 6 | Non Profit - Other 22 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | https://www.sanelijo.org/home | San Diego 4 | 14.074 | San Elijo Lagoon ER | 1983 | Private Conservation 16 | 2 |
15426 | 15426 | 15425 | {"type": "MultiPolygon", "coordinates": [[[[-122.28318, 38.30265], [-122.28294, 38.3029], [-122.2829, 38.30296], [-122.28289, 38.30304], [-122.28294, 38.30335], [-122.28277, 38.30344], [-122.28272, 38.30318], [-122.28268, 38.30281], [-122.28265, 38.3027], [-122.28254, 38.30246], [-122.28229, 38.30218], [-122.28217, 38.30212], [-122.28207, 38.3021], [-122.28203, 38.30204], [-122.2821, 38.30199], [-122.28205, 38.30193], [-122.28217, 38.30187], [-122.2822, 38.30189], [-122.28231, 38.30179], [-122.28244, 38.30173], [-122.28318, 38.30265]]], [[[-122.28323, 38.3012], [-122.28254, 38.30155], [-122.28245, 38.30144], [-122.28269, 38.30123], [-122.28274, 38.3012], [-122.28277, 38.30122], [-122.28284, 38.30112], [-122.28297, 38.30103], [-122.28289, 38.30092], [-122.2829, 38.30087], [-122.28274, 38.30068], [-122.28279, 38.30065], [-122.28323, 38.3012]]], [[[-122.28379, 38.30186], [-122.28306, 38.30224], [-122.28265, 38.3017], [-122.28337, 38.30134], [-122.28379, 38.30186]]], [[[-122.2837, 38.30098], [-122.28341, 38.30111], [-122.28296, 38.30057], [-122.28325, 38.30043], [-122.28332, 38.30043], [-122.2837, 38.30098]]]]} | Open Access 1 | 46689 | Oxbow Commons | 30727 | 2405 | Napa County Flood Control and Water Conservation District 1158 | Special District 4 | Water District 13 | http://www.countyofnapa.org/flooddistrict/ | Special District 4 | 2405 | Napa County Flood Control and Water Conservation District 1100 | Special District 4 | Water District 13 | Napa 11 | 3.865 | Oxbow Commons | None 1363 | |||
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
15358 | 15358 | 15357 | {"type": "Polygon", "coordinates": [[[-118.08395, 34.01292], [-118.0835, 34.01349], [-118.08385, 34.01371], [-118.08368, 34.0139], [-118.08365, 34.01392], [-118.08362, 34.01391], [-118.08245, 34.01323], [-118.08312, 34.01244], [-118.08395, 34.01292]]]} | Restricted Access 2 | 46547 | Pio Pico Playground | 31638 | 2369 | El Rancho Unified School District 1156 | Special District 4 | School District 14 | http://www.erusd.org/ | Special District 4 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 2.817 | Pio Pico Playground | 0 | Local Recreation Area 3 | 4 | |
15342 | 15342 | 15341 | {"type": "Polygon", "coordinates": [[[-118.15776, 33.90102], [-118.15612, 33.90103], [-118.15579, 33.90087], [-118.15578, 33.89949], [-118.15753, 33.8995], [-118.15754, 33.89955], [-118.15769, 33.89956], [-118.15768, 33.89972], [-118.15775, 33.89973], [-118.15776, 33.90102]]]} | Restricted Access 2 | 46525 | Paramount Park | 29813 | 2397 | Paramount Unified School District 1155 | Special District 4 | School District 14 | http://www.paramount.k12.ca.us/ | Special District 4 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 7.536 | Paramount Park | 0 | Local Park 2 | 4 | |
15330 | 15330 | 15329 | {"type": "Polygon", "coordinates": [[[-118.2036, 34.20436], [-118.2036, 34.20462], [-118.20323, 34.20462], [-118.20323, 34.20436], [-118.2036, 34.20436]]]} | Restricted Access 2 | 46505 | Skate Park | 31585 | 2395 | La Canada Unified School District 1154 | Special District 4 | School District 14 | http://lcusd.net/site/default.aspx?PageID=1 | Special District 4 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks/skate | Los Angeles 6 | 0.246 | Skate Park | 0 | Local Recreation Area 3 | 4 |
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
15319 | 15319 | 15318 | {"type": "Polygon", "coordinates": [[[-117.99491, 34.13454], [-117.99491, 34.13492], [-117.99485, 34.13497], [-117.99432, 34.13496], [-117.99491, 34.13454]]]} | Open Access 1 | 46482 | Evergreen Plaza Park | 29759 | 2394 | Metro Gold Line Foothill Extension Construction Authority 1152 | Special District 4 | Transportation Agency 32 | http://www.foothillgoldline.org/about-us/construction-authority/ | Special District 4 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | Los Angeles 6 | 0.318 | Evergreen Plaza Park | 2015 | Local Park 2 | 4 | |
15305 | 15305 | 15304 | {"type": "Polygon", "coordinates": [[[-118.10762, 34.09685], [-118.10762, 34.09685], [-118.10657, 34.09656], [-118.10761, 34.09622], [-118.10765, 34.09626], [-118.10762, 34.09685]]]} | Open Access 1 | 46474 | Plaza Park | 29747 | 3358 | Archdiocese of Los Angeles 1151 | Non Profit 6 | Non Profit - Other 22 | http://www.la-archdiocese.org/Pages/default.aspx | Non Governmental Organization 10 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.869 | Plaza Park | 0 | Local Park 2 | 4 | |
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15301 | 15301 | 15300 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | 46438 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 4.034 | Royal Oaks Trail North | None 1352 | |||
15293 | 15293 | 15292 | {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} | No Public Access 3 | 46424 | El Segundo Blue Butterfly Preserve | 29696 | 6107 | Chevron Corporation 1149 | Private 7 | Commercial 20 | http://www.chevron.com/ | Private 14 | 6107 | Chevron Corporation 1096 | Private 7 | Commercial 18 | Los Angeles 6 | 1.358 | El Segundo Blue Butterfly Preserve | 0 | Private Conservation 16 | 2 |
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]);