superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where MNG_AGENCY = 182 and MNG_AG_TYP = 14
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Port/Harbor District · 5 ✖
MNG_AGENCY 1
- San Diego Unified Port District · 5 ✖
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13705 | 13705 | 13704 | {"type": "Polygon", "coordinates": [[[-117.1728, 32.71668], [-117.17278, 32.71676], [-117.17262, 32.71679], [-117.17261, 32.71695], [-117.17219, 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 | Lane Field Park | https://www.portofsandiego.org/parks/lane-field-park.html | 31204 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 1.889 | Lane Field Park | |
13706 | 13706 | 13705 | {"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 | Point Loma Marina Park | https://www.portofsandiego.org/point-loma-marina-park.html | 31205 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 0.142 | Point Loma Marina Park | |
13707 | 13707 | 13706 | {"type": "Polygon", "coordinates": [[[-117.173, 32.71171], [-117.17297, 32.71171], [-117.17292, 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.71096], [-117.17134, 32.71077], [-117.17143, 32.71077], [-117.17145, 32.71079], [-117.17158, 32.71072], [-117.17172, 32.71061], [-117.17183, 32.71058], [-117.17182, 32.71052], [-117.17227, 32.71038], [-117.17228, 32.71033], [-117.1724, 32.71032], [-117.173, 32.71167], [-117.173, 32.71171]]]} | Open Access 1 | Ruocco Park | https://www.portofsandiego.org/parks/ruocco-park.html | 31206 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 3.492 | Ruocco Park | |
13713 | 13713 | 13712 | {"type": "MultiPolygon", "coordinates": [[[[-117.09958, 32.61991], [-117.09934, 32.62003], [-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.09735, 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.62103], [-117.10295, 32.62088], [-117.10267, 32.62019], [-117.10271, 32.62001], [-117.10253, 32.61958], [-117.10262, 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 | Chula Vista Bayfront Park | https://www.portofsandiego.org/chula-vista-bayfront-park.html | 31201 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 16.033 | Chula Vista Bayfront Park | |
13715 | 13715 | 13714 | {"type": "Polygon", "coordinates": [[[-117.16142, 32.70441], [-117.16105, 32.7048], [-117.16002, 32.70409], [-117.15893, 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 | San Diego Bayfront Park | https://www.portofsandiego.org/san-diego-bayfront-park.html | 31202 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 5.154 | San Diego Bayfront Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);