units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV
These facets timed out: UNIT_NAME
MNG_AG_TYP >30
- City Agency 10,524
- County Agency 1,219
- Recreation/Parks District 1,162
- State Agency 1,141
- Non Profit - Land Trust 601
- Federal Agency 517
- Open Space District 428
- Water District 238
- County Agency - Parks 236
- 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 35
- 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 533
- Los Angeles, City of 491
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 351
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Los Angeles, County of 175
- 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 121
- Santa Barbara, County of 119
- United States Forest Service 111
- Irvine, City of 101
- Fresno, City of 95
- Orange, County of 95
- Consumnes Community Services District 94
- 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 83
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- …
DES_TP >30
- Local Park 9,376
- Local Recreation Area 1,989
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 485
- State Conservation Area 381
- 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 Public Lands 75
- National Wildlife Refuge 75
- 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_WEB >30 ✖
- http://www.sandiego.gov/park-and-recreation/ 528
- http://lacity.org/ 490
- https://www.wildlife.ca.gov/ 399
- http://www.parks.ca.gov/ 355
- http://www.mrca.ca.gov/ 267
- http://www.sanjoseca.gov/index.aspx?NID=204 255
- http://sfrecpark.org/ 243
- http://parks.lacounty.gov 222
- http://portal.cityofsacramento.org/ParksandRec 220
- http://www.cityofventura.net/prcp 151
- http://www.longbeach.gov/park/default.asp 147
- http://www.blm.gov/wo/st/en.html 142
- http://www.slc.ca.gov/ 135
- http://www.roseville.ca.us/parks/default.asp 130
- http://www.ebparks.org/ 126
- http://www2.oaklandnet.com/Government/o/opr/index.htm 122
- http://www.sandiegocounty.gov/parks/ 120
- http://cosb.countyofsb.org/parks/ 118
- http://www.fs.fed.us/ 115
- http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp 102
- http://ocparks.com/ 93
- http://www.nps.gov/ 93
- http://www.yourcsd.com/parks/parks_list.asp 92
- http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm 91
- http://www.haywardrec.org/ 86
- http://www.modestogov.com/prnd/ 85
- http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx 82
- http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 81
- http://www.stocktongov.com/services/parkRec/default.html 81
- http://www.fws.gov/ 79
- …
ACCESS_TYP 4
- Open Access 14,510
- Restricted Access 1,203
- No Public Access 969
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173 | 173 | 172 | {"type": "Polygon", "coordinates": [[[-120.4259, 37.94699], [-120.42564, 37.9476], [-120.4255, 37.94811], [-120.42551, 37.94822], [-120.42504, 37.94841], [-120.42471, 37.94817], [-120.42435, 37.94782], [-120.42412, 37.94745], [-120.42349, 37.94692], [-120.42464, 37.94646], [-120.42483, 37.94685], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} | Open Access 1 | 548 | Cemetery | 17011 | 2050 | Jamestown Cemetery District 66 | Special District 4 | Cemetery District 11 | Special District 4 | 2050 | Jamestown Cemetery District 64 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 6.082 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
175 | 175 | 174 | {"type": "Polygon", "coordinates": [[[-119.65914, 34.41998], [-119.65807, 34.4201], [-119.65671, 34.42044], [-119.65662, 34.42048], [-119.65651, 34.42056], [-119.65592, 34.42119], [-119.65575, 34.42131], [-119.65555, 34.42137], [-119.65541, 34.42139], [-119.65297, 34.42138], [-119.65294, 34.42134], [-119.65294, 34.41914], [-119.65261, 34.41913], [-119.65261, 34.41724], [-119.65352, 34.41719], [-119.65403, 34.41712], [-119.65457, 34.41717], [-119.65502, 34.41711], [-119.65526, 34.41712], [-119.65548, 34.41708], [-119.65595, 34.41711], [-119.65614, 34.41706], [-119.65649, 34.41705], [-119.65687, 34.41702], [-119.65729, 34.41703], [-119.65751, 34.41701], [-119.65793, 34.41701], [-119.65827, 34.41698], [-119.6587, 34.41702], [-119.65912, 34.41699], [-119.65914, 34.41998]]]} | Open Access 1 | 481 | Santa Barbara Cemetery | 25039 | 2140 | Santa Barbara Cemetery Association 67 | Special District 4 | Cemetery District 11 | Special District 4 | 2140 | Santa Barbara Cemetery Association 65 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 59.983 | Santa Barbara Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
182 | 182 | 181 | {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} | Open Access 1 | 579 | Cemetery | 17015 | 2150 | Shaws Flat Cemetery District 69 | Special District 4 | Cemetery District 11 | Special District 4 | 2150 | Shaws Flat Cemetery District 67 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 2.301 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
184 | 184 | 183 | {"type": "Polygon", "coordinates": [[[-120.2455, 37.82767], [-120.24545, 37.82809], [-120.24528, 37.82907], [-120.24525, 37.82917], [-120.24352, 37.82889], [-120.24371, 37.82745], [-120.2455, 37.82767]]]} | Open Access 1 | 561 | Cemetery | 17014 | 2098 | Oak Grove Cemetery District 71 | Special District 4 | Cemetery District 11 | Special District 4 | 2098 | Oak Grove Cemetery District 69 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 6.428 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
189 | 189 | 188 | {"type": "Polygon", "coordinates": [[[-121.69813, 38.13724], [-121.69797, 38.13757], [-121.69794, 38.13778], [-121.698, 38.138], [-121.698, 38.13839], [-121.69766, 38.13941], [-121.69748, 38.13979], [-121.69707, 38.14119], [-121.69655, 38.14207], [-121.69614, 38.14262], [-121.69612, 38.14317], [-121.69601, 38.14374], [-121.69455, 38.14262], [-121.69398, 38.1421], [-121.69404, 38.14198], [-121.69415, 38.14179], [-121.69439, 38.14132], [-121.69453, 38.14097], [-121.69475, 38.14037], [-121.69492, 38.14001], [-121.6952, 38.13921], [-121.6953, 38.13884], [-121.69555, 38.13824], [-121.69594, 38.13708], [-121.6961, 38.13642], [-121.69719, 38.1368], [-121.69813, 38.13724]]]} | Open Access 1 | 520 | Sandy Beach Park | 25025 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2187 | Solano Tri-City and County Cooperative Planning Group 72 | Special District 4 | Open Space District 6 | Solano 26 | 36.239 | Sandy Beach Park | 0 | Local Park 2 | 4 | ||
195 | 195 | 194 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | 569 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 9.887 | Foglesong Park/Eda Henderson Pool | 0 | Local Recreation Area 3 | 4 | ||
239 | 239 | 238 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | Open Access 1 | 773 | Deep Creek Cemetery | 17988 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 4.704 | Deep Creek Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
286 | 286 | 285 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | 778 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.069 | Exeter Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
290 | 290 | 289 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | 782 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.139 | Hamilton Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
298 | 298 | 297 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | 802 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 122 | Special District 4 | Cemetery District 11 | Special District 4 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Tulare 29 | 2.538 | Frazier Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
304 | 304 | 303 | {"type": "Polygon", "coordinates": [[[-119.10787, 36.41389], [-119.10786, 36.41561], [-119.10573, 36.41561], [-119.10572, 36.4146], [-119.10643, 36.4146], [-119.10644, 36.41385], [-119.10787, 36.41389]]]} | Open Access 1 | 1041 | Antelope Cemetery | 15507 | 2184 | Woodlake Public Cemetery District 124 | Special District 4 | Cemetery District 11 | Special District 4 | 2184 | Woodlake Public Cemetery District 121 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.877 | Antelope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
332 | 332 | 331 | {"type": "Polygon", "coordinates": [[[-121.31293, 36.42631], [-121.31293, 36.42822], [-121.31184, 36.42912], [-121.3115, 36.42912], [-121.3115, 36.42606], [-121.31293, 36.42631]]]} | Open Access 1 | 911 | Soledad Cemetery | 25597 | 2153 | Soledad Cemetery District 135 | Special District 4 | Cemetery District 11 | Special District 4 | 2153 | Soledad Cemetery District 132 | Special District 4 | Cemetery District 11 | Monterey 14 | 9.116 | Soledad Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
351 | 351 | 350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | Open Access 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | Tulare Veterans Memorial District 144 | Special District 4 | Cemetery District 11 | Special District 4 | 2168 | Tulare Veterans Memorial District 140 | Special District 4 | Cemetery District 11 | Tulare 29 | 8.555 | Tulare Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
366 | 366 | 365 | {"type": "Polygon", "coordinates": [[[-119.18856, 36.09471], [-119.18594, 36.09472], [-119.18594, 36.09315], [-119.18855, 36.09314], [-119.18856, 36.09471]]]} | Open Access 1 | 1046 | Woodville Cemetery | 27750 | 2185 | Woodville Public Cemetery District 150 | Special District 4 | Cemetery District 11 | Special District 4 | 2185 | Woodville Public Cemetery District 146 | Special District 4 | Cemetery District 11 | Tulare 29 | 10.155 | Woodville Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
378 | 378 | 377 | {"type": "Polygon", "coordinates": [[[-119.20947, 36.30166], [-119.20848, 36.30166], [-119.20849, 36.30084], [-119.20946, 36.30084], [-119.20947, 36.30166]]]} | Open Access 1 | 1136 | Jennings Park | 20389 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 1.978 | Jennings Park | 0 | Local Park 2 | 4 | ||
381 | 381 | 380 | {"type": "Polygon", "coordinates": [[[-119.21304, 36.31701], [-119.213, 36.31821], [-119.20857, 36.31818], [-119.20859, 36.31659], [-119.20864, 36.31665], [-119.20877, 36.31669], [-119.20887, 36.31664], [-119.21059, 36.31665], [-119.21139, 36.31671], [-119.21209, 36.31679], [-119.21304, 36.31701]]]} | Open Access 1 | 1141 | Liberty Park | 21210 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 16.086 | Liberty Park | 0 | Local Park 2 | 4 | ||
384 | 384 | 383 | {"type": "Polygon", "coordinates": [[[-119.20715, 36.29112], [-119.20714, 36.29174], [-119.20533, 36.29176], [-119.20533, 36.29057], [-119.20679, 36.29058], [-119.20679, 36.29112], [-119.20715, 36.29112]]]} | Open Access 1 | 1151 | Roy Park | 24712 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 4.789 | Roy Park | 0 | Local Park 2 | 4 | ||
516 | 516 | 515 | {"type": "Polygon", "coordinates": [[[-120.62395, 36.98985], [-120.62208, 36.98986], [-120.62208, 36.98902], [-120.62395, 36.98902], [-120.62395, 36.98985]]]} | Open Access 1 | 25989 | Pierini Park | 23664 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 3.824 | Pierini Park | 0 | Local Park 2 | 4 | ||
527 | 527 | 526 | {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} | Open Access 1 | 25990 | Des Park | 18106 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.735 | Des 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]);