units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where ACCESS_TYP = 2, COUNTY = 6, DES_TP = 2, LAYER = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB
MNG_AGENCY 16
- Los Angeles, City of 4
- Cerritos, City of 2
- Bell Gardens, City of 2
- Whittier, City of 2
- Long Beach, City of 2
- Glendora, City of 1
- Burbank, City of 1
- Redondo Beach, City of 1
- Lynwood, City of 1
- Compton, City of 1
- Palos Verdes Estates, City of 1
- Hermosa Beach, City of 1
- Pasadena, City of 1
- La Mirada, City of 1
- Lawndale, City of 1
- San Gabriel, City of 1
MNG_AG_TYP 1
- City Agency · 23 ✖
DES_TP 1
- Local Park · 23 ✖
ACCESS_TYP 1
- Restricted Access · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 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 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
4212 | 4212 | 4211 | {"type": "Polygon", "coordinates": [[[-118.35177, 33.8854], [-118.35106, 33.8854], [-118.35104, 33.88537], [-118.35099, 33.88502], [-118.35116, 33.88502], [-118.35131, 33.88511], [-118.35148, 33.88516], [-118.35162, 33.88518], [-118.35177, 33.88517], [-118.35177, 33.8854]]]} | Restricted Access 2 | 44962 | Dan McKenzie Community Gardens | 29797 | 1172 | Lawndale, City of 484 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/html/depthtml/csd/McKenzieGarden.html | Los Angeles 6 | 0.544 | Dan McKenzie Community Gardens | 0 | Local Park 2 | 4 |
4264 | 4264 | 4263 | {"type": "Polygon", "coordinates": [[[-118.10522, 34.07637], [-118.10463, 34.07637], [-118.10463, 34.07569], [-118.1044, 34.07568], [-118.10441, 34.07532], [-118.10455, 34.0753], [-118.10521, 34.07529], [-118.10522, 34.07637]]]} | Restricted Access 2 | 45322 | Marshall Community Park | 32836 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/539/Marshall-Park | Los Angeles 6 | 1.81 | Marshall Community Park | 0 | Local Park 2 | 4 |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
4407 | 4407 | 4406 | {"type": "Polygon", "coordinates": [[[-118.14787, 33.95964], [-118.14683, 33.9602], [-118.14653, 33.95978], [-118.14761, 33.9592], [-118.14787, 33.95964]]]} | Restricted Access 2 | 46199 | Community Garden | 32757 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 1.546 | Community Garden | 0 | Local Park 2 | 4 | |
4432 | 4432 | 4431 | {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97833], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} | Restricted Access 2 | 46559 | Whittier Dog Park | 29862 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.849 | Whittier Dog Park | 0 | Local Park 2 | 4 | |
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-118.29818, 34.06162], [-118.29723, 34.06162], [-118.29617, 34.06163], [-118.29617, 34.06159], [-118.29669, 34.06159], [-118.2967, 34.06149], [-118.29818, 34.06147], [-118.29818, 34.06162]]]} | Restricted Access 2 | 45735 | Robert F Kennedy Inspiration Park | 31643 | 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 | http://www.laparks.org/commissionerhtm/pdf2010/oct06/10-266.pdf | Los Angeles 6 | 0.574 | Robert F Kennedy Inspiration Park | 0 | Local Park 2 | 4 |
6022 | 6022 | 6021 | {"type": "Polygon", "coordinates": [[[-118.06026, 33.87842], [-118.05959, 33.87842], [-118.05956, 33.87688], [-118.06001, 33.87688], [-118.06019, 33.87686], [-118.06024, 33.87689], [-118.06026, 33.87842]]]} | Restricted Access 2 | 729 | Frontier Park | 19131 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 2.643 | Frontier Park | 0 | Local Park 2 | 4 | |
6996 | 6996 | 6995 | {"type": "Polygon", "coordinates": [[[-118.38523, 33.79959], [-118.38522, 33.80151], [-118.38443, 33.80159], [-118.38352, 33.8016], [-118.38261, 33.80165], [-118.38171, 33.80173], [-118.38073, 33.80184], [-118.38, 33.80185], [-118.37929, 33.80181], [-118.37888, 33.80176], [-118.37748, 33.80149], [-118.37709, 33.80147], [-118.37577, 33.80148], [-118.37556, 33.80145], [-118.37535, 33.8014], [-118.37506, 33.80128], [-118.37444, 33.8009], [-118.37413, 33.80077], [-118.37303, 33.80049], [-118.37119, 33.80011], [-118.36992, 33.79979], [-118.36961, 33.79966], [-118.36941, 33.79953], [-118.36931, 33.79944], [-118.36912, 33.7992], [-118.369, 33.79895], [-118.36896, 33.79878], [-118.36893, 33.79857], [-118.36895, 33.7979], [-118.36894, 33.79757], [-118.36869, 33.79637], [-118.36868, 33.79617], [-118.36871, 33.796], [-118.3688, 33.79575], [-118.36887, 33.79561], [-118.36892, 33.79555], [-118.36904, 33.79543], [-118.36932, 33.7952], [-118.36951, 33.79508], [-118.36977, 33.79497], [-118.37001, 33.79492], [-118.37153, 33.7948], [-118.37173, 33.7948], [-118.37201, 33.79483], [-118.37259, 33.79493], [-118.37278, 33.79494], [-118.37624, 33.79506], [-118.37703, 33.79504], [-118.37749, 33.79499], [-118.37774, 33.79501], [-118.37787, 33.79506], [-118.37798, 33.79512], [-118.37919, 33.79616], [-118.37948, 33.79636], [-118.3797, 33.79647], [-118.37997, 33.79657], [-118.38047, 33.79666], [-118.38097, 33.79671], [-118.38202, 33.79672], [-118.38247, 33.79675], [-118.38274, 33.79678], [-118.3829, 33.79682], [-118.38303, 33.79689], [-118.38308, 33.79692], [-118.38306, 33.79708], [-118.38284, 33.79829], [-118.38282, 33.79837], [-118.38275, 33.79841], [-118.38267, 33.79852], [-118.38264, 33.79863], [-118.38265, 33.79871], [-118.3827, 33.79882], [-118.38277, 33.7989], [-118.38287, 33.79895], [-118.38304, 33.79899], [-118.38353, 33.79888], [-118.38369, 33.79888], [-118.38393, 33.79893], [-118.38413, 33.79904], [-118.38452, 33.79939], [-118.38468, 33.79951], [-118.38493, 33.79959], [-118.38514, 33.7996], [-118.38523, 33.79959]], [[-118.37105, 33.79608], [-118.37099, 33.79596], [-118.37086, 33.79601], [-118.37094, 33.79615], [-118.37105, 33.79608]], [[-118.37068, 33.79599], [-118.37087, 33.79592], [-118.37082, 33.79582], [-118.37061, 33.79587], [-118.37068, 33.79599]], [[-118.37741, 33.7953], [-118.37728, 33.79529], [-118.37722, 33.79531], [-118.37715, 33.79535], [-118.3771, 33.7954], [-118.37707, 33.79546], [-118.37706, 33.79554], [-118.37708, 33.79562], [-118.37715, 33.7957], [-118.37721, 33.79573], [-118.37731, 33.79576], [-118.37738, 33.79576], [-118.3775, 33.79572], [-118.3776, 33.79562], [-118.37762, 33.79556], [-118.37761, 33.79543], [-118.37754, 33.79535], [-118.37741, 33.7953]]]} | Restricted Access 2 | 5934 | Palos Verdes Golf Club and City Parkland | 23372 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 211.347 | Palos Verdes Golf Club and City Parkland | 0 | Local Park 2 | 4 | |
7057 | 7057 | 7056 | {"type": "Polygon", "coordinates": [[[-118.38032, 33.83008], [-118.38014, 33.83049], [-118.38004, 33.83074], [-118.37953, 33.83259], [-118.37946, 33.83264], [-118.37939, 33.83263], [-118.37864, 33.83203], [-118.37849, 33.83189], [-118.37858, 33.83155], [-118.37918, 33.82935], [-118.3792, 33.82933], [-118.37923, 33.82933], [-118.37961, 33.82944], [-118.37995, 33.82962], [-118.38006, 33.8297], [-118.37989, 33.82988], [-118.37983, 33.82998], [-118.38032, 33.83008]]]} | Restricted Access 2 | 6052 | Alta Vista Park | 31602 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org/depts/public_works/parks/altavista.asp | Los Angeles 6 | 8.546 | Alta Vista Park | 0 | Local Park 2 | 4 |
7274 | 7274 | 7273 | {"type": "Polygon", "coordinates": [[[-118.03194, 33.98457], [-118.03194, 33.98501], [-118.03164, 33.98513], [-118.03164, 33.98457], [-118.03194, 33.98457]]]} | Restricted Access 2 | 6517 | Bailey Ranch House and Park | 29859 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.383 | Bailey Ranch House and Park | 0 | Local Park 2 | 4 | |
7375 | 7375 | 7374 | {"type": "MultiPolygon", "coordinates": [[[[-117.98765, 33.90292], [-117.98765, 33.90335], [-117.9876, 33.90368], [-117.98739, 33.90458], [-117.98734, 33.90462], [-117.98634, 33.90446], [-117.98612, 33.90441], [-117.9859, 33.90433], [-117.98565, 33.90419], [-117.98544, 33.904], [-117.98527, 33.9038], [-117.98524, 33.90364], [-117.98521, 33.9036], [-117.98511, 33.90356], [-117.98502, 33.9036], [-117.98488, 33.90349], [-117.98521, 33.90315], [-117.9855, 33.90276], [-117.98687, 33.90275], [-117.98688, 33.90286], [-117.98757, 33.90286], [-117.98762, 33.90288], [-117.98765, 33.90292]]], [[[-117.98975, 33.90265], [-117.9879, 33.90266], [-117.98554, 33.90268], [-117.98574, 33.90226], [-117.98587, 33.90182], [-117.98592, 33.90143], [-117.98593, 33.90094], [-117.98973, 33.90093], [-117.98975, 33.90265]]]]} | Restricted Access 2 | 6769 | Behringer Park | 29779 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 26.715 | Behringer Park | 0 | Local Park 2 | 4 | |
7504 | 7504 | 7503 | {"type": "MultiPolygon", "coordinates": [[[[-117.86421, 34.11739], [-117.86389, 34.11734], [-117.86388, 34.11715], [-117.8639, 34.11707], [-117.86404, 34.11685], [-117.86421, 34.11739]]], [[[-117.86747, 34.11601], [-117.86702, 34.11747], [-117.86454, 34.11747], [-117.8645, 34.11742], [-117.86414, 34.11629], [-117.86409, 34.11607], [-117.86563, 34.11606], [-117.86563, 34.11468], [-117.86708, 34.11467], [-117.86708, 34.11404], [-117.86746, 34.11404], [-117.86747, 34.11601]]]]} | Restricted Access 2 | 7039 | Glenoaks Golf Course and Park | 32648 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.cityofglendora.org/departments-services/parks-recreation-senior-services/glen-oaks-golf-course | Los Angeles 6 | 17.737 | Glenoaks GC and Park | 0 | Local Park 2 | 4 |
11515 | 11515 | 11514 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | 48221 | Martin Luther King Jr. Park | 32772 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.547 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
12284 | 12284 | 12283 | {"type": "Polygon", "coordinates": [[[-118.53366, 34.03505], [-118.5333, 34.0359], [-118.53307, 34.0362], [-118.53297, 34.03611], [-118.5328, 34.0361], [-118.53282, 34.036], [-118.53279, 34.03592], [-118.53275, 34.03587], [-118.53261, 34.03578], [-118.53232, 34.03565], [-118.53202, 34.03557], [-118.53186, 34.03554], [-118.53161, 34.03554], [-118.53137, 34.03557], [-118.53079, 34.03574], [-118.53049, 34.03581], [-118.53031, 34.03583], [-118.52994, 34.03584], [-118.52955, 34.0358], [-118.52938, 34.03577], [-118.52913, 34.0357], [-118.52881, 34.03558], [-118.52863, 34.03548], [-118.52845, 34.03537], [-118.52837, 34.03533], [-118.52812, 34.03498], [-118.52804, 34.03454], [-118.52803, 34.03408], [-118.52811, 34.03394], [-118.52793, 34.03354], [-118.52755, 34.03327], [-118.52702, 34.03309], [-118.52664, 34.03355], [-118.52628, 34.03352], [-118.52621, 34.03414], [-118.52671, 34.03416], [-118.52669, 34.03442], [-118.52672, 34.03507], [-118.5268, 34.03551], [-118.52684, 34.03567], [-118.52638, 34.03577], [-118.52637, 34.0358], [-118.52644, 34.03597], [-118.52653, 34.03613], [-118.52676, 34.03645], [-118.5267, 34.03653], [-118.52656, 34.0365], [-118.52642, 34.03631], [-118.52627, 34.03618], [-118.52608, 34.03607], [-118.52593, 34.036], [-118.52578, 34.03596], [-118.52557, 34.03594], [-118.52538, 34.03594], [-118.52528, 34.03596], [-118.52539, 34.03581], [-118.52527, 34.03562], [-118.52498, 34.03597], [-118.52501, 34.03602], [-118.52476, 34.03616], [-118.52463, 34.03626], [-118.52454, 34.03636], [-118.52441, 34.03656], [-118.52436, 34.03671], [-118.52434, 34.03683], [-118.52434, 34.03702], [-118.52438, 34.03721], [-118.52449, 34.03748], [-118.52596, 34.03959], [-118.52609, 34.03975], [-118.52628, 34.03994], [-118.52668, 34.04025], [-118.527, 34.04042], [-118.52706, 34.04049], [-118.52704, 34.04085], [-118.52694, 34.04149], [-118.52664, 34.04146], [-118.5264, 34.0416], [-118.52632, 34.04182], [-118.52584, 34.04176], [-118.52603, 34.04073], [-118.52589, 34.04059], [-118.52501, 34.04047], [-118.52447, 34.03997], [-118.52465, 34.03924], [-118.52323, 34.03721], [-118.52313, 34.03653], [-118.52336, 34.0359], [-118.52367, 34.03554], [-118.52419, 34.03514], [-118.52423, 34.03517], [-118.52427, 34.03515], [-118.52484, 34.03422], [-118.52484, 34.03421], [-118.52478, 34.03419], [-118.52574, 34.03263], [-118.5256, 34.03206], [-118.52621, 34.03192], [-118.52648, 34.03206], [-118.52849, 34.03324], [-118.52951, 34.03374], [-118.52992, 34.03392], [-118.53077, 34.03423], [-118.53142, 34.03444], [-118.53366, 34.03505]]]} | Restricted Access 2 | 25935 | Potrero Canyon Park | 28872 | 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 | 59.924 | Potrero Canyon Park | 0 | Local Park 2 | 4 | |
14223 | 14223 | 14222 | {"type": "Polygon", "coordinates": [[[-118.19795, 33.88644], [-118.1967, 33.88649], [-118.19658, 33.88513], [-118.19786, 33.88512], [-118.19795, 33.88644]]]} | Restricted Access 2 | 44117 | Kelly Park | 20587 | 1065 | Compton, City of 276 | City 2 | City Agency 2 | http://www.comptoncity.org/index.php/Parks-and-Recreation/parks-and-recreation-overview.htm | City 2 | 1065 | Compton, City of 271 | City 2 | City Agency 2 | Los Angeles 6 | 4.325 | Kelly Park | 0 | Local Park 2 | 4 | |
15065 | 15065 | 15064 | {"type": "Polygon", "coordinates": [[[-118.46931, 34.16258], [-118.46866, 34.16231], [-118.46826, 34.16216], [-118.46633, 34.16157], [-118.46632, 34.16106], [-118.46918, 34.16165], [-118.46924, 34.16182], [-118.46929, 34.16204], [-118.46931, 34.16258]]]} | Restricted Access 2 | 45827 | Sherman Oaks Castle Park | 28846 | 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 | http://www.laparks.org/shermanoaks_castlepk/ | Los Angeles 6 | 4.982 | Sherman Oaks Castle 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]);