units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
MNG_AG_LEV 4 ✖
- City 7,486
- Special District 1,077
- County 812
- Joint 1
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16848 | 16848 | 16847 | {"type": "Polygon", "coordinates": [[[-122.19101, 38.04175], [-122.19099, 38.04178], [-122.19086, 38.04185], [-122.1906, 38.04191], [-122.19039, 38.04202], [-122.19028, 38.04212], [-122.19015, 38.04228], [-122.19005, 38.04237], [-122.18937, 38.04276], [-122.18914, 38.04295], [-122.18891, 38.04318], [-122.18882, 38.04325], [-122.18837, 38.04342], [-122.18829, 38.0435], [-122.18825, 38.04362], [-122.18808, 38.04355], [-122.18799, 38.0437], [-122.18818, 38.04379], [-122.18804, 38.04398], [-122.18768, 38.04405], [-122.18769, 38.04413], [-122.1875, 38.04418], [-122.18769, 38.0448], [-122.18742, 38.04484], [-122.18741, 38.04482], [-122.18723, 38.04488], [-122.18694, 38.04494], [-122.18693, 38.04493], [-122.18667, 38.04491], [-122.18666, 38.04492], [-122.18668, 38.04499], [-122.18634, 38.04507], [-122.18625, 38.04481], [-122.18572, 38.04491], [-122.18571, 38.04492], [-122.18579, 38.04516], [-122.18542, 38.04523], [-122.18542, 38.04526], [-122.1853, 38.04528], [-122.18525, 38.04516], [-122.18507, 38.0452], [-122.18506, 38.04523], [-122.18493, 38.04526], [-122.18496, 38.04535], [-122.18479, 38.04538], [-122.18476, 38.04529], [-122.18456, 38.04533], [-122.18445, 38.04524], [-122.18409, 38.04532], [-122.18348, 38.04481], [-122.18335, 38.04533], [-122.18362, 38.04556], [-122.18354, 38.04552], [-122.18336, 38.0457], [-122.1834, 38.04574], [-122.18317, 38.04592], [-122.18342, 38.04611], [-122.18335, 38.04616], [-122.18321, 38.04605], [-122.18297, 38.04623], [-122.1806, 38.04465], [-122.18023, 38.04434], [-122.17991, 38.044], [-122.17963, 38.04363], [-122.17904, 38.04266], [-122.18113, 38.04172], [-122.18334, 38.04281], [-122.18366, 38.04276], [-122.18375, 38.04237], [-122.18264, 38.04163], [-122.1839, 38.04107], [-122.18473, 38.04119], [-122.18494, 38.0412], [-122.18515, 38.04118], [-122.18572, 38.04105], [-122.18589, 38.04102], [-122.18624, 38.04102], [-122.18658, 38.04108], [-122.18686, 38.04117], [-122.1884, 38.04201], [-122.18853, 38.04206], [-122.18868, 38.0421], [-122.18884, 38.0421], [-122.18897, 38.04209], [-122.18959, 38.04199], [-122.18975, 38.04194], [-122.18988, 38.04186], [-122.19, 38.04177], [-122.19011, 38.04161], [-122.19016, 38.0415], [-122.19022, 38.04146], [-122.1903, 38.04144], [-122.19042, 38.04147], [-122.19071, 38.04165], [-122.19083, 38.04168], [-122.19094, 38.04168], [-122.19098, 38.04169], [-122.191, 38.04171], [-122.19101, 38.04175]]]} | Restricted Access 2 | 29402 | Carquinez Strait Regional Shoreline | 16904 | 3126 | Port Costa Conservation Society 1177 | Non Profit 6 | Non Profit - Conservation 12 | http://www.portcosta.com/newsletter.htm | Non Governmental Organization 10 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 76.447 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 | |
16364 | 16364 | 16363 | {"type": "Polygon", "coordinates": [[[-117.78127, 33.86017], [-117.78126, 33.86048], [-117.78076, 33.86071], [-117.76229, 33.86967], [-117.76089, 33.87029], [-117.75995, 33.87067], [-117.7585, 33.8712], [-117.75664, 33.8718], [-117.75577, 33.87211], [-117.75492, 33.87244], [-117.75365, 33.87297], [-117.75361, 33.87262], [-117.75407, 33.87242], [-117.75549, 33.87185], [-117.75646, 33.87151], [-117.75743, 33.87119], [-117.75748, 33.87124], [-117.75843, 33.87093], [-117.75937, 33.87059], [-117.76077, 33.87004], [-117.76213, 33.86943], [-117.78035, 33.86059], [-117.78127, 33.86017]]]} | Open Access 1 | 47964 | Yorba Regional Park | 27778 | 2420 | Orange County Flood Control District 1171 | Special District 4 | Flood District 8 | http://www.ocflood.com/ | Special District 4 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 22.503 | Yorba RP | 0 | Local Park 2 | 4 |
16299 | 16299 | 16298 | {"type": "MultiPolygon", "coordinates": [[[[-117.00698, 32.8493], [-117.00696, 32.8538], [-117.00784, 32.85577], [-117.00829, 32.85706], [-117.00841, 32.8577], [-117.00898, 32.86045], [-117.00905, 32.86085], [-117.00751, 32.86158], [-117.00743, 32.86121], [-117.00733, 32.8609], [-117.00661, 32.85925], [-117.00645, 32.8588], [-117.00637, 32.85845], [-117.00477, 32.84968], [-117.00476, 32.84959], [-117.00497, 32.84953], [-117.00472, 32.84888], [-117.00453, 32.84889], [-117.00424, 32.84725], [-117.00411, 32.84585], [-117.00392, 32.8452], [-117.00418, 32.84515], [-117.00444, 32.84493], [-117.00432, 32.84443], [-117.00441, 32.84444], [-117.00473, 32.84442], [-117.0048, 32.84446], [-117.00484, 32.84453], [-117.00501, 32.84451], [-117.005, 32.84441], [-117.00506, 32.84436], [-117.00548, 32.84432], [-117.00554, 32.84434], [-117.00558, 32.8444], [-117.00574, 32.84438], [-117.00573, 32.84428], [-117.00587, 32.84425], [-117.00601, 32.84469], [-117.00645, 32.84462], [-117.00691, 32.84606], [-117.00698, 32.8493]]], [[[-117.00923, 32.86438], [-117.00906, 32.86491], [-117.00844, 32.86624], [-117.00817, 32.86642], [-117.0076, 32.86635], [-117.00738, 32.86624], [-117.00703, 32.86596], [-117.00697, 32.86578], [-117.00795, 32.86413], [-117.00825, 32.8639], [-117.00917, 32.8642], [-117.00923, 32.86438]]]]} | Open Access 1 | 193 | Santee Lakes Regional Park | 25150 | 2106 | Padre Dam Municipal Water District 1170 | Special District 4 | Water District 13 | http://www.padredam.org/ | Special District 4 | 2106 | Padre Dam Municipal Water District 1109 | Special District 4 | Water District 13 | http://www.santeelakes.com/ | San Diego 4 | 99.056 | Santee Lakes RP | 0 | Local Park 2 | 4 |
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 | |
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 | |
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 | |
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 | |
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 | |
15271 | 15271 | 15270 | {"type": "Polygon", "coordinates": [[[-118.11657, 33.91793], [-118.11657, 33.91795], [-118.11639, 33.9182], [-118.11639, 33.91832], [-118.1159, 33.91833], [-118.11589, 33.9183], [-118.11582, 33.9183], [-118.11581, 33.91828], [-118.11572, 33.91828], [-118.11571, 33.91809], [-118.11509, 33.9181], [-118.11508, 33.91806], [-118.11485, 33.91806], [-118.11484, 33.91809], [-118.11463, 33.91809], [-118.11463, 33.91875], [-118.11356, 33.91874], [-118.11419, 33.91728], [-118.11434, 33.91721], [-118.11651, 33.9172], [-118.11657, 33.91725], [-118.11657, 33.91793]]]} | Restricted Access 2 | 46351 | Columbus High School Park | 31885 | 2368 | Downey Unified School District 1147 | Special District 4 | School District 14 | http://www.dusd.net/ | Special District 4 | 2368 | Downey Unified School District 1095 | Special District 4 | School District 21 | Los Angeles 6 | 7.577 | Columbus High School Park | 0 | Local Park 2 | 4 | |
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06053], [-118.41139, 34.0606], [-118.41083, 34.06087], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06003], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06053]]], [[[-118.41243, 34.06254], [-118.41205, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41232, 34.06203], [-118.41217, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | 46326 | Beverly Hills High School Park | 31849 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 10.447 | Beverly Hills High School Park | 0 | Local Park 2 | 4 | |
15263 | 15263 | 15262 | {"type": "Polygon", "coordinates": [[[-118.38356, 34.06628], [-118.38312, 34.0663], [-118.3831, 34.06602], [-118.38268, 34.06603], [-118.38267, 34.06594], [-118.38262, 34.06594], [-118.3826, 34.06506], [-118.38346, 34.06506], [-118.38351, 34.06508], [-118.38356, 34.06628]]]} | Restricted Access 2 | 46327 | Horace Mann Elementary School Park | 31881 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.532 | Horace Mann Elementary School Park | 0 | Local Park 2 | 4 | |
15264 | 15264 | 15263 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | 46328 | Beverly Vista Elementary School Park | 31882 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.838 | Beverly Vista Elementary School Park | 0 | Local Park 2 | 4 | |
15265 | 15265 | 15264 | {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} | Restricted Access 2 | 46329 | Hawthorne Elementary School Park | 31883 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.583 | Hawthorne Elementary School Park | 0 | Local Park 2 | 4 | |
15266 | 15266 | 15265 | {"type": "Polygon", "coordinates": [[[-118.41726, 34.06839], [-118.41627, 34.06893], [-118.41611, 34.06874], [-118.41596, 34.06861], [-118.41582, 34.06852], [-118.41542, 34.06833], [-118.41525, 34.0682], [-118.41505, 34.068], [-118.41489, 34.06775], [-118.41483, 34.06759], [-118.41478, 34.06733], [-118.41477, 34.06722], [-118.41588, 34.06722], [-118.41602, 34.06756], [-118.41573, 34.06766], [-118.41586, 34.06795], [-118.41595, 34.06793], [-118.416, 34.06794], [-118.41609, 34.06801], [-118.41588, 34.0681], [-118.41597, 34.06833], [-118.41609, 34.0683], [-118.41627, 34.0687], [-118.41651, 34.06863], [-118.41669, 34.06851], [-118.41654, 34.06811], [-118.41696, 34.06797], [-118.41726, 34.06839]]]} | Restricted Access 2 | 46330 | El Rodeo Elementary School Park | 31884 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 3.998 | El Rodeo Elementary School Park | 0 | Local Park 2 | 4 | |
15255 | 15255 | 15254 | {"type": "Polygon", "coordinates": [[[-118.12195, 33.89644], [-118.12189, 33.89649], [-118.12166, 33.89649], [-118.12171, 33.89622], [-118.12195, 33.89622], [-118.12195, 33.89644]]]} | Open Access 1 | 46308 | Chevron Pocket Park | 29600 | 6104 | Chevron Pipe Line Company 1145 | Private 7 | Commercial 20 | http://www.chevronpipeline.com/about/ | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.179 | Chevron PP | 0 | Local Park 2 | 4 | |
16431 | 16431 | 16430 | {"type": "Polygon", "coordinates": [[[-117.83973, 34.08948], [-117.83939, 34.08989], [-117.83876, 34.08965], [-117.83843, 34.08942], [-117.83824, 34.08936], [-117.83808, 34.08936], [-117.83791, 34.08941], [-117.83777, 34.08951], [-117.8376, 34.08971], [-117.83744, 34.08977], [-117.83718, 34.0898], [-117.83699, 34.08985], [-117.83687, 34.08962], [-117.83699, 34.08957], [-117.83757, 34.08887], [-117.83804, 34.08872], [-117.83842, 34.08887], [-117.83904, 34.08915], [-117.83954, 34.08911], [-117.83973, 34.08948]]]} | Open Access 1 | 46301 | Walnut Creek Community Regional Park | 29589 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Walnut_Creek_Community_Regional_Park | Los Angeles 6 | 4.239 | Walnut Creek Community RP | 0 | Local Park 2 | 4 |
15228 | 15228 | 15227 | {"type": "Polygon", "coordinates": [[[-118.11833, 33.88205], [-118.11787, 33.88208], [-118.11777, 33.88205], [-118.11754, 33.88194], [-118.11747, 33.88184], [-118.11747, 33.88161], [-118.11833, 33.88205]]]} | Open Access 1 | 46284 | Bellflower Bike Trail Plaza | 29576 | 2077 | Los Angeles County Metropolitan Transportation Authority 1142 | Special District 4 | Transportation Agency 32 | http://www.metro.net | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.44 | Bellflower Bike Trail Plaza | 0 | Local Park 2 | 4 | |
15201 | 15201 | 15200 | {"type": "Polygon", "coordinates": [[[-118.41981, 33.98441], [-118.4179, 33.98583], [-118.41786, 33.98591], [-118.41784, 33.98601], [-118.41786, 33.98605], [-118.41782, 33.98606], [-118.41773, 33.98597], [-118.41734, 33.98624], [-118.41726, 33.98615], [-118.41972, 33.98432], [-118.41981, 33.98441]]]} | Open Access 1 | 46080 | Milton Street Park | 29422 | 500 | Baldwin Hills Regional Conservation Authority 1140 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/BHRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.029 | Milton Street Park | 0 | Local Park 2 | 4 | |
15168 | 15168 | 15167 | {"type": "Polygon", "coordinates": [[[-118.32353, 33.34225], [-118.32381, 33.34224], [-118.32377, 33.34263], [-118.32321, 33.34256], [-118.32326, 33.34241], [-118.32332, 33.34234], [-118.32339, 33.34229], [-118.32353, 33.34225]]]} | Open Access 1 | 46018 | Avalon City Park | 29343 | 6013 | Northwood II Community Association 1139 | Private 7 | Home Owners Association 16 | Private 14 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | Los Angeles 6 | 0.445 | Avalon City 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]);