units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by DES_TP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,433
- County Agency 1,144
- State Agency 1,141
- Recreation/Parks District 1,112
- Non Profit - Land Trust 601
- Federal Agency 442
- Open Space District 416
- Water District 237
- County Agency - Parks 225
- Home Owners Association 203
- Community Services District 194
- Non Profit - Conservation 148
- Flood District 106
- Cemetery District 60
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 31
- 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 481
- California Department of Fish and Wildlife 443
- Los Angeles, City of 426
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 341
- San Jose, City of 229
- Sacramento, City of 220
- San Francisco, City and County of 217
- East Bay Regional Park District 166
- Los Angeles, County of 155
- Ventura, City of 147
- Long Beach, City of 132
- Roseville, City of 130
- Oakland, City of 119
- Santa Barbara, County of 111
- United States Forest Service 111
- San Diego, County of 107
- Consumnes Community Services District 94
- Orange, County of 90
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- United States Fish and Wildlife Service 82
- Irvine, City of 81
- Stockton, City of 81
- Napa, City of 81
- Hayward Area Recreation and Park District 78
- Tracy, City of 72
- Torrance, City of 67
- Valley-Wide Recreation and Park District 66
- …
DES_TP >30
- Local Park 8,126
- 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 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
- Research or Educational Area 3
- …
AGNCY_LEV 8 ✖
- City 9,308
- Special District 2,311
- County 1,369
- State 1,192
- Non Profit 781
- Federal 509
- Private 265
- Joint 8
ACCESS_TYP 4
- Open Access 13,206
- Restricted Access 1,190
- No Public Access 961
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1718 | 1718 | 1717 | {"type": "Polygon", "coordinates": [[[-118.23745, 34.23344], [-118.23721, 34.23376], [-118.23671, 34.23428], [-118.23649, 34.23467], [-118.23516, 34.23385], [-118.23517, 34.23204], [-118.23745, 34.23344]]]} | Open Access 1 | 14870 | Two Strike Park | 26627 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 8.187 | Two Strike Park | 0 | Local Park 2 | 4 | |
1719 | 1719 | 1718 | {"type": "Polygon", "coordinates": [[[-120.58203, 38.77208], [-120.58176, 38.77203], [-120.57991, 38.772], [-120.58004, 38.76833], [-120.58042, 38.76844], [-120.58081, 38.76858], [-120.5813, 38.76903], [-120.58158, 38.7696], [-120.58168, 38.77008], [-120.58144, 38.77071], [-120.58152, 38.77159], [-120.58172, 38.77186], [-120.58203, 38.77208]]]} | Open Access 1 | 48466 | Forebay Park | 33175 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | https://www.edcgov.us/Government/Parks/Pages/forebay_park.aspx | El Dorado 34 | 12.621 | Forebay Park | 0 | Local Park 2 | 4 |
1721 | 1721 | 1720 | {"type": "Polygon", "coordinates": [[[-122.38761, 40.57401], [-122.38715, 40.57505], [-122.38708, 40.57504], [-122.38665, 40.57598], [-122.38658, 40.57606], [-122.38647, 40.57612], [-122.38622, 40.57617], [-122.38602, 40.57616], [-122.38584, 40.57613], [-122.38372, 40.57537], [-122.38484, 40.57301], [-122.38761, 40.57401]]]} | Open Access 1 | 14879 | South City Park | 25641 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 17.504 | South City Park | 0 | Local Park 2 | 4 | |
1722 | 1722 | 1721 | {"type": "Polygon", "coordinates": [[[-122.43935, 37.79177], [-122.4363, 37.79215], [-122.43599, 37.79058], [-122.43904, 37.79019], [-122.43935, 37.79177]]]} | Open Access 1 | 14881 | Alta Plaza | 15419 | 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 | 11.905 | Alta Plaza | 0 | Local Park 2 | 4 | |
1723 | 1723 | 1722 | {"type": "Polygon", "coordinates": [[[-122.05996, 37.58657], [-122.06015, 37.58658], [-122.0603, 37.58663], [-122.06063, 37.58678], [-122.06074, 37.58685], [-122.06085, 37.58696], [-122.06092, 37.5871], [-122.06095, 37.58724], [-122.06094, 37.58736], [-122.06086, 37.58754], [-122.0596, 37.58923], [-122.05932, 37.58959], [-122.05929, 37.58962], [-122.05925, 37.58962], [-122.05908, 37.58951], [-122.05881, 37.58924], [-122.05864, 37.58913], [-122.05835, 37.58899], [-122.05794, 37.58888], [-122.05791, 37.58885], [-122.0579, 37.58882], [-122.05941, 37.58679], [-122.05952, 37.5867], [-122.05965, 37.58663], [-122.0598, 37.58658], [-122.05996, 37.58657]]]} | Open Access 1 | 12886 | Sylvester Harvey Park | 26153 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 11.625 | Sylvester Harvey Park | 0 | Local Park 2 | 4 | |
1724 | 1724 | 1723 | {"type": "Polygon", "coordinates": [[[-117.80418, 33.72957], [-117.80437, 33.72983], [-117.80448, 33.73013], [-117.80451, 33.7303], [-117.8045, 33.73061], [-117.80439, 33.73097], [-117.80423, 33.73121], [-117.80409, 33.73138], [-117.80388, 33.73153], [-117.80366, 33.73166], [-117.80333, 33.73178], [-117.80327, 33.7316], [-117.80348, 33.73152], [-117.8038, 33.73133], [-117.80312, 33.73005], [-117.80353, 33.72991], [-117.80408, 33.72956], [-117.80418, 33.72957]]]} | Open Access 1 | 12888 | Camino Real Park | 16768 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | Orange 3 | 4.357 | Camino Real Park | 0 | Local Park 2 | 4 | |
1725 | 1725 | 1724 | {"type": "Polygon", "coordinates": [[[-121.19542, 38.82059], [-121.19429, 38.82183], [-121.19403, 38.82168], [-121.19516, 38.82045], [-121.19542, 38.82059]]]} | Open Access 1 | 49001 | Blue Anchor Park | 33700 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | https://loomis.ca.gov/how-do-i/find-2/parks-recreation/ | Placer 35 | 1.147 | Blue Anchor Park | 0 | Local Park 2 | 4 |
1726 | 1726 | 1725 | {"type": "Polygon", "coordinates": [[[-122.3923, 40.58278], [-122.39221, 40.5828], [-122.39188, 40.58203], [-122.39209, 40.58198], [-122.3923, 40.58278]]]} | Open Access 1 | 14916 | Library Park | 21220 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.299 | Library Park | 0 | Local Park 2 | 4 | |
1727 | 1727 | 1726 | {"type": "Polygon", "coordinates": [[[-117.77091, 33.75019], [-117.77024, 33.75143], [-117.77025, 33.75147], [-117.77037, 33.75162], [-117.77037, 33.75166], [-117.77001, 33.75194], [-117.76992, 33.75207], [-117.76991, 33.75218], [-117.76992, 33.75242], [-117.7699, 33.75251], [-117.76973, 33.75262], [-117.76963, 33.75258], [-117.76951, 33.75261], [-117.76941, 33.75261], [-117.76929, 33.75259], [-117.7692, 33.75255], [-117.76914, 33.75248], [-117.76901, 33.75223], [-117.76878, 33.75189], [-117.76851, 33.7514], [-117.76835, 33.75103], [-117.76863, 33.75071], [-117.76901, 33.75045], [-117.76929, 33.7503], [-117.76953, 33.75021], [-117.7699, 33.75012], [-117.77045, 33.75007], [-117.77045, 33.75014], [-117.77091, 33.75019]]]} | Open Access 1 | 12889 | Cedar Grove Park | 16996 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | Orange 3 | 9.591 | Cedar Grove Park | 0 | Local Park 2 | 4 | |
1728 | 1728 | 1727 | {"type": "Polygon", "coordinates": [[[-117.56879, 34.11417], [-117.56761, 34.11418], [-117.56759, 34.11388], [-117.56754, 34.11363], [-117.56745, 34.11334], [-117.5673, 34.113], [-117.56731, 34.11295], [-117.56735, 34.11292], [-117.56837, 34.11268], [-117.56879, 34.11417]]]} | Open Access 1 | 12911 | Spruce Avenue Park | 25753 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 3.899 | Spruce Avenue Park | 0 | Local Park 2 | 4 | |
1729 | 1729 | 1728 | {"type": "Polygon", "coordinates": [[[-122.06061, 37.5823], [-122.06044, 37.58247], [-122.06027, 37.58235], [-122.06005, 37.58217], [-122.05986, 37.58197], [-122.05972, 37.58179], [-122.05959, 37.58154], [-122.06024, 37.58146], [-122.06034, 37.58191], [-122.06037, 37.58196], [-122.06043, 37.58201], [-122.06057, 37.58205], [-122.06061, 37.5823]]]} | Open Access 1 | 12922 | Warbler Park | 27252 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.19 | Warbler Park | 0 | Local Park 2 | 4 | |
1731 | 1731 | 1730 | {"type": "MultiPolygon", "coordinates": [[[[-117.81129, 33.76654], [-117.81097, 33.77124], [-117.8108, 33.77342], [-117.81067, 33.77342], [-117.81095, 33.76974], [-117.81117, 33.76654], [-117.81129, 33.76654]]], [[[-117.81175, 33.75996], [-117.81146, 33.76454], [-117.81131, 33.76637], [-117.81119, 33.76638], [-117.81132, 33.76454], [-117.81133, 33.76422], [-117.8115, 33.76143], [-117.81161, 33.75995], [-117.81175, 33.75996]]]]} | Open Access 1 | 12930 | Esplanade Park | 18714 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.697 | Esplanade Park | 0 | Local Park 2 | 4 | |
1732 | 1732 | 1731 | {"type": "Polygon", "coordinates": [[[-117.79607, 33.73433], [-117.79549, 33.73543], [-117.79537, 33.73547], [-117.79461, 33.73512], [-117.79448, 33.73498], [-117.79435, 33.73497], [-117.79427, 33.735], [-117.79401, 33.73485], [-117.79493, 33.7337], [-117.79524, 33.73394], [-117.79553, 33.73407], [-117.79601, 33.73423], [-117.79607, 33.73433]]]} | Open Access 1 | 12932 | Heritage Park | 19858 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | Orange 3 | 4.987 | Heritage Park | 0 | Local Park 2 | 4 | |
1733 | 1733 | 1732 | {"type": "Polygon", "coordinates": [[[-121.923, 37.48603], [-121.92178, 37.48647], [-121.92177, 37.48649], [-121.92182, 37.48658], [-121.92114, 37.48684], [-121.9199, 37.48473], [-121.9219, 37.48403], [-121.92244, 37.48494], [-121.92239, 37.48497], [-121.923, 37.48603]]]} | Open Access 1 | 12934 | Warm Springs Park | 27260 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 11.662 | Warm Springs Park | 1984 | Local Park 2 | 4 | |
1734 | 1734 | 1733 | {"type": "Polygon", "coordinates": [[[-121.64828, 37.10579], [-121.64748, 37.10612], [-121.64742, 37.10609], [-121.64659, 37.10644], [-121.64631, 37.10659], [-121.64608, 37.10646], [-121.64595, 37.10656], [-121.64579, 37.10674], [-121.64568, 37.10693], [-121.64561, 37.10712], [-121.64413, 37.10621], [-121.64433, 37.106], [-121.64464, 37.10572], [-121.64511, 37.10523], [-121.64597, 37.10577], [-121.64601, 37.10576], [-121.64605, 37.10582], [-121.64615, 37.10585], [-121.64615, 37.10588], [-121.64646, 37.10607], [-121.64784, 37.10551], [-121.64828, 37.10579]]]} | Open Access 1 | 14950 | Paradise Park | 23404 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 7.212 | Paradise Park | 0 | Local Park 2 | 4 | |
1735 | 1735 | 1734 | {"type": "Polygon", "coordinates": [[[-117.23838, 33.21173], [-117.23856, 33.21185], [-117.23857, 33.2119], [-117.23828, 33.21216], [-117.23821, 33.21217], [-117.23734, 33.21166], [-117.23732, 33.21167], [-117.23733, 33.21172], [-117.23731, 33.21171], [-117.2373, 33.21132], [-117.23824, 33.21188], [-117.23838, 33.21173]]]} | Open Access 1 | 12942 | Raintree Park | 24094 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 0.968 | Raintree Park | 0 | Local Park 2 | 4 |
1736 | 1736 | 1735 | {"type": "Polygon", "coordinates": [[[-117.10161, 33.14781], [-117.10054, 33.14783], [-117.10058, 33.14924], [-117.09922, 33.14927], [-117.09919, 33.14852], [-117.09833, 33.14853], [-117.09826, 33.14822], [-117.09916, 33.14747], [-117.09914, 33.1465], [-117.09734, 33.14653], [-117.09741, 33.14629], [-117.0975, 33.14628], [-117.09751, 33.14626], [-117.09905, 33.14625], [-117.10077, 33.14621], [-117.10158, 33.14671], [-117.10161, 33.14781]]]} | Open Access 1 | 12943 | Rod McLeod Park | 24547 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/rod-mcleod-park.aspx | San Diego 4 | 17.211 | Rod McLeod Park | 0 | Local Park 2 | 4 |
1737 | 1737 | 1736 | {"type": "Polygon", "coordinates": [[[-122.02264, 37.56384], [-122.02152, 37.56529], [-122.02068, 37.56488], [-122.02173, 37.56353], [-122.02206, 37.56367], [-122.02247, 37.56378], [-122.02264, 37.56384]]]} | Open Access 1 | 12946 | Westridge Park | 27420 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 3.914 | Westridge Park | 0 | Local Park 2 | 4 | |
1738 | 1738 | 1737 | {"type": "Polygon", "coordinates": [[[-117.84482, 33.61091], [-117.84442, 33.6108], [-117.84419, 33.6107], [-117.84396, 33.61058], [-117.8442, 33.61028], [-117.84435, 33.6102], [-117.84453, 33.61016], [-117.84464, 33.61024], [-117.84461, 33.61032], [-117.84464, 33.61041], [-117.8447, 33.61045], [-117.84478, 33.61046], [-117.84482, 33.61091]]]} | Open Access 1 | 12947 | Spyglass Hill Reservoir Park | 25757 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.949 | Spyglass Hill Reservoir Park | 0 | Local Park 2 | 4 | |
1740 | 1740 | 1739 | {"type": "Polygon", "coordinates": [[[-117.28608, 34.16159], [-117.28607, 34.16208], [-117.28517, 34.16208], [-117.28517, 34.16159], [-117.28608, 34.16159]]]} | Open Access 1 | 12949 | Sierra Park | 25463 | 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.126 | Sierra 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]);