units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 208
- California Department of Fish and Wildlife 150
- San Diego, City of 129
- Los Angeles, City of 103
- Ventura, City of 101
- Consumnes Community Services District 86
- Roseville, City of 63
- East Bay Regional Park District 61
- Mountains Recreation and Conservation Authority 60
- Los Angeles, County of 56
- California State Lands Commission 52
- Long Beach, City of 51
- Butte, County of 45
- Poway, City of 42
- Tracy, City of 41
- United States Forest Service 40
- Irvine, City of 39
- Lake, County of 39
- Folsom, City of 36
- Orange, County of 35
- Stockton, City of 34
- Arcata, City of 34
- El Dorado, County of 33
- Sunrise Recreation and Park District 33
- Southgate Recreation and Park District 32
- Cordova Recreation and Park District 31
- San Jose, City of 29
- United States National Park Service 29
- San Diego, County of 27
- Valley-Wide Recreation and Park District 27
- …
DES_TP >30
- Local Park 2,110
- Local Recreation Area 713
- Local Other or Unknown 591
- State Conservation Area 144
- Local Conservation Area 139
- State Park 125
- Private Conservation 69
- State Recreation Area 67
- State Resource Management Area 55
- National Forest 37
- State Historic or Cultural Area 35
- Recreation Management Area 19
- Private Recreation or Education 18
- National Wildlife Refuge 16
- National Monument or Landmark 14
- National Recreation Area 13
- National Park 9
- National Public Lands 8
- Local Historic or Cultural Area 7
- Local Resource Management Area 5
- Federal Other or Unknown 4
- Conservation Area 3
- Resource Management Area 3
- State Other or Unknown 3
- Historic or Cultural Area 3
- Private Agricultural 3
- Private Other or Unknown 3
- State Wilderness 1
- Area of Critical Environmental Concern 1
- None 1
- …
MNG_AG_TYP 25
- City Agency 2,597
- State Agency 443
- Recreation/Parks District 428
- County Agency 380
- Community Services District 142
- Federal Agency 121
- Open Space District 94
- County Agency - Parks 80
- Non Profit - Land Trust 68
- Water District 42
- Non Profit - Conservation 24
- Irrigation District 13
- Flood District 12
- Non Profit - Other 12
- Special District - Other 11
- County Agency - Other 7
- Port/Harbor District 6
- Cemetery District 3
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Sanitation District 1
- Fire District 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 4,494 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11533 | 11533 | 11532 | {"type": "Polygon", "coordinates": [[[-119.54486, 36.70648], [-119.54482, 36.70651], [-119.54449, 36.70651], [-119.54409, 36.70657], [-119.54394, 36.70635], [-119.54438, 36.70628], [-119.54482, 36.70626], [-119.54486, 36.70648]]]} | Open Access 1 | 48238 | Medrano Park | 33385 | 1315 | Sanger, City of 231 | City 2 | City Agency 2 | http://www.ci.sanger.ca.us/parks-rec.asp | City 2 | 1315 | Sanger, City of 227 | City 2 | City Agency 2 | Fresno 9 | 0.484 | Medrano Park | 0 | Local Park 2 | 4 | |
11535 | 11535 | 11534 | {"type": "Polygon", "coordinates": [[[-119.55396, 36.70525], [-119.55347, 36.70532], [-119.55338, 36.7049], [-119.55387, 36.70483], [-119.55396, 36.70525]]]} | Open Access 1 | 48239 | Sanger Youth Center | 32797 | 1315 | Sanger, City of 231 | City 2 | City Agency 2 | http://www.ci.sanger.ca.us/parks-rec.asp | City 2 | 1315 | Sanger, City of 227 | City 2 | City Agency 2 | Fresno 9 | 0.522 | Sanger Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
11536 | 11536 | 11535 | {"type": "Polygon", "coordinates": [[[-122.87222, 38.64282], [-122.87178, 38.64314], [-122.87062, 38.64408], [-122.87, 38.64377], [-122.86856, 38.64383], [-122.86688, 38.64229], [-122.86594, 38.64229], [-122.86592, 38.6421], [-122.86587, 38.64188], [-122.86589, 38.64183], [-122.86593, 38.64181], [-122.86644, 38.6417], [-122.86694, 38.64153], [-122.86732, 38.64133], [-122.86766, 38.64109], [-122.86885, 38.64215], [-122.86908, 38.64199], [-122.8692, 38.64207], [-122.86931, 38.64209], [-122.86942, 38.64206], [-122.86958, 38.64195], [-122.86976, 38.64211], [-122.87056, 38.64211], [-122.87065, 38.64219], [-122.87141, 38.64269], [-122.87155, 38.64277], [-122.87171, 38.64282], [-122.87188, 38.64284], [-122.87206, 38.64284], [-122.87222, 38.64282]]]} | Open Access 1 | 23644 | Barbieri Brothers Park | 15809 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 19.743 | Barbieri Brothers Park | 0 | Local Park 2 | 4 | |
11537 | 11537 | 11536 | {"type": "Polygon", "coordinates": [[[-117.0486, 32.7894], [-117.04835, 32.78961], [-117.04833, 32.78997], [-117.04827, 32.79007], [-117.0482, 32.7901], [-117.04802, 32.79011], [-117.04794, 32.79007], [-117.04786, 32.78998], [-117.04737, 32.78925], [-117.04693, 32.7887], [-117.04674, 32.7886], [-117.04656, 32.78859], [-117.04647, 32.78865], [-117.04639, 32.78874], [-117.04613, 32.79004], [-117.04591, 32.79039], [-117.04574, 32.79053], [-117.0456, 32.7906], [-117.04548, 32.7906], [-117.04536, 32.79056], [-117.04522, 32.79045], [-117.04521, 32.79013], [-117.04522, 32.78947], [-117.04519, 32.7892], [-117.0451, 32.78876], [-117.0449, 32.78852], [-117.04461, 32.78837], [-117.04434, 32.78864], [-117.04419, 32.78962], [-117.04371, 32.78954], [-117.04284, 32.78998], [-117.04086, 32.79171], [-117.04012, 32.79278], [-117.03984, 32.79352], [-117.04011, 32.79405], [-117.04009, 32.79452], [-117.04001, 32.79427], [-117.03971, 32.79409], [-117.03942, 32.79413], [-117.03887, 32.79482], [-117.03869, 32.79532], [-117.03819, 32.79565], [-117.03811, 32.79563], [-117.03808, 32.79554], [-117.03811, 32.79545], [-117.03834, 32.79523], [-117.03841, 32.79512], [-117.03843, 32.79504], [-117.03833, 32.79497], [-117.03819, 32.79495], [-117.03813, 32.79497], [-117.03816, 32.79486], [-117.03817, 32.79473], [-117.03813, 32.79467], [-117.03805, 32.79462], [-117.03791, 32.79461], [-117.03785, 32.79455], [-117.03783, 32.79437], [-117.03793, 32.79427], [-117.03807, 32.79421], [-117.03807, 32.79409], [-117.038, 32.79397], [-117.03799, 32.79391], [-117.03802, 32.79379], [-117.03833, 32.79304], [-117.03849, 32.79231], [-117.03854, 32.79214], [-117.03873, 32.79176], [-117.03853, 32.79142], [-117.03943, 32.79047], [-117.0404, 32.78811], [-117.04039, 32.78806], [-117.04036, 32.78801], [-117.03996, 32.78782], [-117.03992, 32.78782], [-117.03987, 32.78783], [-117.03939, 32.78814], [-117.03926, 32.78819], [-117.03922, 32.78819], [-117.03919, 32.78816], [-117.03919, 32.78805], [-117.03915, 32.78794], [-117.03922, 32.78778], [-117.03921, 32.78773], [-117.03899, 32.7875], [-117.03895, 32.78749], [-117.03849, 32.78753], [-117.0384, 32.78752], [-117.03827, 32.78749], [-117.03765, 32.78752], [-117.03696, 32.78761], [-117.03661, 32.78772], [-117.03634, 32.7877], [-117.03628, 32.78771], [-117.0362, 32.78768], [-117.03617, 32.78763], [-117.03609, 32.78741], [-117.03609, 32.78722], [-117.0366, 32.78705], [-117.03773, 32.78646], [-117.03818, 32.78581], [-117.03892, 32.78572], [-117.03891, 32.78587], [-117.03882, 32.78601], [-117.03882, 32.78608], [-117.0389, 32.7862], [-117.03898, 32.78624], [-117.03911, 32.78625], [-117.03927, 32.78623], [-117.03941, 32.78619], [-117.0395, 32.78621], [-117.04, 32.78624], [-117.04051, 32.78618], [-117.04079, 32.78607], [-117.04089, 32.78595], [-117.0409, 32.78581], [-117.04115, 32.78577], [-117.04128, 32.78581], [-117.04154, 32.78577], [-117.04161, 32.78574], [-117.04165, 32.7858], [-117.04164, 32.78582], [-117.04207, 32.78639], [-117.04214, 32.78637], [-117.04177, 32.78569], [-117.0418, 32.78567], [-117.04194, 32.78577], [-117.04201, 32.78572], [-117.04174, 32.78546], [-117.04216, 32.78516], [-117.04226, 32.78505], [-117.04235, 32.78493], [-117.04239, 32.78482], [-117.04238, 32.78475], [-117.0423, 32.78466], [-117.04252, 32.78442], [-117.04257, 32.78443], [-117.04259, 32.78437], [-117.04246, 32.78427], [-117.04241, 32.78433], [-117.04244, 32.78437], [-117.04219, 32.78464], [-117.04195, 32.78456], [-117.0417, 32.78456], [-117.0415, 32.78448], [-117.04126, 32.78433], [-117.04123, 32.78435], [-117.0413, 32.78443], [-117.04133, 32.78451], [-117.04133, 32.78456], [-117.04127, 32.78464], [-117.04107, 32.78468], [-117.0407, 32.78481], [-117.04063, 32.78478], [-117.0406, 32.7847], [-117.04048, 32.78469], [-117.04046, 32.78466], [-117.04043, 32.78456], [-117.04039, 32.78451], [-117.04016, 32.78437], [-117.04004, 32.78423], [-117.0401, 32.78407], [-117.04012, 32.78395], [-117.04005, 32.78394], [-117.03993, 32.78402], [-117.03985, 32.78414], [-117.03983, 32.78419], [-117.03971, 32.78417], [-117.03963, 32.78412], [-117.03956, 32.78412], [-117.0393, 32.78398], [-117.039, 32.78389], [-117.03892, 32.78378], [-117.0389, 32.78364], [-117.03892, 32.78344], [-117.03935, 32.78295], [-117.03947, 32.78286], [-117.03961, 32.7828], [-117.03983, 32.78279], [-117.03995, 32.78279], [-117.04, 32.78283], [-117.04002, 32.7829], [-117.03998, 32.78296], [-117.03999, 32.78303], [-117.04026, 32.78319], [-117.04035, 32.78327], [-117.04046, 32.78331], [-117.04055, 32.78331], [-117.04073, 32.78321], [-117.04102, 32.78316], [-117.04115, 32.78317], [-117.04135, 32.78329], [-117.04179, 32.78326], [-117.04224, 32.78326], [-117.0424, 32.78335], [-117.04263, 32.78344], [-117.04282, 32.78343], [-117.04297, 32.78339], [-117.04306, 32.78331], [-117.04309, 32.78317], [-117.04323, 32.78305], [-117.04329, 32.78296], [-117.04334, 32.78285], [-117.04332, 32.78271], [-117.04346, 32.78265], [-117.04349, 32.78257], [-117.04349, 32.78248], [-117.0434, 32.78245], [-117.04332, 32.78239], [-117.04335, 32.78233], [-117.04349, 32.78227], [-117.04354, 32.7822], [-117.04348, 32.7821], [-117.04343, 32.78206], [-117.04337, 32.78194], [-117.04327, 32.78185], [-117.04337, 32.78169], [-117.04358, 32.78157], [-117.0439, 32.78146], [-117.04415, 32.78145], [-117.04468, 32.78124], [-117.04618, 32.78194], [-117.04683, 32.78235], [-117.04659, 32.78242], [-117.04632, 32.78255], [-117.04632, 32.78257], [-117.04672, 32.78273], [-117.04609, 32.7834], [-117.04615, 32.78367], [-117.04623, 32.78392], [-117.04638, 32.78418], [-117.04672, 32.78458], [-117.04686, 32.78472], [-117.04722, 32.78483], [-117.04771, 32.7849], [-117.04743, 32.78562], [-117.04743, 32.78566], [-117.04758, 32.78602], [-117.04728, 32.78609], [-117.04724, 32.78629], [-117.04747, 32.78674], [-117.04768, 32.78689], [-117.04789, 32.78727], [-117.04813, 32.78784], [-117.04821, 32.78881], [-117.04832, 32.78923], [-117.0486, 32.7894]]]} | Open Access 1 | 46818 | Murray Reservoir | 30282 | 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 | http://www.sandiego.gov/water/recreation/reservoirs/murray.shtml | San Diego 4 | 171.108 | Murray Reservoir | 0 | Local Recreation Area 3 | 4 |
11538 | 11538 | 11537 | {"type": "Polygon", "coordinates": [[[-121.22905, 36.3312], [-121.22856, 36.33147], [-121.22839, 36.33127], [-121.22888, 36.331], [-121.22905, 36.3312]]]} | Open Access 1 | 47109 | Traditions Park | 30776 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.353 | Traditions Park | 0 | Local Park 2 | 4 | |
11542 | 11542 | 11541 | {"type": "Polygon", "coordinates": [[[-124.25267, 41.78246], [-124.25248, 41.78431], [-124.25191, 41.78429], [-124.25189, 41.78253], [-124.25267, 41.78246]]]} | Open Access 1 | 29640 | North Beach Fishing Access | 32245 | 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 | Del Norte 50 | 2.776 | North Beach FA | 0 | State Recreation Area 39 | 4 | |
11543 | 11543 | 11542 | {"type": "MultiPolygon", "coordinates": [[[[-116.75415, 33.11659], [-116.74551, 33.11663], [-116.74542, 33.11289], [-116.7368, 33.11289], [-116.73672, 33.10922], [-116.74108, 33.10916], [-116.75405, 33.10902], [-116.75415, 33.11659]]], [[[-117.06775, 33.06646], [-117.06716, 33.06725], [-117.06706, 33.06737], [-117.06694, 33.06746], [-117.06674, 33.06757], [-117.06659, 33.06761], [-117.06614, 33.06765], [-117.06615, 33.06699], [-117.06613, 33.06643], [-117.06607, 33.06616], [-117.06632, 33.0655], [-117.06657, 33.06554], [-117.06673, 33.06562], [-117.06685, 33.06575], [-117.06695, 33.066], [-117.06705, 33.0661], [-117.06732, 33.06576], [-117.06738, 33.06579], [-117.06712, 33.06613], [-117.06775, 33.06646]]], [[[-117.10005, 33.06801], [-117.10004, 33.0681], [-117.09918, 33.06793], [-117.09753, 33.06784], [-117.09802, 33.06603], [-117.09804, 33.06572], [-117.09794, 33.06545], [-117.09654, 33.06581], [-117.09615, 33.06577], [-117.09574, 33.06582], [-117.09543, 33.06595], [-117.09509, 33.06631], [-117.09347, 33.06618], [-117.09347, 33.06612], [-117.08976, 33.06581], [-117.08969, 33.06653], [-117.08962, 33.067], [-117.08943, 33.06903], [-117.08916, 33.07157], [-117.08882, 33.07154], [-117.08889, 33.07095], [-117.08854, 33.07087], [-117.08821, 33.07118], [-117.08815, 33.07128], [-117.08807, 33.07148], [-117.08524, 33.07125], [-117.08536, 33.07057], [-117.08613, 33.07024], [-117.08581, 33.06924], [-117.08589, 33.06833], [-117.08632, 33.06777], [-117.08753, 33.06777], [-117.08762, 33.06754], [-117.08779, 33.06623], [-117.0888, 33.0652], [-117.08987, 33.06472], [-117.09055, 33.05824], [-117.09085, 33.05853], [-117.09103, 33.05874], [-117.09121, 33.05888], [-117.09135, 33.05904], [-117.09166, 33.05919], [-117.09172, 33.05933], [-117.09174, 33.05947], [-117.09168, 33.05958], [-117.09165, 33.05978], [-117.09184, 33.05974], [-117.09202, 33.05974], [-117.09213, 33.05976], [-117.09228, 33.05987], [-117.09235, 33.06], [-117.09239, 33.06006], [-117.0926, 33.06017], [-117.09276, 33.06029], [-117.09296, 33.06034], [-117.09301, 33.06038], [-117.09333, 33.06052], [-117.09392, 33.06053], [-117.09428, 33.06063], [-117.09463, 33.06078], [-117.09508, 33.06103], [-117.09529, 33.0611], [-117.09542, 33.06115], [-117.09562, 33.0613], [-117.09573, 33.06147], [-117.09574, 33.06156], [-117.0957, 33.06166], [-117.09562, 33.06174], [-117.09547, 33.06184], [-117.09542, 33.06191], [-117.09538, 33.06199], [-117.09537, 33.0621], [-117.09538, 33.06216], [-117.09548, 33.06228], [-117.09549, 33.06242], [-117.09547, 33.06251], [-117.09535, 33.06269], [-117.09535, 33.06283], [-117.09531, 33.06299], [-117.09522, 33.06312], [-117.09503, 33.06331], [-117.09488, 33.06337], [-117.09466, 33.06338], [-117.09466, 33.06342], [-117.09476, 33.06346], [-117.09479, 33.0635], [-117.09478, 33.06355], [-117.09473, 33.06365], [-117.09478, 33.06366], [-117.09495, 33.06356], [-117.09516, 33.06349], [-117.09559, 33.06346], [-117.09593, 33.06338], [-117.09621, 33.06337], [-117.09651, 33.06334], [-117.09674, 33.06338], [-117.09686, 33.06339], [-117.09697, 33.06341], [-117.09717, 33.06354], [-117.09725, 33.06361], [-117.0973, 33.06372], [-117.09731, 33.06378], [-117.0973, 33.06383], [-117.09732, 33.06386], [-117.09721, 33.06435], [-117.09726, 33.06436], [-117.09732, 33.06431], [-117.0975, 33.06423], [-117.09765, 33.06421], [-117.09778, 33.06421], [-117.09805, 33.06426], [-117.0982, 33.06433], [-117.09831, 33.06441], [-117.0985, 33.06459], [-117.09858, 33.06472], [-117.09862, 33.06486], [-117.09863, 33.06508], [-117.09869, 33.0652], [-117.09873, 33.06524], [-117.09874, 33.06531], [-117.0988, 33.06542], [-117.09884, 33.06552], [-117.09888, 33.06574], [-117.09888, 33.06593], [-117.0988, 33.06612], [-117.09881, 33.06652], [-117.09908, 33.06711], [-117.09908, 33.06717], [-117.09906, 33.06723], [-117.09902, 33.0673], [-117.09894, 33.06734], [-117.09888, 33.06737], [-117.09881, 33.06738], [-117.09872, 33.06737], [-117.09863, 33.06733], [-117.0986, 33.06734], [-117.09867, 33.06742], [-117.09869, 33.06746], [-117.0987, 33.06753], [-117.09868, 33.06761], [-117.09871, 33.06763], [-117.09888, 33.0676], [-117.09912, 33.0676], [-117.09942, 33.06765], [-117.09966, 33.06771], [-117.0997, 33.06775], [-117.09978, 33.06779], [-117.09995, 33.06782], [-117.10003, 33.06789], [-117.10005, 33.06801]], [[-117.0942, 33.06133], [-117.09419, 33.06132], [-117.09309, 33.06103], [-117.09303, 33.06118], [-117.09413, 33.06148], [-117.0942, 33.06133]]], [[[-117.13513, 33.04138], [-117.13481, 33.04144], [-117.13446, 33.04154], [-117.13417, 33.04167], [-117.13403, 33.04174], [-117.13394, 33.04181], [-117.13391, 33.04181], [-117.13368, 33.04198], [-117.13347, 33.04219], [-117.13332, 33.04214], [-117.13314, 33.04241], [-117.13296, 33.04272], [-117.13279, 33.04267], [-117.13263, 33.04304], [-117.13263, 33.04305], [-117.13281, 33.04311], [-117.1327, 33.04336], [-117.13284, 33.04341], [-117.13268, 33.04382], [-117.13078, 33.04382], [-117.13101, 33.04348], [-117.13122, 33.04321], [-117.13159, 33.04282], [-117.13197, 33.0423], [-117.13276, 33.0414], [-117.13399, 33.04103], [-117.13512, 33.04084], [-117.13513, 33.04138]]], [[[-117.25126, 32.9784], [-117.2474, 32.97836], [-117.2474, 32.98092], [-117.24741, 32.98098], [-117.24658, 32.98117], [-117.24639, 32.98118], [-117.2461, 32.98118], [-117.24268, 32.98074], [-117.24047, 32.98063], [-117.24017, 32.98064], [-117.23874, 32.98074], [-117.23873, 32.97897], [-117.24007, 32.97858], [-117.24168, 32.97829], [-117.24739, 32.97836], [-117.24737, 32.97395], [-117.24781, 32.97386], [-117.24927, 32.97325], [-117.24998, 32.97311], [-117.2509, 32.97555], [-117.25119, 32.97663], [-117.25137, 32.97716], [-117.25143, 32.97786], [-117.25126, 32.9784]]], [[[-117.24306, 32.97398], [-117.24287, 32.97407], [-117.24176, 32.9743], [-117.24176, 32.97464], [-117.24045, 32.97462], [-117.24045, 32.97177], [-117.23966, 32.97176], [-117.23971, 32.97146], [-117.23971, 32.9712], [-117.23969, 32.97091], [-117.23965, 32.97065], [-117.24127, 32.97067], [-117.24169, 32.97116], [-117.24305, 32.97158], [-117.24306, 32.97398]]]]} | Open Access 1 | 46821 | San Dieguito River Park | 30289 | 2134 | San Dieguito River Park Joint Powers Authority 883 | Special District 4 | Open Space District 6 | http://www.sdrp.org/ | Special District 4 | 2134 | San Dieguito River Park Joint Powers Authority 859 | Special District 4 | Open Space District 6 | http://www.sdrp.org/wordpress/trails/ | San Diego 4 | 539.164 | San Dieguito River Park | 0 | Local Park 2 | 4 |
11548 | 11548 | 11547 | {"type": "Polygon", "coordinates": [[[-121.01476, 41.91316], [-121.01476, 41.9204], [-121.00504, 41.92032], [-121.00501, 41.91672], [-120.99031, 41.91664], [-120.99007, 41.91308], [-121.00499, 41.91311], [-121.00502, 41.91671], [-121.00986, 41.91674], [-121.00987, 41.91673], [-121.00986, 41.91312], [-121.01476, 41.91316]]]} | Open Access 1 | 23627 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Modoc 56 | 241.472 | SLC | 0 | State Resource Management Area 55 | 3 | |
11549 | 11549 | 11548 | {"type": "MultiPolygon", "coordinates": [[[[-121.29712, 37.14253], [-121.2971, 37.14615], [-121.28838, 37.14614], [-121.28844, 37.14253], [-121.29712, 37.14253]]], [[[-121.46858, 37.40598], [-121.46698, 37.41181], [-121.46632, 37.41195], [-121.46777, 37.40803], [-121.46562, 37.40803], [-121.46635, 37.40611], [-121.46431, 37.40547], [-121.46786, 37.4055], [-121.46783, 37.40568], [-121.46858, 37.40598]]], [[[-121.47286, 37.40907], [-121.46994, 37.41053], [-121.46781, 37.41159], [-121.46786, 37.4091], [-121.47286, 37.40907]]], [[[-121.48258, 37.41862], [-121.48023, 37.41798], [-121.47953, 37.41952], [-121.48202, 37.42021], [-121.47043, 37.42032], [-121.47051, 37.4198], [-121.4705, 37.4197], [-121.47046, 37.4196], [-121.47028, 37.41929], [-121.47014, 37.41903], [-121.47235, 37.41869], [-121.47403, 37.41785], [-121.47373, 37.4174], [-121.47819, 37.41521], [-121.47719, 37.41362], [-121.47899, 37.41326], [-121.47845, 37.41462], [-121.47935, 37.41604], [-121.4825, 37.41601], [-121.48258, 37.41862]]], [[[-121.4827, 37.40568], [-121.4827, 37.40911], [-121.47831, 37.40899], [-121.47843, 37.41187], [-121.47682, 37.4093], [-121.4747, 37.40968], [-121.4741, 37.40895], [-121.4783, 37.40899], [-121.47816, 37.40564], [-121.4827, 37.40568]]], [[[-121.50674, 37.22769], [-121.49806, 37.22767], [-121.49804, 37.22146], [-121.50672, 37.22122], [-121.50674, 37.22769]]], [[[-121.55854, 37.26361], [-121.55397, 37.2636], [-121.55395, 37.25973], [-121.54939, 37.25972], [-121.54936, 37.25199], [-121.54117, 37.25233], [-121.54116, 37.24874], [-121.53703, 37.24891], [-121.53702, 37.24552], [-121.54934, 37.24504], [-121.54937, 37.25198], [-121.55849, 37.25201], [-121.55854, 37.26361]]], [[[-121.58695, 37.27141], [-121.58209, 37.2714], [-121.58203, 37.26753], [-121.57225, 37.26751], [-121.57223, 37.26364], [-121.56311, 37.26362], [-121.56308, 37.25589], [-121.57219, 37.25591], [-121.57216, 37.24845], [-121.57671, 37.24846], [-121.57675, 37.25591], [-121.57767, 37.25592], [-121.57774, 37.26073], [-121.58195, 37.26075], [-121.58204, 37.26753], [-121.5869, 37.26754], [-121.58695, 37.27141]]], [[[-121.56775, 37.2785], [-121.56318, 37.27851], [-121.56317, 37.27529], [-121.56774, 37.2753], [-121.56775, 37.2785]]], [[[-121.5742, 37.15901], [-121.56967, 37.15903], [-121.56966, 37.15543], [-121.57418, 37.15542], [-121.5742, 37.15901]]], [[[-121.77458, 37.09927], [-121.77003, 37.09933], [-121.76998, 37.09717], [-121.77454, 37.09738], [-121.77458, 37.09927]]]]} | Open Access 1 | 23590 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Santa Clara 19 | 1397.348 | BLM | 1899 | National Public Lands 1 | 3 | |
11555 | 11555 | 11554 | {"type": "Polygon", "coordinates": [[[-122.66792, 38.46122], [-122.66782, 38.46129], [-122.66773, 38.46132], [-122.66731, 38.46157], [-122.66726, 38.46163], [-122.66714, 38.4613], [-122.66776, 38.46098], [-122.66792, 38.46122]]]} | Open Access 1 | 23641 | Trailhead Park | 26509 | 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 | 0.533 | Trailhead Park | 0 | Local Park 2 | 4 | |
11556 | 11556 | 11555 | {"type": "Polygon", "coordinates": [[[-122.71072, 38.36465], [-122.71067, 38.36468], [-122.71069, 38.36478], [-122.71065, 38.36488], [-122.71048, 38.36503], [-122.71044, 38.36511], [-122.71043, 38.3652], [-122.71024, 38.36524], [-122.71015, 38.36529], [-122.70954, 38.36529], [-122.70951, 38.36446], [-122.70998, 38.36444], [-122.70998, 38.36434], [-122.7105, 38.3643], [-122.71052, 38.36438], [-122.71056, 38.36444], [-122.71072, 38.36465]]]} | Open Access 1 | 23643 | Roberts Lake Park | 24494 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 2.239 | Roberts Lake Park | 0 | Local Park 2 | 4 | |
11557 | 11557 | 11556 | {"type": "Polygon", "coordinates": [[[-122.44779, 38.2892], [-122.44774, 38.28951], [-122.44713, 38.28945], [-122.44719, 38.28909], [-122.44773, 38.28914], [-122.44777, 38.28916], [-122.44779, 38.2892]]]} | Open Access 1 | 23645 | Armstrong Park | 15597 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.539 | Armstrong Park | 0 | Local Park 2 | 4 | |
11559 | 11559 | 11558 | {"type": "Polygon", "coordinates": [[[-121.06116, 38.66599], [-121.06067, 38.66612], [-121.06058, 38.66604], [-121.06042, 38.66597], [-121.06024, 38.66593], [-121.06012, 38.66593], [-121.05911, 38.66617], [-121.05881, 38.6654], [-121.06076, 38.66458], [-121.06093, 38.66507], [-121.06106, 38.6657], [-121.06116, 38.66599]]]} | Open Access 1 | 46839 | Alan Lindsey Park | 30317 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.eldoradohillscsd.org/images/park_detail_popups/allan-lindsey/ | El Dorado 34 | 5.429 | Alan Lindsey Park | 0 | Local Park 2 | 4 |
11562 | 11562 | 11561 | {"type": "Polygon", "coordinates": [[[-120.16674, 38.50827], [-120.15343, 38.50783], [-120.1532, 38.50427], [-120.16663, 38.5047], [-120.16674, 38.50827]]]} | Open Access 1 | 23576 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Amador 52 | 113.944 | SLC | 0 | State Resource Management Area 55 | 3 | |
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-122.064, 36.98385], [-122.06366, 36.98401], [-122.06267, 36.98408], [-122.06257, 36.98463], [-122.06235, 36.98486], [-122.06189, 36.98495], [-122.06155, 36.98351], [-122.06155, 36.98317], [-122.06189, 36.98305], [-122.06343, 36.98349], [-122.06394, 36.98377], [-122.064, 36.98385]]]} | Open Access 1 | 23588 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Cruz 5 | 5.72 | SLC | 0 | State Resource Management Area 55 | 3 | |
11564 | 11564 | 11563 | {"type": "Polygon", "coordinates": [[[-122.63916, 38.26806], [-122.63779, 38.26959], [-122.63739, 38.26937], [-122.63732, 38.26941], [-122.63645, 38.26893], [-122.63786, 38.26737], [-122.63811, 38.26751], [-122.63814, 38.26749], [-122.63916, 38.26806]]]} | Open Access 1 | 23646 | Leghorns Park | 21140 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 7.207 | Leghorns Park | 0 | Local Park 2 | 4 | |
11565 | 11565 | 11564 | {"type": "Polygon", "coordinates": [[[-123.4408, 38.6977], [-123.4407, 38.69783], [-123.44058, 38.69816], [-123.43903, 38.69953], [-123.43871, 38.70002], [-123.43817, 38.6997], [-123.43849, 38.6991], [-123.43785, 38.69878], [-123.43721, 38.69906], [-123.43721, 38.69908], [-123.43743, 38.69925], [-123.43732, 38.69934], [-123.43704, 38.69916], [-123.4365, 38.6996], [-123.4365, 38.69961], [-123.43704, 38.69997], [-123.43865, 38.70061], [-123.43862, 38.70064], [-123.43836, 38.70116], [-123.43828, 38.70128], [-123.43822, 38.70128], [-123.43816, 38.70126], [-123.43765, 38.70074], [-123.4373, 38.70043], [-123.43652, 38.7001], [-123.43583, 38.69956], [-123.43667, 38.69873], [-123.4386, 38.69695], [-123.4389, 38.6966], [-123.43925, 38.69631], [-123.43926, 38.69636], [-123.44016, 38.69725], [-123.4408, 38.6977]]]} | Open Access 1 | 23647 | Pebble Beach | 23550 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 20.416 | Pebble Beach | 0 | Local Park 2 | 4 | |
11566 | 11566 | 11565 | {"type": "Polygon", "coordinates": [[[-123.4743, 38.7297], [-123.47379, 38.7302], [-123.47355, 38.72996], [-123.47404, 38.72949], [-123.4743, 38.7297]]]} | Open Access 1 | 23648 | Shell Beach | 25387 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.556 | Shell Beach | 0 | Local Park 2 | 4 | |
11567 | 11567 | 11566 | {"type": "Polygon", "coordinates": [[[-123.45916, 38.71589], [-123.45775, 38.71717], [-123.45715, 38.71765], [-123.45648, 38.71675], [-123.45595, 38.71631], [-123.4566, 38.71574], [-123.45706, 38.71605], [-123.45742, 38.71585], [-123.45649, 38.71505], [-123.45634, 38.71501], [-123.45631, 38.71486], [-123.45642, 38.71479], [-123.4566, 38.71486], [-123.45662, 38.71497], [-123.45735, 38.71555], [-123.45756, 38.71542], [-123.45757, 38.71526], [-123.45657, 38.71442], [-123.45616, 38.71442], [-123.4556, 38.71483], [-123.45522, 38.71454], [-123.45545, 38.71434], [-123.45545, 38.71433], [-123.45328, 38.71253], [-123.45404, 38.7124], [-123.45461, 38.71221], [-123.45484, 38.71259], [-123.4547, 38.7131], [-123.45507, 38.71341], [-123.45618, 38.71372], [-123.45651, 38.71397], [-123.4573, 38.71397], [-123.45798, 38.71439], [-123.4584, 38.7147], [-123.45916, 38.71589]], [[-123.45789, 38.71568], [-123.45723, 38.71618], [-123.45748, 38.71643], [-123.45818, 38.71591], [-123.45841, 38.71567], [-123.4585, 38.71535], [-123.45848, 38.71506], [-123.45832, 38.71477], [-123.45776, 38.71433], [-123.45729, 38.71411], [-123.45699, 38.71407], [-123.45684, 38.71429], [-123.45715, 38.71446], [-123.45723, 38.71441], [-123.45741, 38.71443], [-123.45782, 38.71475], [-123.45794, 38.71492], [-123.458, 38.71515], [-123.458, 38.71542], [-123.45789, 38.71568]]]} | Open Access 1 | 23649 | Stengel Beach | 25827 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 17.102 | Stengel Beach | 0 | Local Park 2 | 4 | |
11568 | 11568 | 11567 | {"type": "Polygon", "coordinates": [[[-122.30822, 37.83781], [-122.30821, 37.83825], [-122.30811, 37.83834], [-122.30805, 37.83835], [-122.30808, 37.83859], [-122.30688, 37.8386], [-122.30689, 37.83838], [-122.30765, 37.83835], [-122.30752, 37.83805], [-122.30775, 37.83797], [-122.30777, 37.83792], [-122.30772, 37.83783], [-122.30779, 37.8378], [-122.30749, 37.83723], [-122.30818, 37.83723], [-122.30819, 37.83736], [-122.30811, 37.83749], [-122.30811, 37.8378], [-122.30822, 37.83781]]]} | Open Access 1 | 23663 | Davenport Park | 17939 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | Alameda 17 | 2.102 | Davenport 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]);