superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4 and MNG_AG_TYP = 2 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14889 | 14889 | 14888 | {"type": "Polygon", "coordinates": [[[-117.25989, 32.84535], [-117.25988, 32.84542], [-117.25976, 32.84547], [-117.25976, 32.84541], [-117.25979, 32.84531], [-117.25984, 32.84528], [-117.25985, 32.84529], [-117.25988, 32.84531], [-117.25989, 32.84535]]]} | Open Access 1 | Ludington Heights Open Space Park East | 21583 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.042 | Ludington Heights OS Park East | ||
12036 | 12036 | 12035 | {"type": "Polygon", "coordinates": [[[-117.24193, 32.80867], [-117.24174, 32.80869], [-117.24161, 32.80874], [-117.24159, 32.80866], [-117.2419, 32.80859], [-117.24193, 32.80867]]]} | Open Access 1 | Color Mini-Park | 30090 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.058 | Color Mini-Park | ||
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 | ||
14892 | 14892 | 14891 | {"type": "Polygon", "coordinates": [[[-117.26515, 32.8438], [-117.26511, 32.84397], [-117.26505, 32.84395], [-117.26498, 32.84389], [-117.26497, 32.84379], [-117.26498, 32.84377], [-117.26501, 32.84375], [-117.26509, 32.84374], [-117.26513, 32.84377], [-117.26515, 32.8438]]]} | Open Access 1 | Ludington Heights Open Space Park West | 21584 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.075 | Ludington Heights OS Park West | ||
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 | ||
11439 | 11439 | 11438 | {"type": "Polygon", "coordinates": [[[-117.23713, 32.71023], [-117.23714, 32.71027], [-117.23708, 32.71051], [-117.23699, 32.71048], [-117.23698, 32.7103], [-117.23704, 32.71021], [-117.23713, 32.71023]]]} | Open Access 1 | McCall Street Mini-Park | 30099 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.089 | McCall Street Mini-Park | ||
14907 | 14907 | 14906 | {"type": "Polygon", "coordinates": [[[-117.10949, 32.77704], [-117.10951, 32.77714], [-117.10945, 32.77755], [-117.10939, 32.77756], [-117.10944, 32.77714], [-117.10941, 32.77704], [-117.10949, 32.77704]]]} | Open Access 1 | Mission Valley Slopes #2 Open Space | 22317 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.095 | Mission Valley Slopes #2 OS | ||
12873 | 12873 | 12872 | {"type": "Polygon", "coordinates": [[[-117.14353, 32.71085], [-117.14337, 32.71085], [-117.14337, 32.71057], [-117.14353, 32.71057], [-117.14353, 32.71085]]]} | Open Access 1 | Sherman Mini-Park | 30102 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.117 | Sherman Mini-Park | ||
720 | 720 | 719 | {"type": "Polygon", "coordinates": [[[-117.16091, 32.71066], [-117.16057, 32.71067], [-117.16057, 32.71053], [-117.16091, 32.71052], [-117.16091, 32.71066]]]} | Open Access 1 | Davis House Mini Park | 17950 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.118 | Davis House MP | ||
12884 | 12884 | 12883 | {"type": "Polygon", "coordinates": [[[-117.2351, 32.72159], [-117.23488, 32.72151], [-117.23474, 32.72148], [-117.23481, 32.72123], [-117.23487, 32.72124], [-117.23492, 32.72139], [-117.235, 32.72149], [-117.2351, 32.72159]]]} | Open Access 1 | Cabrillo Mini-Park South | 30118 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.12 | Cabrillo Mini-Park South | ||
790 | 790 | 789 | {"type": "Polygon", "coordinates": [[[-117.10185, 32.75039], [-117.10185, 32.75069], [-117.10169, 32.75069], [-117.10169, 32.75039], [-117.10185, 32.75039]]]} | Open Access 1 | City Heights Square Mini Park | 33550 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.123 | City Heights Square MP | ||
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 | ||
14093 | 14093 | 14092 | {"type": "Polygon", "coordinates": [[[-117.16198, 32.71308], [-117.16185, 32.71308], [-117.16185, 32.71266], [-117.16198, 32.71267], [-117.16198, 32.71308]]]} | Open Access 1 | G Street Mini Park | 31532 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.138 | G Street MP | ||
9320 | 9320 | 9319 | {"type": "Polygon", "coordinates": [[[-117.07921, 32.69788], [-117.079, 32.69789], [-117.07891, 32.69768], [-117.0791, 32.69765], [-117.07915, 32.69766], [-117.07919, 32.6977], [-117.07921, 32.69788]]]} | Open Access 1 | Santa Isabel Mini-Park | 25092 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.143 | Santa Isabel Mini-Park | ||
12570 | 12570 | 12569 | {"type": "Polygon", "coordinates": [[[-117.12552, 32.73807], [-117.12552, 32.73821], [-117.12512, 32.73821], [-117.12512, 32.73807], [-117.12552, 32.73807]]]} | Open Access 1 | 32nd Street Mini Park | 31228 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.143 | 32nd Street MP | ||
12833 | 12833 | 12832 | {"type": "Polygon", "coordinates": [[[-117.12737, 32.76657], [-117.12714, 32.76651], [-117.12709, 32.76645], [-117.12721, 32.76614], [-117.12737, 32.76657]]]} | Open Access 1 | Kenmore Terrace Mini-Park | 30055 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.146 | Kenmore Terrace Mini-Park | ||
6718 | 6718 | 6717 | {"type": "Polygon", "coordinates": [[[-117.1194, 32.69936], [-117.11924, 32.69936], [-117.11924, 32.699], [-117.1194, 32.699], [-117.1194, 32.69936]]]} | Open Access 1 | Martin Ave Mini-Park | 21902 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.148 | Martin Ave Mini-Park | ||
5796 | 5796 | 5795 | {"type": "Polygon", "coordinates": [[[-117.13376, 32.70693], [-117.13375, 32.70731], [-117.13361, 32.70731], [-117.1336, 32.70693], [-117.13376, 32.70693]]]} | Open Access 1 | L Street Mini Park | 20736 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.151 | L Street MP | ||
12856 | 12856 | 12855 | {"type": "Polygon", "coordinates": [[[-117.27039, 32.84609], [-117.27014, 32.84608], [-117.26993, 32.8462], [-117.27002, 32.84597], [-117.27002, 32.84574], [-117.27016, 32.84595], [-117.27039, 32.84609]]]} | Open Access 1 | Union Place Circle Mini-Park | 30081 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.154 | Union Place Circle Mini-Park | ||
1344 | 1344 | 1343 | {"type": "Polygon", "coordinates": [[[-117.10586, 32.68969], [-117.1057, 32.68969], [-117.10569, 32.68931], [-117.10586, 32.68931], [-117.10586, 32.68969]]]} | Open Access 1 | 41st Street Mini-Park | 15201 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.16 | 41st Street Mini-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]);