units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
646 rows where COUNTY = 4 and DES_TP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, MNG_AG_ID, MNG_AG_LEV, YR_EST
MNG_AGENCY 25
- San Diego, City of 281
- San Diego, County of 68
- Chula Vista, City of 60
- Oceanside, City of 28
- Carlsbad, City of 23
- San Marcos, City of 21
- Encinitas, City of 19
- Coronado, City of 17
- San Diego Unified Port District 17
- Escondido, City of 16
- La Mesa, City of 14
- Poway, City of 13
- Vista, City of 13
- El Cajon, City of 12
- Santee, City of 10
- National City, City of 6
- Lemon Grove, City of 6
- Del Mar, City of 5
- Imperial Beach, City of 5
- Solana Beach, City of 3
- Valley Center Parks and Recreation 3
- Helix Water District 2
- San Dieguito River Park Joint Powers Authority 2
- Ramona Municipal Water District 1
- Padre Dam Municipal Water District 1
AGNCY_TYP 10 ✖
MNG_AG_TYP 6
ACCESS_TYP 3
- Open Access 626
- Restricted Access 11
- No Public Access 9
DES_TP 1
- Local Park · 646 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1300 | 1300 | 1299 | {"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 | 7345 | Color Mini-Park | 30090 | 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.058 | Color Mini-Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
15438 | 15438 | 15437 | {"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 | 46708 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.089 | McCall Street Mini-Park | 0 | Local Park 2 | 4 | |
10722 | 10722 | 10721 | {"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 | 19927 | Sherman Mini-Park | 30102 | 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.117 | Sherman Mini-Park | 0 | Local Park 2 | 4 | |
591 | 591 | 590 | {"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 | 2008 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.118 | Davis House MP | 0 | Local Park 2 | 4 | |
85 | 85 | 84 | {"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 | 221 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.12 | Cabrillo Mini-Park South | 0 | Local Park 2 | 4 | |
13727 | 13727 | 13726 | {"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 | 48831 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.123 | City Heights Square MP | 0 | Local Park 2 | 4 | |
4384 | 4384 | 4383 | {"type": "Polygon", "coordinates": [[[-117.17555, 32.6822], [-117.17543, 32.68228], [-117.1751, 32.68236], [-117.17534, 32.6821], [-117.17555, 32.6822]]]} | Open Access 1 | 45960 | Vista Del Barco Park | 29077 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.128 | Vista Del Barco Park | 0 | Local Park 2 | 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 | |
7643 | 7643 | 7642 | {"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 | 47731 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.138 | G Street MP | 0 | Local Park 2 | 4 | |
15140 | 15140 | 15139 | {"type": "Polygon", "coordinates": [[[-117.36976, 33.19608], [-117.36957, 33.19609], [-117.36957, 33.19581], [-117.36976, 33.19581], [-117.36976, 33.19608]]]} | Open Access 1 | 45965 | Cesar Chavez Park | 29114 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#34 | San Diego 4 | 0.138 | Cesar Chavez Park | 0 | Local Park 2 | 4 |
5250 | 5250 | 5249 | {"type": "Polygon", "coordinates": [[[-117.2247, 32.72492], [-117.22467, 32.72521], [-117.22448, 32.72521], [-117.22451, 32.72491], [-117.2247, 32.72492]]]} | Open Access 1 | 47487 | Point Loma Marina Park | 31205 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/point-loma-marina-park.html | San Diego 4 | 0.142 | Point Loma Marina Park | 0 | Local Park 2 | 4 |
4151 | 4151 | 4150 | {"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 | 47523 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.143 | 32nd Street MP | 0 | Local Park 2 | 4 | |
573 | 573 | 572 | {"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 | 1899 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.144 | Santa Isabel Mini-Park | 0 | Local Park 2 | 4 | |
2464 | 2464 | 2463 | {"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 | 18876 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.146 | Kenmore Terrace Mini-Park | 0 | Local Park 2 | 4 | |
6406 | 6406 | 6405 | {"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 | 1879 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.149 | Martin Ave Mini-Park | 0 | Local Park 2 | 4 | |
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} | Open Access 1 | 704 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 0.15 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
6393 | 6393 | 6392 | {"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 | 1810 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.151 | L Street MP | 0 | Local Park 2 | 4 | |
315 | 315 | 314 | {"type": "Polygon", "coordinates": [[[-117.17162, 32.68965], [-117.17162, 32.68965], [-117.17145, 32.68995], [-117.1713, 32.68952], [-117.17162, 32.68965]]]} | Open Access 1 | 849 | Cronan Park | 17830 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814919 | San Diego 4 | 0.154 | Cronan 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]);