units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where DES_TP = 3, MNG_AGENCY = 294 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 25
MNG_AGENCY 1
- Long Beach, City of · 25 ✖
DES_TP 1
- Local Recreation Area · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
971 | 971 | 970 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84873], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 6612 | 51st St Greenbelt | 29907 | 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.011 | 51st St Greenbelt | 2008 | Local Recreation Area 3 | 4 | |
1126 | 1126 | 1125 | {"type": "MultiPolygon", "coordinates": [[[[-118.19262, 33.86033], [-118.1925, 33.86059], [-118.19247, 33.86057], [-118.19244, 33.8605], [-118.1922, 33.86042], [-118.19216, 33.86047], [-118.19211, 33.86043], [-118.19206, 33.86043], [-118.19206, 33.86014], [-118.19229, 33.86016], [-118.19238, 33.86019], [-118.19262, 33.86033]]], [[[-118.19495, 33.86197], [-118.1949, 33.86207], [-118.19487, 33.86207], [-118.19485, 33.86197], [-118.1935, 33.86102], [-118.19314, 33.86081], [-118.19274, 33.86062], [-118.19263, 33.86064], [-118.19277, 33.86047], [-118.19278, 33.86047], [-118.19475, 33.86186], [-118.19494, 33.86194], [-118.19494, 33.86196], [-118.19495, 33.86197]]], [[[-118.19511, 33.86172], [-118.19507, 33.86179], [-118.195, 33.86182], [-118.19478, 33.86171], [-118.19288, 33.86037], [-118.19326, 33.86055], [-118.19364, 33.86077], [-118.195, 33.86172], [-118.19508, 33.86171], [-118.19511, 33.86172]]]]} | Open Access 1 | 6601 | South Street Parkway | 25680 | 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.42 | South Street Parkway | 0 | Local Recreation Area 3 | 4 | |
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 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.181 | Chittick Field | 2014 | 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 | |
2711 | 2711 | 2710 | {"type": "MultiPolygon", "coordinates": [[[[-118.19943, 33.79521], [-118.19929, 33.79521], [-118.19927, 33.79361], [-118.19943, 33.79359], [-118.19943, 33.79521]]], [[[-118.19942, 33.79542], [-118.19941, 33.79702], [-118.19929, 33.79703], [-118.19927, 33.79542], [-118.19942, 33.79542]]], [[[-118.19944, 33.79178], [-118.19943, 33.79341], [-118.19928, 33.79342], [-118.1993, 33.79177], [-118.19944, 33.79178]]], [[[-118.19946, 33.79006], [-118.19943, 33.7916], [-118.19929, 33.7916], [-118.19931, 33.79007], [-118.19946, 33.79006]]]]} | Open Access 1 | 6685 | Daisy Greenbelt | 17892 | 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.32 | Daisy Greenbelt | 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 | |
5091 | 5091 | 5090 | {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13518, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13696, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} | Restricted Access 2 | 45923 | Recreation Park 18 Hole Golf Course | 33116 | 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 | 119.647 | Rec. Park 18 Hole GC | 0 | Local Recreation Area 3 | 4 | |
7283 | 7283 | 7282 | {"type": "MultiPolygon", "coordinates": [[[[-118.14175, 33.82338], [-118.13512, 33.82334], [-118.13509, 33.82283], [-118.13466, 33.82244], [-118.13408, 33.82244], [-118.13409, 33.81902], [-118.13416, 33.81896], [-118.13886, 33.81895], [-118.139, 33.81906], [-118.1391, 33.81948], [-118.13924, 33.81986], [-118.13935, 33.82009], [-118.13975, 33.82078], [-118.13995, 33.82107], [-118.14019, 33.82136], [-118.14125, 33.82253], [-118.14146, 33.82291], [-118.14163, 33.82315], [-118.14164, 33.82326], [-118.14169, 33.82326], [-118.14175, 33.82338]]], [[[-118.13891, 33.81857], [-118.13879, 33.81867], [-118.13416, 33.81868], [-118.1341, 33.81863], [-118.13413, 33.81186], [-118.13414, 33.81143], [-118.13419, 33.81124], [-118.1342, 33.81077], [-118.13422, 33.81074], [-118.13428, 33.81072], [-118.13441, 33.81072], [-118.13496, 33.81078], [-118.13539, 33.81088], [-118.13582, 33.81105], [-118.13625, 33.81129], [-118.13757, 33.81228], [-118.13794, 33.81248], [-118.13814, 33.81256], [-118.13848, 33.81267], [-118.1388, 33.81275], [-118.1389, 33.81284], [-118.1389, 33.81374], [-118.13894, 33.81402], [-118.13894, 33.81428], [-118.13895, 33.81713], [-118.13889, 33.81799], [-118.13889, 33.81832], [-118.13891, 33.81857]]]]} | Restricted Access 2 | 6575 | Skylinks Golf Course | 33018 | 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 | 152.018 | Skylinks GC | 0 | Local Recreation Area 3 | 4 | |
7327 | 7327 | 7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 6641 | 14th Street Park and Playground | 15173 | 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.661 | 14th Street Park and Playground | 0 | Local Recreation Area 3 | 4 | |
7335 | 7335 | 7334 | {"type": "MultiPolygon", "coordinates": [[[[-118.13513, 33.76319], [-118.13494, 33.76348], [-118.13464, 33.76355], [-118.13433, 33.76341], [-118.13513, 33.76319]]], [[[-118.13617, 33.76292], [-118.13599, 33.7632], [-118.13525, 33.7634], [-118.13521, 33.7634], [-118.13518, 33.76337], [-118.13519, 33.76334], [-118.13531, 33.76315], [-118.13617, 33.76292]]], [[[-118.1372, 33.76265], [-118.13714, 33.7629], [-118.13629, 33.76312], [-118.13625, 33.76312], [-118.13623, 33.76309], [-118.13623, 33.76306], [-118.13636, 33.76287], [-118.1372, 33.76265]]], [[[-118.13839, 33.76234], [-118.13834, 33.76258], [-118.13735, 33.76284], [-118.13743, 33.76259], [-118.13839, 33.76234]]]]} | Open Access 1 | 6648 | Livingston Drive Greenbelt and Playground | 21383 | 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.923 | Livingston Drive Greenbelt and Playground | 2008 | Local Recreation Area 3 | 4 | |
7336 | 7336 | 7335 | {"type": "MultiPolygon", "coordinates": [[[[-118.14362, 33.77567], [-118.14362, 33.77608], [-118.14273, 33.77551], [-118.14273, 33.77544], [-118.14327, 33.77544], [-118.14362, 33.77567]]], [[[-118.14578, 33.77707], [-118.14515, 33.77707], [-118.14381, 33.77621], [-118.14381, 33.77579], [-118.14578, 33.77707]]]]} | Open Access 1 | 6649 | Pacific Electric Greenbelt | 23297 | 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.422 | Pacific Electric Greenbelt | 0 | Local Recreation Area 3 | 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 |
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 |
14743 | 14743 | 14742 | {"type": "Polygon", "coordinates": [[[-118.2041, 33.77812], [-118.20413, 33.77876], [-118.20407, 33.77891], [-118.20398, 33.77907], [-118.20386, 33.77925], [-118.20372, 33.7794], [-118.2035, 33.77958], [-118.20334, 33.77968], [-118.20106, 33.78128], [-118.20102, 33.78137], [-118.2007, 33.78153], [-118.20044, 33.7817], [-118.20015, 33.78197], [-118.19976, 33.78248], [-118.19955, 33.78248], [-118.19977, 33.78213], [-118.20005, 33.78181], [-118.20033, 33.78157], [-118.20115, 33.78099], [-118.20119, 33.78077], [-118.20134, 33.7806], [-118.20151, 33.78056], [-118.20132, 33.78016], [-118.20165, 33.78003], [-118.20194, 33.77984], [-118.20211, 33.77969], [-118.20269, 33.7791], [-118.20278, 33.77899], [-118.20298, 33.77911], [-118.20318, 33.77899], [-118.20318, 33.77898], [-118.20309, 33.77895], [-118.20314, 33.77882], [-118.20323, 33.77885], [-118.20344, 33.77871], [-118.20348, 33.77853], [-118.2035, 33.77836], [-118.20347, 33.77806], [-118.20393, 33.778], [-118.20395, 33.77813], [-118.2041, 33.77812]]]} | Open Access 1 | 45117 | Drake/Chavez Soccer Fields and Parkway | 27996 | 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.964 | Drake/Chavez Soccer Fields and Parkway | 2018 | Local Recreation Area 3 | 4 | |
15096 | 15096 | 15095 | {"type": "MultiPolygon", "coordinates": [[[[-118.09888, 33.79874], [-118.09877, 33.79897], [-118.09852, 33.7992], [-118.09829, 33.79944], [-118.09804, 33.79961], [-118.0977, 33.79975], [-118.09743, 33.7998], [-118.09713, 33.7998], [-118.09686, 33.79988], [-118.09656, 33.80001], [-118.09637, 33.80014], [-118.09597, 33.80071], [-118.09587, 33.80097], [-118.0958, 33.80124], [-118.09568, 33.80195], [-118.09561, 33.80217], [-118.09551, 33.80237], [-118.09538, 33.80256], [-118.09473, 33.80327], [-118.09458, 33.80348], [-118.09451, 33.80361], [-118.09362, 33.80386], [-118.09289, 33.804], [-118.0921, 33.80403], [-118.09141, 33.804], [-118.09101, 33.79591], [-118.09679, 33.79593], [-118.09701, 33.7961], [-118.09718, 33.79627], [-118.09735, 33.79656], [-118.09753, 33.79691], [-118.09762, 33.79721], [-118.09817, 33.79721], [-118.09858, 33.79781], [-118.09869, 33.79802], [-118.09879, 33.7984], [-118.09886, 33.7985], [-118.09888, 33.79874]]], [[[-118.09543, 33.80984], [-118.09439, 33.81005], [-118.09343, 33.81003], [-118.0925, 33.81009], [-118.09177, 33.80986], [-118.0917, 33.80987], [-118.09143, 33.80443], [-118.0916, 33.80443], [-118.09162, 33.80455], [-118.09184, 33.80467], [-118.09209, 33.80476], [-118.09211, 33.8049], [-118.09249, 33.80501], [-118.09295, 33.8052], [-118.09376, 33.80564], [-118.09427, 33.80609], [-118.0948, 33.80682], [-118.09547, 33.8085], [-118.09543, 33.80984]]]]} | Restricted Access 2 | 45888 | El Dorado Park Golf Course | 33114 | 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.eldoradoparkgc.com/ | Los Angeles 6 | 154.986 | El Dorado Park GC | 0 | Local Recreation Area 3 | 4 |
15116 | 15116 | 15115 | {"type": "MultiPolygon", "coordinates": [[[[-118.13464, 33.77502], [-118.13454, 33.77499], [-118.1345, 33.77494], [-118.13435, 33.77491], [-118.13433, 33.77494], [-118.13425, 33.77511], [-118.13425, 33.77522], [-118.12861, 33.77521], [-118.12861, 33.77359], [-118.13185, 33.77359], [-118.13186, 33.77356], [-118.13486, 33.77356], [-118.13498, 33.77362], [-118.13501, 33.77369], [-118.13477, 33.7743], [-118.13469, 33.77462], [-118.13464, 33.77502]]], [[[-118.13709, 33.77258], [-118.13709, 33.77342], [-118.13548, 33.77344], [-118.13554, 33.77351], [-118.13295, 33.77351], [-118.13295, 33.77343], [-118.13291, 33.77343], [-118.13288, 33.77266], [-118.13278, 33.77231], [-118.13275, 33.77212], [-118.13276, 33.7719], [-118.1328, 33.7718], [-118.13288, 33.77168], [-118.13298, 33.77163], [-118.13306, 33.77162], [-118.13502, 33.77188], [-118.13513, 33.77204], [-118.13533, 33.77205], [-118.13573, 33.7722], [-118.1358, 33.77229], [-118.13586, 33.77253], [-118.13593, 33.77262], [-118.13602, 33.7727], [-118.13612, 33.77274], [-118.13623, 33.77276], [-118.13634, 33.77276], [-118.13644, 33.77273], [-118.13657, 33.77265], [-118.13666, 33.77253], [-118.13709, 33.77258]]]]} | Restricted Access 2 | 45922 | Recreation 9 Hole Golf Course | 33115 | 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.recpark9.com/ | Los Angeles 6 | 40.591 | Rec. 9 Hole GC | 0 | Local Recreation Area 3 | 4 |
15121 | 15121 | 15120 | {"type": "Polygon", "coordinates": [[[-118.19844, 33.84148], [-118.19809, 33.84159], [-118.1981, 33.84183], [-118.19442, 33.8431], [-118.194, 33.8431], [-118.19803, 33.8417], [-118.19805, 33.84167], [-118.19804, 33.84148], [-118.198, 33.84136], [-118.19796, 33.84133], [-118.19797, 33.84132], [-118.19827, 33.84145], [-118.19844, 33.84148]]]} | Open Access 1 | 45929 | Sleepy Hollow Greenbelt | 29005 | 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/sleepy-hollow-greenbelt/ | Los Angeles 6 | 1.576 | Sleepy Hollow Greenbelt | 0 | 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 | |
15381 | 15381 | 15380 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 46593 | 34th St Greenbelt | 29894 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.928 | 34th St Greenbelt | 2007 | Local Recreation Area 3 | 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]);