units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
135 rows where ACCESS_TYP = 1 and MNG_AGENCY = 294 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
DES_TP 20
- Local Park 98
- Local Recreation Area 17
- Local Conservation Area 2
- Local Historic or Cultural 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
MNG_AGENCY 1
- Long Beach, City of · 135 ✖
ACCESS_TYP 1
- Open Access · 135 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11432 | 11432 | 11431 | {"type": "Polygon", "coordinates": [[[-118.19075, 33.79976], [-118.19062, 33.79976], [-118.19062, 33.79951], [-118.19075, 33.79951], [-118.19075, 33.79976]]]} | Open Access 1 | 48115 | Locust Tot Lot | 32630 | 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/locust-tot-lot/ | Los Angeles 6 | 0.085 | Locust Tot Lot | 2016 | Local Recreation Area 3 | 4 |
11444 | 11444 | 11443 | {"type": "Polygon", "coordinates": [[[-118.20162, 33.84535], [-118.20155, 33.84639], [-118.20035, 33.8464], [-118.20034, 33.84535], [-118.20162, 33.84535]]]} | Open Access 1 | 48111 | C. David Molina Park | 32623 | 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.293 | C. David Molina Park | 0 | Local Park 2 | 4 | |
15117 | 15117 | 15116 | {"type": "Polygon", "coordinates": [[[-118.18086, 33.77419], [-118.18085, 33.77523], [-118.18052, 33.77524], [-118.18052, 33.77509], [-118.18039, 33.77509], [-118.18051, 33.77465], [-118.18065, 33.77429], [-118.18076, 33.7742], [-118.18086, 33.77419]]]} | Open Access 1 | 45924 | Gumbiner Park | 32574 | 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/gumbiner-park/ | Los Angeles 6 | 0.856 | Gumbiner Park | 0 | Local Park 2 | 4 |
7857 | 7857 | 7856 | {"type": "Polygon", "coordinates": [[[-118.18058, 33.78624], [-118.18058, 33.78705], [-118.17942, 33.78705], [-118.17942, 33.78668], [-118.17991, 33.78668], [-118.17992, 33.78631], [-118.18015, 33.7863], [-118.18015, 33.7856], [-118.18058, 33.7856], [-118.18058, 33.78624]]]} | Open Access 1 | 47194 | Ernest McBride Park & California Recreation Community Center | 30888 | 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/mcbride-park/ | Los Angeles 6 | 2.482 | Ernest McBride Park & California Rec. Community Ctr. | 0 | Local Recreation Area 3 | 4 |
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 | |||
4457 | 4457 | 4456 | {"type": "Polygon", "coordinates": [[[-118.14809, 33.75779], [-118.14772, 33.75908], [-118.14638, 33.7588], [-118.14642, 33.75866], [-118.14626, 33.75863], [-118.14649, 33.75785], [-118.14496, 33.75754], [-118.14525, 33.75697], [-118.14662, 33.75743], [-118.14809, 33.75779]]]} | Open Access 1 | 46629 | Belmont Plaza Beach | 29954 | 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 | 7.27 | Belmont Plaza Beach | 0 | Local Park 2 | 4 | |
16833 | 16833 | 16832 | {"type": "MultiPolygon", "coordinates": [[[[-118.14059, 33.7819], [-118.14053, 33.78192], [-118.14047, 33.78203], [-118.14049, 33.78209], [-118.14042, 33.78227], [-118.1404, 33.78245], [-118.14037, 33.78248], [-118.13988, 33.78248], [-118.13987, 33.78246], [-118.13939, 33.78246], [-118.13938, 33.78248], [-118.13626, 33.78248], [-118.13625, 33.78246], [-118.13577, 33.78246], [-118.13576, 33.78248], [-118.13294, 33.78247], [-118.1328, 33.78246], [-118.13267, 33.78243], [-118.13254, 33.78238], [-118.13243, 33.78231], [-118.13189, 33.78191], [-118.13519, 33.78214], [-118.1352, 33.78245], [-118.14025, 33.78244], [-118.14026, 33.782], [-118.13984, 33.78183], [-118.13951, 33.78164], [-118.13928, 33.78148], [-118.13906, 33.78131], [-118.13873, 33.78094], [-118.1386, 33.78072], [-118.13825, 33.78024], [-118.13781, 33.77978], [-118.13769, 33.77961], [-118.13743, 33.77907], [-118.13746, 33.77879], [-118.13734, 33.77832], [-118.13729, 33.77819], [-118.13711, 33.77794], [-118.13696, 33.77795], [-118.13431, 33.77757], [-118.13252, 33.77718], [-118.13155, 33.77619], [-118.13159, 33.77543], [-118.13731, 33.77544], [-118.13821, 33.77621], [-118.13845, 33.77645], [-118.13863, 33.77666], [-118.13885, 33.77696], [-118.13903, 33.77727], [-118.13918, 33.77756], [-118.13936, 33.77802], [-118.13936, 33.77818], [-118.1393, 33.77832], [-118.13917, 33.77846], [-118.13906, 33.77851], [-118.13898, 33.77851], [-118.13891, 33.77847], [-118.13825, 33.77847], [-118.13809, 33.77845], [-118.13794, 33.77842], [-118.13785, 33.77843], [-118.13761, 33.77828], [-118.13774, 33.77887], [-118.13971, 33.77887], [-118.13975, 33.77919], [-118.13984, 33.77952], [-118.13994, 33.77976], [-118.14014, 33.78014], [-118.14017, 33.78028], [-118.14021, 33.78053], [-118.14035, 33.78094], [-118.14048, 33.78125], [-118.14065, 33.78155], [-118.14065, 33.78172], [-118.14059, 33.7819]]], [[[-118.13709, 33.77522], [-118.13425, 33.77522], [-118.13425, 33.77512], [-118.13435, 33.77491], [-118.13451, 33.77494], [-118.13454, 33.77499], [-118.13464, 33.77501], [-118.13469, 33.77462], [-118.13477, 33.7743], [-118.13501, 33.77369], [-118.13498, 33.77362], [-118.13486, 33.77356], [-118.13559, 33.77356], [-118.13708, 33.77489], [-118.13709, 33.77522]]], [[[-118.14125, 33.78248], [-118.14063, 33.78248], [-118.1406, 33.78245], [-118.14064, 33.78225], [-118.14082, 33.78188], [-118.14099, 33.78184], [-118.14125, 33.78248]]]]} | Open Access 1 | 46628 | Recreation Park | 29953 | 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 | 66.166 | Rec. Park | 0 | Local Recreation Area 3 | 4 | |
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} | Open Access 1 | 6683 | Chittick Field | 29942 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 19.452 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
15378 | 15378 | 15377 | {"type": "Polygon", "coordinates": [[[-118.14144, 33.77431], [-118.14144, 33.77465], [-118.13728, 33.77198], [-118.13729, 33.77178], [-118.13753, 33.77178], [-118.14144, 33.77431]]]} | Open Access 1 | 46621 | The Long Beach Greenbelt | 29941 | 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.662 | The Long Beach Greenbelt | 0 | Local Recreation Area 3 | 4 | |
3981 | 3981 | 3980 | {"type": "Polygon", "coordinates": [[[-118.09099, 33.82783], [-118.09001, 33.82754], [-118.09002, 33.82684], [-118.0909, 33.82686], [-118.09099, 33.82783]]]} | Open Access 1 | 46620 | Gemmrig Park | 29935 | 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.955 | Gemmrig Park | 0 | Local Park 2 | 4 | |
15385 | 15385 | 15384 | {"type": "MultiPolygon", "coordinates": [[[[-118.19643, 33.76504], [-118.19642, 33.7651], [-118.19629, 33.76501], [-118.19586, 33.76476], [-118.19541, 33.76453], [-118.19524, 33.76443], [-118.19465, 33.76412], [-118.19436, 33.764], [-118.19339, 33.76355], [-118.19273, 33.76326], [-118.19276, 33.76323], [-118.19282, 33.76322], [-118.19307, 33.76332], [-118.19491, 33.76418], [-118.19601, 33.76476], [-118.19635, 33.76496], [-118.19641, 33.765], [-118.19643, 33.76504]]], [[[-118.19718, 33.76367], [-118.19722, 33.7637], [-118.19723, 33.76375], [-118.19711, 33.76411], [-118.19693, 33.76441], [-118.1968, 33.76458], [-118.19672, 33.76465], [-118.19667, 33.76459], [-118.19684, 33.7644], [-118.19695, 33.76423], [-118.19704, 33.76405], [-118.19716, 33.76369], [-118.19718, 33.76367]]], [[[-118.19859, 33.76118], [-118.19854, 33.76126], [-118.1984, 33.76122], [-118.19807, 33.76179], [-118.1977, 33.76235], [-118.19774, 33.76238], [-118.19763, 33.76256], [-118.19752, 33.76281], [-118.19732, 33.76358], [-118.19729, 33.76358], [-118.19715, 33.7635], [-118.19718, 33.76339], [-118.19715, 33.76328], [-118.19726, 33.76314], [-118.19746, 33.76252], [-118.19778, 33.762], [-118.19787, 33.7618], [-118.19791, 33.76158], [-118.19791, 33.76134], [-118.19794, 33.76124], [-118.198, 33.76118], [-118.19807, 33.76113], [-118.19823, 33.76109], [-118.19835, 33.7611], [-118.19859, 33.76118]]], [[[-118.1994, 33.76132], [-118.19947, 33.7613], [-118.1995, 33.76133], [-118.1995, 33.76136], [-118.19944, 33.7614], [-118.19927, 33.7616], [-118.1991, 33.76186], [-118.19901, 33.76204], [-118.19895, 33.76223], [-118.19891, 33.76238], [-118.19889, 33.76258], [-118.19882, 33.76258], [-118.19886, 33.76231], [-118.19895, 33.76202], [-118.19913, 33.7617], [-118.19932, 33.76144], [-118.1993, 33.76137], [-118.19902, 33.76123], [-118.19895, 33.76128], [-118.19888, 33.76123], [-118.19878, 33.76118], [-118.19834, 33.76101], [-118.19826, 33.76097], [-118.19825, 33.76096], [-118.19847, 33.76103], [-118.19854, 33.76093], [-118.1994, 33.76132]]]]} | Open Access 1 | 46619 | Shoreline Park Bikepath | 29934 | 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.93 | Shoreline Park Bikepath | 0 | Local Recreation Area 3 | 4 | |
3980 | 3980 | 3979 | {"type": "Polygon", "coordinates": [[[-118.12082, 33.75099], [-118.12081, 33.75102], [-118.12061, 33.75101], [-118.12037, 33.75104], [-118.12012, 33.75112], [-118.11995, 33.75121], [-118.11979, 33.75134], [-118.11882, 33.75237], [-118.11861, 33.75252], [-118.11819, 33.75271], [-118.11817, 33.75267], [-118.11847, 33.75255], [-118.11862, 33.75247], [-118.11878, 33.75235], [-118.11892, 33.75223], [-118.11977, 33.75131], [-118.11991, 33.75119], [-118.12011, 33.75109], [-118.12036, 33.751], [-118.12058, 33.75098], [-118.12082, 33.75099]]]} | Open Access 1 | 46618 | Vista del Golfo Parkway | 29933 | 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.273 | Vista del Golfo Parkway | 0 | Local Recreation Area 3 | 4 | |
15400 | 15400 | 15399 | {"type": "Polygon", "coordinates": [[[-118.20264, 33.82045], [-118.20248, 33.82045], [-118.20153, 33.81926], [-118.20157, 33.81922], [-118.2021, 33.81932], [-118.20229, 33.81937], [-118.2023, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | 46617 | Wrigley Heights Dog Park | 29932 | 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.703 | Wrigley Heights Dog Park | 2014 | Local Park 2 | 4 | |
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 4 | |
1120 | 1120 | 1119 | {"type": "MultiPolygon", "coordinates": [[[[-118.13088, 33.75291], [-118.13072, 33.75313], [-118.12914, 33.75219], [-118.12927, 33.75199], [-118.13088, 33.75291]]], [[[-118.13211, 33.75514], [-118.13039, 33.75789], [-118.13018, 33.75781], [-118.1303, 33.75771], [-118.13125, 33.75618], [-118.13149, 33.75596], [-118.13175, 33.7552], [-118.13179, 33.75507], [-118.1318, 33.7548], [-118.13162, 33.75434], [-118.13155, 33.75402], [-118.13074, 33.7533], [-118.13079, 33.75324], [-118.13095, 33.75332], [-118.13107, 33.7532], [-118.13126, 33.75329], [-118.13114, 33.75345], [-118.13128, 33.75352], [-118.13152, 33.75325], [-118.13174, 33.75337], [-118.1315, 33.75376], [-118.13193, 33.75398], [-118.13176, 33.75425], [-118.13211, 33.75514]]]]} | Open Access 1 | 6585 | Bayshore Beach | 29929 | 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 | 4.159 | Bayshore Beach | 0 | Local Park 2 | 4 | |
7322 | 7322 | 7321 | {"type": "Polygon", "coordinates": [[[-118.21763, 33.79448], [-118.21763, 33.79704], [-118.21597, 33.79703], [-118.21597, 33.79622], [-118.21554, 33.79621], [-118.21554, 33.7953], [-118.21586, 33.79531], [-118.21587, 33.79525], [-118.21586, 33.79524], [-118.21561, 33.79524], [-118.21561, 33.79448], [-118.21763, 33.79448]]]} | Open Access 1 | 6631 | Admiral Issac C. Kidd Park | 29925 | 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 | 12.494 | Admiral Issac C. Kidd Park | 0 | Local Park 2 | 4 | |
15397 | 15397 | 15396 | {"type": "MultiPolygon", "coordinates": [[[[-118.16911, 33.76371], [-118.16907, 33.76395], [-118.16889, 33.76393], [-118.16893, 33.76369], [-118.16911, 33.76371]]], [[[-118.17, 33.76384], [-118.16997, 33.76404], [-118.16979, 33.76401], [-118.16982, 33.76382], [-118.17, 33.76384]]], [[[-118.17089, 33.76396], [-118.17086, 33.76416], [-118.17068, 33.76414], [-118.17072, 33.76393], [-118.17089, 33.76396]]], [[[-118.17176, 33.76423], [-118.17175, 33.7643], [-118.17157, 33.76428], [-118.17158, 33.76412], [-118.17159, 33.76412], [-118.17167, 33.76419], [-118.17176, 33.76423]]], [[[-118.17268, 33.76419], [-118.17265, 33.76435], [-118.17248, 33.76433], [-118.1725, 33.76417], [-118.17268, 33.76419]]], [[[-118.17358, 33.76431], [-118.17354, 33.76452], [-118.17346, 33.76449], [-118.17336, 33.7645], [-118.1734, 33.76428], [-118.17358, 33.76431]]], [[[-118.17447, 33.76442], [-118.17443, 33.76465], [-118.17439, 33.76464], [-118.17435, 33.76461], [-118.17425, 33.76462], [-118.17429, 33.7644], [-118.17447, 33.76442]]], [[[-118.17536, 33.76454], [-118.17533, 33.76475], [-118.17515, 33.76473], [-118.17519, 33.76452], [-118.17536, 33.76454]]], [[[-118.17626, 33.76466], [-118.17623, 33.76484], [-118.17605, 33.76482], [-118.17608, 33.76464], [-118.17626, 33.76466]]], [[[-118.17716, 33.76478], [-118.17711, 33.76501], [-118.17694, 33.76498], [-118.17698, 33.76475], [-118.17716, 33.76478]]], [[[-118.17805, 33.76489], [-118.17801, 33.76512], [-118.17783, 33.7651], [-118.17787, 33.76487], [-118.17805, 33.76489]]], [[[-118.17895, 33.76501], [-118.17891, 33.76521], [-118.17873, 33.76519], [-118.17877, 33.76499], [-118.17895, 33.76501]]], [[[-118.17984, 33.76513], [-118.1798, 33.76535], [-118.17962, 33.76533], [-118.17966, 33.7651], [-118.17984, 33.76513]]], [[[-118.18074, 33.76524], [-118.18068, 33.76554], [-118.18063, 33.76552], [-118.1805, 33.76551], [-118.18056, 33.76522], [-118.18074, 33.76524]]], [[[-118.18164, 33.76534], [-118.18157, 33.76571], [-118.18151, 33.76569], [-118.18139, 33.76569], [-118.18145, 33.76534], [-118.18164, 33.76534]]]]} | Open Access 1 | 46613 | Mini-Parks at 1st Place through 15th Place | 29924 | 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.511 | Mini-Parks at 1st Place through 15th Place | 1980 | Local Park 2 | 4 | |
15392 | 15392 | 15391 | {"type": "Polygon", "coordinates": [[[-118.11977, 33.76092], [-118.11936, 33.76122], [-118.11897, 33.76132], [-118.11864, 33.76148], [-118.1184, 33.76157], [-118.11836, 33.76161], [-118.11829, 33.76175], [-118.11825, 33.76178], [-118.11814, 33.7618], [-118.11783, 33.76151], [-118.11805, 33.76134], [-118.11853, 33.76125], [-118.1189, 33.76111], [-118.11927, 33.76109], [-118.11934, 33.76106], [-118.11943, 33.76114], [-118.11949, 33.76108], [-118.11965, 33.76081], [-118.11977, 33.76092]]]} | Open Access 1 | 46611 | Marina Pacifica Park | 29922 | 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.136 | Marina Pacifica Park | 0 | Local Park 2 | 4 | |
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14804, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | 6605 | Unknown park - Long Beach, City of | 29921 | 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.432 | 0 | Local Other or Unknown 14 | 4 | ||
15390 | 15390 | 15389 | {"type": "Polygon", "coordinates": [[[-118.2227, 33.79832], [-118.22247, 33.79885], [-118.22142, 33.79884], [-118.22142, 33.79833], [-118.2227, 33.79832]]]} | Open Access 1 | 46610 | Hudson Park Community Garden | 29919 | 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.531 | Hudson Park Community Garden | 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]);