units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
211 rows where DES_TP = 3 and MNG_AGENCY = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, PARK_URL
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency 211
MNG_AGENCY 1
- San Diego, City of · 211 ✖
DES_TP 1
- Local Recreation Area · 211 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2826 | 2826 | 2825 | {"type": "Polygon", "coordinates": [[[-117.12944, 32.98294], [-117.12938, 32.98304], [-117.12928, 32.9829], [-117.12938, 32.98285], [-117.12944, 32.98294]]]} | Open Access 1 | 931 | Black Mountain Open Space Park | 10257 | 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 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.04 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | Uptown Open Space | 26740 | 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.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
4934 | 4934 | 4933 | {"type": "Polygon", "coordinates": [[[-117.08994, 32.84113], [-117.08988, 32.84128], [-117.08972, 32.84134], [-117.08976, 32.84106], [-117.08994, 32.84113]]]} | Open Access 1 | 241 | Tierrasanta Open Space | 10608 | 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.095 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
10588 | 10588 | 10587 | {"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 | 18912 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.095 | Mission Valley Slopes #2 OS | 0 | Local Recreation Area 3 | 4 | |
6492 | 6492 | 6491 | {"type": "Polygon", "coordinates": [[[-117.17175, 32.73853], [-117.17141, 32.73854], [-117.17141, 32.7384], [-117.17175, 32.7384], [-117.17175, 32.73853]]]} | Open Access 1 | 180 | Uptown Open Space | 26740 | 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.122 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
7847 | 7847 | 7846 | {"type": "Polygon", "coordinates": [[[-117.15681, 33.0032], [-117.15678, 33.00321], [-117.15678, 33.00317], [-117.15673, 33.00305], [-117.15662, 33.00291], [-117.15655, 33.00286], [-117.1565, 33.00276], [-117.15678, 33.00276], [-117.15681, 33.0032]]]} | Open Access 1 | 9594 | Black Mountain Open Space Park | 10257 | 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 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.148 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
79 | 79 | 78 | {"type": "Polygon", "coordinates": [[[-117.23873, 32.83257], [-117.23825, 32.83268], [-117.2382, 32.83254], [-117.23868, 32.83244], [-117.23873, 32.83257]]]} | Open Access 1 | 236 | La Jolla Open Space | 20766 | 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.172 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
10177 | 10177 | 10176 | {"type": "Polygon", "coordinates": [[[-117.09722, 32.75933], [-117.09681, 32.75932], [-117.09682, 32.75912], [-117.09722, 32.75913], [-117.09722, 32.75933]]]} | Open Access 1 | 18714 | Kensington/College Open Space | 20616 | 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.207 | Kensington/College OS | 0 | Local Recreation Area 3 | 4 | |
10601 | 10601 | 10600 | {"type": "Polygon", "coordinates": [[[-117.11151, 32.76653], [-117.11122, 32.7666], [-117.11114, 32.76647], [-117.11104, 32.76634], [-117.11132, 32.76628], [-117.11139, 32.7664], [-117.11151, 32.76653]]]} | Open Access 1 | 18877 | Mission Valley Hillsides Open Space | 22316 | 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.209 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
10574 | 10574 | 10573 | {"type": "Polygon", "coordinates": [[[-117.11842, 32.77457], [-117.11817, 32.77496], [-117.11806, 32.77488], [-117.11838, 32.77423], [-117.11842, 32.77457]]]} | Open Access 1 | 18954 | Indian Hill Open Space Park | 20202 | 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.246 | Indian Hill OS Park | 0 | Local Recreation Area 3 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 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.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
6160 | 6160 | 6159 | {"type": "Polygon", "coordinates": [[[-117.11329, 32.76932], [-117.11327, 32.76936], [-117.11312, 32.76936], [-117.1129, 32.7698], [-117.11278, 32.7698], [-117.11276, 32.76964], [-117.11278, 32.76955], [-117.11274, 32.76952], [-117.11265, 32.76932], [-117.11329, 32.76932]]]} | Open Access 1 | 18943 | Mission Valley Hillsides Open Space | 22316 | 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.359 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
16619 | 16619 | 16618 | {"type": "Polygon", "coordinates": [[[-117.12478, 32.97097], [-117.12439, 32.97113], [-117.1243, 32.97076], [-117.12468, 32.97063], [-117.12478, 32.97097]]]} | Open Access 1 | 18666 | Black Mountain Open Space Park | 10257 | 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 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.386 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
5822 | 5822 | 5821 | {"type": "Polygon", "coordinates": [[[-117.16627, 32.73925], [-117.16594, 32.73926], [-117.16593, 32.7388], [-117.16627, 32.7388], [-117.16627, 32.73925]]]} | Open Access 1 | 178 | Banker's Hill Canyon Open Space | 15796 | 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.393 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15635 | 15635 | 15634 | {"type": "Polygon", "coordinates": [[[-117.12779, 32.71746], [-117.12751, 32.71747], [-117.12751, 32.71785], [-117.12738, 32.71785], [-117.12737, 32.71703], [-117.12761, 32.71702], [-117.12762, 32.71741], [-117.12778, 32.71741], [-117.12779, 32.71746]]]} | Open Access 1 | 2085 | Golden Hills Open Space | 19363 | 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.436 | Golden Hills OS | 0 | Local Recreation Area 3 | 4 | |
5837 | 5837 | 5836 | {"type": "Polygon", "coordinates": [[[-117.17083, 32.73648], [-117.1707, 32.73656], [-117.17061, 32.73656], [-117.17033, 32.73618], [-117.17009, 32.7358], [-117.17019, 32.73575], [-117.17083, 32.73648]]]} | Open Access 1 | 196 | Uptown Open Space | 26740 | 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.442 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
16146 | 16146 | 16145 | {"type": "Polygon", "coordinates": [[[-117.04013, 32.56541], [-117.03983, 32.56575], [-117.03925, 32.56548], [-117.03925, 32.56518], [-117.03933, 32.5652], [-117.03934, 32.56541], [-117.04013, 32.56541]]]} | Open Access 1 | 19933 | Remington Hills Open Space | 24290 | 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.486 | Remington Hills OS | 0 | Local Recreation Area 3 | 4 | |
5164 | 5164 | 5163 | {"type": "Polygon", "coordinates": [[[-117.05748, 32.92619], [-117.05718, 32.92618], [-117.05706, 32.92616], [-117.05657, 32.92604], [-117.05651, 32.92599], [-117.05665, 32.92571], [-117.05683, 32.92543], [-117.05738, 32.92478], [-117.05746, 32.9248], [-117.05684, 32.9255], [-117.05667, 32.92587], [-117.0567, 32.92592], [-117.05697, 32.92603], [-117.0573, 32.92612], [-117.05747, 32.92614], [-117.05748, 32.92619]]]} | Open Access 1 | 137 | Scripps-Miramar Ranch Open Space | 10552 | 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.499 | Scripps-Miramar Ranch OS | 0 | Local Recreation Area 3 | 4 | |
4987 | 4987 | 4986 | {"type": "Polygon", "coordinates": [[[-117.10994, 32.76641], [-117.1097, 32.76615], [-117.10897, 32.76573], [-117.1089, 32.76582], [-117.1089, 32.76564], [-117.10937, 32.76578], [-117.10969, 32.76575], [-117.10994, 32.76641]]]} | Open Access 1 | 18878 | Kensington/College Open Space | 20616 | 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.503 | Kensington/College OS | 0 | Local Recreation Area 3 | 4 | |
10147 | 10147 | 10146 | {"type": "Polygon", "coordinates": [[[-117.17727, 32.74744], [-117.17689, 32.74791], [-117.17662, 32.74774], [-117.17662, 32.74752], [-117.17714, 32.74736], [-117.17727, 32.74744]]]} | Open Access 1 | 18715 | Uptown Open Space | 26740 | 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.508 | Uptown OS | 0 | Local Recreation Area 3 | 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]);