units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
533 rows where MNG_AGENCY = 4 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST, GAP_STS
DES_TP 21
- Local Park 281
- Local Recreation Area 211
- Local Other or Unknown 15
- Local Conservation Area 9
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_WEB 7 ✖
ACCESS_TYP 4
- Open Access 503
- No Public Access 19
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 533
MNG_AGENCY 1
- San Diego, City of · 533 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5775 | 5775 | 5774 | {"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 | 5 | Zena Mini-Park | 27862 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
3990 | 3990 | 3989 | {"type": "Polygon", "coordinates": [[[-117.10971, 32.69341], [-117.10971, 32.69341], [-117.10898, 32.69341], [-117.1097, 32.69303], [-117.10971, 32.69341]]]} | Open Access 1 | 46700 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.357 | Z Street Mini-Park | 0 | Local Park 2 | 4 | |
3693 | 3693 | 3692 | {"type": "Polygon", "coordinates": [[[-117.16111, 32.91491], [-117.16107, 32.91492], [-117.161, 32.91469], [-117.16087, 32.91473], [-117.16085, 32.9147], [-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.91461], [-117.15962, 32.91441], [-117.1597, 32.91442], [-117.15977, 32.91439], [-117.15981, 32.91435], [-117.15982, 32.91428], [-117.15997, 32.91393], [-117.15996, 32.91391], [-117.15982, 32.91391], [-117.15982, 32.91379], [-117.16087, 32.91379], [-117.16087, 32.91464], [-117.16095, 32.91466], [-117.16103, 32.91465], [-117.16111, 32.91491]]]} | Open Access 1 | 46766 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.329 | Winterwood Lane Neighborhood Park | 0 | Local Park 2 | 4 | |
4833 | 4833 | 4832 | {"type": "Polygon", "coordinates": [[[-117.22565, 32.94823], [-117.22556, 32.94851], [-117.22548, 32.94884], [-117.22537, 32.94883], [-117.22534, 32.94874], [-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 | 46724 | Windwood Mini-Park | 30155 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.2 | Windwood Mini-Park | 0 | Local Park 2 | 4 | |
1313 | 1313 | 1312 | {"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.83306], [-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.28172, 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 | 7343 | Windansea Beach | 30082 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.766 | Windansea Beach | 0 | Local Park 2 | 4 | |
10721 | 10721 | 10720 | {"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 | 19916 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.974 | Wightman Street Neighborhood Park | 0 | Local Park 2 | 4 | |
61 | 61 | 60 | {"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 | 146 | Westview Park | 27432 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.82 | Westview Park | 0 | Local Park 2 | 4 | |
99 | 99 | 98 | {"type": "Polygon", "coordinates": [[[-117.19827, 32.78629], [-117.19822, 32.78654], [-117.19813, 32.78654], [-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.19816, 32.78627], [-117.19827, 32.78629]]]} | Open Access 1 | 266 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.876 | Western Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
14698 | 14698 | 14697 | {"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 | 46749 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.242 | West Maple Canyon Mini-Park | 0 | Local Park 2 | 4 | |
5054 | 5054 | 5053 | {"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 | 46748 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.33 | West Lewis Mini-Park | 0 | Local Park 2 | 4 | |
8009 | 8009 | 8008 | {"type": "Polygon", "coordinates": [[[-117.21811, 32.87657], [-117.21809, 32.87661], [-117.218, 32.87664], [-117.21696, 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 | 47736 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.754 | Weiss Mandell Eastgate Neighborhood Park | 0 | Local Park 2 | 4 | |
15524 | 15524 | 15523 | {"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 | 202 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.988 | Wawona Drive OS | 0 | Local Recreation Area 3 | 4 | |
10595 | 10595 | 10594 | {"type": "Polygon", "coordinates": [[[-117.11138, 32.76116], [-117.11137, 32.76138], [-117.11103, 32.76149], [-117.11104, 32.76166], [-117.11109, 32.76169], [-117.11122, 32.76219], [-117.11103, 32.76219], [-117.11101, 32.76317], [-117.11024, 32.76315], [-117.11018, 32.76308], [-117.11018, 32.76263], [-117.11015, 32.76247], [-117.11009, 32.76227], [-117.10976, 32.76158], [-117.10968, 32.76134], [-117.10965, 32.76112], [-117.11015, 32.76113], [-117.11015, 32.76151], [-117.11019, 32.76149], [-117.1102, 32.76115], [-117.11138, 32.76116]]]} | Open Access 1 | 18869 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.772 | Ward Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
5821 | 5821 | 5820 | {"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 | 46762 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.087 | Walls of Excellence Mini-Park | 0 | Local Park 2 | 4 | |
15556 | 15556 | 15555 | {"type": "Polygon", "coordinates": [[[-117.08751, 32.73595], [-117.087, 32.73677], [-117.08672, 32.73676], [-117.08689, 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 | 45200 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.601 | Wadsworths Olive Grove OS | 0 | Local Recreation Area 3 | 4 | |
5776 | 5776 | 5775 | {"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 | 6 | Wabash Neighborhood Park | 30119 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.131 | Wabash Neighborhood Park | 0 | Local Park 2 | 4 | |
3375 | 3375 | 3374 | {"type": "Polygon", "coordinates": [[[-117.05208, 32.56306], [-117.05206, 32.56544], [-117.05183, 32.56544], [-117.05183, 32.56546], [-117.0516, 32.56549], [-117.0515, 32.56553], [-117.05129, 32.56565], [-117.05116, 32.56581], [-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 | 1077 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.984 | Vista Terrace Neighborhood Park | 0 | Local Park 2 | 4 | |
6232 | 6232 | 6231 | {"type": "Polygon", "coordinates": [[[-117.00638, 32.58097], [-117.00631, 32.58213], [-117.00619, 32.58221], [-117.00617, 32.58225], [-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.58192], [-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 | 1312 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 6.878 | Vista Pacifica Neighborhood Park | 0 | Local Park 2 | 4 | |
11495 | 11495 | 11494 | {"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 | 29580 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.323 | Virgie Hazel McCain and William Henry Carter MP | 0 | Local Park 2 | 4 | |
5874 | 5874 | 5873 | {"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 | 259 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.242 | Villa Norte Neighborhood 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]);