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 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Port/Harbor District · 8 ✖
MNG_AGENCY 1
- San Diego Unified Port District · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8057 | 8057 | 8056 | {"type": "Polygon", "coordinates": [[[-117.11233, 32.64966], [-117.11225, 32.64969], [-117.11193, 32.65041], [-117.11195, 32.65049], [-117.11066, 32.65086], [-117.11106, 32.65199], [-117.11099, 32.65202], [-117.11048, 32.6507], [-117.1105, 32.65067], [-117.11054, 32.65064], [-117.11136, 32.65041], [-117.11141, 32.65038], [-117.11141, 32.65033], [-117.11117, 32.64971], [-117.11113, 32.64967], [-117.11105, 32.64966], [-117.11112, 32.64944], [-117.11189, 32.64922], [-117.11197, 32.64925], [-117.11233, 32.64966]]]} | Open Access 1 | Pepper Park | https://www.portofsandiego.org/pepper-park.html | 23593 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 3.561 | Pepper 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 | |
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 | |
9585 | 9585 | 9584 | {"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.7189], [-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.7158], [-117.22294, 32.71583], [-117.223, 32.71582], [-117.22351, 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.22306, 32.7153], [-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.22803, 32.71212], [-117.22831, 32.71185], [-117.22846, 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.23343, 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.22405, 32.71529], [-117.22399, 32.7153], [-117.22388, 32.71543], [-117.22375, 32.71553], [-117.22381, 32.71561], [-117.22391, 32.71556], [-117.22389, 32.71552], [-117.2241, 32.71535], [-117.22405, 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.71933], [-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.23413, 32.70844], [-117.23412, 32.70854], [-117.23403, 32.70863], [-117.23391, 32.70867], [-117.23385, 32.70867], [-117.23342, 32.70851], [-117.23331, 32.70845], [-117.2333, 32.70838], [-117.23334, 32.70831], [-117.2334, 32.70828], [-117.23389, 32.70823], [-117.23402, 32.70827], [-117.23408, 32.70832], [-117.23413, 32.70844]]]]} | Open Access 1 | Shelter Island Shoreline Park | https://www.portofsandiego.org/shelter-island-shoreline-park.html | 25388 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 22.914 | Shelter Island Shoreline Park | |
9845 | 9845 | 9844 | {"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 | Spanish Landing Park | https://www.portofsandiego.org/spanish-landing-park.html | 25712 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 16.067 | Spanish Landing Park | |
10392 | 10392 | 10391 | {"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.69333], [-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.16529, 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 | Tidelands Park | https://www.portofsandiego.org/coronado-tidelands-park.html | 33716 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 20.485 | Tidelands Park | |
9017 | 9017 | 9016 | {"type": "Polygon", "coordinates": [[[-117.17579, 32.71281], [-117.1746, 32.71317], [-117.17452, 32.71313], [-117.17443, 32.71295], [-117.17382, 32.71267], [-117.17399, 32.71259], [-117.17438, 32.71261], [-117.17456, 32.71266], [-117.17477, 32.71274], [-117.17493, 32.71276], [-117.17507, 32.71274], [-117.17542, 32.71257], [-117.1757, 32.71253], [-117.17579, 32.71281]]]} | Open Access 1 | Tuna Harbor Park | https://www.portofsandiego.org/tuna-harbor-park.html | 26575 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 1.512 | Tuna Harbor 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]);