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 213
- California Department of Fish and Wildlife 186
- San Diego, City of 128
- Mountains Recreation and Conservation Authority 114
- Ventura, City of 97
- Los Angeles, City of 96
- East Bay Regional Park District 92
- Los Angeles, County of 58
- United States Fish and Wildlife Service 58
- California State Lands Commission 57
- Long Beach, City of 54
- Roseville, City of 47
- Butte, County of 44
- Poway, City of 43
- United States Forest Service 38
- Irvine, City of 38
- Midpeninsula Regional Open Space District 37
- Orange, County of 36
- Lake, County of 32
- San Jose, City of 31
- San Diego, County of 31
- Torrance, City of 31
- El Dorado, County of 31
- United States National Park Service 30
- Conejo Open Space Conservation Agency 29
- Yuba County Water Agency 28
- San Ramon, City of 26
- Sunrise Recreation and Park District 26
- Valley-Wide Recreation and Park District 25
- Davis, City of 25
- …
DES_TP >30
- Local Park 1,391
- Local Recreation Area 783
- Local Other or Unknown 668
- State Conservation Area 185
- Local Conservation Area 182
- Private Conservation 157
- Private Recreation or Education 131
- State Park 124
- State Resource Management Area 68
- State Recreation Area 65
- National Wildlife Refuge 53
- State Historic or Cultural Area 37
- National Forest 36
- Recreation Management Area 20
- National Monument or Landmark 18
- State Other or Unknown 15
- National Recreation Area 12
- National Public Lands 11
- National Park 11
- Conservation Area 8
- Private Other or Unknown 8
- Local Historic or Cultural Area 6
- Private Agricultural 6
- Federal Other or Unknown 5
- Local Resource Management Area 4
- Resource Management Area 3
- Historic or Cultural Area 3
- Wilderness Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
MNG_AG_TYP 28
- City Agency 2,202
- State Agency 519
- County Agency 350
- Recreation/Parks District 350
- Federal Agency 172
- Open Space District 152
- Non Profit - Land Trust 132
- Home Owners Association 107
- Water District 70
- County Agency - Parks 67
- Non Profit - Conservation 62
- Community Services District 41
- Flood District 38
- Non Profit - Other 11
- Irrigation District 7
- Commercial 7
- School District 6
- County Agency - Other 5
- Transportation Agency 5
- Special District - Other 4
- Cemetery District 3
- Joint Powers Authority 3
- Other 3
- Port/Harbor District 2
- Sanitation District 2
- Mitigation Bank 2
- Conservation District 2
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 3,412
- Restricted Access 495
- No Public Access 270
- Unknown Access 148
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12744 | 12744 | 12743 | {"type": "Polygon", "coordinates": [[[-121.564, 37.08207], [-121.56143, 37.08298], [-121.56076, 37.08176], [-121.56333, 37.08085], [-121.564, 37.08207]]]} | No Public Access 3 | 29776 | Church and New Land Bank | 17248 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 9.122 | Church and New Land Bank | 0 | Local Resource Management Area 83 | 3 | |
12745 | 12745 | 12744 | {"type": "Polygon", "coordinates": [[[-115.48238, 32.67698], [-115.48238, 32.67704], [-115.4816, 32.67704], [-115.48102, 32.67713], [-115.48102, 32.67576], [-115.48238, 32.67576], [-115.48238, 32.67698]]]} | Open Access 1 | 30420 | Villa Santa Fe Park | 27106 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 4.566 | Villa Santa Fe Park | 0 | Local Park 2 | 4 | |
12746 | 12746 | 12745 | {"type": "MultiPolygon", "coordinates": [[[[-121.73507, 37.03376], [-121.7349, 37.03377], [-121.73489, 37.03349], [-121.73506, 37.03349], [-121.73507, 37.03376]]], [[[-121.73712, 37.03757], [-121.73521, 37.03757], [-121.73515, 37.03406], [-121.73703, 37.03405], [-121.73712, 37.03757]]]]} | No Public Access 3 | 29777 | LaPoint Land Bank | 21018 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 16.403 | LaPoint Land Bank | 0 | Local Resource Management Area 83 | 3 | |
12747 | 12747 | 12746 | {"type": "Polygon", "coordinates": [[[-121.75448, 37.39025], [-121.74693, 37.39537], [-121.73402, 37.3996], [-121.73401, 37.40077], [-121.73193, 37.40007], [-121.73203, 37.40241], [-121.70486, 37.40275], [-121.70468, 37.39184], [-121.70084, 37.39187], [-121.70086, 37.38829], [-121.70109, 37.38808], [-121.70226, 37.38834], [-121.70331, 37.38864], [-121.70443, 37.38903], [-121.70536, 37.38941], [-121.70538, 37.38941], [-121.70536, 37.38879], [-121.70435, 37.38839], [-121.70332, 37.38805], [-121.70263, 37.38786], [-121.7016, 37.38762], [-121.70564, 37.38393], [-121.7049, 37.38325], [-121.70811, 37.38042], [-121.70982, 37.38277], [-121.71136, 37.37906], [-121.71185, 37.37713], [-121.72213, 37.37057], [-121.72217, 37.3706], [-121.72425, 37.3693], [-121.72425, 37.36929], [-121.72421, 37.36925], [-121.72966, 37.36579], [-121.72954, 37.36658], [-121.74128, 37.3778], [-121.74569, 37.37694], [-121.75417, 37.38978], [-121.75417, 37.38982], [-121.75422, 37.38985], [-121.75448, 37.39025]]]} | Restricted Access 2 | 29779 | Blue Oak Ranch Reserve | 16182 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | http://www.ucnrs.org/reserves/blue-oak-ranch-reserve.html | Santa Clara 19 | 2936.434 | Blue Oak Ranch Reserve | 0 | State Conservation Area 8 | 2 |
12748 | 12748 | 12747 | {"type": "Polygon", "coordinates": [[[-122.40442, 38.7015], [-122.40434, 38.70518], [-122.4044, 38.70881], [-122.39971, 38.70871], [-122.39977, 38.71233], [-122.39505, 38.71219], [-122.39504, 38.71256], [-122.39515, 38.71759], [-122.39514, 38.71937], [-122.39481, 38.72669], [-122.3901, 38.72653], [-122.39025, 38.72286], [-122.39034, 38.71916], [-122.38567, 38.71927], [-122.38562, 38.71567], [-122.3856, 38.7088], [-122.38291, 38.70627], [-122.38127, 38.70629], [-122.38127, 38.70509], [-122.38078, 38.70348], [-122.38088, 38.70348], [-122.38088, 38.70346], [-122.3807, 38.70337], [-122.38063, 38.70327], [-122.38061, 38.70321], [-122.38078, 38.70317], [-122.38081, 38.70323], [-122.38086, 38.70328], [-122.38101, 38.70333], [-122.3819, 38.70318], [-122.38215, 38.70286], [-122.38182, 38.70268], [-122.38216, 38.70234], [-122.3824, 38.70215], [-122.38267, 38.70197], [-122.38304, 38.70179], [-122.38318, 38.70207], [-122.38697, 38.70233], [-122.38767, 38.70256], [-122.38801, 38.70231], [-122.3883, 38.70254], [-122.38834, 38.70271], [-122.38845, 38.70279], [-122.38863, 38.7028], [-122.38884, 38.70274], [-122.38888, 38.70256], [-122.38941, 38.70212], [-122.39017, 38.70152], [-122.39025, 38.7049], [-122.39494, 38.70499], [-122.39495, 38.70498], [-122.39495, 38.70131], [-122.40442, 38.7015]]]} | No Public Access 3 | 29780 | Crystal Flats | 17845 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 688.769 | Crystal Flats | None 1116 | |||
12749 | 12749 | 12748 | {"type": "Polygon", "coordinates": [[[-121.64534, 37.09758], [-121.64513, 37.0978], [-121.6447, 37.09753], [-121.64468, 37.09751], [-121.64467, 37.09747], [-121.64508, 37.09703], [-121.64513, 37.09701], [-121.64518, 37.09701], [-121.64536, 37.09709], [-121.64555, 37.09721], [-121.64558, 37.09725], [-121.64557, 37.09729], [-121.64551, 37.09736], [-121.64537, 37.09739], [-121.6453, 37.09744], [-121.64528, 37.09747], [-121.64529, 37.09752], [-121.64534, 37.09758]]]} | Open Access 1 | 29872 | Hamilton Square Park | 19623 | 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 | 0.921 | Hamilton Square Park | 0 | Local Park 2 | 4 | |
12750 | 12750 | 12749 | {"type": "Polygon", "coordinates": [[[-122.38127, 38.70509], [-122.38078, 38.70507], [-122.37824, 38.7051], [-122.3786, 38.70485], [-122.37859, 38.70483], [-122.37331, 38.70478], [-122.3714, 38.70479], [-122.37159, 38.69807], [-122.37114, 38.69802], [-122.37067, 38.69808], [-122.36978, 38.69825], [-122.36949, 38.69832], [-122.36923, 38.69836], [-122.3688, 38.69841], [-122.36838, 38.6984], [-122.36814, 38.69816], [-122.36784, 38.6978], [-122.36761, 38.69742], [-122.36733, 38.6972], [-122.36713, 38.69721], [-122.36712, 38.69704], [-122.36619, 38.69633], [-122.3661, 38.6962], [-122.36593, 38.69603], [-122.36533, 38.69557], [-122.36488, 38.69588], [-122.36327, 38.69474], [-122.362, 38.69372], [-122.36072, 38.69367], [-122.35807, 38.6936], [-122.3581, 38.68997], [-122.37187, 38.68962], [-122.37206, 38.68997], [-122.37181, 38.69006], [-122.37188, 38.69016], [-122.37147, 38.69036], [-122.37179, 38.69049], [-122.37161, 38.69114], [-122.37177, 38.69193], [-122.37056, 38.69187], [-122.37054, 38.69248], [-122.37055, 38.69283], [-122.37196, 38.69288], [-122.37193, 38.69346], [-122.37248, 38.69419], [-122.37326, 38.6953], [-122.37328, 38.69553], [-122.37364, 38.69545], [-122.37369, 38.6956], [-122.37336, 38.69568], [-122.37326, 38.69569], [-122.37324, 38.69604], [-122.37316, 38.6967], [-122.37352, 38.69766], [-122.37423, 38.69847], [-122.37399, 38.69901], [-122.37434, 38.6991], [-122.37431, 38.69925], [-122.37387, 38.69922], [-122.37381, 38.69941], [-122.37374, 38.69958], [-122.37399, 38.70068], [-122.37387, 38.70119], [-122.37401, 38.70131], [-122.37398, 38.70139], [-122.37395, 38.70142], [-122.37365, 38.70124], [-122.37355, 38.70113], [-122.37349, 38.70101], [-122.37344, 38.70073], [-122.37324, 38.70074], [-122.37304, 38.70134], [-122.37295, 38.70159], [-122.37293, 38.70158], [-122.37267, 38.70236], [-122.37296, 38.70301], [-122.37356, 38.7035], [-122.37569, 38.70411], [-122.37701, 38.70406], [-122.37915, 38.70369], [-122.37995, 38.70354], [-122.38078, 38.70348], [-122.38127, 38.70509]]]} | No Public Access 3 | 29781 | Stone Corral Park | 25866 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 260.006 | Stone Corral Park | 0 | Local Park 2 | 4 | |
12751 | 12751 | 12750 | {"type": "Polygon", "coordinates": [[[-122.28639, 38.32781], [-122.28618, 38.32824], [-122.28595, 38.32832], [-122.2858, 38.32854], [-122.28586, 38.32868], [-122.28572, 38.32875], [-122.28578, 38.32889], [-122.28586, 38.32893], [-122.28611, 38.32952], [-122.28229, 38.33143], [-122.28223, 38.33134], [-122.28218, 38.33116], [-122.28212, 38.33105], [-122.28205, 38.33067], [-122.28208, 38.33057], [-122.28221, 38.33029], [-122.28238, 38.3301], [-122.28274, 38.32963], [-122.283, 38.32938], [-122.28354, 38.32942], [-122.28357, 38.32905], [-122.28346, 38.32846], [-122.28339, 38.32831], [-122.28311, 38.32801], [-122.28299, 38.32725], [-122.28348, 38.32666], [-122.2842, 38.32623], [-122.28442, 38.32579], [-122.28415, 38.32526], [-122.28519, 38.32529], [-122.28526, 38.32548], [-122.28543, 38.32545], [-122.28553, 38.32616], [-122.28523, 38.32619], [-122.28523, 38.3262], [-122.28639, 38.32781]]]} | Open Access 1 | 29782 | Trancas Crossing Park | 26513 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 31.544 | Trancas Crossing Park | 0 | Local Park 2 | 4 | |
12752 | 12752 | 12751 | {"type": "Polygon", "coordinates": [[[-122.65077, 38.61356], [-122.64992, 38.61454], [-122.63987, 38.62487], [-122.63944, 38.62453], [-122.63742, 38.62319], [-122.63268, 38.6202], [-122.6332, 38.61993], [-122.6331, 38.61632], [-122.63334, 38.61617], [-122.63377, 38.61611], [-122.63408, 38.61584], [-122.63451, 38.61471], [-122.63559, 38.6144], [-122.63622, 38.61393], [-122.63644, 38.61346], [-122.63665, 38.61321], [-122.63708, 38.61305], [-122.63741, 38.61285], [-122.63794, 38.61266], [-122.63885, 38.61242], [-122.6392, 38.61208], [-122.63977, 38.61055], [-122.63934, 38.61024], [-122.63883, 38.60973], [-122.63892, 38.60957], [-122.63896, 38.60946], [-122.63896, 38.60939], [-122.63889, 38.6093], [-122.63908, 38.60927], [-122.63908, 38.60915], [-122.63931, 38.60891], [-122.63973, 38.60812], [-122.64021, 38.60798], [-122.64038, 38.60761], [-122.64114, 38.60679], [-122.6417, 38.60607], [-122.64476, 38.60766], [-122.64556, 38.60874], [-122.64611, 38.60904], [-122.64892, 38.60685], [-122.64974, 38.60729], [-122.65027, 38.60754], [-122.64673, 38.61137], [-122.65077, 38.61356]]]} | Restricted Access 2 | 29784 | Live Oaks Ranch | 21378 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 423.5 | Live Oaks Ranch | 0 | Private Conservation 16 | 2 | |
12753 | 12753 | 12752 | {"type": "Polygon", "coordinates": [[[-115.4824, 32.68317], [-115.4824, 32.68418], [-115.48237, 32.68422], [-115.48019, 32.68423], [-115.4802, 32.68316], [-115.4824, 32.68317]]]} | Open Access 1 | 30421 | Joel Riesen Field | 20424 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 6.015 | Joel Riesen Field | 0 | Local Recreation Area 3 | 4 | |
12754 | 12754 | 12753 | {"type": "MultiPolygon", "coordinates": [[[[-119.2706, 34.25499], [-119.27035, 34.25506], [-119.27018, 34.25466], [-119.27042, 34.25458], [-119.2706, 34.25499]]], [[[-119.27083, 34.25554], [-119.27058, 34.25561], [-119.27036, 34.25508], [-119.27061, 34.25501], [-119.27083, 34.25554]]], [[[-119.27122, 34.25601], [-119.27109, 34.25605], [-119.27045, 34.25457], [-119.27049, 34.25456], [-119.2705, 34.2546], [-119.27081, 34.25533], [-119.27117, 34.25591], [-119.27122, 34.25601]]], [[[-119.27105, 34.25606], [-119.27081, 34.25613], [-119.27059, 34.25563], [-119.27084, 34.25556], [-119.27105, 34.25606]]]]} | Open Access 1 | 46907 | City Beach | 30410 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.236 | City Beach | 0 | Local Park 2 | 4 | |
12755 | 12755 | 12754 | {"type": "Polygon", "coordinates": [[[-122.71212, 38.43656], [-122.7117, 38.43671], [-122.71147, 38.43682], [-122.71142, 38.43649], [-122.71151, 38.43656], [-122.71162, 38.43657], [-122.71167, 38.43655], [-122.71171, 38.43652], [-122.71173, 38.43645], [-122.71168, 38.43638], [-122.71161, 38.43636], [-122.71132, 38.43638], [-122.71122, 38.43594], [-122.71127, 38.43592], [-122.7112, 38.43553], [-122.71192, 38.43544], [-122.7121, 38.43627], [-122.71212, 38.43656]]]} | Open Access 1 | 29786 | Burbank Home & Gardens | 16508 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.036 | Burbank Home & Gardens | 0 | Local Park 2 | 4 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 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.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 4 | |
12757 | 12757 | 12756 | {"type": "MultiPolygon", "coordinates": [[[[-122.43147, 37.44153], [-122.4313, 37.44155], [-122.43126, 37.44127], [-122.43143, 37.44125], [-122.43147, 37.44153]]], [[[-122.43592, 37.44216], [-122.43558, 37.4422], [-122.43556, 37.44214], [-122.4359, 37.44209], [-122.43592, 37.44216]]], [[[-122.43685, 37.44198], [-122.43668, 37.442], [-122.43664, 37.44172], [-122.43681, 37.4417], [-122.43685, 37.44198]]], [[[-122.43722, 37.44082], [-122.43688, 37.44086], [-122.43684, 37.44058], [-122.43718, 37.44054], [-122.43722, 37.44082]]], [[[-122.43897, 37.44652], [-122.43858, 37.44657], [-122.43855, 37.44629], [-122.43893, 37.44625], [-122.43897, 37.44652]]], [[[-122.43898, 37.44665], [-122.4386, 37.4467], [-122.43859, 37.44664], [-122.43898, 37.44659], [-122.43898, 37.44665]]], [[[-122.43923, 37.44405], [-122.43884, 37.4441], [-122.43882, 37.4439], [-122.4392, 37.44385], [-122.43923, 37.44405]]], [[[-122.43925, 37.44426], [-122.43887, 37.44431], [-122.43885, 37.44417], [-122.43923, 37.44412], [-122.43925, 37.44426]]], [[[-122.43956, 37.44658], [-122.43918, 37.44663], [-122.43914, 37.44629], [-122.43952, 37.44624], [-122.43956, 37.44658]]], [[[-122.43956, 37.44366], [-122.43948, 37.44368], [-122.43944, 37.4434], [-122.43953, 37.44339], [-122.43956, 37.44366]]], [[[-122.43965, 37.43865], [-122.43956, 37.43866], [-122.43951, 37.43839], [-122.43959, 37.43838], [-122.43965, 37.43865]]], [[[-122.4398, 37.44544], [-122.43972, 37.44545], [-122.43968, 37.44518], [-122.43976, 37.44517], [-122.4398, 37.44544]]], [[[-122.4401, 37.4477], [-122.43972, 37.44774], [-122.43971, 37.44768], [-122.44009, 37.44763], [-122.4401, 37.4477]]], [[[-122.43993, 37.44105], [-122.43983, 37.44107], [-122.43976, 37.4408], [-122.43986, 37.44078], [-122.43993, 37.44105]]], [[[-122.44059, 37.44402], [-122.44021, 37.44407], [-122.44022, 37.4442], [-122.43984, 37.44425], [-122.43981, 37.44405], [-122.44019, 37.444], [-122.44018, 37.44386], [-122.44056, 37.44382], [-122.44059, 37.44402]]], [[[-122.44039, 37.44544], [-122.44001, 37.44548], [-122.44, 37.44542], [-122.44038, 37.44537], [-122.44039, 37.44544]]], [[[-122.44042, 37.44272], [-122.44003, 37.44277], [-122.44001, 37.44257], [-122.44039, 37.44252], [-122.44042, 37.44272]]], [[[-122.44043, 37.44286], [-122.44005, 37.44291], [-122.44004, 37.44284], [-122.44042, 37.44279], [-122.44043, 37.44286]]], [[[-122.44055, 37.44375], [-122.44017, 37.44379], [-122.44014, 37.4436], [-122.4401, 37.4436], [-122.44006, 37.44332], [-122.44015, 37.44331], [-122.44019, 37.44358], [-122.44053, 37.44354], [-122.44055, 37.44375]]], [[[-122.44071, 37.44491], [-122.4402, 37.44497], [-122.44016, 37.4447], [-122.44029, 37.44468], [-122.44025, 37.44441], [-122.44064, 37.44436], [-122.44071, 37.44491]]], [[[-122.44071, 37.44783], [-122.44033, 37.44788], [-122.44032, 37.44781], [-122.4407, 37.44776], [-122.44071, 37.44783]]], [[[-122.4406, 37.44861], [-122.44043, 37.44863], [-122.44039, 37.44836], [-122.44056, 37.44833], [-122.4406, 37.44861]]], [[[-122.44088, 37.44621], [-122.4405, 37.44626], [-122.44048, 37.44612], [-122.44086, 37.44607], [-122.44088, 37.44621]]], [[[-122.44118, 37.44402], [-122.4408, 37.44406], [-122.44069, 37.44325], [-122.44103, 37.4432], [-122.44106, 37.44347], [-122.44111, 37.44347], [-122.44118, 37.44402]]], [[[-122.44105, 37.44087], [-122.44095, 37.44089], [-122.44088, 37.44062], [-122.44098, 37.44061], [-122.44105, 37.44087]]], [[[-122.44143, 37.44586], [-122.44104, 37.44591], [-122.44102, 37.44571], [-122.4414, 37.44566], [-122.44143, 37.44586]]], [[[-122.4414, 37.44663], [-122.44114, 37.44666], [-122.44111, 37.44639], [-122.44136, 37.44636], [-122.4414, 37.44663]]], [[[-122.44185, 37.44615], [-122.44147, 37.4462], [-122.44144, 37.446], [-122.44183, 37.44595], [-122.44185, 37.44615]]], [[[-122.44165, 37.44847], [-122.44156, 37.44849], [-122.44152, 37.44821], [-122.44161, 37.4482], [-122.44165, 37.44847]]], [[[-122.44209, 37.44793], [-122.44171, 37.44798], [-122.4417, 37.44791], [-122.44208, 37.44786], [-122.44209, 37.44793]]], [[[-122.44251, 37.44378], [-122.44213, 37.44383], [-122.44211, 37.44369], [-122.4425, 37.44364], [-122.44251, 37.44378]]], [[[-122.44284, 37.44877], [-122.44241, 37.44882], [-122.44238, 37.44855], [-122.4428, 37.4485], [-122.44284, 37.44877]]], [[[-122.44312, 37.44322], [-122.44303, 37.44324], [-122.44308, 37.44357], [-122.44269, 37.44362], [-122.44261, 37.443], [-122.44308, 37.44298], [-122.44312, 37.44322]]], [[[-122.4434, 37.43813], [-122.44272, 37.43822], [-122.44261, 37.43768], [-122.44278, 37.43766], [-122.44284, 37.43793], [-122.44299, 37.43791], [-122.443, 37.4379], [-122.44295, 37.43764], [-122.44329, 37.43759], [-122.4434, 37.43813]]], [[[-122.44276, 37.44688], [-122.44267, 37.44689], [-122.44264, 37.44661], [-122.44272, 37.4466], [-122.44276, 37.44688]]], [[[-122.44387, 37.44495], [-122.44349, 37.44543], [-122.44338, 37.44537], [-122.44385, 37.44478], [-122.44387, 37.44495]]]]} | Open Access 1 | 29801 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 7.271 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
12758 | 12758 | 12757 | {"type": "Polygon", "coordinates": [[[-121.67438, 39.26967], [-121.67598, 39.26967], [-121.67602, 39.26972], [-121.67601, 39.2704], [-121.67595, 39.27044], [-121.67435, 39.27043], [-121.67432, 39.27039], [-121.67432, 39.26972], [-121.67434, 39.26969], [-121.67438, 39.26967]]]} | Open Access 1 | 29857 | Pennington Ranch Park | 23588 | 1177 | Live Oak, City of 432 | City 2 | City Agency 2 | http://www.liveoakcity.org/index.php/departments/parks-a-recreation | City 2 | 1177 | Live Oak, City of 426 | City 2 | City Agency 2 | Sutter 47 | 3.042 | Pennington Ranch Park | 0 | Local Park 2 | 4 | |
12759 | 12759 | 12758 | {"type": "Polygon", "coordinates": [[[-121.66336, 39.27091], [-121.66206, 39.27091], [-121.66229, 39.27159], [-121.66251, 39.27216], [-121.66249, 39.27218], [-121.66279, 39.27297], [-121.66259, 39.273], [-121.66227, 39.27217], [-121.66223, 39.27217], [-121.66184, 39.27105], [-121.66174, 39.27065], [-121.66164, 39.27007], [-121.6616, 39.26953], [-121.66181, 39.26948], [-121.66184, 39.26984], [-121.66191, 39.27025], [-121.66202, 39.27079], [-121.66335, 39.27078], [-121.66336, 39.27091]]]} | Open Access 1 | 29858 | Live Oak Trail | 21377 | 1177 | Live Oak, City of 432 | City 2 | City Agency 2 | http://www.liveoakcity.org/index.php/departments/parks-a-recreation | City 2 | 1177 | Live Oak, City of 426 | City 2 | City Agency 2 | Sutter 47 | 2.401 | Live Oak Trail | 0 | Local Recreation Area 3 | 4 | |
12760 | 12760 | 12759 | {"type": "Polygon", "coordinates": [[[-121.5371, 38.58568], [-121.53598, 38.58568], [-121.53599, 38.58453], [-121.53471, 38.58454], [-121.53471, 38.58397], [-121.5371, 38.58383], [-121.5371, 38.58568]]]} | Restricted Access 2 | 29861 | Westifield School Playsite | 31656 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 6.689 | Westifield School Playsite | None 1117 | |||
12761 | 12761 | 12760 | {"type": "MultiPolygon", "coordinates": [[[[-117.49463, 33.90092], [-117.49453, 33.901], [-117.49383, 33.90091], [-117.49395, 33.9007], [-117.49401, 33.90052], [-117.49414, 33.90042], [-117.49421, 33.90034], [-117.49424, 33.90023], [-117.49421, 33.90011], [-117.49404, 33.89988], [-117.49393, 33.89967], [-117.49386, 33.89952], [-117.49387, 33.89939], [-117.49385, 33.89936], [-117.49373, 33.89929], [-117.49363, 33.89919], [-117.49355, 33.89914], [-117.49328, 33.89906], [-117.49316, 33.89906], [-117.49304, 33.89901], [-117.49297, 33.89895], [-117.49283, 33.89878], [-117.49358, 33.89836], [-117.49418, 33.89909], [-117.49433, 33.89935], [-117.49447, 33.89966], [-117.49456, 33.89993], [-117.49462, 33.90026], [-117.49465, 33.90054], [-117.49463, 33.90092]]], [[[-117.49574, 33.90107], [-117.49564, 33.90112], [-117.49505, 33.90105], [-117.49499, 33.90098], [-117.49501, 33.90053], [-117.49494, 33.89995], [-117.49488, 33.89974], [-117.49474, 33.89939], [-117.49484, 33.89936], [-117.49538, 33.90002], [-117.49532, 33.90011], [-117.49532, 33.90021], [-117.49567, 33.90064], [-117.49573, 33.90074], [-117.49576, 33.90088], [-117.49574, 33.90107]]]]} | Open Access 1 | 30005 | Riverwalk Dog Park | 24468 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.013 | Riverwalk Dog Park | 0 | Local Park 2 | 4 | |
12762 | 12762 | 12761 | {"type": "MultiPolygon", "coordinates": [[[[-117.3255, 34.30229], [-117.32542, 34.30354], [-117.32522, 34.30354], [-117.32497, 34.30363], [-117.32481, 34.30356], [-117.32471, 34.30363], [-117.3239, 34.30354], [-117.32354, 34.30329], [-117.32319, 34.30325], [-117.32311, 34.30317], [-117.32217, 34.30299], [-117.32185, 34.30308], [-117.32146, 34.30304], [-117.32105, 34.30317], [-117.31996, 34.30369], [-117.3197, 34.30394], [-117.3197, 34.30356], [-117.31959, 34.30347], [-117.31918, 34.30343], [-117.31854, 34.30365], [-117.31813, 34.30418], [-117.31658, 34.30505], [-117.31611, 34.30512], [-117.31575, 34.30505], [-117.31509, 34.30455], [-117.31445, 34.30434], [-117.31368, 34.30398], [-117.31197, 34.30361], [-117.31191, 34.30342], [-117.31145, 34.30292], [-117.31128, 34.30249], [-117.31129, 34.30234], [-117.31567, 34.30237], [-117.31571, 34.30046], [-117.32007, 34.3005], [-117.32008, 34.30226], [-117.3255, 34.30229]]], [[[-117.35559, 34.28418], [-117.35537, 34.28686], [-117.35453, 34.28781], [-117.33216, 34.28767], [-117.32957, 34.28773], [-117.32958, 34.28832], [-117.3286, 34.28852], [-117.32808, 34.28893], [-117.32802, 34.28931], [-117.32832, 34.2895], [-117.32857, 34.28989], [-117.32876, 34.28998], [-117.32926, 34.28982], [-117.32959, 34.28989], [-117.32959, 34.29092], [-117.32929, 34.29143], [-117.32923, 34.29179], [-117.32899, 34.292], [-117.32909, 34.29241], [-117.32896, 34.2926], [-117.32827, 34.29294], [-117.32794, 34.29278], [-117.32749, 34.29278], [-117.32714, 34.29317], [-117.32714, 34.29337], [-117.32725, 34.29346], [-117.32722, 34.29365], [-117.32694, 34.29383], [-117.32678, 34.29383], [-117.32674, 34.29374], [-117.32645, 34.29376], [-117.32639, 34.29383], [-117.32595, 34.29371], [-117.32586, 34.29347], [-117.32562, 34.2934], [-117.32537, 34.29362], [-117.32526, 34.29392], [-117.32496, 34.29426], [-117.32496, 34.29444], [-117.32515, 34.29461], [-117.32573, 34.29463], [-117.32581, 34.29472], [-117.32567, 34.29545], [-117.32586, 34.29564], [-117.32672, 34.2955], [-117.32694, 34.29557], [-117.32719, 34.2958], [-117.32719, 34.29589], [-117.32749, 34.29612], [-117.32846, 34.29598], [-117.3286, 34.29585], [-117.32884, 34.29585], [-117.32904, 34.29605], [-117.32959, 34.29612], [-117.3297, 34.29706], [-117.31656, 34.29689], [-117.31647, 34.29615], [-117.3165, 34.2941], [-117.31647, 34.28782], [-117.3208, 34.28788], [-117.32081, 34.28049], [-117.32507, 34.28054], [-117.32505, 34.28], [-117.32505, 34.27809], [-117.32519, 34.2768], [-117.32829, 34.27678], [-117.32828, 34.27858], [-117.32829, 34.27961], [-117.32838, 34.27974], [-117.32911, 34.28019], [-117.33125, 34.28039], [-117.33125, 34.28038], [-117.33118, 34.28022], [-117.33119, 34.2799], [-117.33128, 34.27972], [-117.33156, 34.27937], [-117.33161, 34.27924], [-117.33151, 34.2792], [-117.33127, 34.27926], [-117.33108, 34.27927], [-117.33101, 34.27918], [-117.33086, 34.27883], [-117.33386, 34.27888], [-117.33387, 34.27857], [-117.33486, 34.27858], [-117.33493, 34.2761], [-117.33531, 34.27611], [-117.33588, 34.2762], [-117.33718, 34.2765], [-117.33755, 34.27661], [-117.33835, 34.2768], [-117.33934, 34.27708], [-117.3424, 34.27781], [-117.34271, 34.27791], [-117.34466, 34.27843], [-117.34515, 34.27859], [-117.3456, 34.27878], [-117.34664, 34.2793], [-117.34696, 34.2795], [-117.3469, 34.28061], [-117.34799, 34.28056], [-117.34852, 34.28107], [-117.34919, 34.28176], [-117.34962, 34.28214], [-117.34985, 34.28226], [-117.35047, 34.2825], [-117.35114, 34.28271], [-117.35209, 34.28298], [-117.35239, 34.28308], [-117.35364, 34.2834], [-117.35393, 34.28345], [-117.35452, 34.28363], [-117.35493, 34.28381], [-117.35527, 34.28402], [-117.35547, 34.28411], [-117.35559, 34.28418]], [[-117.3316, 34.28109], [-117.33154, 34.28186], [-117.33218, 34.28191], [-117.33224, 34.28109], [-117.3316, 34.28109]]]]} | Open Access 1 | 44432 | Silverwood Lake State Recreation Area | 1838 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=650 | San Bernardino 22 | 1071.542 | Silverwood Lake SRA | 1978 | State Recreation Area 39 | 4 |
12763 | 12763 | 12762 | {"type": "Polygon", "coordinates": [[[-118.35893, 33.85167], [-118.35893, 33.85181], [-118.35772, 33.85181], [-118.35772, 33.85168], [-118.35893, 33.85167]]]} | No Public Access 3 | 35836 | Entradero Swale 6 | 29163 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.421 | Entradero Swale 6 | None 1118 |
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]);