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 SUID_NMA
This data as json, copyable, CSV (advanced)
MNG_AGENCY 3
DES_TP 2
MNG_AG_TYP 1
- Port/Harbor District · 13 ✖
MNG_AG_LEV 1 ✖
ACCESS_TYP 1
- Open Access 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7020 | 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 | 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 | |
7022 | 7022 | 7021 | {"type": "Polygon", "coordinates": [[[-118.2842, 33.74996], [-118.28396, 33.75], [-118.28374, 33.75009], [-118.28364, 33.75019], [-118.28346, 33.75047], [-118.28311, 33.75031], [-118.28295, 33.75006], [-118.28377, 33.74976], [-118.28397, 33.74971], [-118.28417, 33.74968], [-118.2842, 33.74996]]]} | Open Access 1 | 5970 | Knoll Hill Dog Park | 29113 | 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 | 1.1 | Knoll Hill Dog Park | 0 | Local Park 2 | 4 | |
15341 | 15341 | 15340 | {"type": "Polygon", "coordinates": [[[-118.27845, 33.7717], [-118.27842, 33.77173], [-118.27628, 33.77185], [-118.27622, 33.77118], [-118.27493, 33.77125], [-118.27471, 33.77127], [-118.27476, 33.77189], [-118.27471, 33.77193], [-118.2677, 33.77232], [-118.26765, 33.77179], [-118.26713, 33.77182], [-118.26707, 33.77111], [-118.26709, 33.77108], [-118.26712, 33.77107], [-118.27804, 33.77047], [-118.27817, 33.7705], [-118.27844, 33.77049], [-118.27848, 33.7705], [-118.2785, 33.77054], [-118.27845, 33.7717]]]} | Open Access 1 | 46523 | Wilmington Waterfront Park | 29811 | 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/recreation/wwpark.asp | Los Angeles 6 | 33.444 | Wilmington Waterfront 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 |
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 |
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 |
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 |
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 |
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 |
8286 | 8286 | 8285 | {"type": "Polygon", "coordinates": [[[-117.168, 32.69221], [-117.16798, 32.69238], [-117.16772, 32.69284], [-117.16768, 32.69298], [-117.16768, 32.69312], [-117.16744, 32.69323], [-117.16734, 32.69334], [-117.16727, 32.69348], [-117.16719, 32.69358], [-117.16703, 32.69353], [-117.16679, 32.69349], [-117.16635, 32.69346], [-117.16612, 32.69339], [-117.16582, 32.69326], [-117.16554, 32.69305], [-117.16528, 32.69289], [-117.16493, 32.69278], [-117.16459, 32.6927], [-117.16439, 32.69259], [-117.16415, 32.69237], [-117.16415, 32.69213], [-117.16422, 32.69183], [-117.16433, 32.69157], [-117.16443, 32.69125], [-117.16462, 32.6905], [-117.16484, 32.68974], [-117.16528, 32.69013], [-117.16569, 32.6904], [-117.16573, 32.69051], [-117.16574, 32.69059], [-117.16563, 32.69067], [-117.16563, 32.69069], [-117.16582, 32.69074], [-117.16597, 32.69082], [-117.16685, 32.69144], [-117.16739, 32.69168], [-117.16781, 32.69188], [-117.16791, 32.69198], [-117.168, 32.69221]]]} | Open Access 1 | 12676 | Tidelands Park | 33716 | 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-tidelands-park.html | San Diego 4 | 20.484 | Tidelands Park | 0 | Local Park 2 | 4 |
6071 | 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 |
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]);