units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
314 rows where DES_TP = 2 and MNG_AGENCY = 24 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 3
- Open Access 291
- No Public Access 16
- Restricted Access 7
MNG_AG_TYP 1
- City Agency 314
MNG_AGENCY 1
- Los Angeles, City of · 314 ✖
DES_TP 1
- Local Park · 314 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17068 | 17068 | 17067 | {"type": "Polygon", "coordinates": [[[-118.41271, 34.21563], [-118.41251, 34.21562], [-118.41224, 34.21561], [-118.41271, 34.21543], [-118.41278, 34.21558], [-118.41276, 34.21562], [-118.41271, 34.21563]]]} | Open Access 1 | 45531 | Bellaire Avenue Pocket Park | 28362 | 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://cd2.lacity.org/DISTRICT2/CD2Resources/index.htm | Los Angeles 6 | 0.138 | Bellaire Avenue PP | 0 | Local Park 2 | 4 |
17020 | 17020 | 17019 | {"type": "Polygon", "coordinates": [[[-118.35353, 34.02459], [-118.34938, 34.02421], [-118.34938, 34.02163], [-118.35353, 34.02166], [-118.35353, 34.02459]]]} | Open Access 1 | 9393 | Rancho Cienega Sports Center Park | 24134 | 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 | 28.966 | Rancho Cienega Sports Ctr. Park | 0 | Local Park 2 | 4 | |
16579 | 16579 | 16578 | {"type": "Polygon", "coordinates": [[[-118.26602, 33.98243], [-118.26601, 33.98246], [-118.26532, 33.98245], [-118.26532, 33.98214], [-118.26542, 33.98217], [-118.26602, 33.98243]]]} | Open Access 1 | 45801 | Gage and Avalon Triangle Pocket Park | 28821 | 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.303 | Gage and Avalon Triangle PP | 0 | Local Park 2 | 4 | |
16578 | 16578 | 16577 | {"type": "Polygon", "coordinates": [[[-118.31016, 34.09328], [-118.30999, 34.09328], [-118.30999, 34.09286], [-118.31015, 34.09286], [-118.31016, 34.09328]]]} | Open Access 1 | 45756 | Lexington Avenue Pocket Park | 29817 | 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/dos/parks/facility/seilyRodriguezPk.htm | Los Angeles 6 | 0.172 | Lexington Avenue PP | 0 | Local Park 2 | 4 |
16577 | 16577 | 16576 | {"type": "Polygon", "coordinates": [[[-118.26074, 33.99884], [-118.26054, 33.99884], [-118.26054, 33.99864], [-118.26074, 33.99864], [-118.26074, 33.99884]]]} | Open Access 1 | 45740 | McKinley Avenue Pocket Park | 28744 | 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.105 | McKinley Avenue PP | 0 | Local Park 2 | 4 | |
16325 | 16325 | 16324 | {"type": "MultiPolygon", "coordinates": [[[[-118.19062, 34.08663], [-118.19061, 34.08715], [-118.18947, 34.08713], [-118.18947, 34.08664], [-118.19062, 34.08663]]], [[[-118.18826, 34.09929], [-118.18796, 34.09997], [-118.18782, 34.10017], [-118.18741, 34.10006], [-118.18762, 34.09954], [-118.18715, 34.0994], [-118.18732, 34.09902], [-118.18826, 34.09929]]], [[[-118.18938, 34.09975], [-118.18906, 34.10053], [-118.1886, 34.1004], [-118.18891, 34.09962], [-118.18938, 34.09975]]], [[[-118.19218, 34.1035], [-118.19218, 34.10387], [-118.19164, 34.10386], [-118.19197, 34.10362], [-118.19218, 34.1035]]], [[[-118.20217, 34.09975], [-118.20053, 34.10126], [-118.20031, 34.10144], [-118.20007, 34.1016], [-118.19986, 34.10172], [-118.19954, 34.10187], [-118.19814, 34.10243], [-118.1976, 34.10262], [-118.19733, 34.10268], [-118.19713, 34.10271], [-118.19626, 34.10272], [-118.1962, 34.10266], [-118.19617, 34.10261], [-118.19614, 34.1025], [-118.19754, 34.10236], [-118.1979, 34.10216], [-118.1978, 34.10138], [-118.19684, 34.10111], [-118.19593, 34.10131], [-118.1956, 34.10221], [-118.19592, 34.10252], [-118.19583, 34.10253], [-118.19582, 34.10254], [-118.19599, 34.1027], [-118.19552, 34.10272], [-118.19509, 34.10276], [-118.19456, 34.10273], [-118.19455, 34.10266], [-118.19407, 34.10271], [-118.19371, 34.10271], [-118.19339, 34.10274], [-118.19301, 34.10281], [-118.19267, 34.10291], [-118.19228, 34.10296], [-118.19228, 34.10289], [-118.19219, 34.10289], [-118.19218, 34.10311], [-118.19174, 34.10328], [-118.19126, 34.10358], [-118.19125, 34.10304], [-118.19106, 34.10303], [-118.19106, 34.10371], [-118.19083, 34.10385], [-118.18851, 34.10381], [-118.18803, 34.10389], [-118.18796, 34.10358], [-118.18801, 34.1035], [-118.18847, 34.10342], [-118.18933, 34.10343], [-118.18939, 34.10332], [-118.19094, 34.10125], [-118.19103, 34.10111], [-118.18962, 34.10069], [-118.18978, 34.10031], [-118.18994, 34.10034], [-118.1907, 34.09852], [-118.19069, 34.09851], [-118.18963, 34.09851], [-118.18997, 34.09807], [-118.19006, 34.0979], [-118.19013, 34.09769], [-118.19045, 34.09488], [-118.1909, 34.09487], [-118.19068, 34.09332], [-118.1905, 34.09292], [-118.19117, 34.09288], [-118.19114, 34.09112], [-118.1906, 34.09113], [-118.19123, 34.08961], [-118.19052, 34.0894], [-118.19073, 34.08888], [-118.19027, 34.08875], [-118.19071, 34.08768], [-118.19043, 34.08767], [-118.19042, 34.08758], [-118.19019, 34.08758], [-118.19018, 34.08721], [-118.19061, 34.08722], [-118.19078, 34.08715], [-118.19276, 34.08715], [-118.19277, 34.08756], [-118.19285, 34.08766], [-118.19286, 34.08824], [-118.19292, 34.08822], [-118.19292, 34.08765], [-118.19295, 34.08753], [-118.19549, 34.08695], [-118.19557, 34.08705], [-118.19593, 34.08718], [-118.19594, 34.08752], [-118.19617, 34.08753], [-118.19618, 34.08776], [-118.1967, 34.08776], [-118.19671, 34.08853], [-118.19618, 34.08854], [-118.19618, 34.08929], [-118.19609, 34.08929], [-118.19609, 34.0901], [-118.19619, 34.09011], [-118.19619, 34.09022], [-118.19609, 34.09023], [-118.19611, 34.09186], [-118.19619, 34.09187], [-118.19619, 34.0919], [-118.19611, 34.09198], [-118.19604, 34.09199], [-118.19605, 34.09307], [-118.19668, 34.09307], [-118.19669, 34.09442], [-118.19676, 34.09444], [-118.19771, 34.09444], [-118.1978, 34.09456], [-118.19783, 34.09449], [-118.19788, 34.09443], [-118.19819, 34.09423], [-118.19859, 34.09533], [-118.19895, 34.09534], [-118.19897, 34.09668], [-118.20031, 34.097], [-118.20096, 34.09708], [-118.20153, 34.09735], [-118.20198, 34.09596], [-118.20214, 34.09652], [-118.20228, 34.09711], [-118.20227, 34.09738], [-118.20206, 34.09844], [-118.20187, 34.0995], [-118.20217, 34.09975]]]]} | Open Access 1 | 6931 | Ernest E Debs Regional Park | 5632 | 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/dos/parks/facility/ernestEDebsPk.htm | Los Angeles 6 | 318.764 | Ernest E Debs RP | 0 | Local Park 2 | 4 |
16322 | 16322 | 16321 | {"type": "Polygon", "coordinates": [[[-118.29733, 33.78306], [-118.29732, 33.78487], [-118.29727, 33.78524], [-118.29716, 33.78559], [-118.29699, 33.78592], [-118.29674, 33.78626], [-118.29676, 33.78629], [-118.2965, 33.78655], [-118.29529, 33.78763], [-118.29317, 33.78763], [-118.29316, 33.78768], [-118.29309, 33.78772], [-118.29309, 33.78773], [-118.29516, 33.78774], [-118.29168, 33.79085], [-118.28715, 33.79084], [-118.28628, 33.79083], [-118.28575, 33.79081], [-118.28576, 33.78947], [-118.28549, 33.78866], [-118.28439, 33.78878], [-118.28366, 33.78888], [-118.28323, 33.78926], [-118.28253, 33.78972], [-118.2825, 33.78964], [-118.28234, 33.78939], [-118.2821, 33.78868], [-118.28171, 33.78616], [-118.28172, 33.78611], [-118.28176, 33.78609], [-118.28339, 33.78609], [-118.2834, 33.78601], [-118.28676, 33.78603], [-118.28677, 33.78505], [-118.29271, 33.78506], [-118.29272, 33.78505], [-118.29217, 33.78417], [-118.2912, 33.78406], [-118.29131, 33.78353], [-118.2915, 33.78321], [-118.29136, 33.78297], [-118.29116, 33.78302], [-118.29098, 33.78328], [-118.29084, 33.78383], [-118.29024, 33.78361], [-118.28999, 33.78336], [-118.28927, 33.78292], [-118.28864, 33.78309], [-118.28832, 33.78305], [-118.28855, 33.78286], [-118.28931, 33.78244], [-118.28976, 33.78271], [-118.29018, 33.78243], [-118.29014, 33.78217], [-118.28988, 33.78185], [-118.2897, 33.78218], [-118.28817, 33.78218], [-118.28784, 33.78203], [-118.28724, 33.78212], [-118.28617, 33.78195], [-118.28615, 33.78217], [-118.28537, 33.78217], [-118.28546, 33.78189], [-118.28505, 33.78123], [-118.28447, 33.78109], [-118.2838, 33.78065], [-118.28334, 33.78074], [-118.28283, 33.78127], [-118.28258, 33.78101], [-118.2817, 33.78107], [-118.28111, 33.78164], [-118.2811, 33.78066], [-118.28106, 33.78018], [-118.28199, 33.78024], [-118.28245, 33.77936], [-118.28247, 33.77897], [-118.28478, 33.77884], [-118.28487, 33.77923], [-118.28502, 33.77935], [-118.2855, 33.77943], [-118.28565, 33.77961], [-118.28889, 33.77944], [-118.28936, 33.77947], [-118.28974, 33.77954], [-118.28996, 33.77874], [-118.29181, 33.77908], [-118.29212, 33.77916], [-118.29237, 33.77926], [-118.29611, 33.78139], [-118.29615, 33.78147], [-118.29581, 33.78147], [-118.29581, 33.78219], [-118.29659, 33.7822], [-118.29687, 33.78256], [-118.29733, 33.78306]]]} | Open Access 1 | 5976 | Ken Malloy Harbor Regional Park | 5694 | 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/dos/parks/facility/kenMalloyHarborPk.htm | Los Angeles 6 | 291.733 | Ken Malloy Harbor RP | 0 | Local Park 2 | 4 |
15414 | 15414 | 15413 | {"type": "Polygon", "coordinates": [[[-118.36138, 34.08051], [-118.36127, 34.08051], [-118.36128, 34.08027], [-118.36137, 34.08028], [-118.36138, 34.08051]]]} | Open Access 1 | 46642 | Rosewood Gardens Park | 29970 | 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.06 | Rosewood Gardens Park | 0 | Local Park 2 | 4 | |
15413 | 15413 | 15412 | {"type": "MultiPolygon", "coordinates": [[[[-118.40506, 34.14332], [-118.40506, 34.1435], [-118.4013, 34.14384], [-118.40099, 34.14392], [-118.4008, 34.14398], [-118.39995, 34.14449], [-118.39972, 34.14459], [-118.39948, 34.14464], [-118.39927, 34.14465], [-118.399, 34.14463], [-118.39821, 34.14454], [-118.39772, 34.14455], [-118.39754, 34.14458], [-118.39716, 34.14472], [-118.39686, 34.14493], [-118.39669, 34.14509], [-118.39648, 34.14534], [-118.39623, 34.14571], [-118.39615, 34.14548], [-118.39637, 34.14518], [-118.39651, 34.14502], [-118.3967, 34.14485], [-118.39702, 34.14462], [-118.39726, 34.14451], [-118.39772, 34.1444], [-118.39838, 34.14443], [-118.39917, 34.1445], [-118.39937, 34.14449], [-118.39954, 34.14446], [-118.39972, 34.1444], [-118.39992, 34.14429], [-118.40036, 34.14401], [-118.40062, 34.14387], [-118.40093, 34.14376], [-118.40114, 34.14372], [-118.40367, 34.14348], [-118.4049, 34.14335], [-118.40506, 34.14332]]], [[[-118.46594, 34.16153], [-118.46563, 34.16144], [-118.46507, 34.16133], [-118.46418, 34.1613], [-118.46376, 34.16125], [-118.46343, 34.16118], [-118.46321, 34.16111], [-118.46287, 34.16097], [-118.46255, 34.1608], [-118.46209, 34.16063], [-118.46189, 34.1606], [-118.46159, 34.1606], [-118.46081, 34.16067], [-118.46018, 34.16075], [-118.45996, 34.16076], [-118.45978, 34.16075], [-118.45951, 34.16071], [-118.45926, 34.16064], [-118.45903, 34.16052], [-118.45873, 34.16024], [-118.4585, 34.15989], [-118.45825, 34.15965], [-118.45804, 34.15946], [-118.45774, 34.15925], [-118.45757, 34.15916], [-118.45757, 34.1591], [-118.45762, 34.15907], [-118.45765, 34.15907], [-118.45787, 34.15919], [-118.45806, 34.15931], [-118.45831, 34.15952], [-118.45843, 34.15965], [-118.45885, 34.16023], [-118.459, 34.16038], [-118.45916, 34.16049], [-118.45961, 34.16067], [-118.45978, 34.16067], [-118.46049, 34.16062], [-118.46084, 34.16055], [-118.46106, 34.16053], [-118.46164, 34.1605], [-118.46189, 34.1605], [-118.46208, 34.16052], [-118.46227, 34.16056], [-118.46253, 34.16068], [-118.46301, 34.16095], [-118.46314, 34.161], [-118.46388, 34.16117], [-118.4646, 34.16124], [-118.46525, 34.16124], [-118.46571, 34.1613], [-118.46594, 34.16135], [-118.46594, 34.16153]]]]} | Open Access 1 | 46641 | Los Angeles Riverfront Park | 29969 | 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 | 6.166 | Los Angeles Riverfront Park | 0 | Local Park 2 | 4 | |
15411 | 15411 | 15410 | {"type": "Polygon", "coordinates": [[[-118.16223, 34.07928], [-118.16218, 34.07944], [-118.16207, 34.07962], [-118.16192, 34.07976], [-118.16169, 34.07994], [-118.16143, 34.07969], [-118.16147, 34.07957], [-118.16139, 34.07914], [-118.16146, 34.07911], [-118.16147, 34.07896], [-118.16169, 34.0791], [-118.16195, 34.07919], [-118.16219, 34.07922], [-118.16223, 34.07928]]]} | Open Access 1 | 46639 | El Sereno Arroyo Park | 29966 | 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.211 | El Sereno Arroyo Park | 0 | Local Park 2 | 4 | |
15393 | 15393 | 15392 | {"type": "Polygon", "coordinates": [[[-118.26837, 34.11576], [-118.26813, 34.11585], [-118.2677, 34.11526], [-118.26719, 34.11465], [-118.26658, 34.11399], [-118.26597, 34.11338], [-118.26604, 34.11332], [-118.26617, 34.11327], [-118.2663, 34.11326], [-118.26647, 34.1133], [-118.26667, 34.11343], [-118.26716, 34.11388], [-118.26734, 34.11406], [-118.26762, 34.11441], [-118.26797, 34.11499], [-118.26837, 34.11576]]]} | Open Access 1 | 46643 | Sunnynook Park | 29971 | 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.519 | Sunnynook Park | 0 | Local Park 2 | 4 | |
15088 | 15088 | 15087 | {"type": "MultiPolygon", "coordinates": [[[[-118.38194, 34.16461], [-118.38166, 34.16468], [-118.38168, 34.1648], [-118.37909, 34.1648], [-118.37909, 34.16221], [-118.37913, 34.1622], [-118.37913, 34.16182], [-118.37913, 34.16129], [-118.37908, 34.16128], [-118.37908, 34.15962], [-118.3791, 34.15961], [-118.37916, 34.15894], [-118.37922, 34.1589], [-118.37945, 34.15918], [-118.3796, 34.15913], [-118.37965, 34.15929], [-118.37981, 34.15962], [-118.38037, 34.16069], [-118.38135, 34.16306], [-118.38194, 34.16461]]], [[[-118.38348, 34.16829], [-118.38339, 34.16829], [-118.38338, 34.1683], [-118.38282, 34.1683], [-118.38265, 34.16822], [-118.38217, 34.16815], [-118.38163, 34.168], [-118.38136, 34.16795], [-118.37909, 34.16795], [-118.37909, 34.16756], [-118.37911, 34.16755], [-118.37911, 34.16751], [-118.37909, 34.1675], [-118.37909, 34.16709], [-118.37911, 34.16708], [-118.37911, 34.16691], [-118.37909, 34.1669], [-118.37909, 34.16499], [-118.38187, 34.16499], [-118.3819, 34.16508], [-118.38202, 34.16523], [-118.38207, 34.16536], [-118.38221, 34.16533], [-118.38221, 34.16539], [-118.38235, 34.16578], [-118.38249, 34.16611], [-118.38348, 34.16829]]]]} | Open Access 1 | 45870 | North Hollywood Park | 22824 | 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 | 53.01 | North Hollywood Park | 0 | Local Park 2 | 4 | |
15072 | 15072 | 15071 | {"type": "Polygon", "coordinates": [[[-118.25693, 34.0028], [-118.25661, 34.0028], [-118.25661, 34.00258], [-118.2567, 34.00258], [-118.25674, 34.00268], [-118.25687, 34.00265], [-118.25693, 34.0028]]]} | Open Access 1 | 45837 | Vernon Library Pocket Park | 28857 | 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://eng.lacity.org/docs/dpw/bids/E170940F.pdf | Los Angeles 6 | 0.126 | Vernon Library PP | 0 | Local Park 2 | 4 |
15069 | 15069 | 15068 | {"type": "Polygon", "coordinates": [[[-118.26494, 34.06366], [-118.26472, 34.06401], [-118.26443, 34.06388], [-118.26465, 34.06353], [-118.26494, 34.06366]]]} | Open Access 1 | 45834 | Unidad Park | 28853 | 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.324 | Unidad Park | 2007 | Local Park 2 | 4 | |
15066 | 15066 | 15065 | {"type": "Polygon", "coordinates": [[[-118.4739, 34.30474], [-118.47369, 34.30492], [-118.47285, 34.30427], [-118.47284, 34.30423], [-118.4733, 34.30381], [-118.4739, 34.30474]]]} | Open Access 1 | 45831 | Telfair Park | 28850 | 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/dos/parks/facility/telfairPk.htm | Los Angeles 6 | 1.29 | Telfair 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 |
15064 | 15064 | 15063 | {"type": "Polygon", "coordinates": [[[-118.28888, 34.00161], [-118.28837, 34.00161], [-118.28837, 34.0015], [-118.28888, 34.0015], [-118.28888, 34.00161]]]} | Open Access 1 | 45822 | Orchard Avenue Pocket Park | 28841 | 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/dos/outdoorFitness.htm | Los Angeles 6 | 0.141 | Orchard Avenue PP | 0 | Local Park 2 | 4 |
15063 | 15063 | 15062 | {"type": "Polygon", "coordinates": [[[-118.59735, 34.1673], [-118.59689, 34.16721], [-118.59699, 34.16688], [-118.59728, 34.16693], [-118.59732, 34.16696], [-118.59735, 34.1671], [-118.59735, 34.1673]]]} | Open Access 1 | 45820 | Old Fire Station 84 Pocket Park | 28839 | 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/environmental/oldFire.htm | Los Angeles 6 | 0.359 | Old Fire Station 84 PP | 0 | Local Park 2 | 4 |
15057 | 15057 | 15056 | {"type": "Polygon", "coordinates": [[[-118.46455, 33.9882], [-118.46422, 33.98835], [-118.4632, 33.98875], [-118.4627, 33.98899], [-118.46269, 33.98897], [-118.46317, 33.98869], [-118.4634, 33.98852], [-118.46348, 33.98845], [-118.46434, 33.98792], [-118.46449, 33.98815], [-118.46455, 33.9882]]]} | Open Access 1 | 45835 | Venice of America Centennial Park | 28854 | 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.885 | Venice of America Centennial Park | 0 | Local Park 2 | 4 | |
15050 | 15050 | 15049 | {"type": "Polygon", "coordinates": [[[-118.31903, 34.101], [-118.31887, 34.101], [-118.31887, 34.10054], [-118.31903, 34.10054], [-118.31903, 34.101]]]} | Open Access 1 | 45719 | Carlton Way Pocket Park | 28612 | 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.tpl.org/our-work/parks-for-people/carlton-way-pocket-park | Los Angeles 6 | 0.191 | Carlton Way PP | 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]);