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_AG_TYP 30
- City Agency 4,207
- State Agency 695
- Recreation/Parks District 626
- County Agency 583
- Federal Agency 273
- Non Profit - Land Trust 238
- Open Space District 176
- Community Services District 149
- County Agency - Parks 130
- Water District 120
- Home Owners Association 115
- Non Profit - Conservation 87
- Flood District 54
- School District 29
- Irrigation District 25
- Non Profit - Other 20
- Cemetery District 13
- County Agency - Other 11
- Special District - Other 11
- Port/Harbor District 8
- Commercial 8
- Joint Powers Authority 7
- Sanitation District 5
- Other 5
- Transportation Agency 5
- Conservation District 4
- Non Profit - Education 3
- Mitigation Bank 2
- Metropolitan Planning Organization 1
- Fire District 1
MNG_AGENCY >30
- California Department of Parks and Recreation 270
- California Department of Fish and Wildlife 266
- San Diego, City of 206
- Sacramento, City of 145
- Los Angeles, City of 131
- East Bay Regional Park District 125
- Mountains Recreation and Conservation Authority 119
- Ventura, City of 110
- Roseville, City of 97
- Consumnes Community Services District 86
- San Jose, City of 72
- Los Angeles, County of 70
- California State Lands Commission 66
- United States Bureau of Land Management 63
- United States Fish and Wildlife Service 63
- Long Beach, City of 61
- United States Forest Service 58
- San Francisco, City and County of 57
- Davis, City of 56
- Stockton, City of 56
- Orange, County of 52
- Modesto, City of 48
- Poway, City of 46
- Irvine, City of 46
- Tracy, City of 46
- Santa Barbara, County of 45
- Manteca, City of 45
- Butte, County of 45
- Rocklin, City of 44
- Midpeninsula Regional Open Space District 42
- …
DES_TP >30
- Local Park 3,487
- Local Recreation Area 1,094
- Local Other or Unknown 718
- Private Conservation 280
- Local Conservation Area 252
- State Conservation Area 251
- State Park 157
- Private Recreation or Education 145
- State Resource Management Area 93
- State Recreation Area 87
- National Wildlife Refuge 57
- National Forest 53
- State Historic or Cultural Area 48
- National Public Lands 41
- Recreation Management Area 30
- Local Historic or Cultural Area 27
- National Monument or Landmark 24
- State Other or Unknown 19
- National Recreation Area 18
- National Park 14
- Local Resource Management Area 13
- Federal Other or Unknown 13
- Conservation Area 9
- Private Agricultural 9
- Private Other or Unknown 9
- Resource Management Area 6
- Historic or Cultural Area 4
- Area of Critical Environmental Concern 3
- Wilderness Area 2
- State Wilderness 1
- …
ACCESS_TYP 4
- Open Access 6,319
- Restricted Access 672
- No Public Access 441
- Unknown Access 179
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9458 | 9458 | 9457 | {"type": "Polygon", "coordinates": [[[-121.91787, 37.70301], [-121.91749, 37.7032], [-121.91745, 37.7035], [-121.91675, 37.70379], [-121.91628, 37.70412], [-121.91617, 37.70434], [-121.9134, 37.70372], [-121.91278, 37.70359], [-121.91207, 37.70363], [-121.91182, 37.70216], [-121.91671, 37.7022], [-121.91696, 37.70262], [-121.91755, 37.70242], [-121.91787, 37.70301]]]} | Restricted Access 2 | 15814 | Dublin Sports Grounds | 18293 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 22.454 | Dublin Sports Grounds | 1989 | None 781 | ||
9459 | 9459 | 9458 | {"type": "Polygon", "coordinates": [[[-118.95668, 35.40007], [-118.95754, 35.40009], [-118.95756, 35.40127], [-118.95671, 35.40127], [-118.95407, 35.40129], [-118.95526, 35.40028], [-118.95542, 35.40016], [-118.95552, 35.40011], [-118.95563, 35.40009], [-118.95668, 35.40007]]]} | Open Access 1 | 15816 | Siemon Park | 25440 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 8.187 | Siemon Park | 0 | Local Park 2 | 4 | |
9460 | 9460 | 9459 | {"type": "Polygon", "coordinates": [[[-121.87704, 39.76343], [-121.8758, 39.76415], [-121.87473, 39.76307], [-121.87603, 39.76234], [-121.87704, 39.76343]]]} | Open Access 1 | 15817 | Peterson Park | 23633 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 4.991 | Peterson Park | 0 | Local Park 2 | 4 | |
9461 | 9461 | 9460 | {"type": "Polygon", "coordinates": [[[-117.15184, 34.04827], [-117.14763, 34.04827], [-117.14757, 34.04675], [-117.14764, 34.04659], [-117.14799, 34.04678], [-117.14798, 34.04683], [-117.14857, 34.04712], [-117.1487, 34.04712], [-117.14886, 34.04718], [-117.14902, 34.04717], [-117.14927, 34.04711], [-117.1495, 34.04711], [-117.14987, 34.04714], [-117.15037, 34.04724], [-117.15067, 34.04734], [-117.15074, 34.04738], [-117.15092, 34.0476], [-117.15129, 34.04791], [-117.15161, 34.04799], [-117.15177, 34.04808], [-117.15184, 34.04827]]]} | Open Access 1 | 15818 | Citrus Grove - Fifth St | 17271 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 10.66 | Citrus Grove - Fifth St | None 782 | |||
9462 | 9462 | 9461 | {"type": "MultiPolygon", "coordinates": [[[[-117.74571, 33.5005], [-117.74518, 33.50106], [-117.74514, 33.50106], [-117.74485, 33.50091], [-117.74481, 33.50074], [-117.74412, 33.50007], [-117.74386, 33.49969], [-117.7435, 33.49927], [-117.74351, 33.49913], [-117.74349, 33.49904], [-117.74345, 33.49895], [-117.74339, 33.49893], [-117.7433, 33.49884], [-117.74307, 33.49878], [-117.74292, 33.49866], [-117.74284, 33.49857], [-117.7427, 33.49868], [-117.74249, 33.49863], [-117.74215, 33.49859], [-117.74161, 33.49828], [-117.7411, 33.49784], [-117.74078, 33.49745], [-117.7407, 33.49706], [-117.74067, 33.49704], [-117.74064, 33.49695], [-117.74062, 33.49684], [-117.74057, 33.49666], [-117.7405, 33.49662], [-117.7404, 33.49647], [-117.74038, 33.49641], [-117.74009, 33.49624], [-117.73991, 33.49625], [-117.73944, 33.49564], [-117.73923, 33.49529], [-117.7391, 33.4947], [-117.73927, 33.49442], [-117.73917, 33.4941], [-117.7398, 33.49355], [-117.7398, 33.4936], [-117.73988, 33.49366], [-117.73988, 33.49377], [-117.73981, 33.49388], [-117.73962, 33.49414], [-117.7396, 33.49427], [-117.73966, 33.4944], [-117.73968, 33.49451], [-117.73982, 33.49466], [-117.7399, 33.4948], [-117.73992, 33.49489], [-117.73997, 33.49495], [-117.74019, 33.4951], [-117.74024, 33.4952], [-117.74028, 33.49532], [-117.74029, 33.49544], [-117.74032, 33.49552], [-117.74047, 33.49575], [-117.7409, 33.49587], [-117.74107, 33.49585], [-117.74114, 33.49589], [-117.74121, 33.49598], [-117.74119, 33.49611], [-117.74106, 33.4963], [-117.74106, 33.49657], [-117.7411, 33.4967], [-117.74121, 33.49697], [-117.74125, 33.49703], [-117.74137, 33.4971], [-117.74167, 33.49735], [-117.742, 33.49752], [-117.74226, 33.49769], [-117.74235, 33.49778], [-117.74246, 33.4978], [-117.74252, 33.49786], [-117.7427, 33.49797], [-117.74289, 33.49803], [-117.74306, 33.49812], [-117.74318, 33.49821], [-117.74336, 33.49824], [-117.7435, 33.49806], [-117.74359, 33.49803], [-117.7437, 33.49795], [-117.74379, 33.49795], [-117.74383, 33.49803], [-117.7438, 33.49809], [-117.74365, 33.4982], [-117.74361, 33.49827], [-117.74364, 33.49831], [-117.74379, 33.49835], [-117.74393, 33.49845], [-117.7441, 33.49841], [-117.74421, 33.49843], [-117.74428, 33.49846], [-117.74424, 33.49855], [-117.74418, 33.49865], [-117.74415, 33.49879], [-117.74423, 33.49891], [-117.74425, 33.49898], [-117.74426, 33.49919], [-117.74453, 33.49948], [-117.74474, 33.49963], [-117.74503, 33.4998], [-117.74519, 33.49993], [-117.74528, 33.50003], [-117.74542, 33.5001], [-117.74547, 33.50016], [-117.74549, 33.50025], [-117.74558, 33.50032], [-117.74566, 33.50048], [-117.74571, 33.5005]]], [[[-117.74679, 33.50232], [-117.74662, 33.5025], [-117.74653, 33.50254], [-117.74643, 33.50256], [-117.74628, 33.50236], [-117.74632, 33.50231], [-117.74634, 33.50223], [-117.74628, 33.50198], [-117.74607, 33.50188], [-117.74596, 33.50173], [-117.74592, 33.50157], [-117.74593, 33.50147], [-117.74607, 33.50138], [-117.74615, 33.50145], [-117.74615, 33.50151], [-117.74641, 33.50162], [-117.74654, 33.50154], [-117.74666, 33.50154], [-117.74669, 33.50163], [-117.7467, 33.50176], [-117.74666, 33.50191], [-117.74666, 33.502], [-117.74673, 33.50211], [-117.74675, 33.50222], [-117.74679, 33.50232]]], [[[-117.75133, 33.50794], [-117.75119, 33.50797], [-117.75105, 33.50804], [-117.75095, 33.50794], [-117.75085, 33.50768], [-117.75078, 33.50756], [-117.75069, 33.50724], [-117.75045, 33.50702], [-117.75017, 33.50705], [-117.74972, 33.50692], [-117.74954, 33.50672], [-117.74923, 33.50647], [-117.74899, 33.50617], [-117.74885, 33.50594], [-117.74865, 33.50579], [-117.74834, 33.50551], [-117.748, 33.50525], [-117.74786, 33.50474], [-117.74764, 33.50458], [-117.74744, 33.50427], [-117.7473, 33.50414], [-117.74726, 33.5038], [-117.74684, 33.50356], [-117.74705, 33.50331], [-117.74744, 33.50365], [-117.74756, 33.50389], [-117.74759, 33.504], [-117.74765, 33.50406], [-117.74776, 33.50414], [-117.74796, 33.50422], [-117.74809, 33.50436], [-117.74819, 33.5045], [-117.74827, 33.50466], [-117.7483, 33.5048], [-117.74838, 33.5049], [-117.74849, 33.50493], [-117.74865, 33.5051], [-117.74887, 33.50529], [-117.74889, 33.50538], [-117.74893, 33.50548], [-117.74898, 33.50555], [-117.74906, 33.50559], [-117.74931, 33.50586], [-117.74947, 33.50598], [-117.74964, 33.50608], [-117.74984, 33.50633], [-117.74988, 33.50641], [-117.7502, 33.50658], [-117.75036, 33.50673], [-117.75045, 33.50677], [-117.75055, 33.50678], [-117.75067, 33.50673], [-117.75078, 33.50667], [-117.75093, 33.50663], [-117.75107, 33.50665], [-117.75114, 33.50673], [-117.75118, 33.50689], [-117.75117, 33.50707], [-117.75126, 33.50722], [-117.75122, 33.50729], [-117.75124, 33.5077], [-117.75133, 33.50794]]], [[[-117.75269, 33.51143], [-117.75257, 33.51156], [-117.75251, 33.51167], [-117.75246, 33.51185], [-117.75247, 33.51199], [-117.75245, 33.5121], [-117.75238, 33.51226], [-117.75219, 33.51236], [-117.75198, 33.51242], [-117.74989, 33.51241], [-117.74968, 33.51243], [-117.74962, 33.51202], [-117.74932, 33.51168], [-117.74996, 33.51147], [-117.7502, 33.51164], [-117.75062, 33.51162], [-117.75087, 33.51145], [-117.75107, 33.51119], [-117.7512, 33.51111], [-117.75127, 33.5112], [-117.75133, 33.51136], [-117.75139, 33.51142], [-117.75146, 33.51145], [-117.75159, 33.51145], [-117.75204, 33.51131], [-117.75212, 33.51127], [-117.75222, 33.51118], [-117.75225, 33.51117], [-117.75253, 33.5113], [-117.75269, 33.51143]]], [[[-117.75603, 33.51286], [-117.75547, 33.51286], [-117.75541, 33.51285], [-117.75535, 33.51276], [-117.75531, 33.51274], [-117.75524, 33.51266], [-117.75502, 33.51258], [-117.75489, 33.51238], [-117.75449, 33.51197], [-117.75426, 33.51178], [-117.754, 33.51162], [-117.75374, 33.51189], [-117.75372, 33.51187], [-117.75397, 33.5116], [-117.75351, 33.51121], [-117.7529, 33.51086], [-117.75295, 33.51076], [-117.75302, 33.5107], [-117.75302, 33.51058], [-117.75308, 33.5105], [-117.75312, 33.51038], [-117.75318, 33.51028], [-117.75327, 33.51019], [-117.75332, 33.51016], [-117.75342, 33.51017], [-117.75361, 33.51037], [-117.75379, 33.51045], [-117.75409, 33.51076], [-117.75428, 33.51091], [-117.75446, 33.51112], [-117.75493, 33.5116], [-117.75532, 33.51215], [-117.75572, 33.51257], [-117.75586, 33.51275], [-117.75603, 33.51286]]]]} | Open Access 1 | 15813 | Aliso Beach Park | 32092 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/beaches/aliso/ | Orange 3 | 39.83 | Aliso Beach Park | 0 | Local Park 2 | 4 |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9464 | 9464 | 9463 | {"type": "Polygon", "coordinates": [[[-118.85099, 34.21159], [-118.8503, 34.21154], [-118.8503, 34.21143], [-118.84988, 34.21124], [-118.84971, 34.21097], [-118.84963, 34.21041], [-118.84965, 34.21015], [-118.84964, 34.20969], [-118.84969, 34.20932], [-118.84971, 34.20895], [-118.84985, 34.20843], [-118.85001, 34.20788], [-118.85019, 34.20741], [-118.85041, 34.20703], [-118.85075, 34.20653], [-118.85074, 34.21121], [-118.85099, 34.21159]]]} | Open Access 1 | 15840 | Fiore Playfield | 18906 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | Ventura 8 | 10.483 | Fiore Playfield | 0 | Local Recreation Area 3 | 4 | |
9465 | 9465 | 9464 | {"type": "Polygon", "coordinates": [[[-121.80608, 39.76755], [-121.80419, 39.76528], [-121.80279, 39.76367], [-121.80359, 39.76323], [-121.80417, 39.76268], [-121.80426, 39.76274], [-121.80495, 39.76259], [-121.80525, 39.76249], [-121.80535, 39.76249], [-121.80539, 39.76252], [-121.80554, 39.76278], [-121.80578, 39.7633], [-121.80587, 39.76356], [-121.80597, 39.76392], [-121.80605, 39.76446], [-121.80608, 39.76755]]]} | Open Access 1 | 15842 | Wildwood Park | 27520 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 19.795 | Wildwood Park | 0 | Local Park 2 | 4 | |
9466 | 9466 | 9465 | {"type": "Polygon", "coordinates": [[[-117.15736, 34.07374], [-117.1573, 34.07722], [-117.15629, 34.07721], [-117.15632, 34.07548], [-117.15642, 34.07547], [-117.15643, 34.07529], [-117.15634, 34.07528], [-117.15634, 34.07384], [-117.15643, 34.07383], [-117.15644, 34.07373], [-117.15736, 34.07374]]]} | Open Access 1 | 15843 | Citrus Grove - MULLIN | 17276 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 8.789 | Citrus Grove - MULLIN | None 783 | |||
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-118.79539, 34.10451], [-118.79505, 34.10457], [-118.79501, 34.10437], [-118.79516, 34.10434], [-118.79538, 34.10447], [-118.79539, 34.10451]]]} | No Public Access 3 | 12425 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.136 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9468 | 9468 | 9467 | {"type": "Polygon", "coordinates": [[[-117.78613, 35.15297], [-117.78142, 35.15322], [-117.78147, 35.15123], [-117.7846, 35.1512], [-117.78608, 35.15118], [-117.78613, 35.15297]]]} | Open Access 1 | 15916 | I Park | 20168 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 21.994 | I Park | 0 | Local Park 2 | 4 | |
9469 | 9469 | 9468 | {"type": "Polygon", "coordinates": [[[-118.66968, 34.13331], [-118.66965, 34.13376], [-118.66961, 34.13403], [-118.6695, 34.13402], [-118.66949, 34.13387], [-118.66933, 34.13366], [-118.6693, 34.13358], [-118.66931, 34.1335], [-118.66934, 34.13343], [-118.6694, 34.13337], [-118.6696, 34.13328], [-118.66963, 34.13328], [-118.66968, 34.13331]]]} | No Public Access 3 | 12426 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.465 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9470 | 9470 | 9469 | {"type": "Polygon", "coordinates": [[[-119.11572, 35.32089], [-119.11439, 35.3209], [-119.11417, 35.32089], [-119.11356, 35.32089], [-119.11358, 35.32013], [-119.11354, 35.32006], [-119.11342, 35.31995], [-119.11336, 35.31962], [-119.11337, 35.31931], [-119.11351, 35.31923], [-119.11355, 35.31918], [-119.11357, 35.31909], [-119.11356, 35.3189], [-119.11411, 35.3189], [-119.11481, 35.31884], [-119.1148, 35.31891], [-119.11484, 35.31904], [-119.11496, 35.31914], [-119.11514, 35.31917], [-119.1152, 35.31915], [-119.11572, 35.31918], [-119.11574, 35.32029], [-119.11572, 35.32089]]]} | Open Access 1 | 15836 | Tevis Park | 26272 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 10.605 | Tevis Park | 0 | Local Park 2 | 4 | |
9471 | 9471 | 9470 | {"type": "Polygon", "coordinates": [[[-121.82954, 39.71984], [-121.82923, 39.72018], [-121.82893, 39.72001], [-121.82925, 39.71967], [-121.82954, 39.71984]]]} | Open Access 1 | 15837 | Rotary Park | 24687 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 0.36 | Rotary Park | 0 | Local Park 2 | 4 | |
9472 | 9472 | 9471 | {"type": "Polygon", "coordinates": [[[-117.15621, 34.07062], [-117.15617, 34.07368], [-117.15412, 34.07369], [-117.15413, 34.07021], [-117.15611, 34.07019], [-117.15618, 34.07025], [-117.15618, 34.07061], [-117.15621, 34.07062]]]} | Open Access 1 | 15838 | Citrus Grove - LUGONIA | 17274 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 18.236 | Citrus Grove - LUGONIA | None 784 | |||
9473 | 9473 | 9472 | {"type": "Polygon", "coordinates": [[[-122.0861, 37.38814], [-122.08746, 37.38875], [-122.08749, 37.38879], [-122.08749, 37.38882], [-122.08701, 37.38957], [-122.0865, 37.39014], [-122.08645, 37.39016], [-122.08641, 37.39015], [-122.08617, 37.39], [-122.086, 37.3899], [-122.08598, 37.38991], [-122.08464, 37.3893], [-122.08474, 37.38914], [-122.08482, 37.38909], [-122.0849, 37.38906], [-122.08533, 37.38902], [-122.08541, 37.389], [-122.08552, 37.38893], [-122.08562, 37.38882], [-122.0861, 37.38814]]]} | Open Access 1 | 15839 | Eagle Park | 18340 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 6.918 | Eagle Park | 1940 | Local Park 2 | 4 | |
9474 | 9474 | 9473 | {"type": "MultiPolygon", "coordinates": [[[[-122.30915, 37.84566], [-122.30817, 37.84588], [-122.30821, 37.8476], [-122.30107, 37.84921], [-122.30081, 37.84913], [-122.30112, 37.84812], [-122.30117, 37.84744], [-122.30225, 37.84718], [-122.30225, 37.84437], [-122.29844, 37.84436], [-122.29811, 37.84292], [-122.29818, 37.84243], [-122.29797, 37.84227], [-122.29795, 37.84217], [-122.29789, 37.8416], [-122.29789, 37.84144], [-122.29792, 37.84125], [-122.29802, 37.84093], [-122.29939, 37.84074], [-122.30721, 37.84074], [-122.30856, 37.84072], [-122.30857, 37.84074], [-122.30914, 37.84075], [-122.30915, 37.84566]]], [[[-122.31153, 37.86418], [-122.31141, 37.86454], [-122.31122, 37.86464], [-122.31104, 37.86465], [-122.3106, 37.86471], [-122.30591, 37.86568], [-122.30577, 37.86572], [-122.30563, 37.86572], [-122.30537, 37.86541], [-122.30393, 37.86453], [-122.30218, 37.85889], [-122.3003, 37.85163], [-122.30027, 37.85145], [-122.30027, 37.85121], [-122.30025, 37.85105], [-122.30068, 37.84959], [-122.30208, 37.84924], [-122.30822, 37.84786], [-122.30848, 37.85877], [-122.31153, 37.86418]]], [[[-122.31316, 37.8691], [-122.30903, 37.86998], [-122.30548, 37.87079], [-122.30529, 37.87011], [-122.30499, 37.86879], [-122.30499, 37.86853], [-122.30507, 37.86831], [-122.30574, 37.86731], [-122.30583, 37.86703], [-122.30579, 37.8668], [-122.30572, 37.8666], [-122.30575, 37.86651], [-122.30584, 37.86647], [-122.31099, 37.86543], [-122.3112, 37.8655], [-122.31316, 37.8691]]], [[[-122.31846, 37.87579], [-122.31005, 37.87748], [-122.30873, 37.87383], [-122.30661, 37.87435], [-122.30561, 37.87119], [-122.31326, 37.86954], [-122.31446, 37.87081], [-122.31516, 37.87171], [-122.31566, 37.87224], [-122.31846, 37.87579]]], [[[-122.33944, 37.89058], [-122.32869, 37.8935], [-122.32262, 37.89493], [-122.32444, 37.89221], [-122.32573, 37.89251], [-122.32599, 37.89234], [-122.32592, 37.89206], [-122.32566, 37.89202], [-122.32559, 37.89173], [-122.32561, 37.89111], [-122.32568, 37.8908], [-122.326, 37.89082], [-122.3265, 37.89088], [-122.32691, 37.89087], [-122.32717, 37.89084], [-122.32745, 37.89074], [-122.3275, 37.89097], [-122.32748, 37.89129], [-122.32754, 37.89159], [-122.32756, 37.8916], [-122.32776, 37.8908], [-122.32775, 37.89047], [-122.32777, 37.89024], [-122.3277, 37.88994], [-122.32767, 37.88943], [-122.32756, 37.88886], [-122.32763, 37.88856], [-122.32718, 37.88871], [-122.32695, 37.88868], [-122.32661, 37.88861], [-122.32619, 37.88847], [-122.3258, 37.88824], [-122.3254, 37.88804], [-122.32501, 37.88804], [-122.32463, 37.88788], [-122.32431, 37.88803], [-122.32374, 37.88809], [-122.32341, 37.88824], [-122.32319, 37.88832], [-122.32315, 37.88872], [-122.32321, 37.88893], [-122.32312, 37.8891], [-122.31722, 37.88925], [-122.3171, 37.88922], [-122.31602, 37.88795], [-122.31595, 37.88794], [-122.31593, 37.88793], [-122.31594, 37.88071], [-122.31252, 37.88139], [-122.31236, 37.88109], [-122.31217, 37.88081], [-122.31211, 37.88068], [-122.31185, 37.88037], [-122.31159, 37.88009], [-122.3108, 37.8791], [-122.31005, 37.87812], [-122.3099, 37.8779], [-122.30983, 37.87775], [-122.31024, 37.87767], [-122.31046, 37.87778], [-122.31051, 37.87772], [-122.31053, 37.87761], [-122.31588, 37.87656], [-122.31865, 37.87593], [-122.32167, 37.87952], [-122.32559, 37.88405], [-122.33014, 37.88463], [-122.3307, 37.88919], [-122.33944, 37.89058]]]]} | Open Access 1 | 15869 | McLaughlin Eastshore State Park | 29199 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Alameda 17 | 1084.173 | McLaughlin Eastshore SP | 0 | None 785 | |
9475 | 9475 | 9474 | {"type": "Polygon", "coordinates": [[[-121.99706, 37.85874], [-121.99272, 37.85889], [-121.99271, 37.85879], [-121.99179, 37.85882], [-121.99177, 37.85859], [-121.99113, 37.85861], [-121.99114, 37.85894], [-121.98799, 37.85902], [-121.98802, 37.85534], [-121.98347, 37.85552], [-121.9834, 37.85198], [-121.98093, 37.85206], [-121.98203, 37.84983], [-121.98481, 37.84974], [-121.98472, 37.84989], [-121.98475, 37.85233], [-121.98792, 37.85218], [-121.98792, 37.85182], [-121.99283, 37.85166], [-121.99236, 37.85244], [-121.99237, 37.8527], [-121.99281, 37.85361], [-121.99269, 37.85461], [-121.9942, 37.85475], [-121.99566, 37.85534], [-121.99601, 37.85511], [-121.997, 37.85504], [-121.99706, 37.85874]]]} | Open Access 1 | 17309 | Las Trampas/Diablo Regional Trail | 21069 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 174.441 | Las Trampas/Diablo Reg. Trail | 1976 | Local Recreation Area 3 | 4 | |
9476 | 9476 | 9475 | {"type": "Polygon", "coordinates": [[[-119.13443, 35.32752], [-119.13344, 35.32788], [-119.13326, 35.32759], [-119.13319, 35.32756], [-119.13322, 35.32748], [-119.13322, 35.3274], [-119.13317, 35.32734], [-119.13316, 35.32725], [-119.13316, 35.32675], [-119.13318, 35.32669], [-119.13317, 35.32658], [-119.13314, 35.32653], [-119.13308, 35.32648], [-119.13293, 35.32641], [-119.13282, 35.3264], [-119.13267, 35.32642], [-119.13267, 35.32597], [-119.13269, 35.32588], [-119.13416, 35.32588], [-119.13437, 35.32728], [-119.13443, 35.32752]]]} | Open Access 1 | 15871 | Windermere Park | 27624 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.812 | Windermere Park | 0 | Local Park 2 | 4 | |
9477 | 9477 | 9476 | {"type": "Polygon", "coordinates": [[[-121.63011, 39.1475], [-121.62898, 39.1475], [-121.62898, 39.14596], [-121.6293, 39.14596], [-121.62948, 39.14591], [-121.6301, 39.14591], [-121.63011, 39.1475]]]} | Open Access 1 | 15888 | Kingwood Park | 20673 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 4.209 | Kingwood 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]);