units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by LAYER
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 523
- San Diego, County of 121
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 57
- Oceanside, City of 45
- Carlsbad, City of 40
- San Marcos, City of 40
- Escondido, City of 34
- California Department of Fish and Wildlife 31
- Home Owners Association - Unknown Name 27
- California Department of Transportation 22
- California Department of Parks and Recreation 21
- The Environmental Trust 21
- Coronado, City of 19
- San Diego Unified Port District 19
- Vista, City of 18
- El Cajon, City of 17
- Fallbrook Land Conservancy 15
- La Mesa, City of 14
- Endangered Habitats Conservancy 14
- Center for Natural Lands Management 13
- Santee, City of 12
- United States Fish and Wildlife Service 10
- Del Mar, City of 8
- National City, City of 7
- San Diego River Park Foundation 7
- San Dieguito River Valley Land Conservancy 6
- Lemon Grove, City of 6
- University of California 5
- …
DES_TP >30
- Local Park 639
- Local Recreation Area 306
- Local Other or Unknown 99
- Private Conservation 87
- Local Conservation Area 56
- Private Recreation or Education 38
- State Conservation Area 35
- State Other or Unknown 20
- State Park 16
- National Wildlife Refuge 11
- State Resource Management Area 6
- Local Historic or Cultural Area 3
- Private Other or Unknown 3
- State Recreation Area 2
- Local Resource Management Area 2
- State Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Recreation Management Area 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 21
- City Agency 985
- County Agency 121
- State Agency 86
- Non Profit - Land Trust 69
- Home Owners Association 28
- Non Profit - Conservation 24
- Water District 23
- Port/Harbor District 19
- Federal Agency 14
- Non Profit - Other 7
- Commercial 5
- Recreation/Parks District 4
- Transportation Agency 4
- Open Space District 2
- Irrigation District 2
- Special District - Other 2
- Other 2
- School District 1
- Mitigation Bank 1
- Utility 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,146
- No Public Access 128
- Restricted Access 100
- Unknown Access 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | 40 | {"type": "Polygon", "coordinates": [[[-117.19344, 32.75165], [-117.19315, 32.75181], [-117.19311, 32.75179], [-117.19296, 32.75158], [-117.1933, 32.75139], [-117.19344, 32.75165]]]} | Open Access 1 | 95 | El Campo Santo Neighborhood Park | 30058 | 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.276 | El Campo Santo Neighborhood Park | 0 | Local Park 2 | 4 | |
46 | 46 | 45 | {"type": "Polygon", "coordinates": [[[-117.08226, 32.82508], [-117.08219, 32.82527], [-117.08213, 32.82555], [-117.08203, 32.82574], [-117.08095, 32.8251], [-117.08087, 32.82511], [-117.08059, 32.82491], [-117.08031, 32.82482], [-117.07942, 32.82465], [-117.0796, 32.8244], [-117.08002, 32.82402], [-117.08018, 32.82416], [-117.08058, 32.82439], [-117.08226, 32.82508]]]} | Open Access 1 | 131 | 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 | 4.081 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-117.04877, 32.81115], [-117.04766, 32.81153], [-117.04656, 32.81065], [-117.04633, 32.81056], [-117.04656, 32.80996], [-117.04591, 32.8096], [-117.04518, 32.80917], [-117.0453, 32.80896], [-117.04544, 32.80897], [-117.04612, 32.8091], [-117.04679, 32.80933], [-117.04712, 32.80941], [-117.04749, 32.80943], [-117.04824, 32.80934], [-117.04829, 32.8096], [-117.0481, 32.80978], [-117.04786, 32.81015], [-117.04788, 32.81022], [-117.04852, 32.81057], [-117.04845, 32.81084], [-117.04877, 32.81115]]]} | Open Access 1 | 107 | Tuxedo Neighborhood Park | 30163 | 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 | 10.11 | Tuxedo Neighborhood Park | 0 | Local Park 2 | 4 | |
52 | 52 | 51 | {"type": "Polygon", "coordinates": [[[-117.25242, 32.75012], [-117.25237, 32.75054], [-117.25232, 32.75081], [-117.25179, 32.75049], [-117.25206, 32.75019], [-117.2521, 32.7502], [-117.25219, 32.75008], [-117.25188, 32.74988], [-117.25193, 32.74983], [-117.25242, 32.75012]]]} | Open Access 1 | 46758 | Saratoga Park | 30209 | 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.754 | Saratoga Park | 0 | Local Park 2 | 4 | |
56 | 56 | 55 | {"type": "Polygon", "coordinates": [[[-117.06137, 32.79131], [-117.06126, 32.79227], [-117.06098, 32.79279], [-117.06081, 32.79305], [-117.05968, 32.79265], [-117.05975, 32.79246], [-117.05991, 32.79163], [-117.06039, 32.7917], [-117.06047, 32.79131], [-117.06137, 32.79131]]]} | Open Access 1 | 157 | Pasatiempo Park West Open Space | 23492 | 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.178 | Pasatiempo Park West OS | 0 | Local Recreation Area 3 | 4 | |
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-117.16831, 32.71264], [-117.16831, 32.71356], [-117.1674, 32.71356], [-117.1674, 32.71264], [-117.16831, 32.71264]]]} | Open Access 1 | 170 | Pantoja Neighborhood Park | 30100 | 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 | 2.149 | Pantoja Neighborhood Park | 0 | Local Park 2 | 4 | |
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-117.02209, 32.79762], [-117.02195, 32.79979], [-117.02062, 32.79972], [-117.02075, 32.79755], [-117.02202, 32.79758], [-117.02207, 32.7976], [-117.02209, 32.79762]]]} | Open Access 1 | 129 | San Carlos Community Park | 24847 | 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.486 | San Carlos Community 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 | |
68 | 68 | 67 | {"type": "MultiPolygon", "coordinates": [[[[-117.08318, 32.79598], [-117.08318, 32.79625], [-117.07976, 32.79623], [-117.07979, 32.79489], [-117.08005, 32.79464], [-117.08026, 32.79453], [-117.08041, 32.79449], [-117.08053, 32.79447], [-117.08069, 32.79447], [-117.08088, 32.79451], [-117.08105, 32.79458], [-117.08115, 32.79463], [-117.08253, 32.7958], [-117.0828, 32.79593], [-117.083, 32.79597], [-117.08318, 32.79598]]], [[[-117.08168, 32.79321], [-117.08167, 32.7939], [-117.08165, 32.79398], [-117.08157, 32.79411], [-117.08123, 32.79443], [-117.08117, 32.79444], [-117.08096, 32.79435], [-117.08077, 32.79431], [-117.08057, 32.7943], [-117.08036, 32.79433], [-117.07996, 32.79402], [-117.08082, 32.79319], [-117.08168, 32.79321]]]]} | Open Access 1 | 155 | Allied Gardens Community Park | 15383 | 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 | 13.814 | Allied Gardens Community Park | 0 | Local Park 2 | 4 | |
69 | 69 | 68 | {"type": "Polygon", "coordinates": [[[-117.06833, 32.78979], [-117.0681, 32.78985], [-117.06791, 32.78987], [-117.06755, 32.78998], [-117.06712, 32.79007], [-117.0668, 32.78832], [-117.06803, 32.78813], [-117.06823, 32.7894], [-117.06833, 32.78979]]]} | Open Access 1 | 163 | Princess Del Cerro Neighborhood Park | 30167 | 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.472 | Princess Del Cerro Neighborhood Park | 0 | Local Park 2 | 4 | |
70 | 70 | 69 | {"type": "Polygon", "coordinates": [[[-117.09581, 32.78702], [-117.0958, 32.78757], [-117.09407, 32.78755], [-117.09403, 32.78751], [-117.09402, 32.78697], [-117.09483, 32.78698], [-117.09581, 32.78702]]]} | Open Access 1 | 164 | Grantville Neighborhood Park | 30217 | 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 | 2.604 | Grantville Neighborhood Park | 0 | Local Park 2 | 4 | |
76 | 76 | 75 | {"type": "Polygon", "coordinates": [[[-117.21231, 32.83417], [-117.2123, 32.83532], [-117.21045, 32.83532], [-117.21045, 32.83506], [-117.21039, 32.83505], [-117.2104, 32.83456], [-117.2105, 32.83441], [-117.21086, 32.83404], [-117.21145, 32.83441], [-117.21146, 32.8344], [-117.21146, 32.83418], [-117.21231, 32.83417]]]} | Open Access 1 | 228 | Gershwin Neighborhood Park | 30085 | 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.364 | Gershwin Neighborhood Park | 0 | Local Park 2 | 4 | |
78 | 78 | 77 | {"type": "Polygon", "coordinates": [[[-117.19807, 32.83041], [-117.19753, 32.83309], [-117.19713, 32.83285], [-117.19702, 32.83282], [-117.19501, 32.83283], [-117.19496, 32.83279], [-117.19496, 32.83237], [-117.19537, 32.83236], [-117.19604, 32.83176], [-117.19599, 32.83096], [-117.19602, 32.8307], [-117.19625, 32.83031], [-117.19676, 32.82987], [-117.19728, 32.83002], [-117.19807, 32.83041]]]} | Open Access 1 | 235 | North Clairemont Community Park | 22814 | 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 | 14.501 | North Clairemont Community Park | 0 | Local Park 2 | 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 | |
80 | 80 | 79 | {"type": "Polygon", "coordinates": [[[-117.02291, 32.84594], [-117.02264, 32.84628], [-117.02204, 32.84691], [-117.02175, 32.84719], [-117.02112, 32.84769], [-117.02078, 32.84792], [-117.02051, 32.84808], [-117.0205, 32.84593], [-117.02291, 32.84594]]]} | Open Access 1 | 194 | West Hills Park | 27359 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=70 | San Diego 4 | 7.496 | West Hills Park | 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 | |
98 | 98 | 97 | {"type": "MultiPolygon", "coordinates": [[[[-117.1681, 32.83591], [-117.16809, 32.83651], [-117.16806, 32.83679], [-117.16796, 32.83715], [-117.16778, 32.8376], [-117.1677, 32.83797], [-117.16768, 32.83814], [-117.16768, 32.83894], [-117.1651, 32.83896], [-117.16509, 32.8392], [-117.1635, 32.83922], [-117.16349, 32.83822], [-117.16255, 32.83823], [-117.16249, 32.83577], [-117.16617, 32.83574], [-117.16618, 32.83593], [-117.1681, 32.83591]]], [[[-117.16833, 32.83894], [-117.16791, 32.83894], [-117.16791, 32.83815], [-117.16794, 32.83788], [-117.16803, 32.83757], [-117.16822, 32.83706], [-117.16831, 32.83659], [-117.16833, 32.83894]]]]} | Open Access 1 | 252 | Hickman Field Athletic Complex | 19895 | 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 | 44.171 | Hickman Field Athletic Complex | 0 | Local Recreation Area 3 | 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 | |
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
106 | 106 | 105 | {"type": "Polygon", "coordinates": [[[-117.10318, 32.90156], [-117.10307, 32.9016], [-117.10187, 32.90144], [-117.10218, 32.90092], [-117.10229, 32.90072], [-117.10315, 32.90065], [-117.1031, 32.90102], [-117.10311, 32.90134], [-117.10318, 32.90156]]]} | Open Access 1 | 293 | Aviary Neighborhood Park | 30137 | 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 | 2.256 | Aviary 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]);