units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP >30
- Local Park 314
- Local Recreation Area 116
- Local Other or Unknown 26
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 432
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 491
MNG_AGENCY 1
- Los Angeles, City of · 491 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7260 | 7260 | 7259 | {"type": "Polygon", "coordinates": [[[-118.2864, 33.75129], [-118.28462, 33.75194], [-118.28435, 33.752], [-118.28352, 33.752], [-118.2833, 33.75197], [-118.28308, 33.75187], [-118.28289, 33.75176], [-118.28268, 33.75159], [-118.28261, 33.75149], [-118.28262, 33.75146], [-118.28264, 33.75144], [-118.28298, 33.7514], [-118.2831, 33.75136], [-118.28316, 33.7513], [-118.28341, 33.75078], [-118.28377, 33.75022], [-118.28384, 33.75016], [-118.28393, 33.75013], [-118.28408, 33.75009], [-118.28424, 33.75007], [-118.28446, 33.75007], [-118.28446, 33.75089], [-118.28451, 33.75102], [-118.2846, 33.75111], [-118.28464, 33.75114], [-118.28476, 33.75119], [-118.28491, 33.75118], [-118.28611, 33.75074], [-118.2864, 33.75129]]]} | Open Access 1 | 48929 | Knoll Hill Little League | 33648 | 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.901 | Knoll Hill Little League | None 599 | |||
11341 | 11341 | 11340 | {"type": "Polygon", "coordinates": [[[-118.29214, 33.74614], [-118.29214, 33.74647], [-118.29177, 33.74647], [-118.29177, 33.74612], [-118.29179, 33.74611], [-118.2921, 33.74611], [-118.29214, 33.74614]]]} | Open Access 1 | 48106 | Los Angeles Sister Cities Plaza | 32611 | 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 | https://www.laparks.org/park/los-angeles-sister-cities-plaza | Los Angeles 6 | 0.333 | Los Angeles Sister Cities Plaza | 0 | Local Park 2 | 4 |
11415 | 11415 | 11414 | {"type": "Polygon", "coordinates": [[[-118.44058, 34.20165], [-118.44015, 34.20165], [-118.44015, 34.20137], [-118.44021, 34.20134], [-118.44058, 34.20134], [-118.44058, 34.20165]]]} | Open Access 1 | 48104 | Greenwood Square Park | 32609 | 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 | https://www.laparks.org/park/greenwood-square-park | Los Angeles 6 | 0.331 | Greenwood Square Park | 0 | Local Park 2 | 4 |
11428 | 11428 | 11427 | {"type": "Polygon", "coordinates": [[[-118.29133, 33.98266], [-118.29128, 33.9827], [-118.2911, 33.9827], [-118.2911, 33.98267], [-118.29108, 33.98267], [-118.29108, 33.98255], [-118.29105, 33.98254], [-118.29105, 33.9822], [-118.2913, 33.98228], [-118.29132, 33.9823], [-118.29133, 33.98266]]]} | Open Access 1 | 48096 | Vermont Gage Park | 32601 | 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 | https://www.laparks.org/park/vermont-and-gage-park | Los Angeles 6 | 0.305 | Vermont Gage Park | 0 | Local Park 2 | 4 |
9403 | 9403 | 9402 | {"type": "Polygon", "coordinates": [[[-118.24174, 34.10059], [-118.24079, 34.10067], [-118.24073, 34.10141], [-118.24026, 34.10153], [-118.24008, 34.10105], [-118.23989, 34.10064], [-118.23963, 34.10019], [-118.2394, 34.09986], [-118.23909, 34.09947], [-118.23674, 34.09668], [-118.23649, 34.09643], [-118.23621, 34.09616], [-118.23573, 34.09577], [-118.2354, 34.09553], [-118.23528, 34.09552], [-118.2349, 34.09526], [-118.23451, 34.09501], [-118.23528, 34.09444], [-118.23594, 34.09452], [-118.23634, 34.09459], [-118.23672, 34.09469], [-118.2371, 34.09481], [-118.23747, 34.09495], [-118.238, 34.09522], [-118.23834, 34.09543], [-118.23864, 34.09566], [-118.23904, 34.09601], [-118.23927, 34.09626], [-118.23949, 34.09652], [-118.24137, 34.09927], [-118.24154, 34.0996], [-118.24166, 34.09996], [-118.24173, 34.10033], [-118.24174, 34.10059]]]} | No Public Access 3 | 47812 | G2 Parcel | 31694 | 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 | 41.839 | G2 Parcel | 0 | None 775 | ||
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 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 | 0.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
4782 | 4782 | 4781 | {"type": "MultiPolygon", "coordinates": [[[[-118.31523, 34.27262], [-118.31155, 34.27525], [-118.31209, 34.27614], [-118.31019, 34.27715], [-118.31018, 34.27759], [-118.30864, 34.278], [-118.30827, 34.27922], [-118.30683, 34.28], [-118.30504, 34.28028], [-118.30418, 34.27659], [-118.3067, 34.27613], [-118.30776, 34.27606], [-118.30797, 34.27532], [-118.30739, 34.27455], [-118.3079, 34.27436], [-118.30845, 34.27422], [-118.30878, 34.27411], [-118.30893, 34.27404], [-118.30921, 34.27384], [-118.30958, 34.27409], [-118.31025, 34.27505], [-118.31221, 34.27344], [-118.31465, 34.27267], [-118.31408, 34.27288], [-118.31389, 34.27298], [-118.31396, 34.27307], [-118.31454, 34.27284], [-118.31523, 34.27262]], [[-118.30988, 34.27535], [-118.30988, 34.27534], [-118.30953, 34.27504], [-118.30924, 34.27461], [-118.30928, 34.27454], [-118.30927, 34.27453], [-118.30885, 34.27447], [-118.3087, 34.27429], [-118.30803, 34.27437], [-118.30782, 34.27443], [-118.30784, 34.27447], [-118.30799, 34.27441], [-118.3086, 34.27434], [-118.30861, 34.27438], [-118.30817, 34.27444], [-118.30816, 34.27446], [-118.30908, 34.27567], [-118.30988, 34.27535]]], [[[-118.31018, 34.27763], [-118.31014, 34.27952], [-118.30543, 34.28199], [-118.30505, 34.28031], [-118.30684, 34.28003], [-118.30831, 34.27923], [-118.30868, 34.27803], [-118.31018, 34.27763]]], [[[-118.31695, 34.27216], [-118.31632, 34.27264], [-118.31581, 34.27301], [-118.3158, 34.27253], [-118.31583, 34.27253], [-118.31587, 34.27248], [-118.31656, 34.27226], [-118.31695, 34.27216]]]]} | Restricted Access 2 | 47252 | Unnamed site - Los Angeles, City of | 30961 | 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 | 88.776 | 0 | Local Other or Unknown 14 | 4 | ||
14818 | 14818 | 14817 | {"type": "Polygon", "coordinates": [[[-118.29521, 34.27884], [-118.29519, 34.2801], [-118.29503, 34.28012], [-118.29504, 34.2803], [-118.2952, 34.28031], [-118.29519, 34.28119], [-118.29466, 34.28157], [-118.29422, 34.28183], [-118.29408, 34.28193], [-118.29383, 34.28219], [-118.29376, 34.2823], [-118.29367, 34.28249], [-118.29368, 34.28251], [-118.29404, 34.28224], [-118.29422, 34.28204], [-118.29436, 34.28194], [-118.29469, 34.28176], [-118.29496, 34.28158], [-118.29518, 34.28141], [-118.29514, 34.28609], [-118.29164, 34.28609], [-118.29167, 34.28599], [-118.29165, 34.28597], [-118.29157, 34.28602], [-118.29153, 34.28609], [-118.29132, 34.28609], [-118.2914, 34.28588], [-118.29123, 34.28531], [-118.29102, 34.2843], [-118.29098, 34.28401], [-118.29159, 34.28334], [-118.29146, 34.28272], [-118.29116, 34.28235], [-118.29016, 34.28207], [-118.28993, 34.28138], [-118.28979, 34.28133], [-118.28989, 34.2811], [-118.28996, 34.28047], [-118.29016, 34.28012], [-118.29081, 34.27972], [-118.29084, 34.27882], [-118.29521, 34.27884]]]} | Open Access 1 | 47239 | Tujunga Little League Field | 31254 | 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.tujungalittleleague.com/ | Los Angeles 6 | 79.152 | Tujunga Little League Field | 0 | Local Recreation Area 3 | 4 |
17042 | 17042 | 17041 | {"type": "Polygon", "coordinates": [[[-118.37326, 34.27372], [-118.36895, 34.2735], [-118.36894, 34.27339], [-118.36827, 34.27335], [-118.3682, 34.27332], [-118.3682, 34.27247], [-118.36822, 34.27225], [-118.36828, 34.2722], [-118.36834, 34.27218], [-118.36839, 34.27207], [-118.36845, 34.27199], [-118.36856, 34.2719], [-118.36875, 34.27177], [-118.36887, 34.27172], [-118.36924, 34.27164], [-118.36933, 34.27158], [-118.36934, 34.27154], [-118.36933, 34.27138], [-118.36919, 34.27127], [-118.3688, 34.27111], [-118.36873, 34.27105], [-118.36865, 34.27091], [-118.36862, 34.27081], [-118.36862, 34.27071], [-118.36868, 34.27055], [-118.36874, 34.27046], [-118.36878, 34.27038], [-118.36881, 34.2701], [-118.36881, 34.26999], [-118.36876, 34.26986], [-118.36871, 34.26981], [-118.36861, 34.26974], [-118.36851, 34.26964], [-118.36848, 34.26958], [-118.36848, 34.26953], [-118.36828, 34.26945], [-118.36821, 34.26921], [-118.36819, 34.269], [-118.3725, 34.26887], [-118.3728, 34.26881], [-118.37297, 34.26886], [-118.37307, 34.26895], [-118.37311, 34.26911], [-118.3728, 34.27074], [-118.37326, 34.27372]]]} | Restricted Access 2 | 47236 | Hansen Dam Equestrian Center | 30949 | 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://hansendamhorsecenter.com/ | Los Angeles 6 | 52.323 | Hansen Dam Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 |
12275 | 12275 | 12274 | {"type": "Polygon", "coordinates": [[[-118.18582, 34.1138], [-118.18566, 34.11396], [-118.18559, 34.11393], [-118.18558, 34.11395], [-118.18563, 34.11399], [-118.18476, 34.11484], [-118.18453, 34.11494], [-118.18429, 34.11501], [-118.18404, 34.11507], [-118.18378, 34.1151], [-118.18338, 34.11496], [-118.18348, 34.11486], [-118.18355, 34.1147], [-118.18392, 34.11442], [-118.18404, 34.11403], [-118.1844, 34.11402], [-118.18582, 34.1138]]]} | Open Access 1 | 46909 | Highland Park Adult Senior Citizen Center | 30450 | 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 | 3.717 | Highland Park Adult Senior Citizen Ctr. | 0 | Local Recreation Area 3 | 4 | |
12271 | 12271 | 12270 | {"type": "Polygon", "coordinates": [[[-118.2914, 33.95801], [-118.2914, 33.95822], [-118.291, 33.95822], [-118.29101, 33.95801], [-118.2914, 33.95801]]]} | No Public Access 3 | 46878 | Community Build Youth Center Expansion | 30356 | 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 | 0.207 | Community Build Youth Ctr. Expansion | None 1070 | |||
12267 | 12267 | 12266 | {"type": "Polygon", "coordinates": [[[-118.50705, 34.19144], [-118.50564, 34.19144], [-118.5056, 34.19012], [-118.50703, 34.19012], [-118.50705, 34.19144]]]} | Restricted Access 2 | 46875 | Birmingham High School Park | 31941 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.741 | Birmingham High School Park | 0 | Local Park 2 | 4 | |
12253 | 12253 | 12252 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20166, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.2012, 34.07523], [-118.20091, 34.07524], [-118.2009, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20177, 34.07498], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | 46874 | Abraham Lincoln High School Park | 31843 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.467 | Abraham Lincoln High School Park | 0 | Local Park 2 | 4 | |
16932 | 16932 | 16931 | {"type": "Polygon", "coordinates": [[[-118.28341, 33.74301], [-118.28271, 33.74301], [-118.28272, 33.74245], [-118.28339, 33.74246], [-118.28341, 33.74249], [-118.28341, 33.74301]]]} | Open Access 1 | 46872 | Rancho San Pedro Recreation Center | 30349 | 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 | 0.985 | Rancho San Pedro Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
12210 | 12210 | 12209 | {"type": "Polygon", "coordinates": [[[-118.2635, 34.06257], [-118.26306, 34.06324], [-118.26301, 34.06325], [-118.26135, 34.0625], [-118.2617, 34.06184], [-118.2635, 34.06257]]]} | Restricted Access 2 | 46871 | Belmont High School Park | 31940 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.751 | Belmont High School Park | 0 | Local Park 2 | 4 | |
14195 | 14195 | 14194 | {"type": "Polygon", "coordinates": [[[-118.54281, 34.25984], [-118.54023, 34.25984], [-118.5403, 34.2596], [-118.5404, 34.25932], [-118.54124, 34.2574], [-118.54174, 34.25744], [-118.54281, 34.25743], [-118.54281, 34.25984]]]} | Restricted Access 2 | 46859 | Northridge City Little League | 30336 | 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 | 12.794 | Northridge City Little League | None 1208 | |||
12087 | 12087 | 12086 | {"type": "MultiPolygon", "coordinates": [[[[-118.41597, 33.98684], [-118.41682, 33.98637], [-118.4172, 33.9861], [-118.42424, 33.98091], [-118.42423, 33.98089], [-118.42749, 33.97856], [-118.42905, 33.97752], [-118.43012, 33.97684], [-118.43162, 33.97594], [-118.4325, 33.97537], [-118.43253, 33.97541], [-118.43245, 33.97547], [-118.4325, 33.97555], [-118.43243, 33.97558], [-118.4323, 33.9756], [-118.43172, 33.97596], [-118.43135, 33.97616], [-118.43008, 33.97693], [-118.42908, 33.97756], [-118.42733, 33.97874], [-118.42729, 33.97875], [-118.42705, 33.97891], [-118.4252, 33.98023], [-118.42496, 33.98044], [-118.42282, 33.98202], [-118.42282, 33.98203], [-118.42297, 33.98218], [-118.42288, 33.98224], [-118.42275, 33.98209], [-118.42269, 33.98213], [-118.41929, 33.9846], [-118.41722, 33.98613], [-118.41612, 33.98697], [-118.41605, 33.98692], [-118.41584, 33.98705], [-118.41533, 33.98744], [-118.41532, 33.98748], [-118.41257, 33.98955], [-118.4119, 33.98993], [-118.41174, 33.99009], [-118.4118, 33.99018], [-118.41172, 33.9902], [-118.40635, 33.99335], [-118.40617, 33.99349], [-118.40518, 33.99448], [-118.40502, 33.99457], [-118.405, 33.99449], [-118.40512, 33.99441], [-118.40631, 33.99332], [-118.41069, 33.99074], [-118.41186, 33.98988], [-118.41254, 33.98952], [-118.41525, 33.98747], [-118.41575, 33.98698], [-118.41597, 33.98684]]], [[[-118.40476, 33.9948], [-118.40448, 33.99506], [-118.40385, 33.99577], [-118.40371, 33.99594], [-118.403, 33.99677], [-118.40288, 33.99699], [-118.40277, 33.99766], [-118.40238, 33.99838], [-118.40239, 33.99842], [-118.4016, 33.9998], [-118.40152, 33.99976], [-118.40198, 33.99897], [-118.40229, 33.99853], [-118.40229, 33.99852], [-118.40137, 33.99966], [-118.40126, 33.99987], [-118.4012, 33.99986], [-118.40137, 33.99952], [-118.40229, 33.99834], [-118.40271, 33.99759], [-118.40282, 33.99697], [-118.40295, 33.99674], [-118.4036, 33.996], [-118.40378, 33.99575], [-118.40399, 33.99553], [-118.40442, 33.99499], [-118.4045, 33.99491], [-118.40476, 33.9948]]], [[[-118.40076, 34.00143], [-118.40066, 34.00171], [-118.40048, 34.00221], [-118.40042, 34.00218], [-118.40059, 34.00163], [-118.40068, 34.00143], [-118.40076, 34.00143]]], [[[-118.37695, 34.02689], [-118.37693, 34.02697], [-118.37689, 34.02697], [-118.37687, 34.02699], [-118.37674, 34.02699], [-118.37649, 34.02765], [-118.3765, 34.02765], [-118.37664, 34.02745], [-118.3768, 34.02705], [-118.37687, 34.02701], [-118.37669, 34.02745], [-118.37653, 34.0277], [-118.3764, 34.02785], [-118.37638, 34.0279], [-118.37635, 34.02789], [-118.37669, 34.02699], [-118.37625, 34.02698], [-118.37626, 34.02689], [-118.37623, 34.02686], [-118.37627, 34.02684], [-118.37632, 34.02687], [-118.37672, 34.02687], [-118.37681, 34.02654], [-118.37689, 34.02614], [-118.37694, 34.02617], [-118.37688, 34.02654], [-118.37678, 34.02687], [-118.37692, 34.02687], [-118.37692, 34.02688], [-118.37695, 34.02689]]]]} | Open Access 1 | 46847 | Ballona Creek Trail and Bike Path | 30330 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 7.103 | Ballona Creek Trail and Bike Path | 0 | Local Recreation Area 3 | 4 | |
4464 | 4464 | 4463 | {"type": "Polygon", "coordinates": [[[-118.2356, 34.04165], [-118.23514, 34.0417], [-118.23507, 34.04127], [-118.23553, 34.04121], [-118.2356, 34.04165]]]} | Open Access 1 | 46647 | Arts District Park | 32785 | 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 | 0.514 | Arts District Park | 2016 | Local Park 2 | 4 | |
4463 | 4463 | 4462 | {"type": "Polygon", "coordinates": [[[-118.52909, 34.18524], [-118.52906, 34.18542], [-118.529, 34.18552], [-118.52891, 34.18561], [-118.52875, 34.18571], [-118.5286, 34.18575], [-118.52848, 34.18576], [-118.52829, 34.18574], [-118.52821, 34.18572], [-118.52783, 34.18552], [-118.52739, 34.18533], [-118.52739, 34.18524], [-118.52909, 34.18524]]]} | Open Access 1 | 46646 | Caballero Creek Park | 29974 | 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 | 1.528 | Caballero Creek 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]);