units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where DES_TP = 2 and MNG_AGENCY = 294
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 85
MNG_AGENCY 1
- Long Beach, City of · 85 ✖
DES_TP 1
- Local Park · 85 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 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://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 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 | |
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 | |
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 | |
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 | |
7297 | 7297 | 7296 | {"type": "MultiPolygon", "coordinates": [[[[-118.12655, 33.764], [-118.12636, 33.76408], [-118.12377, 33.76183], [-118.12399, 33.76165], [-118.12655, 33.764]]], [[[-118.12538, 33.76725], [-118.12531, 33.76744], [-118.12529, 33.76765], [-118.12527, 33.76769], [-118.12506, 33.76776], [-118.12488, 33.76772], [-118.12507, 33.76713], [-118.12513, 33.76718], [-118.12538, 33.76725]]], [[[-118.13116, 33.76835], [-118.13102, 33.76843], [-118.12997, 33.76837], [-118.12976, 33.76835], [-118.12936, 33.76824], [-118.12909, 33.76822], [-118.12773, 33.76831], [-118.12773, 33.76804], [-118.12767, 33.76801], [-118.1276, 33.76791], [-118.1278, 33.76779], [-118.1279, 33.76787], [-118.1279, 33.76797], [-118.12796, 33.76805], [-118.12806, 33.7681], [-118.12861, 33.76812], [-118.12937, 33.76811], [-118.12952, 33.76816], [-118.12967, 33.76814], [-118.12982, 33.76803], [-118.13, 33.76786], [-118.13008, 33.7677], [-118.13016, 33.76766], [-118.13081, 33.76826], [-118.13106, 33.76827], [-118.13116, 33.76835]]]]} | Open Access 1 | 6581 | Marine Stadium Park | 21849 | 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.842 | Marine Stadium Park | 0 | Local Park 2 | 4 | |
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86063], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | 6600 | DeForest Park | 18015 | 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 | 34.12 | DeForest Park | 2018 | Local Park 2 | 4 | |
7303 | 7303 | 7302 | {"type": "MultiPolygon", "coordinates": [[[[-118.1339, 33.75143], [-118.13244, 33.75337], [-118.13223, 33.75326], [-118.1325, 33.7529], [-118.13249, 33.75289], [-118.13243, 33.75287], [-118.13216, 33.75322], [-118.13042, 33.75231], [-118.13063, 33.75203], [-118.13056, 33.75198], [-118.13049, 33.75195], [-118.13028, 33.75224], [-118.12972, 33.75195], [-118.12999, 33.75159], [-118.12993, 33.75155], [-118.12965, 33.75191], [-118.12874, 33.75144], [-118.12894, 33.75115], [-118.12655, 33.74983], [-118.12441, 33.74861], [-118.12216, 33.74728], [-118.12094, 33.74658], [-118.12034, 33.7463], [-118.11915, 33.74576], [-118.11863, 33.74558], [-118.11827, 33.7455], [-118.11797, 33.7454], [-118.11798, 33.74537], [-118.11789, 33.74533], [-118.11762, 33.74568], [-118.11715, 33.74543], [-118.11719, 33.74536], [-118.11664, 33.74505], [-118.11771, 33.74349], [-118.11778, 33.7436], [-118.11787, 33.7437], [-118.11972, 33.7451], [-118.12233, 33.74681], [-118.12259, 33.74701], [-118.12286, 33.74717], [-118.12299, 33.74728], [-118.12361, 33.74762], [-118.12417, 33.74785], [-118.12484, 33.74819], [-118.12766, 33.74905], [-118.12844, 33.74937], [-118.12883, 33.74948], [-118.12931, 33.74968], [-118.12965, 33.74979], [-118.12998, 33.74993], [-118.13055, 33.7501], [-118.1312, 33.75037], [-118.13193, 33.75063], [-118.13349, 33.75125], [-118.1339, 33.75143]]], [[[-118.12134, 33.74925], [-118.12116, 33.74946], [-118.1204, 33.74887], [-118.1203, 33.74856], [-118.12014, 33.74849], [-118.11929, 33.74762], [-118.11787, 33.74681], [-118.11823, 33.7463], [-118.11841, 33.74654], [-118.11858, 33.74672], [-118.11946, 33.74748], [-118.1199, 33.74797], [-118.12038, 33.7484], [-118.12036, 33.74843], [-118.12045, 33.74848], [-118.12083, 33.74887], [-118.12134, 33.74925]]], [[[-118.12847, 33.75181], [-118.12844, 33.75187], [-118.12809, 33.75186], [-118.1255, 33.75117], [-118.12338, 33.75035], [-118.12263, 33.74994], [-118.1227, 33.74984], [-118.12324, 33.74999], [-118.12382, 33.75028], [-118.12512, 33.75067], [-118.12573, 33.75094], [-118.12636, 33.75116], [-118.12847, 33.75181]]]]} | Open Access 1 | 6586 | Peninsula Beach | 23578 | 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 | 61.768 | Peninsula Beach | 0 | Local Park 2 | 4 | |
7304 | 7304 | 7303 | {"type": "Polygon", "coordinates": [[[-118.1834, 33.76411], [-118.18316, 33.76539], [-118.18309, 33.76538], [-118.18307, 33.76547], [-118.18236, 33.76542], [-118.18238, 33.76532], [-118.18186, 33.76524], [-118.18183, 33.76536], [-118.18164, 33.76534], [-118.18145, 33.76534], [-118.17698, 33.76475], [-118.1768, 33.76474], [-118.17179, 33.76407], [-118.1716, 33.76411], [-118.17089, 33.76396], [-118.16946, 33.76377], [-118.16946, 33.76376], [-118.16902, 33.7637], [-118.16918, 33.76281], [-118.16993, 33.76293], [-118.17053, 33.76303], [-118.17088, 33.76311], [-118.17134, 33.76324], [-118.17264, 33.76338], [-118.17411, 33.76338], [-118.17465, 33.76332], [-118.17525, 33.7633], [-118.17654, 33.76338], [-118.17721, 33.76338], [-118.17812, 33.76333], [-118.17907, 33.7632], [-118.17996, 33.76298], [-118.18051, 33.76266], [-118.181, 33.76231], [-118.18149, 33.76159], [-118.18316, 33.76335], [-118.18317, 33.76386], [-118.1834, 33.76411]]]} | Open Access 1 | 6587 | Alamitos Beach | 15314 | 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 | 56.546 | Alamitos Beach | 0 | Local Park 2 | 4 | |
7305 | 7305 | 7304 | {"type": "Polygon", "coordinates": [[[-118.2025, 33.77758], [-118.2026, 33.7777], [-118.20268, 33.77783], [-118.20278, 33.7781], [-118.2028, 33.77825], [-118.2028, 33.77839], [-118.20273, 33.77867], [-118.20265, 33.77884], [-118.20253, 33.779], [-118.20193, 33.7796], [-118.20178, 33.77972], [-118.20163, 33.77982], [-118.20139, 33.77945], [-118.20154, 33.77936], [-118.20187, 33.77912], [-118.20155, 33.77883], [-118.20169, 33.77871], [-118.20177, 33.77862], [-118.20163, 33.77852], [-118.20155, 33.7786], [-118.20145, 33.77868], [-118.20123, 33.7788], [-118.20097, 33.77886], [-118.2007, 33.77886], [-118.2007, 33.77787], [-118.20101, 33.77788], [-118.20123, 33.77793], [-118.20146, 33.77804], [-118.20157, 33.77813], [-118.20163, 33.7782], [-118.2025, 33.77758]]]} | Open Access 1 | 6589 | Drake Park | 18271 | 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.124 | Drake Park | 0 | Local Park 2 | 4 | |
7306 | 7306 | 7305 | {"type": "Polygon", "coordinates": [[[-118.17036, 33.83866], [-118.16951, 33.84005], [-118.16951, 33.84054], [-118.16776, 33.84055], [-118.16775, 33.8387], [-118.16781, 33.83865], [-118.17036, 33.83866]]]} | Open Access 1 | 6591 | Cherry Avenue Park | 17164 | 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.933 | Cherry Avenue Park | 0 | Local Park 2 | 4 | |
7307 | 7307 | 7306 | {"type": "Polygon", "coordinates": [[[-118.21529, 33.8152], [-118.21119, 33.81519], [-118.21119, 33.81407], [-118.21528, 33.81406], [-118.21529, 33.8152]]]} | Open Access 1 | 6592 | Silverado Park | 25498 | 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.725 | Silverado 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]);