units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,469
- County Agency 1,213
- Recreation/Parks District 1,161
- State Agency 1,138
- Non Profit - Land Trust 601
- Federal Agency 516
- Open Space District 427
- Water District 238
- County Agency - Parks 235
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 34
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 513
- Los Angeles, City of 489
- California Department of Fish and Wildlife 441
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 350
- San Jose, City of 253
- San Francisco, City and County of 239
- Sacramento, City of 220
- Los Angeles, County of 174
- East Bay Regional Park District 167
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- San Diego, County of 123
- Oakland, City of 122
- United States Bureau of Land Management 120
- Santa Barbara, County of 117
- United States Forest Service 111
- Irvine, City of 101
- Orange, County of 95
- Consumnes Community Services District 94
- Fresno, City of 92
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 82
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- …
DES_TP >30
- Local Park 9,322
- Local Recreation Area 1,982
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 484
- State Conservation Area 379
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Wildlife Refuge 75
- National Public Lands 74
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
AGNCY_TYP >30 ✖
- City Agency 10,341
- County Agency 1,257
- State Agency 1,195
- Recreation/Parks District 1,097
- Non Profit - Land Trust 599
- Federal Agency 583
- Open Space District 328
- Water District 269
- Home Owners Association 218
- Community Services District 196
- School District 163
- County Agency - Parks 157
- Non Profit - Conservation 138
- Flood District 128
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 35
- County Agency - Other 32
- Port/Harbor District 32
- Commercial 20
- Special District - Other 16
- Utility 13
- Conservation District 12
- Sanitation District 11
- Joint Powers Authority 10
- Transportation Agency 9
- Other 8
- Non Profit - Cemetery District 5
- Mitigation Bank 4
- Non Profit - Education 4
- …
ACCESS_TYP 4
- Open Access 14,445
- Restricted Access 1,200
- No Public Access 968
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
71 | 71 | 70 | {"type": "MultiPolygon", "coordinates": [[[[-121.12968, 37.47162], [-121.12901, 37.47193], [-121.12846, 37.47115], [-121.12967, 37.4715], [-121.12968, 37.47162]]], [[[-121.12992, 37.4719], [-121.12992, 37.4719], [-121.12973, 37.47288], [-121.12916, 37.47211], [-121.1298, 37.47182], [-121.12992, 37.4719]]]]} | Open Access 1 | 209 | Veterans Memorial Park | 27031 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.982 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
72 | 72 | 71 | {"type": "Polygon", "coordinates": [[[-120.63097, 35.24673], [-120.63073, 35.24675], [-120.63063, 35.24673], [-120.63043, 35.24674], [-120.6303, 35.24677], [-120.63025, 35.24681], [-120.63016, 35.24683], [-120.63008, 35.24682], [-120.62998, 35.24677], [-120.62994, 35.2467], [-120.62993, 35.24662], [-120.63, 35.24651], [-120.63004, 35.24648], [-120.63007, 35.24644], [-120.63012, 35.24628], [-120.6301, 35.24623], [-120.63011, 35.24615], [-120.63017, 35.2461], [-120.63019, 35.24606], [-120.63018, 35.24601], [-120.63013, 35.24596], [-120.63051, 35.24609], [-120.63065, 35.24616], [-120.63074, 35.24623], [-120.63083, 35.24633], [-120.63089, 35.24643], [-120.63095, 35.2466], [-120.63097, 35.24673]]]} | Open Access 1 | 167 | Rodriguez Adobe | 24553 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.39 | Rodriguez Adobe | None 10 | |||
73 | 73 | 72 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.1445, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | 172 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.056 | Newcastle Park | 0 | Local Park 2 | 4 | |
74 | 74 | 73 | {"type": "Polygon", "coordinates": [[[-121.88839, 37.30077], [-121.88844, 37.30077], [-121.88849, 37.3008], [-121.88874, 37.30116], [-121.88913, 37.30175], [-121.88914, 37.3018], [-121.88912, 37.30184], [-121.88672, 37.30289], [-121.88666, 37.30289], [-121.88661, 37.30287], [-121.88592, 37.30185], [-121.88593, 37.3018], [-121.88839, 37.30077]]]} | Open Access 1 | 173 | River Glen Park | 24409 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.688 | River Glen Park | 1983 | Local Park 2 | 4 | |
75 | 75 | 74 | {"type": "Polygon", "coordinates": [[[-122.05137, 36.97047], [-122.05103, 36.97055], [-122.05096, 36.97049], [-122.05087, 36.97031], [-122.05129, 36.97021], [-122.05137, 36.97047]]]} | Open Access 1 | 182 | Round Tree Park | 24704 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.27 | Round Tree 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 | |
77 | 77 | 76 | {"type": "Polygon", "coordinates": [[[-121.15853, 37.47069], [-121.1585, 37.47121], [-121.15777, 37.47121], [-121.15777, 37.47066], [-121.15847, 37.47066], [-121.15853, 37.47069]]]} | Open Access 1 | 200 | Rosette Park | 24626 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.001 | Rosette 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 |
81 | 81 | 80 | {"type": "Polygon", "coordinates": [[[-121.12814, 37.46297], [-121.12754, 37.4631], [-121.1266, 37.46244], [-121.12814, 37.46244], [-121.12811, 37.4628], [-121.12812, 37.46289], [-121.12814, 37.46297]]]} | Open Access 1 | 213 | Sunflower Park | 25993 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.599 | Sunflower Park | 0 | Local Park 2 | 4 | |
82 | 82 | 81 | {"type": "Polygon", "coordinates": [[[-115.57468, 32.84244], [-115.57468, 32.84326], [-115.5737, 32.84326], [-115.57371, 32.84244], [-115.57468, 32.84244]]]} | Open Access 1 | 263 | Freddie White Park | 19078 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 2.047 | Freddie White Park | 0 | Local Park 2 | 4 | |
83 | 83 | 82 | {"type": "Polygon", "coordinates": [[[-120.451, 34.95142], [-120.45136, 34.95142], [-120.4514, 34.95145], [-120.45139, 34.95211], [-120.45135, 34.95213], [-120.45059, 34.95212], [-120.4506, 34.95142], [-120.451, 34.95142]]]} | Open Access 1 | 215 | Russell Park | 24739 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 1.403 | Russell Park | 0 | Local Park 2 | 4 | |
84 | 84 | 83 | {"type": "Polygon", "coordinates": [[[-121.14983, 37.46874], [-121.14983, 37.46946], [-121.14809, 37.46893], [-121.1481, 37.46872], [-121.14983, 37.46874]]]} | Open Access 1 | 220 | Sunglow Park | 25996 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.956 | Sunglow 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 | |
86 | 86 | 85 | {"type": "MultiPolygon", "coordinates": [[[[-121.14464, 37.45253], [-121.14452, 37.4562], [-121.14113, 37.45496], [-121.14118, 37.45251], [-121.14464, 37.45253]]], [[[-121.14422, 37.45628], [-121.14118, 37.45628], [-121.1412, 37.45516], [-121.1412, 37.45516], [-121.14422, 37.45628]]]]} | Open Access 1 | 225 | T.W. Patterson Sports Complex | 26158 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 29.665 | T.W. Patterson Sports Complex | 0 | Local Recreation Area 3 | 4 | |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-121.74459, 36.92013], [-121.74445, 36.92037], [-121.74431, 36.92032], [-121.74415, 36.92034], [-121.744, 36.92028], [-121.74398, 36.92024], [-121.74411, 36.92], [-121.74416, 36.91997], [-121.7442, 36.91998], [-121.74459, 36.92013]]]} | Open Access 1 | 247 | Brentwood Park | 16362 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.377 | Brentwood Park | 0 | Local Park 2 | 4 | |
88 | 88 | 87 | {"type": "Polygon", "coordinates": [[[-119.7813, 36.80352], [-119.7813, 36.80494], [-119.77923, 36.80494], [-119.77923, 36.80318], [-119.78046, 36.80319], [-119.78045, 36.80352], [-119.7813, 36.80352]]]} | Open Access 1 | 250 | Cary Park | 16928 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.198 | Cary Park | 0 | Local Park 2 | 4 | |
89 | 89 | 88 | {"type": "MultiPolygon", "coordinates": [[[[-121.8271, 36.58062], [-121.82287, 36.58502], [-121.81841, 36.58218], [-121.82009, 36.58191], [-121.82254, 36.57939], [-121.82254, 36.57938], [-121.81988, 36.57848], [-121.81974, 36.57825], [-121.82001, 36.57814], [-121.82023, 36.57809], [-121.82059, 36.57806], [-121.82087, 36.57809], [-121.82109, 36.57814], [-121.82169, 36.57835], [-121.82197, 36.5784], [-121.82225, 36.5784], [-121.82261, 36.57836], [-121.82277, 36.57835], [-121.82365, 36.5784], [-121.82406, 36.57838], [-121.82441, 36.57832], [-121.82476, 36.57821], [-121.82509, 36.57804], [-121.82647, 36.57976], [-121.8271, 36.58062]]], [[[-121.82489, 36.57785], [-121.82473, 36.57794], [-121.82453, 36.57802], [-121.82383, 36.57666], [-121.82432, 36.57715], [-121.82462, 36.5775], [-121.82469, 36.57768], [-121.82489, 36.57785]]]]} | Open Access 1 | 231 | Ryan Ranch Park | 24759 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 75.676 | Ryan Ranch 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]);