superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
- Open Access 408
- No Public Access 14
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 433
MNG_AGENCY 1
- San Diego, City of · 433 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11509 | 11509 | 11508 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | Zena Mini-Park | 27862 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.067 | Zena Mini-Park | ||
12845 | 12845 | 12844 | {"type": "Polygon", "coordinates": [[[-117.10971, 32.69341], [-117.1097, 32.69341], [-117.10898, 32.69341], [-117.1097, 32.69303], [-117.10971, 32.69341]]]} | Open Access 1 | Z Street Mini-Park | 30067 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.357 | Z Street Mini-Park | ||
12983 | 12983 | 12982 | {"type": "Polygon", "coordinates": [[[-117.16111, 32.91491], [-117.16107, 32.91492], [-117.161, 32.91469], [-117.16087, 32.91473], [-117.16085, 32.91471], [-117.16012, 32.91494], [-117.15918, 32.91534], [-117.15885, 32.91546], [-117.15905, 32.91521], [-117.1591, 32.91494], [-117.15889, 32.9146], [-117.15954, 32.9146], [-117.15962, 32.91441], [-117.15971, 32.91442], [-117.15977, 32.91439], [-117.15981, 32.91435], [-117.15982, 32.91427], [-117.15997, 32.91393], [-117.15996, 32.91391], [-117.15982, 32.91391], [-117.15982, 32.91379], [-117.16087, 32.91379], [-117.16087, 32.91463], [-117.16095, 32.91466], [-117.16103, 32.91465], [-117.16111, 32.91491]]]} | Open Access 1 | Winterwood Lane Neighborhood Park | 30218 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 4.335 | Winterwood Lane Neighborhood Park | ||
12920 | 12920 | 12919 | {"type": "Polygon", "coordinates": [[[-117.22565, 32.94823], [-117.22556, 32.94851], [-117.22548, 32.94884], [-117.22537, 32.94883], [-117.22534, 32.94875], [-117.22529, 32.94871], [-117.22492, 32.94855], [-117.22507, 32.94829], [-117.22475, 32.94814], [-117.22487, 32.94786], [-117.22494, 32.94784], [-117.22564, 32.94821], [-117.22565, 32.94823]]]} | Open Access 1 | Windwood Mini-Park | 30155 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.203 | Windwood Mini-Park | ||
12857 | 12857 | 12856 | {"type": "MultiPolygon", "coordinates": [[[[-117.28146, 32.83159], [-117.28102, 32.83168], [-117.28046, 32.82992], [-117.28048, 32.82989], [-117.281, 32.82977], [-117.28102, 32.82982], [-117.28103, 32.83024], [-117.2811, 32.83061], [-117.28137, 32.83085], [-117.28127, 32.83117], [-117.28139, 32.83138], [-117.28146, 32.83159]]], [[[-117.28234, 32.83273], [-117.28232, 32.83307], [-117.28222, 32.83335], [-117.28198, 32.83379], [-117.28194, 32.83384], [-117.28185, 32.83405], [-117.28183, 32.83436], [-117.28173, 32.83463], [-117.28173, 32.83468], [-117.28151, 32.83466], [-117.28153, 32.83456], [-117.28171, 32.83441], [-117.28164, 32.83425], [-117.28158, 32.83422], [-117.28176, 32.83378], [-117.28174, 32.83366], [-117.28165, 32.83358], [-117.28183, 32.83336], [-117.28187, 32.83309], [-117.2818, 32.83286], [-117.28234, 32.83273]]]]} | Open Access 1 | Windansea Beach | 30082 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.77 | Windansea Beach | ||
12886 | 12886 | 12885 | {"type": "Polygon", "coordinates": [[[-117.08637, 32.74748], [-117.08588, 32.74812], [-117.08552, 32.74818], [-117.08531, 32.74818], [-117.0859, 32.74739], [-117.08612, 32.74746], [-117.08637, 32.74748]]]} | Open Access 1 | Wightman Street Neighborhood Park | 30121 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.974 | Wightman Street Neighborhood Park | ||
11157 | 11157 | 11156 | {"type": "Polygon", "coordinates": [[[-117.12117, 32.92243], [-117.12114, 32.92415], [-117.11938, 32.9242], [-117.11931, 32.92417], [-117.11913, 32.9225], [-117.11913, 32.92238], [-117.12117, 32.92243]]]} | Open Access 1 | Westview Park | 27432 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 8.819 | Westview Park | ||
12930 | 12930 | 12929 | {"type": "Polygon", "coordinates": [[[-117.19827, 32.78629], [-117.19822, 32.78654], [-117.19813, 32.78655], [-117.19802, 32.78715], [-117.19689, 32.78688], [-117.19654, 32.78708], [-117.19612, 32.78764], [-117.19569, 32.78779], [-117.19555, 32.78777], [-117.19465, 32.78693], [-117.1948, 32.78573], [-117.19718, 32.78581], [-117.19821, 32.78595], [-117.19817, 32.78626], [-117.19827, 32.78629]]]} | Open Access 1 | Western Hills Neighborhood Park | 30165 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 12.879 | Western Hills Neighborhood Park | ||
12965 | 12965 | 12964 | {"type": "Polygon", "coordinates": [[[-117.16575, 32.73251], [-117.16563, 32.73264], [-117.16531, 32.73292], [-117.16531, 32.73252], [-117.16575, 32.73251]]]} | Open Access 1 | West Maple Canyon Mini-Park | 30201 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.242 | West Maple Canyon Mini-Park | ||
12964 | 12964 | 12963 | {"type": "Polygon", "coordinates": [[[-117.17153, 32.7519], [-117.1707, 32.75191], [-117.17051, 32.75205], [-117.17051, 32.75178], [-117.17134, 32.75177], [-117.17134, 32.75182], [-117.1714, 32.75187], [-117.17153, 32.7519]]]} | Open Access 1 | West Lewis Mini-Park | 30200 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.331 | West Lewis Mini-Park | ||
14107 | 14107 | 14106 | {"type": "Polygon", "coordinates": [[[-117.21811, 32.87657], [-117.21809, 32.87661], [-117.218, 32.87664], [-117.21697, 32.87666], [-117.21654, 32.87677], [-117.2164, 32.87634], [-117.21541, 32.87589], [-117.21425, 32.87618], [-117.21425, 32.87547], [-117.21431, 32.87534], [-117.21436, 32.87529], [-117.21448, 32.87522], [-117.21463, 32.87518], [-117.21746, 32.87517], [-117.21749, 32.87594], [-117.21811, 32.8764], [-117.21811, 32.87657]]]} | Open Access 1 | Weiss Mandell Eastgate Neighborhood Park | 31539 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 9.759 | Weiss Mandell Eastgate Neighborhood Park | ||
14761 | 14761 | 14760 | {"type": "Polygon", "coordinates": [[[-117.22892, 32.73309], [-117.22881, 32.73321], [-117.22872, 32.73319], [-117.22845, 32.73238], [-117.22814, 32.73121], [-117.22805, 32.73081], [-117.22812, 32.73078], [-117.22825, 32.73086], [-117.22819, 32.73095], [-117.22843, 32.73188], [-117.2287, 32.73205], [-117.22876, 32.73233], [-117.2286, 32.73251], [-117.22875, 32.73299], [-117.22892, 32.73309]]]} | Open Access 1 | Wawona Drive Open Space | 27321 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.991 | Wawona Drive OS | ||
12985 | 12985 | 12984 | {"type": "Polygon", "coordinates": [[[-117.11138, 32.76116], [-117.11137, 32.76138], [-117.11103, 32.7615], [-117.11104, 32.76166], [-117.1111, 32.76169], [-117.11122, 32.76219], [-117.11103, 32.7622], [-117.11101, 32.76317], [-117.11024, 32.76315], [-117.11018, 32.76308], [-117.11018, 32.76263], [-117.11015, 32.76247], [-117.11008, 32.76227], [-117.10976, 32.76158], [-117.10968, 32.76134], [-117.10965, 32.76112], [-117.11015, 32.76113], [-117.11016, 32.7615], [-117.11019, 32.76148], [-117.1102, 32.76115], [-117.11138, 32.76116]]]} | Open Access 1 | Ward Canyon Neighborhood Park | 30220 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 5.782 | Ward Canyon Neighborhood Park | ||
12978 | 12978 | 12977 | {"type": "Polygon", "coordinates": [[[-117.08852, 32.70427], [-117.08852, 32.70444], [-117.08831, 32.70444], [-117.08831, 32.70431], [-117.08833, 32.70428], [-117.08852, 32.70427]]]} | Open Access 1 | Walls of Excellence Mini-Park | 30213 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.087 | Walls of Excellence Mini-Park | ||
10969 | 10969 | 10968 | {"type": "Polygon", "coordinates": [[[-117.08751, 32.73595], [-117.087, 32.73677], [-117.08672, 32.73676], [-117.08688, 32.73654], [-117.08677, 32.73643], [-117.08694, 32.73621], [-117.08711, 32.73629], [-117.08739, 32.73587], [-117.08751, 32.73595]]]} | Open Access 1 | Wadsworths Olive Grove Open Space | 27207 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.604 | Wadsworths Olive Grove OS | ||
11450 | 11450 | 11449 | {"type": "Polygon", "coordinates": [[[-117.12088, 32.74978], [-117.12063, 32.74969], [-117.12063, 32.74952], [-117.12075, 32.74941], [-117.12088, 32.74978]]]} | Open Access 1 | Wabash Neighborhood Park | 30119 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.131 | Wabash Neighborhood Park | ||
12874 | 12874 | 12873 | {"type": "Polygon", "coordinates": [[[-117.05208, 32.56306], [-117.05206, 32.56544], [-117.05184, 32.56544], [-117.05183, 32.56546], [-117.0516, 32.56549], [-117.05149, 32.56553], [-117.05129, 32.56565], [-117.05116, 32.5658], [-117.0511, 32.5659], [-117.05106, 32.56593], [-117.05063, 32.56584], [-117.05045, 32.56579], [-117.05028, 32.56573], [-117.05012, 32.56564], [-117.04998, 32.56554], [-117.04986, 32.56543], [-117.05098, 32.56543], [-117.051, 32.56306], [-117.05208, 32.56306]]]} | Open Access 1 | Vista Terrace Neighborhood Park | 30104 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7.995 | Vista Terrace Neighborhood Park | ||
12852 | 12852 | 12851 | {"type": "Polygon", "coordinates": [[[-117.00638, 32.58097], [-117.00631, 32.58213], [-117.00619, 32.58221], [-117.00617, 32.58226], [-117.00617, 32.58231], [-117.00619, 32.58235], [-117.00624, 32.58239], [-117.00632, 32.58241], [-117.00631, 32.58265], [-117.0055, 32.58251], [-117.00507, 32.5824], [-117.00458, 32.58233], [-117.00457, 32.58225], [-117.00445, 32.58216], [-117.00471, 32.58193], [-117.0045, 32.58174], [-117.00455, 32.58167], [-117.00487, 32.58116], [-117.00491, 32.58104], [-117.00497, 32.5808], [-117.005, 32.58074], [-117.00503, 32.58071], [-117.00508, 32.58071], [-117.00531, 32.58081], [-117.00558, 32.58088], [-117.00577, 32.58091], [-117.00632, 32.58093], [-117.00635, 32.58094], [-117.00638, 32.58097]]]} | Open Access 1 | Vista Pacifica Neighborhood Park | 30077 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6.881 | Vista Pacifica Neighborhood Park | ||
13024 | 13024 | 13023 | {"type": "Polygon", "coordinates": [[[-117.11064, 32.73711], [-117.11063, 32.73738], [-117.11017, 32.73738], [-117.11017, 32.73711], [-117.11064, 32.73711]]]} | Open Access 1 | Virgie Hazel McCain and William Henry Carter Mini Park | 30270 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.323 | Virgie Hazel McCain and William Henry Carter MP | ||
12863 | 12863 | 12862 | {"type": "Polygon", "coordinates": [[[-117.08963, 32.83691], [-117.0884, 32.83738], [-117.08779, 32.83622], [-117.08876, 32.83529], [-117.08963, 32.83691]]]} | Open Access 1 | Villa Norte Neighborhood Park | 30088 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 5.242 | Villa Norte Neighborhood 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]);