units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
309 rows where COUNTY = 4 and DES_TP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST
MNG_AGENCY 24
- San Diego, City of 211
- San Marcos, City of 14
- Carlsbad, City of 12
- Poway, City of 12
- Oceanside, City of 10
- Escondido, City of 8
- San Diego, County of 7
- Chula Vista, City of 7
- Encinitas, City of 6
- El Cajon, City of 4
- Coronado, City of 2
- Valley Center Water District 2
- Sweetwater Authority 2
- Olivenhain Municipal Water District 2
- National City, City of 1
- Vista, City of 1
- San Diego Unified Port District 1
- Yuima Municipal Water District 1
- Helix Water District 1
- San Diego County Water Authority 1
- Vallecitos Water District 1
- Vista Unified School District 1
- Rainbow Municipal Water District 1
- Otay Water District 1
MNG_AG_TYP 6
ACCESS_TYP 4
- Open Access 277
- Restricted Access 16
- No Public Access 15
- Unknown Access 1
DES_TP 1
- Local Recreation Area · 309 ✖
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 | |
15991 | 15991 | 15990 | {"type": "Polygon", "coordinates": [[[-117.1688, 33.15147], [-117.16874, 33.15146], [-117.16824, 33.15127], [-117.16804, 33.15122], [-117.16773, 33.15117], [-117.16777, 33.15112], [-117.16796, 33.15118], [-117.168, 33.15117], [-117.16818, 33.15124], [-117.16821, 33.15121], [-117.16838, 33.1513], [-117.16843, 33.15128], [-117.16859, 33.15137], [-117.16863, 33.15136], [-117.1688, 33.15147]]]} | Open Access 1 | 1808 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.109 | City of San Marcos 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 |
16002 | 16002 | 16001 | {"type": "Polygon", "coordinates": [[[-117.17026, 33.15271], [-117.17005, 33.15254], [-117.16937, 33.15188], [-117.16919, 33.15172], [-117.16898, 33.15158], [-117.16899, 33.15154], [-117.16912, 33.15166], [-117.16917, 33.15165], [-117.16928, 33.15177], [-117.16932, 33.15177], [-117.16943, 33.1519], [-117.16947, 33.1519], [-117.16959, 33.15205], [-117.16963, 33.15205], [-117.16975, 33.15221], [-117.16979, 33.15221], [-117.1699, 33.15236], [-117.16995, 33.15237], [-117.17007, 33.15252], [-117.17012, 33.15253], [-117.17026, 33.15271]]]} | Open Access 1 | 1818 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.155 | City of San Marcos OS | 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 | |
16011 | 16011 | 16010 | {"type": "Polygon", "coordinates": [[[-117.17372, 33.15323], [-117.17372, 33.15323], [-117.1724, 33.15322], [-117.17351, 33.15316], [-117.17363, 33.15296], [-117.17372, 33.15286], [-117.17372, 33.15323]]]} | Open Access 1 | 1820 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.221 | City of San Marcos 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 | |
16088 | 16088 | 16087 | {"type": "Polygon", "coordinates": [[[-117.06918, 32.64875], [-117.06908, 32.64878], [-117.06907, 32.6488], [-117.06875, 32.64877], [-117.06877, 32.64866], [-117.06873, 32.64853], [-117.06906, 32.64844], [-117.06918, 32.64875]]]} | Open Access 1 | 45190 | Chula Vista Open Space | 17242 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 0.292 | Chula Vista 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 |
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]);