units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 10,518
- County Agency 1,218
- Recreation/Parks District 1,159
- State Agency 1,137
- Non Profit - Land Trust 599
- Federal Agency 515
- Open Space District 408
- County Agency - Parks 236
- Water District 236
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 43
- School District 38
- County Agency - Other 35
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
DES_TP >30
- Local Park 9,376
- Local Recreation Area 1,989
- Local Other or Unknown 1,158
- Private Conservation 629
- Local Conservation Area 485
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Public Lands 75
- National Wildlife Refuge 75
- State Other or Unknown 66
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 47
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 22
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
AGNCY_WEB >30 ✖
- http://www.sandiego.gov/park-and-recreation/ 527
- http://lacity.org/ 490
- https://www.wildlife.ca.gov/ 399
- http://www.parks.ca.gov/ 355
- http://www.mrca.ca.gov/ 257
- http://www.sanjoseca.gov/index.aspx?NID=204 255
- http://sfrecpark.org/ 243
- http://parks.lacounty.gov 222
- http://portal.cityofsacramento.org/ParksandRec 220
- http://www.cityofventura.net/prcp 151
- http://www.longbeach.gov/park/default.asp 146
- http://www.blm.gov/wo/st/en.html 142
- http://www.slc.ca.gov/ 135
- http://www.roseville.ca.us/parks/default.asp 130
- http://www.ebparks.org/ 126
- http://www2.oaklandnet.com/Government/o/opr/index.htm 122
- http://www.sandiegocounty.gov/parks/ 120
- http://cosb.countyofsb.org/parks/ 118
- http://www.fs.fed.us/ 115
- http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp 102
- http://ocparks.com/ 93
- http://www.nps.gov/ 93
- http://www.yourcsd.com/parks/parks_list.asp 92
- http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm 91
- http://www.haywardrec.org/ 86
- http://www.modestogov.com/prnd/ 85
- http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx 82
- http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 81
- http://www.stocktongov.com/services/parkRec/default.html 81
- http://www.fws.gov/ 79
- …
ACCESS_TYP 4
- Open Access 14,482
- Restricted Access 1,200
- No Public Access 969
- Unknown Access 375
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4506 | 4506 | 4505 | {"type": "MultiPolygon", "coordinates": [[[[-118.37478, 34.11664], [-118.37453, 34.11673], [-118.37446, 34.11661], [-118.37475, 34.1165], [-118.37478, 34.11664]]], [[[-118.37538, 34.11762], [-118.37508, 34.11773], [-118.37474, 34.11711], [-118.37503, 34.117], [-118.37538, 34.11762]]]]} | Open Access 1 | 6889 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.668 | 0 | Local Other or Unknown 14 | 4 | ||
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.191 | 0 | Local Other or Unknown 14 | 4 | ||
4508 | 4508 | 4507 | {"type": "Polygon", "coordinates": [[[-118.34372, 34.1194], [-118.34372, 34.11929], [-118.34358, 34.11895], [-118.34331, 34.11856], [-118.34283, 34.11838], [-118.34277, 34.11827], [-118.3425, 34.11819], [-118.34244, 34.11812], [-118.34226, 34.1181], [-118.34186, 34.11792], [-118.34163, 34.11776], [-118.34125, 34.11772], [-118.34131, 34.11719], [-118.33774, 34.11599], [-118.33761, 34.11579], [-118.33752, 34.11561], [-118.33746, 34.11542], [-118.33733, 34.11489], [-118.3373, 34.11488], [-118.33714, 34.11426], [-118.33668, 34.11316], [-118.3369, 34.11309], [-118.33688, 34.11302], [-118.33796, 34.11422], [-118.34016, 34.11581], [-118.34219, 34.11649], [-118.34209, 34.11665], [-118.34205, 34.11676], [-118.34206, 34.11695], [-118.34214, 34.11712], [-118.34228, 34.11726], [-118.34283, 34.11765], [-118.34385, 34.11885], [-118.34396, 34.11913], [-118.34397, 34.11923], [-118.34393, 34.1193], [-118.34388, 34.11935], [-118.3438, 34.11939], [-118.34372, 34.1194]]]} | Open Access 1 | 6894 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.897 | 0 | Local Other or Unknown 14 | 4 | ||
4509 | 4509 | 4508 | {"type": "Polygon", "coordinates": [[[-118.35605, 34.11531], [-118.35604, 34.11544], [-118.35595, 34.11553], [-118.35563, 34.11566], [-118.35575, 34.11594], [-118.35567, 34.1163], [-118.35515, 34.11646], [-118.35515, 34.11606], [-118.35543, 34.11557], [-118.35583, 34.11544], [-118.35588, 34.11538], [-118.35589, 34.11533], [-118.35605, 34.11531]]]} | Open Access 1 | 6896 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.11 | 0 | Local Other or Unknown 14 | 4 | ||
4510 | 4510 | 4509 | {"type": "Polygon", "coordinates": [[[-118.05241, 34.18273], [-118.05234, 34.1863], [-118.04795, 34.18635], [-118.04802, 34.18273], [-118.05241, 34.18273]]]} | Open Access 1 | 6978 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.911 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
4514 | 4514 | 4513 | {"type": "Polygon", "coordinates": [[[-118.36336, 34.26205], [-118.36208, 34.26532], [-118.36242, 34.26582], [-118.36086, 34.2658], [-118.36086, 34.2641], [-118.36323, 34.26203], [-118.36336, 34.26205]]]} | Unknown Access 4 | 12349 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.984 | 0 | Local Other or Unknown 14 | 4 | ||
4515 | 4515 | 4514 | {"type": "MultiPolygon", "coordinates": [[[[-118.64895, 34.12981], [-118.64844, 34.13005], [-118.64835, 34.12994], [-118.64828, 34.12958], [-118.64857, 34.12955], [-118.6485, 34.12907], [-118.64877, 34.12907], [-118.64887, 34.12969], [-118.64895, 34.12981]]], [[[-118.64944, 34.13051], [-118.64912, 34.13073], [-118.64901, 34.13071], [-118.64871, 34.1304], [-118.64861, 34.13016], [-118.64849, 34.13008], [-118.64898, 34.12985], [-118.64944, 34.13051]]], [[[-118.64947, 34.12956], [-118.649, 34.12979], [-118.64892, 34.12968], [-118.64883, 34.12907], [-118.6494, 34.12907], [-118.64947, 34.12956]]], [[[-118.64997, 34.13028], [-118.64972, 34.13037], [-118.64949, 34.13048], [-118.64903, 34.12983], [-118.6495, 34.1296], [-118.64997, 34.13028]]], [[[-118.65, 34.12907], [-118.64999, 34.12924], [-118.64997, 34.1302], [-118.64953, 34.12955], [-118.64945, 34.12907], [-118.65, 34.12907]]]]} | Open Access 1 | 12478 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.915 | 0 | Local Other or Unknown 14 | 4 | ||
4516 | 4516 | 4515 | {"type": "MultiPolygon", "coordinates": [[[[-118.6416, 34.13135], [-118.6416, 34.13144], [-118.64151, 34.13165], [-118.64161, 34.13202], [-118.6416, 34.13272], [-118.64118, 34.13272], [-118.64117, 34.13135], [-118.6416, 34.13135]]], [[[-118.64237, 34.13272], [-118.64169, 34.13272], [-118.64169, 34.132], [-118.6416, 34.13165], [-118.64168, 34.13145], [-118.64168, 34.13113], [-118.6416, 34.13088], [-118.64198, 34.13088], [-118.6422, 34.13114], [-118.64222, 34.13139], [-118.64203, 34.13179], [-118.64222, 34.13252], [-118.64237, 34.13272]]], [[[-118.64323, 34.13088], [-118.64323, 34.13111], [-118.64308, 34.13132], [-118.64272, 34.13136], [-118.64245, 34.13177], [-118.64261, 34.13219], [-118.64277, 34.1323], [-118.6428, 34.13246], [-118.64299, 34.13272], [-118.64247, 34.13272], [-118.6423, 34.1325], [-118.64211, 34.1318], [-118.64231, 34.1314], [-118.64228, 34.13112], [-118.64208, 34.13088], [-118.64323, 34.13088]]]]} | Unknown Access 4 | 12479 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.231 | 0 | Local Other or Unknown 14 | 4 | ||
4517 | 4517 | 4516 | {"type": "Polygon", "coordinates": [[[-118.59376, 34.10825], [-118.59353, 34.10855], [-118.59332, 34.10845], [-118.59354, 34.10801], [-118.59376, 34.10825]]]} | Open Access 1 | 12625 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.297 | 0 | Local Other or Unknown 14 | 4 | ||
4518 | 4518 | 4517 | {"type": "Polygon", "coordinates": [[[-118.64113, 34.06113], [-118.63972, 34.06114], [-118.63974, 34.06107], [-118.63988, 34.06084], [-118.63989, 34.06076], [-118.63988, 34.0607], [-118.63984, 34.06064], [-118.63979, 34.0606], [-118.63969, 34.06056], [-118.63966, 34.06051], [-118.6396, 34.06018], [-118.63967, 34.06008], [-118.63969, 34.06001], [-118.64113, 34.06], [-118.64113, 34.06113]]]} | Open Access 1 | 12627 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.004 | 0 | Local Other or Unknown 14 | 4 | ||
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.73389], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | 12713 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 770 | County 3 | County Agency - Other 9 | http://www.ocde.us/ | County 3 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | Orange 3 | 105.765 | 0 | Local Other or Unknown 14 | 4 | ||
4520 | 4520 | 4519 | {"type": "Polygon", "coordinates": [[[-119.13455, 35.37983], [-119.13454, 35.38338], [-119.13233, 35.38337], [-119.13234, 35.37982], [-119.13455, 35.37983]]]} | Open Access 1 | 13519 | Unnamed site - North of the River Recreation and Park District | 32826 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.594 | 0 | Local Other or Unknown 14 | 4 | ||
4521 | 4521 | 4520 | {"type": "Polygon", "coordinates": [[[-118.47583, 34.33719], [-118.46689, 34.33699], [-118.46707, 34.3301], [-118.46764, 34.33011], [-118.47158, 34.32993], [-118.4757, 34.32915], [-118.47581, 34.32922], [-118.47583, 34.33719]], [[-118.46964, 34.33229], [-118.47016, 34.33283], [-118.47061, 34.33269], [-118.47003, 34.33102], [-118.46957, 34.33034], [-118.46943, 34.33022], [-118.46915, 34.33012], [-118.46839, 34.33012], [-118.46838, 34.33055], [-118.46883, 34.33059], [-118.46832, 34.33146], [-118.46763, 34.33149], [-118.46779, 34.33473], [-118.46846, 34.33474], [-118.4686, 34.33234], [-118.46964, 34.33229]]]} | Unknown Access 4 | 14635 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 146.941 | 0 | Local Other or Unknown 14 | 4 | ||
4523 | 4523 | 4522 | {"type": "Polygon", "coordinates": [[[-118.52638, 34.34073], [-118.52611, 34.34068], [-118.52602, 34.34082], [-118.52551, 34.34042], [-118.52522, 34.3407], [-118.52444, 34.34014], [-118.52444, 34.33818], [-118.52633, 34.3382], [-118.52638, 34.34073]]]} | Unknown Access 4 | 15193 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 11.377 | 0 | Local Other or Unknown 14 | 4 | ||
4527 | 4527 | 4526 | {"type": "Polygon", "coordinates": [[[-117.72013, 34.57987], [-117.72007, 34.58708], [-117.71578, 34.58707], [-117.71584, 34.57984], [-117.72013, 34.57987]]]} | Unknown Access 4 | 17524 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 78.061 | 0 | Local Other or Unknown 14 | 4 | ||
4528 | 4528 | 4527 | {"type": "Polygon", "coordinates": [[[-118.41348, 34.74982], [-118.40925, 34.74988], [-118.4093, 34.75713], [-118.40483, 34.7572], [-118.40473, 34.7463], [-118.41347, 34.74617], [-118.41348, 34.74982]]]} | Unknown Access 4 | 17564 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 161.323 | 0 | Local Other or Unknown 14 | 4 | ||
4530 | 4530 | 4529 | {"type": "MultiPolygon", "coordinates": [[[[-119.6514, 36.81889], [-119.65097, 36.81932], [-119.65097, 36.81957], [-119.65051, 36.81957], [-119.65033, 36.81959], [-119.65012, 36.8196], [-119.65006, 36.81956], [-119.65001, 36.8194], [-119.65, 36.81924], [-119.65003, 36.81904], [-119.65009, 36.81899], [-119.65035, 36.81897], [-119.65105, 36.81896], [-119.65116, 36.81894], [-119.6513, 36.81887], [-119.65135, 36.81887], [-119.6514, 36.81889]]], [[[-119.65415, 36.81664], [-119.65396, 36.81664], [-119.65381, 36.81677], [-119.65373, 36.81681], [-119.65341, 36.81684], [-119.65327, 36.81692], [-119.65319, 36.81703], [-119.65309, 36.81731], [-119.65302, 36.81735], [-119.65298, 36.81741], [-119.65298, 36.81748], [-119.653, 36.81752], [-119.65311, 36.8176], [-119.65281, 36.8176], [-119.65264, 36.81764], [-119.65225, 36.81764], [-119.65224, 36.81796], [-119.65232, 36.81798], [-119.65226, 36.81805], [-119.65206, 36.81812], [-119.6515, 36.81876], [-119.65136, 36.81869], [-119.65167, 36.81831], [-119.65202, 36.81792], [-119.65203, 36.81784], [-119.65211, 36.81778], [-119.65213, 36.81768], [-119.65206, 36.81758], [-119.65204, 36.81751], [-119.65263, 36.8175], [-119.65273, 36.81748], [-119.65281, 36.81744], [-119.6529, 36.81734], [-119.65303, 36.81699], [-119.65311, 36.81686], [-119.65322, 36.81677], [-119.65334, 36.81672], [-119.65346, 36.8167], [-119.65362, 36.81669], [-119.6537, 36.81666], [-119.6539, 36.81649], [-119.6539, 36.81631], [-119.65402, 36.81633], [-119.6541, 36.81639], [-119.65415, 36.81648], [-119.65415, 36.81664]]], [[[-119.65351, 36.79302], [-119.65342, 36.79309], [-119.65342, 36.79339], [-119.65311, 36.79339], [-119.65307, 36.79337], [-119.65306, 36.79334], [-119.65306, 36.79298], [-119.65348, 36.79298], [-119.65351, 36.79302]]], [[[-119.65478, 36.81582], [-119.65478, 36.81604], [-119.65463, 36.81604], [-119.65428, 36.81634], [-119.65418, 36.81624], [-119.6545, 36.81596], [-119.6545, 36.81582], [-119.65478, 36.81582]]], [[[-119.67228, 36.80779], [-119.67221, 36.80782], [-119.67211, 36.80781], [-119.67204, 36.80754], [-119.67204, 36.80747], [-119.67207, 36.80731], [-119.67213, 36.80716], [-119.6722, 36.80714], [-119.67227, 36.80717], [-119.67228, 36.80779]]], [[[-119.67672, 36.86383], [-119.67672, 36.86416], [-119.67562, 36.86415], [-119.67554, 36.86417], [-119.67549, 36.86419], [-119.67541, 36.86412], [-119.67597, 36.86398], [-119.67672, 36.86383]]]]} | Open Access 1 | 18266 | Unknown park - Clovis, City of | 28715 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 4.819 | 0 | Local Other or Unknown 14 | 4 | ||
4531 | 4531 | 4530 | {"type": "Polygon", "coordinates": [[[-117.08544, 34.21542], [-117.08542, 34.22251], [-117.08407, 34.22245], [-117.08415, 34.22223], [-117.08413, 34.22191], [-117.0839, 34.22174], [-117.08329, 34.22154], [-117.08268, 34.22152], [-117.08221, 34.22141], [-117.08181, 34.22089], [-117.08145, 34.22017], [-117.08127, 34.21946], [-117.08113, 34.21914], [-117.08087, 34.21887], [-117.08049, 34.2187], [-117.08027, 34.21843], [-117.08021, 34.21815], [-117.0801, 34.21792], [-117.07994, 34.21776], [-117.07952, 34.21768], [-117.07906, 34.2178], [-117.07588, 34.219], [-117.07557, 34.21902], [-117.07495, 34.21901], [-117.07449, 34.21893], [-117.07394, 34.21892], [-117.07325, 34.21894], [-117.07251, 34.21904], [-117.07197, 34.21922], [-117.07435, 34.21745], [-117.07487, 34.21718], [-117.0755, 34.21664], [-117.07606, 34.21615], [-117.07698, 34.2154], [-117.07709, 34.21533], [-117.08106, 34.21533], [-117.08107, 34.21539], [-117.08544, 34.21542]]]} | Open Access 1 | 18388 | Unnamed site - California Wildlife Conservation Board | 28679 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | San Bernardino 22 | 117.167 | 0 | State Other or Unknown 104 | 4 | ||
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | Unnamed site - San Diego, City of | 31719 | 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 | San Diego 4 | 1.217 | 0 | Local Other or Unknown 14 | 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]);