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 9,377
- County Agency 1,116
- Recreation/Parks District 1,109
- State Agency 1,100
- Non Profit - Land Trust 563
- Federal Agency 485
- Open Space District 400
- Water District 234
- County Agency - Parks 224
- Home Owners Association 197
- Community Services District 195
- Non Profit - Conservation 146
- Flood District 100
- Irrigation District 47
- Cemetery District 45
- Non Profit - Other 45
- School District 38
- County Agency - Other 30
- Port/Harbor District 29
- Special District - Other 15
- Commercial 14
- 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 465
- California Department of Fish and Wildlife 427
- Los Angeles, City of 420
- California Department of Parks and Recreation 372
- Mountains Recreation and Conservation Authority 325
- San Jose, City of 220
- Sacramento, City of 220
- San Francisco, City and County of 196
- East Bay Regional Park District 164
- Los Angeles, County of 151
- Ventura, City of 144
- Roseville, City of 130
- Long Beach, City of 127
- Oakland, City of 119
- United States Bureau of Land Management 116
- Santa Barbara, County of 108
- United States Forest Service 105
- San Diego, County of 103
- Irvine, City of 96
- Consumnes Community Services District 94
- Orange, County of 85
- Modesto, City of 85
- California State Lands Commission 83
- Stockton, City of 81
- Napa, City of 81
- United States Fish and Wildlife Service 80
- Hayward Area Recreation and Park District 79
- United States National Park Service 78
- Tracy, City of 73
- Torrance, City of 67
- …
DES_TP >30
- Local Park 8,271
- Local Recreation Area 1,870
- Local Other or Unknown 1,162
- Private Conservation 591
- Local Conservation Area 456
- State Conservation Area 368
- Private Recreation or Education 261
- State Park 204
- State Resource Management Area 156
- State Recreation Area 140
- Local Historic or Cultural Area 93
- National Forest 92
- National Wildlife Refuge 73
- National Public Lands 71
- State Other or Unknown 68
- State Historic or Cultural Area 63
- Recreation Management Area 56
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 37
- Resource Management Area 23
- Local Resource Management Area 23
- Federal Other or Unknown 23
- National Park 22
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,106
- Restricted Access 1,153
- No Public Access 926
- Unknown Access 376
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1508 | 1508 | 1507 | {"type": "Polygon", "coordinates": [[[-118.28008, 34.03134], [-118.28007, 34.0314], [-118.27987, 34.0317], [-118.2798, 34.03175], [-118.27974, 34.03184], [-118.27926, 34.03163], [-118.2796, 34.0311], [-118.27971, 34.03115], [-118.27979, 34.03115], [-118.28003, 34.03126], [-118.28006, 34.03129], [-118.28008, 34.03134]]]} | Open Access 1 | 10696 | Saint James Park | 24789 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.896 | Saint James Park | 0 | Local Park 2 | 4 | |
1509 | 1509 | 1508 | {"type": "Polygon", "coordinates": [[[-122.73461, 38.46734], [-122.7346, 38.46746], [-122.73412, 38.46747], [-122.73412, 38.46903], [-122.73393, 38.46903], [-122.73392, 38.46856], [-122.73274, 38.46856], [-122.73272, 38.46715], [-122.73363, 38.46714], [-122.73415, 38.46715], [-122.73416, 38.46733], [-122.73461, 38.46734]]]} | Open Access 1 | 10704 | Bicentennial Park | 16066 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.086 | Bicentennial Park | 0 | Local Park 2 | 4 | |
1510 | 1510 | 1509 | {"type": "Polygon", "coordinates": [[[-117.31851, 34.11384], [-117.31737, 34.11384], [-117.31737, 34.11306], [-117.31851, 34.11305], [-117.31851, 34.11384]]]} | Open Access 1 | 10705 | Guadalupe Field Park | 19543 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.257 | Guadalupe Field Park | 0 | Local Recreation Area 3 | 4 | |
1511 | 1511 | 1510 | {"type": "Polygon", "coordinates": [[[-122.05125, 37.54145], [-122.05097, 37.54229], [-122.05084, 37.54249], [-122.05067, 37.54266], [-122.04921, 37.54073], [-122.04898, 37.54054], [-122.04953, 37.54009], [-122.04957, 37.54009], [-122.04963, 37.54011], [-122.04965, 37.54009], [-122.05123, 37.5414], [-122.05125, 37.54145]]]} | Open Access 1 | 12752 | Mirabeau Park | 22280 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 6.07 | Mirabeau Park | 1973 | Local Park 2 | 4 | |
1512 | 1512 | 1511 | {"type": "Polygon", "coordinates": [[[-122.71874, 38.48454], [-122.71869, 38.48464], [-122.71849, 38.48473], [-122.71825, 38.48472], [-122.71701, 38.48418], [-122.71617, 38.48412], [-122.71608, 38.48403], [-122.71597, 38.48385], [-122.71598, 38.48356], [-122.71586, 38.48337], [-122.71585, 38.48324], [-122.71575, 38.48311], [-122.71563, 38.48271], [-122.71578, 38.48242], [-122.71645, 38.48208], [-122.71813, 38.48189], [-122.71837, 38.48227], [-122.71839, 38.48241], [-122.71821, 38.48312], [-122.7183, 38.48367], [-122.71853, 38.48395], [-122.71869, 38.48423], [-122.71869, 38.4844], [-122.71874, 38.48454]]]} | Open Access 1 | 10727 | Fountain Grove Park | 19021 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 14.016 | Fountain Grove Park | 0 | Local Park 2 | 4 | |
1513 | 1513 | 1512 | {"type": "Polygon", "coordinates": [[[-122.66983, 38.44622], [-122.66942, 38.44646], [-122.66856, 38.44559], [-122.66888, 38.44549], [-122.66888, 38.44548], [-122.66836, 38.44493], [-122.66851, 38.44486], [-122.66983, 38.44622]]]} | Open Access 1 | 10798 | Peter Springs Park | 23629 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.6 | Peter Springs Park | 0 | Local Park 2 | 4 | |
1514 | 1514 | 1513 | {"type": "Polygon", "coordinates": [[[-122.68198, 38.46239], [-122.68133, 38.4633], [-122.68079, 38.46269], [-122.68076, 38.46258], [-122.68051, 38.46228], [-122.68082, 38.46212], [-122.68198, 38.46239]]]} | Open Access 1 | 10806 | Brush Creek Park | 16453 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.058 | Brush Creek Park | 0 | Local Park 2 | 4 | |
1515 | 1515 | 1514 | {"type": "Polygon", "coordinates": [[[-122.67494, 38.46701], [-122.67483, 38.46705], [-122.67478, 38.46712], [-122.6748, 38.4672], [-122.67489, 38.46727], [-122.67491, 38.46731], [-122.6741, 38.46748], [-122.67319, 38.4677], [-122.67352, 38.46749], [-122.67366, 38.46738], [-122.67374, 38.46724], [-122.67378, 38.46711], [-122.67402, 38.46693], [-122.67454, 38.46643], [-122.67469, 38.46656], [-122.67479, 38.46669], [-122.6749, 38.46689], [-122.67494, 38.46701]]]} | Open Access 1 | 10815 | Rinconada Park | 24373 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.021 | Rinconada Park | 0 | Local Park 2 | 4 | |
1516 | 1516 | 1515 | {"type": "Polygon", "coordinates": [[[-121.91031, 36.62062], [-121.91016, 36.62096], [-121.90987, 36.6208], [-121.90954, 36.62069], [-121.9097, 36.62033], [-121.90994, 36.6204], [-121.90991, 36.62051], [-121.91031, 36.62062]]]} | Open Access 1 | 10994 | Andy Jacobson Park | 15489 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 0.587 | Andy Jacobson Park | 0 | Local Park 2 | 4 | |
1517 | 1517 | 1516 | {"type": "Polygon", "coordinates": [[[-121.7324, 37.92885], [-121.73174, 37.92982], [-121.73166, 37.92985], [-121.72989, 37.92896], [-121.73018, 37.92863], [-121.73051, 37.92855], [-121.73172, 37.92869], [-121.73214, 37.92876], [-121.7324, 37.92885]]]} | Open Access 1 | 11473 | Apple Hill Park | 15539 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 4.417 | Apple Hill Park | 0 | Local Park 2 | 4 | |
1518 | 1518 | 1517 | {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} | Open Access 1 | 47719 | Adobe Park | 31505 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | Alameda 17 | 3.894 | Adobe Park | 0 | Local Park 2 | 4 |
1519 | 1519 | 1518 | {"type": "Polygon", "coordinates": [[[-122.06248, 37.57326], [-122.06228, 37.5735], [-122.06199, 37.57334], [-122.06219, 37.5731], [-122.06248, 37.57326]]]} | Open Access 1 | 47720 | Cerruti Park | 31508 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.246 | Cerruti Park | 0 | Local Park 2 | 4 | |
1520 | 1520 | 1519 | {"type": "Polygon", "coordinates": [[[-122.00809, 36.98128], [-122.00809, 36.98128], [-122.00733, 36.98127], [-122.00796, 36.98109], [-122.00807, 36.98104], [-122.00809, 36.98128]]]} | Open Access 1 | 47747 | El Portal Park | 31556 | 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.212 | El Portal Park | 0 | Local Park 2 | 4 | |
1521 | 1521 | 1520 | {"type": "Polygon", "coordinates": [[[-120.99672, 37.80546], [-120.99665, 37.80552], [-120.99623, 37.80552], [-120.99623, 37.80524], [-120.99672, 37.80525], [-120.99672, 37.80546]]]} | Open Access 1 | 24700 | Dinosaur Park | 18157 | 1101 | Escalon, City of 199 | City 2 | City Agency 2 | http://cityofescalon.org/departments/parks-recreation/parks-2/ | City 2 | 1101 | Escalon, City of 195 | City 2 | City Agency 2 | San Joaquin 39 | 0.329 | Dinosaur Park | 0 | Local Park 2 | 4 | |
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} | Open Access 1 | 12843 | Corral Mountain Open Space | 17655 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 46.202 | Corral Mtn. OS | 0 | Private Recreation or Education 65 | 4 | |
1524 | 1524 | 1523 | {"type": "Polygon", "coordinates": [[[-117.12865, 33.15166], [-117.12863, 33.15202], [-117.12765, 33.15199], [-117.12767, 33.15133], [-117.12844, 33.15134], [-117.12843, 33.15165], [-117.12865, 33.15166]]]} | Open Access 1 | 47730 | Woodland Park Tennis Courts | 31531 | 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 | 1.518 | Woodland Park Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
1525 | 1525 | 1524 | {"type": "Polygon", "coordinates": [[[-122.46518, 37.78019], [-122.46486, 37.7802], [-122.46483, 37.77994], [-122.46516, 37.77993], [-122.46518, 37.78019]]]} | Open Access 1 | 15947 | Muriel Leff Mini Park | 22604 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.206 | Muriel Leff MP | 0 | Local Park 2 | 4 | |
1526 | 1526 | 1525 | {"type": "Polygon", "coordinates": [[[-118.50099, 34.17906], [-118.49854, 34.17803], [-118.49442, 34.17649], [-118.48937, 34.17455], [-118.47912, 34.17066], [-118.48, 34.17022], [-118.48079, 34.16993], [-118.48155, 34.16969], [-118.48232, 34.16949], [-118.48336, 34.16927], [-118.48464, 34.16886], [-118.48587, 34.16861], [-118.48659, 34.16843], [-118.48732, 34.16823], [-118.48784, 34.16822], [-118.48841, 34.16791], [-118.48987, 34.16748], [-118.49042, 34.16735], [-118.49087, 34.16727], [-118.49143, 34.16721], [-118.492, 34.1672], [-118.49256, 34.16722], [-118.49313, 34.16728], [-118.49369, 34.16739], [-118.49412, 34.1675], [-118.49465, 34.16768], [-118.49526, 34.16794], [-118.49583, 34.16825], [-118.49636, 34.16861], [-118.49669, 34.16888], [-118.49692, 34.16909], [-118.49738, 34.16963], [-118.49767, 34.1701], [-118.49815, 34.17079], [-118.49842, 34.17144], [-118.49856, 34.17168], [-118.49871, 34.17186], [-118.49887, 34.17201], [-118.49905, 34.17213], [-118.49927, 34.17223], [-118.49953, 34.17249], [-118.50001, 34.17249], [-118.50089, 34.17236], [-118.50092, 34.17238], [-118.50093, 34.17592], [-118.50098, 34.17593], [-118.50099, 34.17906]]]} | Restricted Access 2 | 12883 | Balboa Golf Course & Encino Golf Course | 33032 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 320.852 | Balboa GC & Encino GC | 0 | Recreation Management Area 49 | 4 | |
1527 | 1527 | 1526 | {"type": "Polygon", "coordinates": [[[-118.26948, 33.99658], [-118.26946, 33.99832], [-118.26534, 33.99833], [-118.2653, 33.99661], [-118.26948, 33.99658]]]} | Open Access 1 | 12887 | South Park | 25672 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 18.202 | South 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]);