units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AG_TYP = 14 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9107 | 9107 | 9106 | {"type": "Polygon", "coordinates": [[[-121.75969, 36.85239], [-121.7588, 36.85017], [-121.7571, 36.84595], [-121.75825, 36.84599], [-121.75836, 36.84608], [-121.75912, 36.84764], [-121.76009, 36.85016], [-121.76023, 36.85075], [-121.76019, 36.85134], [-121.75969, 36.85239]]]} | Open Access 1 | 15088 | Elkhorn Slough / Elkhorn Highlands | 18574 | 2087 | Moss Landing Harbor District 902 | Special District 4 | Port/Harbor District 15 | http://mosslandingharbor.dst.ca.us/ | Special District 4 | 2087 | Moss Landing Harbor District 876 | Special District 4 | Port/Harbor District 14 | Monterey 14 | 17.855 | Elkhorn Slough / Elkhorn Highlands | None 754 | |||
943 | 943 | 942 | {"type": "Polygon", "coordinates": [[[-118.27882, 33.74921], [-118.27815, 33.74968], [-118.27802, 33.74974], [-118.27789, 33.74976], [-118.27754, 33.74975], [-118.27741, 33.7497], [-118.27737, 33.74959], [-118.27431, 33.74883], [-118.27439, 33.74872], [-118.27446, 33.74854], [-118.27431, 33.74848], [-118.27435, 33.7484], [-118.2745, 33.74844], [-118.27759, 33.74948], [-118.2778, 33.74945], [-118.27835, 33.74882], [-118.27882, 33.74921]]]} | Open Access 1 | 5961 | Cruise Ship Promenade | 29098 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | http://www.portoflosangeles.org/ | Los Angeles 6 | 3.946 | Cruise Ship Promenade | None 85 | ||
7648 | 7648 | 7647 | {"type": "Polygon", "coordinates": [[[-117.11377, 32.61359], [-117.11375, 32.61403], [-117.11361, 32.61439], [-117.11328, 32.61458], [-117.11248, 32.61658], [-117.11221, 32.61694], [-117.11171, 32.61699], [-117.10505, 32.61491], [-117.10484, 32.61492], [-117.10439, 32.61365], [-117.10416, 32.61334], [-117.10343, 32.61347], [-117.10329, 32.61356], [-117.10315, 32.61354], [-117.10185, 32.61386], [-117.10134, 32.61391], [-117.09805, 32.61389], [-117.0981, 32.61364], [-117.10049, 32.61375], [-117.10148, 32.61376], [-117.10163, 32.61366], [-117.10181, 32.61369], [-117.10189, 32.61371], [-117.10254, 32.61349], [-117.10447, 32.61307], [-117.10485, 32.61297], [-117.10499, 32.61283], [-117.10524, 32.61279], [-117.106, 32.61235], [-117.10611, 32.61219], [-117.10625, 32.61219], [-117.10671, 32.61241], [-117.11126, 32.61384], [-117.1118, 32.61389], [-117.11182, 32.61398], [-117.11303, 32.61434], [-117.11347, 32.61429], [-117.1137, 32.61374], [-117.11377, 32.61359]]]} | Open Access 1 | 7392 | Chula Vista Wildlife Reserve | 17243 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | San Diego 4 | 64.761 | Chula Vista Wildlife Reserve | 0 | Local Conservation Area 4 | 2 | |
9051 | 9051 | 9050 | {"type": "MultiPolygon", "coordinates": [[[[-121.74811, 36.84037], [-121.74543, 36.84145], [-121.74463, 36.84106], [-121.74407, 36.84074], [-121.74335, 36.84028], [-121.74267, 36.83979], [-121.74204, 36.83925], [-121.7416, 36.83883], [-121.74132, 36.83854], [-121.74079, 36.83793], [-121.74035, 36.83733], [-121.74214, 36.83679], [-121.74112, 36.83498], [-121.74105, 36.83472], [-121.74284, 36.83471], [-121.74313, 36.83523], [-121.74319, 36.83641], [-121.74298, 36.83741], [-121.74303, 36.83802], [-121.74327, 36.83833], [-121.74358, 36.8388], [-121.74446, 36.83916], [-121.74503, 36.83945], [-121.74567, 36.83981], [-121.7469, 36.84016], [-121.74755, 36.84023], [-121.74811, 36.84037]]], [[[-121.74618, 36.82093], [-121.74511, 36.8275], [-121.74492, 36.82802], [-121.74274, 36.83083], [-121.74254, 36.83099], [-121.74174, 36.83099], [-121.74504, 36.82509], [-121.74514, 36.82461], [-121.74618, 36.82093]]], [[[-121.76322, 36.81416], [-121.76285, 36.81372], [-121.7627, 36.81373], [-121.75955, 36.81424], [-121.7514, 36.81598], [-121.75103, 36.81597], [-121.75085, 36.81605], [-121.74736, 36.8182], [-121.7467, 36.81878], [-121.74672, 36.81872], [-121.74919, 36.8163], [-121.75306, 36.81523], [-121.76193, 36.81384], [-121.76279, 36.81351], [-121.76322, 36.81416]]], [[[-121.76072, 36.85572], [-121.75963, 36.85711], [-121.75787, 36.85793], [-121.75783, 36.8579], [-121.75636, 36.85782], [-121.75564, 36.85821], [-121.75607, 36.85687], [-121.7567, 36.85712], [-121.75798, 36.85705], [-121.75926, 36.85652], [-121.75959, 36.85525], [-121.75933, 36.85394], [-121.75935, 36.85301], [-121.75969, 36.85239], [-121.76014, 36.85351], [-121.7605, 36.85466], [-121.76072, 36.85572]]], [[[-121.78009, 36.81303], [-121.77988, 36.81318], [-121.77742, 36.81323], [-121.77614, 36.81332], [-121.77508, 36.8137], [-121.77355, 36.81382], [-121.77157, 36.81358], [-121.7711, 36.8136], [-121.77036, 36.81426], [-121.76996, 36.81491], [-121.76992, 36.8157], [-121.76934, 36.81621], [-121.76829, 36.81698], [-121.76711, 36.81734], [-121.76565, 36.81736], [-121.76555, 36.81742], [-121.76494, 36.81743], [-121.76479, 36.8169], [-121.76424, 36.81608], [-121.76426, 36.81609], [-121.77109, 36.8136], [-121.77108, 36.81288], [-121.78009, 36.81277], [-121.78009, 36.81303]]], [[[-121.78782, 36.79713], [-121.78758, 36.79751], [-121.78748, 36.79779], [-121.78744, 36.79793], [-121.78745, 36.7984], [-121.78735, 36.79871], [-121.78728, 36.799], [-121.7872, 36.79914], [-121.78713, 36.7993], [-121.78711, 36.79949], [-121.78713, 36.79969], [-121.78646, 36.7993], [-121.7869, 36.79832], [-121.78689, 36.79831], [-121.78665, 36.79829], [-121.78684, 36.79719], [-121.78699, 36.7972], [-121.78704, 36.79698], [-121.78782, 36.79713]]], [[[-121.79025, 36.7907], [-121.78968, 36.79183], [-121.78832, 36.79147], [-121.78854, 36.79028], [-121.79025, 36.7907]]]]} | Open Access 1 | 14978 | Elkhorn Slough | 18571 | 2087 | Moss Landing Harbor District 902 | Special District 4 | Port/Harbor District 15 | http://mosslandingharbor.dst.ca.us/ | Special District 4 | 2087 | Moss Landing Harbor District 876 | Special District 4 | Port/Harbor District 14 | Monterey 14 | 131.427 | Elkhorn Slough | 0 | Local Conservation Area 4 | 2 | |
500 | 500 | 499 | {"type": "Polygon", "coordinates": [[[-117.1728, 32.71668], [-117.17278, 32.71676], [-117.17262, 32.71679], [-117.17261, 32.71695], [-117.1722, 32.71685], [-117.17129, 32.71683], [-117.17128, 32.71657], [-117.17223, 32.71657], [-117.17231, 32.71653], [-117.17235, 32.71589], [-117.17279, 32.71589], [-117.1728, 32.71668]]]} | Open Access 1 | 47486 | Lane Field Park | 31204 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/parks/lane-field-park.html | San Diego 4 | 1.887 | Lane Field Park | 0 | Local Recreation Area 3 | 4 |
5716 | 5716 | 5715 | {"type": "Polygon", "coordinates": [[[-120.76127, 35.1596], [-120.76127, 35.16227], [-120.75687, 35.16244], [-120.75682, 35.16235], [-120.75667, 35.1622], [-120.75662, 35.16211], [-120.75658, 35.16201], [-120.75658, 35.16191], [-120.75659, 35.16181], [-120.75663, 35.16172], [-120.75678, 35.16151], [-120.75683, 35.16138], [-120.75691, 35.16091], [-120.75688, 35.16085], [-120.75668, 35.16071], [-120.75661, 35.16063], [-120.75654, 35.16037], [-120.75654, 35.16029], [-120.75655, 35.16023], [-120.75658, 35.16025], [-120.75665, 35.16025], [-120.75773, 35.16026], [-120.75792, 35.16018], [-120.75792, 35.15968], [-120.75812, 35.15964], [-120.75861, 35.15959], [-120.75888, 35.15961], [-120.75923, 35.15968], [-120.75951, 35.15963], [-120.75963, 35.15963], [-120.75974, 35.15965], [-120.75986, 35.1597], [-120.75999, 35.15967], [-120.7603, 35.15954], [-120.76051, 35.15949], [-120.76067, 35.15951], [-120.76078, 35.15955], [-120.76098, 35.15956], [-120.76127, 35.1596]]]} | Open Access 1 | 48514 | Point San Luis Lighthouse Public Access | 33227 | 2114 | Port San Luis Harbor District 509 | Special District 4 | Port/Harbor District 15 | http://www.portsanluis.com/ | Special District 4 | 2114 | Port San Luis Harbor District 501 | Special District 4 | Port/Harbor District 14 | http://pointsanluislighthouse.org/ | San Luis Obispo 1 | 29.329 | Point San Luis Lighthouse PA | 0 | Local Recreation Area 3 | 4 |
7019 | 7019 | 7018 | {"type": "Polygon", "coordinates": [[[-118.28592, 33.71434], [-118.28588, 33.71469], [-118.28592, 33.71498], [-118.28564, 33.71556], [-118.28542, 33.71631], [-118.28546, 33.71662], [-118.28435, 33.7181], [-118.28417, 33.7184], [-118.28345, 33.71926], [-118.28338, 33.71977], [-118.28316, 33.72016], [-118.28318, 33.72028], [-118.28308, 33.72031], [-118.28345, 33.7209], [-118.28395, 33.72204], [-118.28411, 33.72244], [-118.28426, 33.72301], [-118.28445, 33.7239], [-118.28434, 33.72394], [-118.28389, 33.72397], [-118.28306, 33.72182], [-118.28152, 33.72222], [-118.28118, 33.72129], [-118.28269, 33.72088], [-118.28241, 33.72004], [-118.28248, 33.72002], [-118.28236, 33.71965], [-118.28222, 33.71969], [-118.28216, 33.71947], [-118.28226, 33.71943], [-118.28193, 33.71853], [-118.28185, 33.71854], [-118.28176, 33.71823], [-118.28044, 33.71852], [-118.28044, 33.7186], [-118.28016, 33.71866], [-118.27982, 33.71774], [-118.28155, 33.71727], [-118.28161, 33.71721], [-118.28173, 33.71692], [-118.28178, 33.71669], [-118.2815, 33.71617], [-118.28043, 33.71566], [-118.28029, 33.71561], [-118.2791, 33.71561], [-118.279, 33.71563], [-118.27841, 33.71586], [-118.27837, 33.71586], [-118.27833, 33.71583], [-118.27831, 33.71578], [-118.27832, 33.71575], [-118.2784, 33.7157], [-118.27901, 33.71552], [-118.27912, 33.7155], [-118.28029, 33.71548], [-118.28042, 33.71549], [-118.28159, 33.71607], [-118.2819, 33.71666], [-118.28264, 33.71686], [-118.28323, 33.71682], [-118.28341, 33.71662], [-118.28376, 33.71619], [-118.28391, 33.71596], [-118.28418, 33.71546], [-118.28439, 33.71495], [-118.28448, 33.71454], [-118.2845, 33.71434], [-118.28592, 33.71434]]]} | Open Access 1 | 5954 | Cabrillo Beach Marina and Recreation Complex | 29073 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | https://www.portoflosangeles.org | Los Angeles 6 | 45.403 | Cabrillo Beach Marina and Rec. Complex | 0 | Local Recreation Area 3 | 4 |
7021 | 7021 | 7020 | {"type": "Polygon", "coordinates": [[[-118.27952, 33.74733], [-118.2791, 33.74733], [-118.27909, 33.74602], [-118.2791, 33.74184], [-118.2791, 33.74155], [-118.27906, 33.7414], [-118.27932, 33.74155], [-118.2794, 33.74155], [-118.27939, 33.74317], [-118.27943, 33.74318], [-118.27946, 33.74316], [-118.27948, 33.7434], [-118.27939, 33.74341], [-118.27938, 33.74663], [-118.27939, 33.74687], [-118.27944, 33.7471], [-118.27952, 33.74733]]]} | Open Access 1 | 5963 | Harbor Boulevard Parkway | 29110 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | Los Angeles 6 | 4.463 | Harbor Boulevard Parkway | 0 | Local Recreation Area 3 | 4 | |
15055 | 15055 | 15054 | {"type": "Polygon", "coordinates": [[[-120.75792, 35.15968], [-120.75792, 35.16019], [-120.75773, 35.16026], [-120.75658, 35.16025], [-120.75652, 35.16021], [-120.75651, 35.16016], [-120.75654, 35.15984], [-120.75647, 35.15959], [-120.75648, 35.15954], [-120.75651, 35.15949], [-120.75663, 35.15949], [-120.75677, 35.15953], [-120.75692, 35.15961], [-120.75725, 35.15965], [-120.75753, 35.15962], [-120.75792, 35.15968]]]} | Open Access 1 | 48515 | Point San Luis Lighthouse Public Access | 33227 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 2114 | Port San Luis Harbor District 501 | Special District 4 | Port/Harbor District 14 | http://pointsanluislighthouse.org/ | San Luis Obispo 1 | 2.258 | Point San Luis Lighthouse PA | 0 | Local Recreation Area 3 | 4 |
496 | 496 | 495 | {"type": "Polygon", "coordinates": [[[-117.16142, 32.70441], [-117.16105, 32.7048], [-117.16002, 32.70409], [-117.15894, 32.70438], [-117.15841, 32.70444], [-117.15826, 32.70436], [-117.15952, 32.70313], [-117.16011, 32.70349], [-117.16142, 32.70441]]]} | Open Access 1 | 47480 | San Diego Bayfront Park | 31202 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/san-diego-bayfront-park.html | San Diego 4 | 5.152 | San Diego Bayfront Park | 0 | Local Park 2 | 4 |
980 | 980 | 979 | {"type": "MultiPolygon", "coordinates": [[[[-117.10428, 32.62561], [-117.10272, 32.62605], [-117.10268, 32.62598], [-117.10278, 32.62597], [-117.10427, 32.62555], [-117.10428, 32.62561]]], [[[-117.10838, 32.62958], [-117.10777, 32.62978], [-117.10679, 32.62795], [-117.10655, 32.62786], [-117.10661, 32.62779], [-117.10544, 32.62575], [-117.10444, 32.6258], [-117.10439, 32.62564], [-117.10433, 32.62565], [-117.10431, 32.62554], [-117.1058, 32.62514], [-117.10838, 32.62958]]]]} | Open Access 1 | 5495 | Bayside Park | 15899 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/chula-vista-bayside-park.html | San Diego 4 | 9.299 | Bayside Park | 0 | Local Park 2 | 4 |
2301 | 2301 | 2300 | {"type": "Polygon", "coordinates": [[[-120.73811, 35.17924], [-120.73753, 35.17954], [-120.73744, 35.17945], [-120.73689, 35.17974], [-120.73252, 35.17845], [-120.73259, 35.17824], [-120.73358, 35.17835], [-120.73447, 35.17848], [-120.73526, 35.17867], [-120.73583, 35.17877], [-120.73652, 35.17883], [-120.73712, 35.17891], [-120.73783, 35.17923], [-120.73808, 35.1791], [-120.73811, 35.17924]]]} | Open Access 1 | 16939 | Avila Beach | 15731 | 2114 | Port San Luis Harbor District 509 | Special District 4 | Port/Harbor District 15 | http://www.portsanluis.com/ | Special District 4 | 2114 | Port San Luis Harbor District 501 | Special District 4 | Port/Harbor District 14 | San Luis Obispo 1 | 7.241 | Avila Beach | 0 | Local Park 2 | 4 | |
2836 | 2836 | 2835 | {"type": "Polygon", "coordinates": [[[-117.21384, 32.72823], [-117.21312, 32.72832], [-117.20895, 32.72874], [-117.20604, 32.72901], [-117.20516, 32.72907], [-117.20513, 32.7292], [-117.20489, 32.72922], [-117.20399, 32.72923], [-117.19926, 32.72923], [-117.19849, 32.72878], [-117.1987, 32.72875], [-117.199, 32.72867], [-117.19923, 32.72864], [-117.19928, 32.72856], [-117.19939, 32.72853], [-117.19967, 32.72863], [-117.19994, 32.72869], [-117.20437, 32.72869], [-117.20737, 32.72857], [-117.20898, 32.72845], [-117.21342, 32.72796], [-117.21356, 32.72797], [-117.21373, 32.72805], [-117.21384, 32.72817], [-117.21384, 32.72823]]]} | Open Access 1 | 4 | Spanish Landing Park | 25712 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/spanish-landing-park.html | San Diego 4 | 16.066 | Spanish Landing Park | 0 | Local Park 2 | 4 |
3509 | 3509 | 3508 | {"type": "Polygon", "coordinates": [[[-117.12994, 32.62431], [-117.12988, 32.62433], [-117.1297, 32.62432], [-117.1296, 32.62435], [-117.12953, 32.6244], [-117.12951, 32.62445], [-117.12951, 32.62455], [-117.1292, 32.62461], [-117.12905, 32.62378], [-117.12872, 32.62252], [-117.12862, 32.62224], [-117.12862, 32.62214], [-117.12865, 32.62205], [-117.12875, 32.62196], [-117.12994, 32.62431]]]} | Open Access 1 | 26053 | Grand Caribe Shoreline Park | 19423 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/grand-caribe-shoreline-park.html | San Diego 4 | 3.1 | Grand Caribe Shoreline Park | 0 | Local Park 2 | 4 |
3605 | 3605 | 3604 | {"type": "Polygon", "coordinates": [[[-117.15136, 32.69642], [-117.15104, 32.69673], [-117.15091, 32.69665], [-117.15023, 32.69736], [-117.14963, 32.69696], [-117.14946, 32.69688], [-117.14928, 32.69684], [-117.14929, 32.69675], [-117.14934, 32.69665], [-117.14983, 32.69614], [-117.15032, 32.69646], [-117.15043, 32.69633], [-117.15035, 32.69627], [-117.15068, 32.69593], [-117.1509, 32.69595], [-117.15113, 32.69617], [-117.15123, 32.69631], [-117.15136, 32.69642]]]} | Open Access 1 | 29262 | Cesar E Chavez Park | 17102 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/cesar-chavez-park.html | San Diego 4 | 3.738 | Cesar E Chavez Park | 0 | Local Park 2 | 4 |
4142 | 4142 | 4141 | {"type": "MultiPolygon", "coordinates": [[[[-117.09958, 32.61991], [-117.09934, 32.62003], [-117.09922, 32.62012], [-117.09913, 32.62021], [-117.09904, 32.62033], [-117.09865, 32.62097], [-117.09833, 32.6209], [-117.09808, 32.62086], [-117.09777, 32.62086], [-117.09743, 32.62088], [-117.09725, 32.62091], [-117.09534, 32.62143], [-117.09523, 32.62115], [-117.09736, 32.62055], [-117.09738, 32.62037], [-117.09771, 32.62036], [-117.09957, 32.61984], [-117.09958, 32.61991]]], [[[-117.10451, 32.62192], [-117.10429, 32.62215], [-117.10402, 32.62226], [-117.10363, 32.62235], [-117.10342, 32.62233], [-117.10315, 32.62218], [-117.10301, 32.62193], [-117.10293, 32.62169], [-117.10295, 32.62156], [-117.10304, 32.6215], [-117.10324, 32.62143], [-117.10323, 32.62102], [-117.10295, 32.62088], [-117.10267, 32.62019], [-117.10271, 32.62001], [-117.10253, 32.61958], [-117.10263, 32.6195], [-117.10258, 32.61947], [-117.10254, 32.61939], [-117.10248, 32.61934], [-117.10239, 32.61931], [-117.10229, 32.61931], [-117.10148, 32.61952], [-117.10104, 32.61954], [-117.10069, 32.6196], [-117.10052, 32.61958], [-117.10331, 32.61879], [-117.10433, 32.62109], [-117.10451, 32.62156], [-117.10451, 32.62192]]]]} | Open Access 1 | 47479 | Chula Vista Bayfront Park | 31201 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/chula-vista-bayfront-park.html | San Diego 4 | 16.026 | Chula Vista Bayfront Park | 0 | Local Park 2 | 4 |
5250 | 5250 | 5249 | {"type": "Polygon", "coordinates": [[[-117.2247, 32.72492], [-117.22467, 32.72521], [-117.22448, 32.72521], [-117.22451, 32.72491], [-117.2247, 32.72492]]]} | Open Access 1 | 47487 | Point Loma Marina Park | 31205 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/point-loma-marina-park.html | San Diego 4 | 0.142 | Point Loma Marina Park | 0 | Local Park 2 | 4 |
5251 | 5251 | 5250 | {"type": "Polygon", "coordinates": [[[-117.173, 32.71171], [-117.17297, 32.71171], [-117.17293, 32.71166], [-117.17283, 32.71163], [-117.17279, 32.71164], [-117.17275, 32.71161], [-117.17261, 32.7116], [-117.17232, 32.71148], [-117.17195, 32.7114], [-117.17124, 32.71139], [-117.1712, 32.71138], [-117.17117, 32.71132], [-117.17117, 32.71105], [-117.17122, 32.711], [-117.17131, 32.71097], [-117.17134, 32.71077], [-117.17143, 32.71077], [-117.17144, 32.71079], [-117.17158, 32.71072], [-117.17172, 32.71061], [-117.17183, 32.71058], [-117.17182, 32.71052], [-117.17228, 32.71038], [-117.17228, 32.71033], [-117.1724, 32.71032], [-117.173, 32.71167], [-117.173, 32.71171]]]} | Open Access 1 | 47488 | Ruocco Park | 31206 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/parks/ruocco-park.html | San Diego 4 | 3.49 | Ruocco Park | 0 | Local Park 2 | 4 |
5460 | 5460 | 5459 | {"type": "Polygon", "coordinates": [[[-122.38986, 37.7765], [-122.38982, 37.77659], [-122.38764, 37.77675], [-122.38752, 37.77674], [-122.38739, 37.77668], [-122.38733, 37.77661], [-122.38731, 37.77656], [-122.3873, 37.77609], [-122.38762, 37.77606], [-122.38765, 37.77631], [-122.38769, 37.77639], [-122.38774, 37.77644], [-122.38981, 37.77634], [-122.38986, 37.7765]]]} | Open Access 1 | 6265 | Willie Mccovey Park | 27569 | 2198 | San Francisco, Port of 807 | Special District 4 | Port/Harbor District 15 | http://www.sfport.com/index.aspx?page=60 | Special District 4 | 2198 | San Francisco, Port of 786 | Special District 4 | Port/Harbor District 14 | San Francisco 13 | 1.981 | Willie Mccovey Park | 0 | Local Park 2 | 4 | |
5561 | 5561 | 5560 | {"type": "Polygon", "coordinates": [[[-117.17221, 32.6999], [-117.17211, 32.7001], [-117.17102, 32.6997], [-117.17097, 32.69967], [-117.17083, 32.69942], [-117.17076, 32.69937], [-117.17067, 32.69933], [-117.17052, 32.69934], [-117.17043, 32.69931], [-117.17024, 32.69922], [-117.17006, 32.6991], [-117.16996, 32.69911], [-117.1698, 32.69915], [-117.16962, 32.69918], [-117.16901, 32.69889], [-117.16914, 32.69885], [-117.16904, 32.69858], [-117.1698, 32.69838], [-117.17003, 32.69899], [-117.17025, 32.69908], [-117.17031, 32.69907], [-117.17053, 32.69915], [-117.17075, 32.69909], [-117.17086, 32.69913], [-117.17107, 32.69962], [-117.17145, 32.69978], [-117.17154, 32.69964], [-117.17221, 32.6999]]]} | Open Access 1 | 26054 | Coronado Landing Park | 17647 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/coronado-landing-park.html | San Diego 4 | 2.44 | Coronado Landing 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]);