units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,663
- County Agency 1,092
- Recreation/Parks District 1,087
- State Agency 1,049
- Non Profit - Land Trust 585
- Federal Agency 476
- Open Space District 359
- County Agency - Parks 213
- Water District 203
- Home Owners Association 196
- Community Services District 190
- Non Profit - Conservation 138
- Flood District 67
- Cemetery District 47
- School District 37
- Irrigation District 36
- Non Profit - Other 33
- Port/Harbor District 31
- County Agency - Other 26
- Special District - Other 15
- Sanitation District 7
- Commercial 6
- Non Profit - Cemetery District 5
- Transportation Agency 5
- Conservation District 4
- Joint Powers Authority 3
- Other 3
- Mitigation Bank 3
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 483
- Los Angeles, City of 458
- California Department of Fish and Wildlife 440
- California Department of Parks and Recreation 375
- Mountains Recreation and Conservation Authority 305
- San Jose, City of 243
- Sacramento, City of 214
- San Francisco, City and County of 201
- Los Angeles, County of 157
- East Bay Regional Park District 154
- Ventura, City of 142
- Long Beach, City of 133
- Roseville, City of 125
- United States Bureau of Land Management 116
- Oakland, City of 115
- San Diego, County of 114
- United States Forest Service 103
- Santa Barbara, County of 101
- Irvine, City of 98
- Consumnes Community Services District 94
- United States National Park Service 89
- Orange, County of 88
- Modesto, City of 84
- Hayward Area Recreation and Park District 83
- California State Lands Commission 82
- Stockton, City of 78
- United States Fish and Wildlife Service 77
- Fresno, City of 75
- Napa, City of 75
- Huntington Beach, City of 73
- …
DES_TP >30
- Local Park 9,109
- Local Recreation Area 1,959
- Local Other or Unknown 1,178
- Private Conservation 620
- Local Conservation Area 480
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 144
- Local Historic or Cultural Area 102
- National Forest 98
- 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
- …
ACCESS_TYP 4
- Open Access 13,360
- Restricted Access 1,090
- No Public Access 809
- Unknown Access 327
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
399 | 399 | 398 | {"type": "Polygon", "coordinates": [[[-117.67941, 34.11771], [-117.67723, 34.11772], [-117.67722, 34.116], [-117.6794, 34.11599], [-117.67941, 34.11771]]]} | Open Access 1 | 1203 | Greenbelt Park | 19473 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 9.512 | Greenbelt Park | 0 | Local Park 2 | 4 | |
400 | 400 | 399 | {"type": "Polygon", "coordinates": [[[-121.93951, 38.36208], [-121.9394, 38.3621], [-121.93921, 38.36218], [-121.93907, 38.36221], [-121.93876, 38.36222], [-121.93861, 38.36224], [-121.93817, 38.36246], [-121.938, 38.36247], [-121.93788, 38.36242], [-121.93768, 38.36205], [-121.93759, 38.36196], [-121.93748, 38.36181], [-121.93743, 38.36171], [-121.93741, 38.36157], [-121.93736, 38.36147], [-121.93732, 38.36111], [-121.93771, 38.36102], [-121.93861, 38.36076], [-121.93867, 38.36075], [-121.93871, 38.36078], [-121.93918, 38.36149], [-121.93951, 38.36208]]]} | Open Access 1 | 1215 | Stonegate Park | 25888 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.702 | Stonegate Park | 0 | Local Park 2 | 4 | |
401 | 401 | 400 | {"type": "Polygon", "coordinates": [[[-115.52412, 32.9724], [-115.52322, 32.9724], [-115.52322, 32.97086], [-115.52412, 32.97086], [-115.52412, 32.9724]]]} | Open Access 1 | 1270 | Guadalupe Park | 19557 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 3.577 | Guadalupe Park | 0 | Local Park 2 | 4 | |
402 | 402 | 401 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | 1556 | Springville Ecological Reserve | 25751 | 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 | Tulare 29 | 4.947 | Springville ER | 0 | State Conservation Area 8 | 2 | |
403 | 403 | 402 | {"type": "Polygon", "coordinates": [[[-122.51336, 37.9088], [-122.51314, 37.90905], [-122.51286, 37.9095], [-122.51262, 37.91045], [-122.51268, 37.91098], [-122.51245, 37.91139], [-122.51184, 37.91121], [-122.51148, 37.91148], [-122.51096, 37.91151], [-122.51099, 37.91097], [-122.51073, 37.90717], [-122.51103, 37.90745], [-122.51151, 37.90854], [-122.51207, 37.90839], [-122.51279, 37.90839], [-122.51308, 37.90879], [-122.51336, 37.9088]]]} | Open Access 1 | 1554 | Tiburon Ridge Open Space Preserve | 26341 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 14.684 | Tiburon Ridge OSP | 0 | Local Conservation Area 4 | 2 | |
405 | 405 | 404 | {"type": "Polygon", "coordinates": [[[-119.34539, 36.23661], [-119.3433, 36.23661], [-119.34258, 36.23569], [-119.34356, 36.2354], [-119.34401, 36.23528], [-119.3445, 36.23512], [-119.34479, 36.23504], [-119.34501, 36.23538], [-119.34514, 36.23564], [-119.34523, 36.23588], [-119.34531, 36.23614], [-119.34539, 36.23661]]]} | Open Access 1 | 1245 | Blain Park | 16148 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 7.423 | Blain Park | 0 | Local Park 2 | 4 | |
406 | 406 | 405 | {"type": "Polygon", "coordinates": [[[-118.29329, 34.16445], [-118.29239, 34.1653], [-118.29166, 34.16477], [-118.29256, 34.16391], [-118.29329, 34.16445]]]} | Open Access 1 | 1246 | Griffith Manor Park | 19516 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 2.805 | Griffith Manor Park | 0 | Local Park 2 | 4 | |
407 | 407 | 406 | {"type": "Polygon", "coordinates": [[[-119.35321, 36.21913], [-119.3532, 36.22023], [-119.35146, 36.22027], [-119.351, 36.21817], [-119.35206, 36.21818], [-119.35301, 36.21816], [-119.3532, 36.21824], [-119.35321, 36.21913]]]} | Open Access 1 | 1252 | Centennial Park | 17030 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 10.109 | Centennial Park | 0 | Local Park 2 | 4 | |
408 | 408 | 407 | {"type": "Polygon", "coordinates": [[[-117.74, 34.11611], [-117.73999, 34.11804], [-117.738, 34.11801], [-117.73801, 34.1178], [-117.73811, 34.11634], [-117.73813, 34.11613], [-117.73814, 34.1161], [-117.73818, 34.11609], [-117.73923, 34.11609], [-117.73975, 34.1161], [-117.73989, 34.11612], [-117.74, 34.11611]]]} | Open Access 1 | 1253 | Griffith Park | 19517 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 9.444 | Griffith Park | 0 | Local Park 2 | 4 | |
411 | 411 | 410 | {"type": "Polygon", "coordinates": [[[-117.30344, 34.0362], [-117.30312, 34.03635], [-117.303, 34.03459], [-117.30316, 34.0344], [-117.30322, 34.03425], [-117.30325, 34.03409], [-117.30331, 34.03405], [-117.30333, 34.03405], [-117.30333, 34.03443], [-117.30332, 34.03444], [-117.30344, 34.0362]]]} | Open Access 1 | 47372 | Griffin Park | 31098 | 1123 | Grand Terrace, City of 165 | City 2 | City Agency 2 | http://www.cityofgrandterrace.org/index.aspx?nid=25 | City 2 | 1123 | Grand Terrace, City of 161 | City 2 | City Agency 2 | San Bernardino 22 | 1.632 | Griffin Park | 0 | Local Park 2 | 4 | |
412 | 412 | 411 | {"type": "Polygon", "coordinates": [[[-117.33003, 34.06197], [-117.32998, 34.06223], [-117.329, 34.06209], [-117.32902, 34.062], [-117.32935, 34.06202], [-117.33003, 34.06197]]]} | Open Access 1 | 47373 | N Street Mini Park West | 31096 | 1062 | Colton, City of 166 | City 2 | City Agency 2 | http://www.ci.colton.ca.us/index.aspx?NID=136 | City 2 | 1062 | Colton, City of 162 | City 2 | City Agency 2 | San Bernardino 22 | 0.397 | N Street MP West | 0 | Local Park 2 | 4 | |
413 | 413 | 412 | {"type": "Polygon", "coordinates": [[[-118.60477, 34.27717], [-118.60418, 34.27703], [-118.60318, 34.2767], [-118.60222, 34.27647], [-118.60128, 34.2759], [-118.59886, 34.27528], [-118.59773, 34.27477], [-118.5968, 34.27437], [-118.59644, 34.27429], [-118.59687, 34.27384], [-118.59763, 34.27384], [-118.59817, 34.27352], [-118.59822, 34.27339], [-118.59913, 34.27345], [-118.59979, 34.27347], [-118.60035, 34.2736], [-118.60064, 34.27325], [-118.60057, 34.27261], [-118.60272, 34.2726], [-118.60273, 34.27228], [-118.60457, 34.27224], [-118.60449, 34.27236], [-118.60431, 34.27294], [-118.60432, 34.27441], [-118.60439, 34.27467], [-118.60448, 34.27485], [-118.60448, 34.27491], [-118.60457, 34.27492], [-118.60477, 34.27613], [-118.60481, 34.27645], [-118.60482, 34.27667], [-118.6048, 34.27695], [-118.60477, 34.27717]]]} | Open Access 1 | 831 | Stoney Point Park | 30273 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 55.047 | Stoney Point Park | 0 | Local Park 2 | 4 | |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
415 | 415 | 414 | {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21136, 34.11055], [-118.21098, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21117, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} | Open Access 1 | 1647 | Heidelberg Park | 19791 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.734 | Heidelberg Park | 0 | Local Park 2 | 4 | |
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 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 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
417 | 417 | 416 | {"type": "Polygon", "coordinates": [[[-119.79275, 36.7758], [-119.79168, 36.77582], [-119.79168, 36.77414], [-119.79274, 36.77413], [-119.79275, 36.7758]]]} | Open Access 1 | 1290 | Lafayette Park | 20831 | 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 | 4.353 | Lafayette Park | 0 | Local Park 2 | 4 | |
418 | 418 | 417 | {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} | Open Access 1 | 1666 | Upper Struve Slough | 28147 | 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 | 15.625 | Upper Struve Slough | 0 | Local Conservation Area 4 | 2 | |
419 | 419 | 418 | {"type": "Polygon", "coordinates": [[[-119.35505, 36.20879], [-119.35454, 36.20886], [-119.35447, 36.20859], [-119.35391, 36.20865], [-119.35361, 36.2071], [-119.35416, 36.20701], [-119.35428, 36.20746], [-119.35473, 36.2074], [-119.35505, 36.20879]]]} | Open Access 1 | 1293 | Tyler Park | 26629 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 3.989 | Tyler Park | 0 | Local Park 2 | 4 | |
420 | 420 | 419 | {"type": "Polygon", "coordinates": [[[-117.97183, 33.79249], [-117.97103, 33.79199], [-117.97103, 33.79179], [-117.97112, 33.79178], [-117.97112, 33.79137], [-117.97181, 33.79137], [-117.97183, 33.79249]]]} | Open Access 1 | 1294 | Gutosky Park | 19574 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 1.639 | Gutosky Park | 0 | Local Park 2 | 4 | |
421 | 421 | 420 | {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} | Open Access 1 | 1297 | Zumwalt Park | 27871 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 2.969 | Zumwalt 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]);