units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, YR_EST, GAP_STS
DES_TP 21
- Local Park 101
- Local Recreation Area 25
- Local Historic or Cultural Area 3
- Local Conservation Area 2
- Local Other or Unknown 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
LAYER 4 ✖
- City 144
- County 2
- Special District 1
- Private 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 148
MNG_AGENCY 1
- Long Beach, City of · 148 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4375 | 4375 | 4374 | {"type": "Polygon", "coordinates": [[[-118.1965, 33.7631], [-118.19637, 33.76302], [-118.19634, 33.7629], [-118.19626, 33.76281], [-118.19616, 33.76275], [-118.19604, 33.76273], [-118.19594, 33.76275], [-118.19584, 33.76279], [-118.19578, 33.76284], [-118.19572, 33.76293], [-118.19569, 33.76295], [-118.19537, 33.76299], [-118.19512, 33.76308], [-118.19509, 33.76306], [-118.19499, 33.76286], [-118.19472, 33.76282], [-118.19432, 33.76268], [-118.19406, 33.76252], [-118.19384, 33.76233], [-118.19337, 33.76235], [-118.19334, 33.76226], [-118.19327, 33.76219], [-118.19355, 33.76191], [-118.19345, 33.76185], [-118.19323, 33.76178], [-118.1931, 33.76178], [-118.19313, 33.76213], [-118.19299, 33.76214], [-118.19294, 33.76179], [-118.19276, 33.76184], [-118.19266, 33.76189], [-118.19257, 33.76196], [-118.19243, 33.76212], [-118.19237, 33.7623], [-118.19236, 33.76241], [-118.19278, 33.76257], [-118.19269, 33.76272], [-118.19261, 33.76269], [-118.19259, 33.76272], [-118.19076, 33.76199], [-118.19029, 33.76183], [-118.19027, 33.7617], [-118.19036, 33.76167], [-118.19036, 33.76161], [-118.19164, 33.76205], [-118.19171, 33.76203], [-118.19177, 33.76204], [-118.19182, 33.76207], [-118.19185, 33.76214], [-118.19195, 33.76217], [-118.19204, 33.76218], [-118.19219, 33.76214], [-118.19226, 33.762], [-118.19236, 33.76188], [-118.19248, 33.76177], [-118.19263, 33.76168], [-118.1928, 33.76162], [-118.19296, 33.76159], [-118.19311, 33.76159], [-118.19327, 33.7616], [-118.19351, 33.76167], [-118.19366, 33.76175], [-118.19379, 33.76185], [-118.1939, 33.76186], [-118.194, 33.76191], [-118.19406, 33.76197], [-118.19408, 33.76204], [-118.19408, 33.76211], [-118.19406, 33.7622], [-118.19423, 33.76236], [-118.19443, 33.76248], [-118.19464, 33.76256], [-118.19487, 33.76261], [-118.1951, 33.76263], [-118.19535, 33.76261], [-118.19565, 33.76253], [-118.19591, 33.7624], [-118.19613, 33.76221], [-118.19629, 33.762], [-118.19636, 33.76184], [-118.1964, 33.76167], [-118.19641, 33.7615], [-118.19639, 33.76133], [-118.19633, 33.76115], [-118.19621, 33.76113], [-118.19612, 33.76108], [-118.19606, 33.76101], [-118.19604, 33.76091], [-118.19607, 33.76083], [-118.19614, 33.76076], [-118.19642, 33.76068], [-118.19652, 33.76076], [-118.19658, 33.76086], [-118.19659, 33.76093], [-118.19657, 33.761], [-118.19653, 33.76107], [-118.19646, 33.76112], [-118.19645, 33.76118], [-118.19647, 33.76123], [-118.19654, 33.76131], [-118.19658, 33.76138], [-118.19661, 33.76151], [-118.19659, 33.76166], [-118.19646, 33.76184], [-118.19642, 33.76195], [-118.19657, 33.76268], [-118.19655, 33.76293], [-118.1965, 33.7631]]]} | Open Access 1 | 45920 | Rainbow Harbor Esplanade | 28994 | 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 | http://www.longbeach.gov/park/park-and-facilities/directory/rainbow-harbor-esplanade/ | Los Angeles 6 | 6.934 | Rainbow Harbor Esplanade | None 389 | ||
4458 | 4458 | 4457 | {"type": "Polygon", "coordinates": [[[-118.14947, 33.75539], [-118.14946, 33.75548], [-118.14907, 33.75548], [-118.14906, 33.75553], [-118.14897, 33.75553], [-118.14897, 33.75556], [-118.14888, 33.75557], [-118.14861, 33.75645], [-118.14864, 33.75647], [-118.14864, 33.75653], [-118.1486, 33.75667], [-118.14856, 33.75674], [-118.14852, 33.75674], [-118.14791, 33.75887], [-118.14838, 33.75898], [-118.14834, 33.75914], [-118.14824, 33.75913], [-118.14821, 33.75924], [-118.14797, 33.75913], [-118.14772, 33.75908], [-118.14809, 33.75779], [-118.14842, 33.75671], [-118.1484, 33.7567], [-118.1484, 33.75656], [-118.14847, 33.75645], [-118.14851, 33.75645], [-118.14865, 33.75594], [-118.14863, 33.75593], [-118.1487, 33.75568], [-118.1486, 33.75555], [-118.14853, 33.75562], [-118.14856, 33.75566], [-118.14836, 33.75576], [-118.14831, 33.75569], [-118.14849, 33.75561], [-118.1485, 33.75559], [-118.14846, 33.75556], [-118.14829, 33.75563], [-118.14823, 33.75556], [-118.14841, 33.75547], [-118.14847, 33.75552], [-118.14856, 33.75549], [-118.14859, 33.75548], [-118.14862, 33.75539], [-118.1483, 33.75524], [-118.14835, 33.75515], [-118.14869, 33.75531], [-118.14871, 33.75528], [-118.14891, 33.75528], [-118.14907, 33.75535], [-118.14908, 33.75539], [-118.14947, 33.75539]]]} | Open Access 1 | 46630 | Belmont Veterans Memorial Pier | 29955 | 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 | 2.094 | Belmont Veterans Memorial Pier | None 398 | |||
7328 | 7328 | 7327 | {"type": "Polygon", "coordinates": [[[-118.12344, 33.75467], [-118.1234, 33.75459], [-118.1234, 33.75451], [-118.12344, 33.75443], [-118.12352, 33.75438], [-118.12362, 33.75435], [-118.12371, 33.75437], [-118.1238, 33.75441], [-118.12385, 33.75448], [-118.12387, 33.75455], [-118.12385, 33.75462], [-118.12381, 33.75468], [-118.12374, 33.75473], [-118.12367, 33.75475], [-118.12358, 33.75475], [-118.1235, 33.75472], [-118.12344, 33.75467]]]} | Open Access 1 | 6654 | La Bella Fontana Di Napoli | 20741 | 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.369 | La Bella Fontana Di Napoli | None 605 | |||
7330 | 7330 | 7329 | {"type": "MultiPolygon", "coordinates": [[[[-118.1632, 33.76891], [-118.16311, 33.76896], [-118.16311, 33.76887], [-118.16315, 33.76889], [-118.1632, 33.76891]]], [[[-118.16334, 33.77076], [-118.16323, 33.77082], [-118.16314, 33.7709], [-118.16315, 33.77079], [-118.16313, 33.77068], [-118.16334, 33.77076]]], [[[-118.16428, 33.76891], [-118.16414, 33.769], [-118.16403, 33.76911], [-118.16392, 33.769], [-118.16378, 33.76891], [-118.16392, 33.76882], [-118.16403, 33.76871], [-118.16414, 33.76882], [-118.16428, 33.76891]]], [[[-118.16441, 33.77044], [-118.16441, 33.77044], [-118.16398, 33.77055], [-118.16404, 33.77047], [-118.16408, 33.77039], [-118.1641, 33.7703], [-118.1641, 33.7702], [-118.16423, 33.77032], [-118.16441, 33.77044]]]]} | Open Access 1 | 6643 | Carroll Parks | 16919 | 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.426 | Carroll Parks | None 606 | |||
7351 | 7351 | 7350 | {"type": "MultiPolygon", "coordinates": [[[[-118.20441, 33.8045], [-118.20433, 33.8046], [-118.20414, 33.8046], [-118.20413, 33.80458], [-118.20401, 33.80458], [-118.204, 33.8046], [-118.20355, 33.8046], [-118.20349, 33.80463], [-118.20345, 33.80467], [-118.20344, 33.80477], [-118.2025, 33.80477], [-118.20246, 33.80475], [-118.20246, 33.8046], [-118.20249, 33.8046], [-118.20249, 33.80452], [-118.20251, 33.8045], [-118.20441, 33.8045]]], [[[-118.20458, 33.81893], [-118.20429, 33.81892], [-118.20427, 33.81165], [-118.20428, 33.81154], [-118.20428, 33.80838], [-118.20426, 33.80766], [-118.20426, 33.80502], [-118.20428, 33.80502], [-118.20431, 33.80542], [-118.20447, 33.80664], [-118.20455, 33.80772], [-118.20454, 33.81285], [-118.20458, 33.81507], [-118.20457, 33.81568], [-118.20458, 33.81609], [-118.20454, 33.81631], [-118.20458, 33.81654], [-118.20453, 33.81736], [-118.20458, 33.81893]]]]} | Open Access 1 | 6673 | Willow & Golden N | 29903 | 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 | 9.937 | Willow & Golden N | None 608 | |||
10797 | 10797 | 10796 | {"type": "Polygon", "coordinates": [[[-118.1182, 33.75324], [-118.11816, 33.75325], [-118.11796, 33.75306], [-118.11778, 33.75291], [-118.11766, 33.75284], [-118.11739, 33.75275], [-118.11803, 33.75272], [-118.11813, 33.75268], [-118.11813, 33.75273], [-118.11819, 33.75279], [-118.1182, 33.75293], [-118.1182, 33.75324]]]} | Open Access 1 | 20229 | Overlook Park (Naples Plaza) | 23275 | 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.466 | Overlook Park (Naples Plaza) | None 943 | |||
15090 | 15090 | 15089 | {"type": "Polygon", "coordinates": [[[-118.1524, 33.78869], [-118.15241, 33.78971], [-118.1524, 33.78972], [-118.15195, 33.78972], [-118.15193, 33.78965], [-118.15193, 33.78958], [-118.15201, 33.78931], [-118.15211, 33.78912], [-118.15227, 33.7889], [-118.1524, 33.78869]]]} | Open Access 1 | 45872 | Plaza Zaferia | 28943 | 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.788 | Plaza Zaferia | None 1310 | |||
15098 | 15098 | 15097 | {"type": "Polygon", "coordinates": [[[-118.1915, 33.75965], [-118.19129, 33.75965], [-118.19107, 33.75873], [-118.19099, 33.75844], [-118.19075, 33.75812], [-118.18989, 33.75769], [-118.18933, 33.75744], [-118.18928, 33.75747], [-118.18899, 33.75735], [-118.18895, 33.75728], [-118.18806, 33.75691], [-118.18783, 33.75686], [-118.18752, 33.7568], [-118.18691, 33.75676], [-118.18649, 33.75684], [-118.18604, 33.75696], [-118.18557, 33.75715], [-118.18512, 33.75736], [-118.18436, 33.75765], [-118.18401, 33.75776], [-118.18401, 33.75778], [-118.18416, 33.75802], [-118.18368, 33.75822], [-118.1834, 33.75784], [-118.18597, 33.75681], [-118.18695, 33.75659], [-118.18787, 33.75663], [-118.18835, 33.75679], [-118.18882, 33.75698], [-118.18948, 33.7573], [-118.19059, 33.75777], [-118.19073, 33.75785], [-118.19087, 33.75794], [-118.19107, 33.75815], [-118.1912, 33.7584], [-118.19125, 33.75857], [-118.19126, 33.75874], [-118.1915, 33.75965]]]} | Open Access 1 | 45884 | Downtown Marina Mole | 28961 | 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 | 5.133 | Downtown Marina Mole | None 1311 | |||
15100 | 15100 | 15099 | {"type": "Polygon", "coordinates": [[[-118.19153, 33.77061], [-118.19153, 33.77074], [-118.19112, 33.77074], [-118.19111, 33.77071], [-118.19104, 33.77071], [-118.19104, 33.77074], [-118.19091, 33.77074], [-118.19091, 33.77061], [-118.19153, 33.77061]]]} | Open Access 1 | 45892 | Harvey Milk Promenade | 28969 | 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.204 | Harvey Milk Promenade | None 1312 | |||
15104 | 15104 | 15103 | {"type": "Polygon", "coordinates": [[[-118.11965, 33.7608], [-118.11701, 33.75838], [-118.11694, 33.75835], [-118.1168, 33.75835], [-118.11668, 33.7584], [-118.1165, 33.75853], [-118.1164, 33.75854], [-118.11633, 33.75852], [-118.11608, 33.75832], [-118.11531, 33.75762], [-118.11531, 33.7576], [-118.11527, 33.75757], [-118.11514, 33.75749], [-118.11501, 33.75745], [-118.11529, 33.7574], [-118.11572, 33.75726], [-118.11599, 33.75708], [-118.11976, 33.76053], [-118.1198, 33.76062], [-118.11979, 33.76069], [-118.11975, 33.76074], [-118.11965, 33.7608]]]} | Open Access 1 | 45900 | Davies Launch Ramp | 28975 | 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 | 6.061 | Davies Launch Ramp | None 1313 | |||
15106 | 15106 | 15105 | {"type": "Polygon", "coordinates": [[[-118.19716, 33.76369], [-118.19705, 33.76402], [-118.19697, 33.76419], [-118.19684, 33.7644], [-118.19667, 33.76459], [-118.19658, 33.76458], [-118.19607, 33.76429], [-118.19559, 33.76406], [-118.19599, 33.76352], [-118.19603, 33.76342], [-118.19603, 33.76328], [-118.19614, 33.76327], [-118.19626, 33.76322], [-118.19631, 33.76322], [-118.19716, 33.76369]]]} | Restricted Access 2 | 45903 | Long Beach Aquarium of the Pacific | 28978 | 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 | 3.167 | Long Beach Aquarium of the Pacific | None 1314 | |||
15108 | 15108 | 15107 | {"type": "Polygon", "coordinates": [[[-118.12176, 33.759], [-118.1204, 33.75905], [-118.12026, 33.75893], [-118.12025, 33.75889], [-118.12011, 33.75885], [-118.11987, 33.75871], [-118.11979, 33.75864], [-118.11957, 33.75836], [-118.11919, 33.75805], [-118.11881, 33.75768], [-118.11836, 33.75736], [-118.11801, 33.75714], [-118.11791, 33.75712], [-118.11782, 33.75706], [-118.11758, 33.7568], [-118.11728, 33.75668], [-118.11767, 33.75657], [-118.11775, 33.75657], [-118.1179, 33.75667], [-118.11806, 33.75674], [-118.11829, 33.75677], [-118.11919, 33.75681], [-118.11948, 33.75691], [-118.12176, 33.759]]]} | Open Access 1 | 45910 | Marine Park (Mother's Beach) | 28985 | 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 | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Marine-Park-(Mothers-Beach)/ | Los Angeles 6 | 9.237 | Marine Park (Mother's Beach) | None 1315 | ||
15120 | 15120 | 15119 | {"type": "Polygon", "coordinates": [[[-118.12003, 33.76752], [-118.11884, 33.76735], [-118.11846, 33.76798], [-118.11831, 33.76815], [-118.11855, 33.76849], [-118.11861, 33.7688], [-118.11844, 33.76887], [-118.11778, 33.76904], [-118.11738, 33.76793], [-118.11731, 33.7679], [-118.11735, 33.76788], [-118.11718, 33.76743], [-118.11721, 33.76737], [-118.118, 33.76719], [-118.11837, 33.76714], [-118.11971, 33.76701], [-118.12003, 33.76752]]]} | Open Access 1 | 45928 | Sims Pond | 29004 | 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 | 6.036 | Sims Pond | None 1316 | |||
15122 | 15122 | 15121 | {"type": "Polygon", "coordinates": [[[-118.1242, 33.75299], [-118.12413, 33.75324], [-118.12382, 33.75319], [-118.12388, 33.75293], [-118.1242, 33.75299]]]} | Open Access 1 | 45934 | The Colonnade | 29009 | 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 | http://www.longbeach.gov/park/park-and-facilities/directory/the-colonnade/ | Los Angeles 6 | 0.211 | The Colonnade | None 1317 | ||
15383 | 15383 | 15382 | {"type": "Polygon", "coordinates": [[[-118.2044, 33.80427], [-118.20253, 33.80427], [-118.2025, 33.80426], [-118.20249, 33.80421], [-118.20246, 33.80421], [-118.20246, 33.80405], [-118.20248, 33.80403], [-118.20428, 33.80403], [-118.20428, 33.80418], [-118.2044, 33.80427]]]} | Open Access 1 | 46599 | Willow & Golden S | 29904 | 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 | 1.117 | Willow & Golden S | None 1358 | |||
963 | 963 | 962 | {"type": "Polygon", "coordinates": [[[-118.13204, 33.83966], [-118.13203, 33.84296], [-118.1306, 33.84295], [-118.13062, 33.83966], [-118.13204, 33.83966]]]} | Open Access 1 | 6576 | Pan American Park | 23383 | 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 | 11.97 | Pan American Park | 0 | Local Park 2 | 4 | |
965 | 965 | 964 | {"type": "Polygon", "coordinates": [[[-118.17515, 33.78271], [-118.17514, 33.78433], [-118.17425, 33.78433], [-118.17426, 33.78271], [-118.17515, 33.78271]]]} | Open Access 1 | 6588 | Douglas MacArthur Park | 18245 | 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 | 3.648 | Douglas MacArthur Park | 0 | Local Park 2 | 4 | |
967 | 967 | 966 | {"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]} | Open Access 1 | 6603 | Houghton Park | 20109 | 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 | 26.14 | Houghton Park | 0 | Local Park 2 | 4 | |
968 | 968 | 967 | {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} | Restricted Access 2 | 6607 | Heartwell Golf Course | 33019 | 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 | 36.514 | Heartwell GC | 0 | Local Recreation Area 3 | 4 | |
969 | 969 | 968 | {"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19542, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19734, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19821, 33.7671], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76709], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]} | Open Access 1 | 6608 | Santa Cruz Park | 25082 | 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 | 2.096 | Santa Cruz 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]);