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_AGENCY >30
- California Department of Parks and Recreation 221
- California Department of Fish and Wildlife 205
- San Diego, City of 135
- Los Angeles, City of 115
- Mountains Recreation and Conservation Authority 115
- East Bay Regional Park District 110
- Ventura, City of 103
- Consumnes Community Services District 86
- Roseville, City of 67
- Los Angeles, County of 65
- California State Lands Commission 61
- United States Fish and Wildlife Service 60
- Long Beach, City of 56
- Butte, County of 45
- Poway, City of 43
- Tracy, City of 41
- United States Forest Service 40
- Irvine, City of 39
- Lake, County of 39
- Orange, County of 38
- Midpeninsula Regional Open Space District 38
- Stockton, City of 37
- Folsom, City of 36
- Arcata, City of 36
- San Diego, County of 34
- San Jose, City of 33
- El Dorado, County of 33
- Southgate Recreation and Park District 33
- Sunrise Recreation and Park District 33
- San Ramon, City of 32
- …
DES_TP >30
- Local Park 2,259
- Local Recreation Area 890
- Local Other or Unknown 692
- Local Conservation Area 203
- Private Conservation 201
- State Conservation Area 194
- Private Recreation or Education 139
- State Park 130
- State Resource Management Area 80
- State Recreation Area 69
- National Wildlife Refuge 54
- State Historic or Cultural Area 38
- National Forest 37
- Recreation Management Area 21
- National Monument or Landmark 19
- State Other or Unknown 16
- National Public Lands 13
- National Recreation Area 13
- National Park 11
- Local Resource Management Area 10
- Conservation Area 9
- Private Other or Unknown 9
- Private Agricultural 8
- Local Historic or Cultural Area 7
- Federal Other or Unknown 7
- Resource Management Area 4
- Historic or Cultural Area 3
- Wilderness Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
MNG_AG_TYP 29
- City Agency 2,864
- State Agency 557
- Recreation/Parks District 523
- County Agency 411
- Federal Agency 184
- Non Profit - Land Trust 166
- Open Space District 160
- Community Services District 144
- Home Owners Association 111
- County Agency - Parks 92
- Water District 86
- Non Profit - Conservation 78
- Flood District 48
- Irrigation District 24
- School District 18
- Non Profit - Other 14
- Special District - Other 11
- County Agency - Other 8
- Commercial 7
- Port/Harbor District 6
- Transportation Agency 5
- Conservation District 4
- Cemetery District 3
- Joint Powers Authority 3
- Other 3
- Sanitation District 2
- Mitigation Bank 2
- Non Profit - Education 2
- Fire District 1
ACCESS_TYP 4
- Open Access 4,494
- Restricted Access 545
- No Public Access 336
- Unknown Access 162
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11532 | 11532 | 11531 | {"type": "Polygon", "coordinates": [[[-118.36133, 34.08128], [-118.35973, 34.08131], [-118.35972, 34.08204], [-118.3585, 34.08204], [-118.35848, 34.08065], [-118.3593, 34.08065], [-118.35932, 34.08052], [-118.36132, 34.08051], [-118.36133, 34.08128]]]} | Restricted Access 2 | 46866 | Fairfax High School Park | 31935 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 7.626 | Fairfax High School Park | 0 | Local Park 2 | 4 | |
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 | |
11534 | 11534 | 11533 | {"type": "Polygon", "coordinates": [[[-118.26649, 33.96746], [-118.26648, 33.96797], [-118.26529, 33.96796], [-118.26529, 33.96746], [-118.26649, 33.96746]]]} | Restricted Access 2 | 46864 | Freemont High School Wellness Center and Community Garden | 30341 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 1.529 | Freemont High School Wellness Ctr. and Community Garden | 2012 | 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 | |
11539 | 11539 | 11538 | {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80745], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89571, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]} | No Public Access 3 | 46831 | Sarjay/La Cresta Property | 30299 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 21.548 | Sarjay/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11540 | 11540 | 11539 | {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} | No Public Access 3 | 46832 | Saxena/La Cresta Property | 30300 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 4.044 | Saxena/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11541 | 11541 | 11540 | {"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88489, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87185, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86273, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86725, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88467, 32.80066], [-116.88552, 32.79991], [-116.88576, 32.79977], [-116.88578, 32.79976], [-116.88582, 32.79981], [-116.88587, 32.79984], [-116.88598, 32.79984], [-116.88607, 32.79978], [-116.88609, 32.79973], [-116.88609, 32.79967], [-116.88613, 32.79963], [-116.88632, 32.79956], [-116.88653, 32.79952], [-116.88688, 32.79951], [-116.88723, 32.79957], [-116.88744, 32.79964], [-116.88765, 32.79975], [-116.88855, 32.80046], [-116.88872, 32.80056], [-116.8889, 32.80061], [-116.88896, 32.80068], [-116.88895, 32.80074], [-116.88882, 32.80092], [-116.88881, 32.801], [-116.88883, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]} | No Public Access 3 | 46833 | South Crest Properties | 30301 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 586.423 | South Crest Properties | 0 | Private Conservation 16 | 2 | |
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 |
11544 | 11544 | 11543 | {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19482, 33.0613], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06393], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]} | No Public Access 3 | 46822 | Bridges Property | 30290 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 96.326 | Bridges Property | 0 | Private Conservation 16 | 2 | |
11545 | 11545 | 11544 | {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83782, 32.83791], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.83431], [-116.83922, 32.83545]]]} | No Public Access 3 | 46823 | Gibson Property | 30291 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 251.399 | Gibson Property | 0 | Private Conservation 16 | 2 | |
11546 | 11546 | 11545 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | 46824 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 1.954 | Guyot/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11547 | 11547 | 11546 | {"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90258, 32.86929], [-116.90321, 32.8702], [-116.90357, 32.87149], [-116.90313, 32.87153], [-116.90277, 32.87162], [-116.90228, 32.87168], [-116.89941, 32.871], [-116.89778, 32.87065], [-116.89597, 32.87065], [-116.89596, 32.86588], [-116.89775, 32.86452], [-116.89789, 32.8644], [-116.89813, 32.86414], [-116.89845, 32.86372], [-116.89896, 32.86285], [-116.90128, 32.86311], [-116.90141, 32.86392], [-116.90299, 32.86415], [-116.90314, 32.86538], [-116.90379, 32.8653], [-116.90449, 32.86918]]]} | No Public Access 3 | 46825 | Hanson Property | 30293 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 141.528 | Hanson Property | 0 | Private Conservation 16 | 2 | |
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 | |
11550 | 11550 | 11549 | {"type": "Polygon", "coordinates": [[[-122.15107, 37.66265], [-122.14971, 37.66346], [-122.14945, 37.66398], [-122.1474, 37.66495], [-122.14554, 37.66547], [-122.14345, 37.66316], [-122.139, 37.65856], [-122.13938, 37.65851], [-122.13948, 37.6586], [-122.13969, 37.65847], [-122.14042, 37.65838], [-122.14166, 37.65981], [-122.14167, 37.65974], [-122.14402, 37.65974], [-122.14683, 37.65976], [-122.15107, 37.66265]]]} | No Public Access 3 | 23596 | San Francisco Bay | 32293 | 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 | Alameda 17 | 87.824 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
11551 | 11551 | 11550 | {"type": "MultiPolygon", "coordinates": [[[[-120.48135, 37.664], [-120.48132, 37.6642], [-120.48125, 37.66437], [-120.4811, 37.66452], [-120.48045, 37.66487], [-120.48026, 37.66491], [-120.48014, 37.66503], [-120.48008, 37.66532], [-120.48024, 37.66591], [-120.48028, 37.66614], [-120.4798, 37.66635], [-120.47901, 37.66496], [-120.4796, 37.66459], [-120.48005, 37.664], [-120.48135, 37.664]]], [[[-120.4855, 37.66112], [-120.48408, 37.66265], [-120.48188, 37.66423], [-120.48187, 37.66342], [-120.48365, 37.66179], [-120.48456, 37.66139], [-120.4855, 37.66112]]], [[[-120.49114, 37.6524], [-120.49083, 37.65283], [-120.48841, 37.65436], [-120.48773, 37.65488], [-120.48736, 37.65553], [-120.48638, 37.65828], [-120.48687, 37.65881], [-120.48684, 37.65947], [-120.48661, 37.65996], [-120.48558, 37.66106], [-120.48505, 37.66093], [-120.48574, 37.65927], [-120.48583, 37.65912], [-120.48578, 37.65798], [-120.48685, 37.65542], [-120.48765, 37.65458], [-120.48824, 37.6535], [-120.48889, 37.65314], [-120.48929, 37.65245], [-120.49114, 37.6524]]]]} | No Public Access 3 | 23600 | Basso Bridge | 32041 | 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 | Stanislaus 2 | 31.439 | Basso Bridge | 0 | State Resource Management Area 55 | 3 |
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]);