units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

33 rows where MNG_AG_TYP = 14

View and edit SQL

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, GAP_STS

MNG_AG_TYP

  • Port/Harbor District · 33

ACCESS_TYP

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
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
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
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  
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 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 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 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 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 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 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 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 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 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
5651 5650 {"type": "MultiPolygon", "coordinates": [[[[-117.23481, 32.70867], [-117.23453, 32.70872], [-117.23408, 32.70871], [-117.23418, 32.70864], [-117.23425, 32.70854], [-117.23427, 32.70845], [-117.23425, 32.70832], [-117.23418, 32.70823], [-117.23409, 32.70816], [-117.23397, 32.70811], [-117.23384, 32.7081], [-117.2332, 32.70819], [-117.23264, 32.70834], [-117.23221, 32.70853], [-117.23165, 32.70889], [-117.2314, 32.70908], [-117.23107, 32.70939], [-117.22976, 32.71094], [-117.22935, 32.7114], [-117.22919, 32.71156], [-117.22641, 32.71385], [-117.22558, 32.71451], [-117.22521, 32.71482], [-117.2247, 32.71529], [-117.22376, 32.71604], [-117.22268, 32.71676], [-117.22233, 32.71697], [-117.22213, 32.71712], [-117.22203, 32.71721], [-117.22057, 32.71887], [-117.22052, 32.71895], [-117.22044, 32.71891], [-117.22023, 32.71914], [-117.22032, 32.71889], [-117.22032, 32.71885], [-117.22028, 32.71828], [-117.22029, 32.71823], [-117.22037, 32.71808], [-117.22051, 32.71789], [-117.221, 32.71733], [-117.22166, 32.71663], [-117.22209, 32.71624], [-117.22255, 32.71587], [-117.22259, 32.71576], [-117.22259, 32.71571], [-117.22256, 32.7156], [-117.22258, 32.71552], [-117.22263, 32.7155], [-117.2227, 32.71552], [-117.22288, 32.71581], [-117.22294, 32.71583], [-117.223, 32.71582], [-117.22352, 32.71545], [-117.22359, 32.71535], [-117.22359, 32.71527], [-117.22355, 32.71519], [-117.22343, 32.7151], [-117.22337, 32.71509], [-117.22324, 32.71512], [-117.22305, 32.71531], [-117.22294, 32.71538], [-117.22288, 32.7154], [-117.22283, 32.71537], [-117.22282, 32.71532], [-117.22284, 32.71528], [-117.22318, 32.71503], [-117.22326, 32.71498], [-117.22333, 32.71496], [-117.22359, 32.71496], [-117.22444, 32.71469], [-117.22509, 32.71442], [-117.22538, 32.7142], [-117.22733, 32.71264], [-117.22804, 32.71212], [-117.22831, 32.71185], [-117.22845, 32.71176], [-117.22872, 32.71147], [-117.22895, 32.71127], [-117.22913, 32.71108], [-117.22931, 32.71093], [-117.22995, 32.71027], [-117.23028, 32.70993], [-117.23097, 32.70915], [-117.23127, 32.70889], [-117.2315, 32.70871], [-117.23181, 32.70851], [-117.23209, 32.70837], [-117.23238, 32.70825], [-117.23287, 32.70809], [-117.23317, 32.70801], [-117.23344, 32.70796], [-117.23399, 32.70792], [-117.23433, 32.70793], [-117.23443, 32.70795], [-117.23463, 32.70801], [-117.2348, 32.70812], [-117.23485, 32.70838], [-117.23484, 32.70853], [-117.23481, 32.70867]], [[-117.22404, 32.71529], [-117.22399, 32.7153], [-117.22388, 32.71543], [-117.22374, 32.71553], [-117.22381, 32.71562], [-117.22391, 32.71555], [-117.22389, 32.71552], [-117.22411, 32.71534], [-117.22404, 32.71529]]], [[[-117.22229, 32.71844], [-117.22218, 32.71849], [-117.2221, 32.71854], [-117.222, 32.71866], [-117.22197, 32.71865], [-117.2213, 32.71939], [-117.22119, 32.71932], [-117.22109, 32.7194], [-117.22101, 32.71944], [-117.22088, 32.71946], [-117.22077, 32.71945], [-117.22068, 32.71941], [-117.2206, 32.71937], [-117.22054, 32.7193], [-117.22049, 32.71923], [-117.22047, 32.71911], [-117.2205, 32.71899], [-117.2205, 32.7191], [-117.22052, 32.71921], [-117.22058, 32.71929], [-117.22065, 32.71935], [-117.22077, 32.7194], [-117.22086, 32.71941], [-117.22098, 32.7194], [-117.22105, 32.71937], [-117.22116, 32.71929], [-117.22208, 32.71822], [-117.22229, 32.71844]]], [[[-117.23342, 32.70851], [-117.23331, 32.70845], [-117.2333, 32.70838], [-117.23334, 32.70831], [-117.2334, 32.70828], [-117.23375, 32.70824], [-117.23389, 32.70823], [-117.23402, 32.70827], [-117.23408, 32.70832], [-117.23413, 32.70844], [-117.23412, 32.70854], [-117.23408, 32.70859], [-117.23403, 32.70863], [-117.23391, 32.70867], [-117.23384, 32.70867], [-117.23371, 32.70863], [-117.23342, 32.70851]]]]} Open Access 1 2 Shelter Island Shoreline Park 25388 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/shelter-island-shoreline-park.html San Diego 4 22.918 Shelter Island Shoreline Park 0 Local Park 2 4
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
5774 5773 {"type": "MultiPolygon", "coordinates": [[[[-117.21277, 32.72409], [-117.21242, 32.72415], [-117.21242, 32.72416], [-117.21255, 32.72421], [-117.21263, 32.72426], [-117.21269, 32.72434], [-117.21273, 32.72447], [-117.21271, 32.72458], [-117.21263, 32.72468], [-117.21253, 32.72474], [-117.21242, 32.72477], [-117.21231, 32.72477], [-117.2122, 32.72474], [-117.21211, 32.72467], [-117.21204, 32.72457], [-117.21198, 32.72453], [-117.21186, 32.72448], [-117.21175, 32.72447], [-117.20891, 32.72485], [-117.20875, 32.72489], [-117.20862, 32.72495], [-117.2083, 32.72515], [-117.20804, 32.72523], [-117.20804, 32.72522], [-117.2082, 32.72517], [-117.20834, 32.7251], [-117.20868, 32.7249], [-117.20886, 32.72484], [-117.2118, 32.72445], [-117.2119, 32.72447], [-117.21199, 32.72452], [-117.21206, 32.72457], [-117.21214, 32.72467], [-117.21222, 32.72472], [-117.21233, 32.72475], [-117.21247, 32.72475], [-117.21257, 32.7247], [-117.21265, 32.72462], [-117.21269, 32.72452], [-117.21269, 32.72443], [-117.21265, 32.72433], [-117.21257, 32.72426], [-117.21247, 32.72421], [-117.21235, 32.7242], [-117.20882, 32.72469], [-117.20868, 32.72472], [-117.20855, 32.72478], [-117.20818, 32.72501], [-117.20794, 32.72508], [-117.20575, 32.72528], [-117.20556, 32.72526], [-117.20516, 32.72509], [-117.20502, 32.72505], [-117.20491, 32.72504], [-117.20472, 32.72506], [-117.19821, 32.72516], [-117.19534, 32.72498], [-117.19334, 32.72482], [-117.19051, 32.72449], [-117.1898, 32.72438], [-117.1897, 32.72439], [-117.18962, 32.72441], [-117.1895, 32.7245], [-117.18954, 32.72421], [-117.19152, 32.72448], [-117.1935, 32.72472], [-117.19748, 32.725], [-117.20082, 32.72506], [-117.20418, 32.72498], [-117.20622, 32.72484], [-117.20787, 32.72469], [-117.20964, 32.72449], [-117.21135, 32.72425], [-117.21275, 32.72401], [-117.21277, 32.72409]]], [[[-117.18975, 32.72447], [-117.18983, 32.72447], [-117.1899, 32.72451], [-117.18995, 32.72456], [-117.18998, 32.72463], [-117.18998, 32.72469], [-117.18995, 32.72476], [-117.18988, 32.72481], [-117.1898, 32.72484], [-117.18971, 32.72484], [-117.18963, 32.72481], [-117.18957, 32.72475], [-117.18954, 32.72469], [-117.18955, 32.72461], [-117.18959, 32.72453], [-117.18967, 32.72448], [-117.18975, 32.72447]]], [[[-117.19031, 32.72454], [-117.19017, 32.72458], [-117.19008, 32.72464], [-117.19006, 32.72456], [-117.19002, 32.7245], [-117.19031, 32.72454]]], [[[-117.21235, 32.72429], [-117.21245, 32.7243], [-117.21253, 32.72435], [-117.21257, 32.7244], [-117.21259, 32.72447], [-117.21259, 32.72454], [-117.21254, 32.72461], [-117.21248, 32.72466], [-117.21238, 32.72468], [-117.21228, 32.72467], [-117.2122, 32.72463], [-117.21214, 32.72456], [-117.21212, 32.72448], [-117.21214, 32.72441], [-117.21219, 32.72434], [-117.21226, 32.7243], [-117.21235, 32.72429]]]]} Open Access 1 3 Harbor Island Park 19664 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/harbor-island-park.html San Diego 4 9.626 Harbor Island Park 0 Local Park 2 4
6071 6070 {"type": "Polygon", "coordinates": [[[-117.17247, 32.69894], [-117.17197, 32.69981], [-117.17153, 32.69964], [-117.17205, 32.69877], [-117.17247, 32.69894]]]} Open Access 1 809 Centennial Park 33718 1069 Coronado, City of 105 City 2 City Agency 2 http://www.coronado.ca.us/category/subcategory-rec.php City 2 2133 San Diego Unified Port District 182 Special District 4 Port/Harbor District 14 https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814369 San Diego 4 1.186 Centennial Park 0 Local Park 2 4
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
7020 7019 {"type": "Polygon", "coordinates": [[[-118.28054, 33.74937], [-118.28035, 33.74943], [-118.28005, 33.74926], [-118.27972, 33.749], [-118.27957, 33.74883], [-118.27934, 33.74842], [-118.27924, 33.74812], [-118.27912, 33.74757], [-118.27911, 33.74733], [-118.27952, 33.74733], [-118.27958, 33.74747], [-118.28053, 33.74908], [-118.28054, 33.74937]]]} Open Access 1 5962 Gateway Plaza 29103 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 3.492 Gateway Plaza 0 Local Park 2 4
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 78.681ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette