units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
DES_TP 21
- Local Park 85
- Local Recreation Area 22
- 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
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 128
MNG_AGENCY 1
- Long Beach, City of · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2714 | 2714 | 2713 | {"type": "MultiPolygon", "coordinates": [[[[-118.21183, 33.82355], [-118.21117, 33.82355], [-118.21118, 33.82341], [-118.21183, 33.82341], [-118.21183, 33.82355]]], [[[-118.21441, 33.82237], [-118.21313, 33.8242], [-118.21309, 33.82422], [-118.21282, 33.82418], [-118.21282, 33.82385], [-118.21441, 33.82237]]]]} | Open Access 1 | 6689 | Tanaka Park | 26179 | 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.624 | Tanaka Park | 0 | Local Park 2 | 4 | |
2951 | 2951 | 2950 | {"type": "Polygon", "coordinates": [[[-118.16535, 33.78974], [-118.16492, 33.78974], [-118.16342, 33.78877], [-118.16342, 33.78849], [-118.16535, 33.78974]]]} | Open Access 1 | 20230 | Rotary Centennial Park | 24683 | 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.209 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
3647 | 3647 | 3646 | {"type": "Polygon", "coordinates": [[[-118.18416, 33.84964], [-118.18416, 33.84977], [-118.1839, 33.84978], [-118.18368, 33.84995], [-118.18366, 33.85], [-118.18366, 33.85103], [-118.18368, 33.85107], [-118.1839, 33.85124], [-118.18415, 33.85125], [-118.18412, 33.8514], [-118.18406, 33.85154], [-118.18391, 33.85147], [-118.18377, 33.85139], [-118.18366, 33.85128], [-118.18358, 33.85119], [-118.18348, 33.85098], [-118.18344, 33.85061], [-118.18338, 33.85051], [-118.18271, 33.85006], [-118.18216, 33.84996], [-118.18039, 33.85003], [-118.18036, 33.85027], [-118.18017, 33.85029], [-118.18011, 33.85019], [-118.18008, 33.84977], [-118.17983, 33.84976], [-118.17975, 33.84957], [-118.17968, 33.84949], [-118.17974, 33.84942], [-118.17984, 33.84936], [-118.18021, 33.84922], [-118.18033, 33.84962], [-118.18037, 33.84983], [-118.18193, 33.84976], [-118.18192, 33.84935], [-118.18226, 33.84923], [-118.18204, 33.84878], [-118.18212, 33.84873], [-118.18233, 33.84879], [-118.18248, 33.84853], [-118.18292, 33.84865], [-118.18288, 33.84873], [-118.18271, 33.84886], [-118.18251, 33.84906], [-118.18305, 33.84956], [-118.18339, 33.84983], [-118.18349, 33.84986], [-118.18356, 33.84986], [-118.18363, 33.84983], [-118.18379, 33.8497], [-118.18388, 33.84966], [-118.18397, 33.84964], [-118.18416, 33.84964]]]} | Open Access 1 | 29559 | Atlantic Plaza Park | 15675 | 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.585 | Atlantic Plaza Park | 0 | Local Park 2 | 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 | |
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 | |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 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 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
4380 | 4380 | 4379 | {"type": "Polygon", "coordinates": [[[-118.17688, 33.84102], [-118.17654, 33.8412], [-118.17644, 33.84116], [-118.17644, 33.84082], [-118.17673, 33.84082], [-118.17688, 33.84102]]]} | Open Access 1 | 45939 | Orange Park | 29014 | 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.301 | Orange Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |||
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 | ||
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 | |
5166 | 5166 | 5165 | {"type": "Polygon", "coordinates": [[[-118.07283, 33.81486], [-118.07254, 33.81515], [-118.07246, 33.81527], [-118.07239, 33.81542], [-118.07195, 33.8153], [-118.07283, 33.81486]]]} | Open Access 1 | 6690 | Lilly Park | 21238 | 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.332 | Lilly Park | 0 | Local Park 2 | 4 | |
7239 | 7239 | 7238 | {"type": "MultiPolygon", "coordinates": [[[[-118.19906, 33.82499], [-118.1991, 33.825], [-118.19941, 33.82546], [-118.19942, 33.8255], [-118.19859, 33.82589], [-118.19854, 33.82589], [-118.19827, 33.82551], [-118.1982, 33.82544], [-118.1982, 33.8254], [-118.19906, 33.82499]]], [[[-118.20044, 33.8271], [-118.19882, 33.82786], [-118.1986, 33.82599], [-118.19944, 33.82559], [-118.20044, 33.8271]]]]} | Open Access 1 | 6574 | Los Cerritos Park | 21511 | 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.692 | Los Cerritos Park | 0 | Local Park 2 | 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 | |
7286 | 7286 | 7285 | {"type": "MultiPolygon", "coordinates": [[[[-118.1883, 33.85382], [-118.18813, 33.85382], [-118.18813, 33.85341], [-118.1883, 33.85341], [-118.1883, 33.85382]]], [[[-118.18933, 33.85382], [-118.18843, 33.85382], [-118.18843, 33.85341], [-118.18932, 33.8534], [-118.18933, 33.85382]]]]} | Open Access 1 | 6597 | Grace Park | 28712 | 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.112 | Grace Park | 0 | Local Park 2 | 4 | |
7287 | 7287 | 7286 | {"type": "MultiPolygon", "coordinates": [[[[-118.11639, 33.83036], [-118.11638, 33.83207], [-118.11633, 33.83212], [-118.10791, 33.83209], [-118.10789, 33.83205], [-118.1079, 33.83031], [-118.10859, 33.83031], [-118.1086, 33.83034], [-118.11639, 33.83036]]], [[[-118.125, 33.83134], [-118.12426, 33.83135], [-118.12427, 33.83168], [-118.12499, 33.83168], [-118.12499, 33.83216], [-118.1168, 33.83213], [-118.11674, 33.83208], [-118.11672, 33.83131], [-118.11672, 33.83032], [-118.125, 33.83035], [-118.125, 33.83134]]], [[[-118.1337, 33.83037], [-118.13369, 33.8321], [-118.13362, 33.83217], [-118.12534, 33.83215], [-118.12534, 33.83154], [-118.12601, 33.83153], [-118.12601, 33.83086], [-118.12532, 33.83085], [-118.12532, 33.83035], [-118.1337, 33.83037]]]]} | Open Access 1 | 6578 | Heartwell Park | 19777 | 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 | 112.244 | Heartwell Park | 0 | Local Park 2 | 4 | |
7288 | 7288 | 7287 | {"type": "MultiPolygon", "coordinates": [[[[-118.20289, 33.77061], [-118.2028, 33.77062], [-118.2028, 33.77101], [-118.20239, 33.771], [-118.20239, 33.77061], [-118.20258, 33.7706], [-118.20259, 33.77059], [-118.20251, 33.77054], [-118.20225, 33.7705], [-118.20193, 33.7705], [-118.20192, 33.77037], [-118.20193, 33.77027], [-118.2019, 33.77026], [-118.20191, 33.77014], [-118.20189, 33.77011], [-118.20183, 33.77008], [-118.20183, 33.76935], [-118.20193, 33.76935], [-118.20194, 33.7694], [-118.20234, 33.7694], [-118.20235, 33.76937], [-118.20278, 33.76942], [-118.20289, 33.77061]], [[-118.20234, 33.76981], [-118.20194, 33.7698], [-118.20193, 33.76982], [-118.20233, 33.76983], [-118.20234, 33.76981]]], [[[-118.20234, 33.771], [-118.20193, 33.77101], [-118.20193, 33.7706], [-118.20226, 33.7706], [-118.20234, 33.77061], [-118.20234, 33.771]]], [[[-118.20234, 33.77103], [-118.20234, 33.77152], [-118.20192, 33.77152], [-118.20193, 33.77103], [-118.20234, 33.77103]]], [[[-118.20234, 33.77166], [-118.20202, 33.77164], [-118.20196, 33.77163], [-118.20193, 33.77159], [-118.20234, 33.77159], [-118.20234, 33.77166]]], [[[-118.2028, 33.77103], [-118.20278, 33.77158], [-118.20256, 33.77168], [-118.20239, 33.77167], [-118.20239, 33.77103], [-118.2028, 33.77103]]], [[[-118.20306, 33.77226], [-118.20298, 33.77231], [-118.20278, 33.77239], [-118.20264, 33.77241], [-118.20245, 33.77241], [-118.2021, 33.77236], [-118.20193, 33.77238], [-118.20193, 33.77181], [-118.20222, 33.77182], [-118.20249, 33.77186], [-118.20259, 33.77186], [-118.20279, 33.7718], [-118.20305, 33.77165], [-118.20306, 33.77226]]], [[[-118.2028, 33.7728], [-118.20193, 33.77281], [-118.20192, 33.77254], [-118.20213, 33.77253], [-118.20246, 33.77258], [-118.20266, 33.77258], [-118.20279, 33.77256], [-118.2028, 33.7728]]], [[[-118.20281, 33.77399], [-118.20277, 33.77402], [-118.20239, 33.77401], [-118.20239, 33.7739], [-118.20238, 33.77303], [-118.20279, 33.77303], [-118.20281, 33.77399]]], [[[-118.20234, 33.77347], [-118.20234, 33.77401], [-118.20193, 33.77402], [-118.20193, 33.77303], [-118.20234, 33.77303], [-118.20234, 33.77347]]]]} | Open Access 1 | 6579 | Cesar E. Chavez Park | 17104 | 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.078 | Cesar E. Chavez 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]);