units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,454 rows where AGNCY_LEV = 3 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 149
- Santa Barbara, County of 116
- San Diego, County of 116
- Orange, County of 89
- Los Angeles - Department of Parks and Recreation, County of 59
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 49
- Monterey, County of 46
- Kern, County of 46
- El Dorado, County of 42
- Santa Clara County Parks and Recreation Dept., County of 39
- Riverside, County of 38
- Marin County Parks Department, County of 32
- San Luis Obispo, County of 31
- Placer, County of 27
- San Mateo County Parks and Recreation Dept., County of 24
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 10
- …
DES_TP >30
- Local Park 798
- Local Other or Unknown 221
- Local Recreation Area 146
- Local Conservation Area 114
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 11
ACCESS_TYP 4
- Open Access 1,275
- Restricted Access 77
- No Public Access 46
- Unknown Access 36
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13119 | 13119 | 13118 | {"type": "Polygon", "coordinates": [[[-117.03429, 34.05023], [-117.03428, 34.05205], [-117.02584, 34.05208], [-117.02582, 34.0496], [-117.0264, 34.04972], [-117.02709, 34.04997], [-117.0277, 34.04982], [-117.02836, 34.04976], [-117.02879, 34.04956], [-117.02917, 34.04944], [-117.02963, 34.04933], [-117.03007, 34.04927], [-117.03008, 34.04906], [-117.03226, 34.04903], [-117.03227, 34.05024], [-117.03429, 34.05023]]]} | No Public Access 3 | 35036 | Bryant St Detention Basin | 16460 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 51.946 | Bryant St Detention Basin | 0 | None 1138 | ||
12684 | 12684 | 12683 | {"type": "MultiPolygon", "coordinates": [[[[-124.23966, 41.77097], [-124.23864, 41.77117], [-124.23847, 41.77079], [-124.23837, 41.77061], [-124.2383, 41.77053], [-124.23809, 41.77029], [-124.23778, 41.76998], [-124.23727, 41.76955], [-124.22932, 41.76403], [-124.23032, 41.76399], [-124.2313, 41.7646], [-124.23231, 41.76529], [-124.23319, 41.76587], [-124.23412, 41.76635], [-124.2342, 41.76637], [-124.23494, 41.76685], [-124.23562, 41.76742], [-124.236, 41.76782], [-124.23687, 41.76861], [-124.23692, 41.7687], [-124.2371, 41.76889], [-124.2383, 41.77003], [-124.23917, 41.77076], [-124.23952, 41.7709], [-124.23966, 41.77097]]], [[[-124.25357, 41.78535], [-124.2531, 41.78529], [-124.25267, 41.78538], [-124.25246, 41.7854], [-124.25172, 41.78564], [-124.25108, 41.78595], [-124.25085, 41.78611], [-124.25074, 41.78616], [-124.25049, 41.78634], [-124.24986, 41.78696], [-124.24973, 41.78716], [-124.24952, 41.78732], [-124.2494, 41.78752], [-124.24871, 41.78753], [-124.24443, 41.78444], [-124.24436, 41.78221], [-124.24399, 41.77305], [-124.24457, 41.77304], [-124.24459, 41.77204], [-124.24479, 41.77198], [-124.24507, 41.77183], [-124.24528, 41.7716], [-124.2457, 41.77092], [-124.24621, 41.77072], [-124.24689, 41.77071], [-124.2469, 41.77073], [-124.24706, 41.77073], [-124.24772, 41.77089], [-124.24788, 41.77103], [-124.24788, 41.77115], [-124.24811, 41.77166], [-124.24833, 41.7718], [-124.24836, 41.77244], [-124.24816, 41.77264], [-124.24818, 41.77302], [-124.24825, 41.77336], [-124.24824, 41.77358], [-124.2483, 41.77389], [-124.2485, 41.77414], [-124.24875, 41.77441], [-124.24879, 41.77451], [-124.24899, 41.77468], [-124.24914, 41.77488], [-124.24932, 41.77485], [-124.24943, 41.77486], [-124.24979, 41.7748], [-124.24995, 41.7747], [-124.25017, 41.77466], [-124.25035, 41.77471], [-124.25073, 41.77472], [-124.25085, 41.77478], [-124.25094, 41.77496], [-124.25088, 41.77517], [-124.25097, 41.77524], [-124.251, 41.77532], [-124.25099, 41.77543], [-124.2509, 41.7755], [-124.25091, 41.77559], [-124.2508, 41.77563], [-124.2504, 41.77569], [-124.25012, 41.77588], [-124.2501, 41.77596], [-124.25024, 41.7763], [-124.25046, 41.77656], [-124.25068, 41.77671], [-124.25078, 41.77687], [-124.25111, 41.77717], [-124.25126, 41.77726], [-124.25139, 41.77729], [-124.25165, 41.77755], [-124.25177, 41.77759], [-124.25209, 41.77775], [-124.25226, 41.77793], [-124.25269, 41.77815], [-124.25297, 41.77831], [-124.25301, 41.7783], [-124.25344, 41.77855], [-124.25346, 41.7795], [-124.25344, 41.78037], [-124.25349, 41.7824], [-124.25189, 41.78253], [-124.25191, 41.78428], [-124.25247, 41.78431], [-124.25301, 41.78431], [-124.25302, 41.78446], [-124.25355, 41.78445], [-124.25357, 41.78535]]]]} | Open Access 1 | 29662 | Point St. George | 3081 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.visitredwoodcoast.com/content/point-st-george-heritage-area/ncoC5001D7E35E00EA39 | Del Norte 50 | 262.074 | Point St. George | None 1102 | ||
12434 | 12434 | 12433 | {"type": "Polygon", "coordinates": [[[-119.70244, 36.73399], [-119.70282, 36.73399], [-119.70289, 36.73401], [-119.70294, 36.73405], [-119.7034, 36.73496], [-119.7034, 36.73503], [-119.70336, 36.73509], [-119.70325, 36.73514], [-119.70255, 36.73514], [-119.70247, 36.73512], [-119.70241, 36.73508], [-119.70238, 36.735], [-119.70237, 36.73404], [-119.70239, 36.734], [-119.70244, 36.73399]]]} | Open Access 1 | 48757 | Montecito | 33484 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 2.258 | Montecito | None 1079 | |||
11838 | 11838 | 11837 | {"type": "MultiPolygon", "coordinates": [[[[-119.50841, 35.71741], [-119.50835, 35.72211], [-119.50147, 35.72213], [-119.50148, 35.71744], [-119.50841, 35.71741]]], [[[-119.53642, 35.24923], [-119.53637, 35.25286], [-119.52764, 35.25288], [-119.52764, 35.24926], [-119.53642, 35.24923]]], [[[-119.5627, 35.26741], [-119.56269, 35.27111], [-119.55377, 35.2711], [-119.55377, 35.26739], [-119.5627, 35.26741]]], [[[-119.56271, 35.25653], [-119.56267, 35.26018], [-119.55822, 35.26019], [-119.5583, 35.25655], [-119.56271, 35.25653]]], [[[-119.56721, 35.36867], [-119.56296, 35.36869], [-119.56291, 35.36697], [-119.56275, 35.36696], [-119.56272, 35.36146], [-119.55829, 35.36147], [-119.55824, 35.35402], [-119.56269, 35.35404], [-119.56273, 35.36145], [-119.56711, 35.36145], [-119.56721, 35.36867]]], [[[-119.61863, 35.45225], [-119.61846, 35.45226], [-119.61843, 35.45575], [-119.60085, 35.45588], [-119.60076, 35.44504], [-119.60968, 35.44502], [-119.60974, 35.45224], [-119.61863, 35.45221], [-119.61863, 35.45225]]], [[[-119.62058, 35.63057], [-119.62057, 35.63396], [-119.61564, 35.63389], [-119.61562, 35.63049], [-119.62058, 35.63057]]], [[[-119.63516, 35.65584], [-119.62545, 35.65571], [-119.62534, 35.65207], [-119.63513, 35.65218], [-119.63516, 35.65584]]], [[[-119.6351, 35.63078], [-119.63514, 35.63416], [-119.63512, 35.63772], [-119.63501, 35.64495], [-119.62541, 35.64483], [-119.62537, 35.64127], [-119.62536, 35.63063], [-119.6351, 35.63078]]], [[[-119.63056, 35.6812], [-119.63053, 35.68485], [-119.62542, 35.68479], [-119.62545, 35.68117], [-119.63056, 35.6812]]], [[[-119.63796, 35.36139], [-119.63356, 35.36141], [-119.63356, 35.3578], [-119.63791, 35.35778], [-119.63796, 35.36139]]], [[[-119.64439, 35.69219], [-119.64411, 35.69937], [-119.64393, 35.70294], [-119.63934, 35.7029], [-119.63474, 35.70289], [-119.63481, 35.69214], [-119.64439, 35.69219]]], [[[-119.65439, 35.64517], [-119.65408, 35.66684], [-119.64457, 35.66678], [-119.64465, 35.65954], [-119.64471, 35.64506], [-119.65439, 35.64517]]], [[[-119.66193, 35.73204], [-119.65318, 35.73203], [-119.65309, 35.72562], [-119.65309, 35.71788], [-119.66189, 35.71792], [-119.66193, 35.73204]]], [[[-119.68501, 35.70294], [-119.6823, 35.70958], [-119.68209, 35.7102], [-119.66189, 35.7102], [-119.66189, 35.70291], [-119.68501, 35.70294]]]]} | Open Access 1 | 24167 | Kern County Valley Floor Habitat Conservation Plan | 4801 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 2784.022 | Kern County Valley Floor Habitat Conservation Plan | None 1041 | |||
11486 | 11486 | 11485 | {"type": "Polygon", "coordinates": [[[-121.23036, 40.31128], [-121.22869, 40.31078], [-121.22893, 40.31053], [-121.22915, 40.31023], [-121.22982, 40.31054], [-121.23019, 40.31006], [-121.2305, 40.3102], [-121.23071, 40.30993], [-121.23103, 40.31009], [-121.23108, 40.31008], [-121.23123, 40.31016], [-121.23127, 40.31012], [-121.23164, 40.3103], [-121.23135, 40.31089], [-121.23114, 40.31086], [-121.23077, 40.31138], [-121.23036, 40.31128]]]} | Open Access 1 | 48187 | Chester Park and Ballfields | 32850 | 362 | Plumas, County of 664 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | Plumas 57 | 5.319 | Chester Park and Ballfields | 0 | None 1021 | ||
11447 | 11447 | 11446 | {"type": "Polygon", "coordinates": [[[-117.92427, 33.98937], [-117.92229, 33.98922], [-117.92235, 33.98879], [-117.92237, 33.98878], [-117.9235, 33.98886], [-117.92365, 33.98889], [-117.92386, 33.98897], [-117.92404, 33.98909], [-117.92417, 33.98922], [-117.92427, 33.98937]]]} | Open Access 1 | 48140 | Albatross Road Rest Area | 32670 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/albatross-road-rest-area/ | Los Angeles 6 | 1.94 | Albatross Road Rest Area | None 1016 | ||
11443 | 11443 | 11442 | {"type": "MultiPolygon", "coordinates": [[[[-121.94454, 37.59589], [-121.9445, 37.5966], [-121.93814, 37.59689], [-121.93805, 37.59691], [-121.93803, 37.59707], [-121.93759, 37.59703], [-121.93756, 37.59685], [-121.93765, 37.59503], [-121.9375, 37.59448], [-121.93727, 37.59404], [-121.93713, 37.59343], [-121.93704, 37.59338], [-121.93704, 37.59322], [-121.93638, 37.59218], [-121.93598, 37.59189], [-121.93532, 37.59164], [-121.93475, 37.59162], [-121.93417, 37.59175], [-121.9335, 37.59209], [-121.93247, 37.59285], [-121.93129, 37.59484], [-121.92813, 37.5967], [-121.92649, 37.59793], [-121.92556, 37.59832], [-121.92507, 37.59842], [-121.92386, 37.59841], [-121.92295, 37.59823], [-121.92171, 37.59775], [-121.92047, 37.59709], [-121.91785, 37.59507], [-121.91651, 37.59391], [-121.91529, 37.59344], [-121.91377, 37.59308], [-121.9117, 37.593], [-121.91096, 37.59321], [-121.90743, 37.59454], [-121.90541, 37.59502], [-121.9041, 37.59509], [-121.90379, 37.59498], [-121.9025, 37.59479], [-121.90243, 37.5947], [-121.89927, 37.59391], [-121.89615, 37.59332], [-121.89377, 37.59299], [-121.89169, 37.59278], [-121.88985, 37.5927], [-121.88751, 37.59265], [-121.88603, 37.59248], [-121.88454, 37.59259], [-121.88357, 37.5945], [-121.88357, 37.59451], [-121.8838, 37.59455], [-121.88415, 37.59487], [-121.88431, 37.5952], [-121.88422, 37.59584], [-121.8838, 37.59632], [-121.88324, 37.59679], [-121.88106, 37.5982], [-121.87861, 37.5989], [-121.87608, 37.59934], [-121.87581, 37.59943], [-121.87526, 37.59963], [-121.87493, 37.59997], [-121.87465, 37.60046], [-121.87458, 37.60089], [-121.87403, 37.60137], [-121.87424, 37.60596], [-121.87601, 37.60632], [-121.87797, 37.60915], [-121.87819, 37.61072], [-121.87926, 37.61261], [-121.8793, 37.61288], [-121.88058, 37.61696], [-121.88223, 37.62116], [-121.88225, 37.62415], [-121.88319, 37.62619], [-121.88229, 37.62637], [-121.8819, 37.62639], [-121.88065, 37.62668], [-121.87351, 37.60837], [-121.87332, 37.60844], [-121.84693, 37.60243], [-121.84797, 37.60206], [-121.84833, 37.60157], [-121.84883, 37.60066], [-121.84904, 37.60049], [-121.84936, 37.60021], [-121.85073, 37.59936], [-121.8516, 37.5987], [-121.8527, 37.59814], [-121.85374, 37.59783], [-121.85501, 37.59773], [-121.85521, 37.59424], [-121.84563, 37.59215], [-121.84468, 37.58728], [-121.8384, 37.58725], [-121.83811, 37.58273], [-121.83739, 37.58308], [-121.83619, 37.58377], [-121.83348, 37.58497], [-121.82973, 37.58706], [-121.82743, 37.58894], [-121.82469, 37.5913], [-121.82157, 37.59432], [-121.81939, 37.59664], [-121.81939, 37.60076], [-121.80555, 37.60081], [-121.80554, 37.59818], [-121.7862, 37.59816], [-121.78118, 37.60198], [-121.7783, 37.60025], [-121.77841, 37.59127], [-121.77808, 37.59126], [-121.77702, 37.59019], [-121.77666, 37.58996], [-121.76516, 37.59044], [-121.76521, 37.5822], [-121.75297, 37.58206], [-121.75305, 37.57885], [-121.75304, 37.57884], [-121.73468, 37.57873], [-121.72581, 37.5787], [-121.72591, 37.57156], [-121.71649, 37.57154], [-121.71651, 37.5642], [-121.73482, 37.5642], [-121.74385, 37.56409], [-121.75314, 37.56408], [-121.7713, 37.56422], [-121.78771, 37.56431], [-121.78805, 37.55397], [-121.79753, 37.55397], [-121.79756, 37.55702], [-121.80108, 37.55707], [-121.80111, 37.56421], [-121.80659, 37.56424], [-121.83004, 37.5643], [-121.83002, 37.56079], [-121.83412, 37.56075], [-121.83379, 37.54986], [-121.84302, 37.54992], [-121.84321, 37.53688], [-121.84359, 37.53692], [-121.84373, 37.53692], [-121.84384, 37.53694], [-121.84415, 37.53703], [-121.84434, 37.53704], [-121.84444, 37.53701], [-121.84463, 37.53699], [-121.84522, 37.53709], [-121.84552, 37.53705], [-121.84582, 37.53694], [-121.84617, 37.53694], [-121.84646, 37.53688], [-121.84684, 37.53674], [-121.84716, 37.53648], [-121.84735, 37.53629], [-121.84772, 37.53609], [-121.84796, 37.53606], [-121.84833, 37.53615], [-121.84871, 37.53615], [-121.8493, 37.53591], [-121.84978, 37.53595], [-121.85, 37.53589], [-121.85023, 37.5359], [-121.85049, 37.53588], [-121.85089, 37.53583], [-121.85142, 37.53574], [-121.85196, 37.53559], [-121.85226, 37.53555], [-121.85263, 37.53557], [-121.8528, 37.53564], [-121.85303, 37.53568], [-121.85303, 37.53566], [-121.85287, 37.53547], [-121.85267, 37.53514], [-121.85237, 37.5348], [-121.85191, 37.53405], [-121.85171, 37.53351], [-121.85168, 37.5327], [-121.85203, 37.53169], [-121.85209, 37.5316], [-121.85212, 37.53149], [-121.85263, 37.5307], [-121.85277, 37.53054], [-121.85276, 37.53032], [-121.85271, 37.53019], [-121.85304, 37.53025], [-121.85308, 37.53044], [-121.85356, 37.53043], [-121.85474, 37.53091], [-121.85545, 37.53365], [-121.85593, 37.53399], [-121.85602, 37.53431], [-121.85607, 37.53469], [-121.85699, 37.53534], [-121.85796, 37.5364], [-121.85795, 37.53698], [-121.85706, 37.53799], [-121.85711, 37.53827], [-121.85743, 37.53873], [-121.85775, 37.5391], [-121.85784, 37.53962], [-121.85776, 37.53985], [-121.85748, 37.54004], [-121.8583, 37.54118], [-121.86353, 37.54128], [-121.86876, 37.54132], [-121.86872, 37.54202], [-121.86881, 37.54203], [-121.86853, 37.54853], [-121.87777, 37.5487], [-121.87772, 37.55591], [-121.88367, 37.56239], [-121.88792, 37.56245], [-121.88737, 37.5628], [-121.88555, 37.56433], [-121.88473, 37.56514], [-121.88422, 37.56581], [-121.88383, 37.56677], [-121.88363, 37.56767], [-121.88289, 37.56655], [-121.87588, 37.56873], [-121.87359, 37.56389], [-121.87433, 37.56394], [-121.87434, 37.56392], [-121.87182, 37.55949], [-121.87054, 37.55965], [-121.86967, 37.55838], [-121.86646, 37.55893], [-121.86683, 37.55955], [-121.86737, 37.56007], [-121.86796, 37.56061], [-121.86822, 37.56105], [-121.86838, 37.56164], [-121.86852, 37.56205], [-121.86902, 37.56287], [-121.86932, 37.56316], [-121.86983, 37.56407], [-121.86994, 37.56438], [-121.87011, 37.56499], [-121.87052, 37.56575], [-121.87163, 37.56752], [-121.87212, 37.56842], [-121.87268, 37.56936], [-121.87334, 37.57057], [-121.87385, 37.5716], [-121.8742, 37.57256], [-121.87457, 37.57364], [-121.87464, 37.57422], [-121.87466, 37.57468], [-121.87446, 37.57505], [-121.87432, 37.57549], [-121.87432, 37.57589], [-121.87451, 37.57632], [-121.87488, 37.57667], [-121.87523, 37.57686], [-121.87572, 37.57725], [-121.87623, 37.57774], [-121.87727, 37.57843], [-121.87827, 37.57765], [-121.87945, 37.57681], [-121.88062, 37.57626], [-121.88185, 37.57589], [-121.88547, 37.57537], [-121.88675, 37.57441], [-121.88784, 37.57368], [-121.89152, 37.57192], [-121.89421, 37.57061], [-121.89475, 37.57098], [-121.89846, 37.57472], [-121.89959, 37.5745], [-121.90226, 37.58205], [-121.90273, 37.58256], [-121.90382, 37.58353], [-121.90441, 37.58374], [-121.905, 37.5839], [-121.9055, 37.58398], [-121.90573, 37.58405], [-121.90595, 37.58408], [-121.90624, 37.58416], [-121.9064, 37.58417], [-121.90762, 37.58414], [-121.90808, 37.58424], [-121.90897, 37.58425], [-121.90915, 37.58423], [-121.91012, 37.58425], [-121.91119, 37.58414], [-121.9119, 37.58423], [-121.91202, 37.58427], [-121.91219, 37.58429], [-121.91256, 37.5843], [-121.91316, 37.58444], [-121.91329, 37.58454], [-121.91386, 37.58472], [-121.91427, 37.58614], [-121.91474, 37.58654], [-121.9225, 37.59049], [-121.9275, 37.58729], [-121.92784, 37.58575], [-121.92993, 37.58591], [-121.93276, 37.59108], [-121.93278, 37.59108], [-121.93276, 37.59073], [-121.93717, 37.59057], [-121.93766, 37.59076], [-121.93777, 37.59095], [-121.93838, 37.59124], [-121.93886, 37.59122], [-121.93897, 37.59126], [-121.93899, 37.59152], [-121.93939, 37.59171], [-121.93954, 37.5932], [-121.9395, 37.59431], [-121.94454, 37.59589]], [[-121.86961, 37.55723], [-121.86962, 37.55722], [-121.86724, 37.55421], [-121.86443, 37.55485], [-121.86549, 37.55604], [-121.86566, 37.55668], [-121.86615, 37.55767], [-121.86961, 37.55723]]], [[[-121.85097, 37.4845], [-121.85077, 37.48814], [-121.84666, 37.48816], [-121.84646, 37.49134], [-121.84263, 37.49125], [-121.84281, 37.49994], [-121.84289, 37.50646], [-121.83018, 37.50608], [-121.82899, 37.5048], [-121.82867, 37.50442], [-121.82791, 37.50396], [-121.82703, 37.50361], [-121.82642, 37.50342], [-121.82603, 37.50385], [-121.82564, 37.50399], [-121.82543, 37.50361], [-121.82524, 37.50319], [-121.82486, 37.50313], [-121.8222, 37.50333], [-121.82052, 37.5033], [-121.81987, 37.50434], [-121.81957, 37.50444], [-121.81978, 37.50496], [-121.81948, 37.50513], [-121.81907, 37.50437], [-121.81697, 37.5036], [-121.81576, 37.50409], [-121.81492, 37.50464], [-121.81415, 37.5054], [-121.81386, 37.50563], [-121.80686, 37.50544], [-121.79132, 37.50475], [-121.7734, 37.50472], [-121.75468, 37.50453], [-121.75463, 37.49994], [-121.75464, 37.49101], [-121.7732, 37.49074], [-121.77317, 37.48541], [-121.77316, 37.4854], [-121.77318, 37.48406], [-121.79079, 37.48417], [-121.79589, 37.48398], [-121.80073, 37.48399], [-121.82337, 37.48423], [-121.83148, 37.48424], [-121.83287, 37.48434], [-121.84627, 37.48444], [-121.85057, 37.48444], [-121.85097, 37.4845]]], [[[-121.86477, 37.49128], [-121.86466, 37.49523], [-121.8601, 37.49519], [-121.86005, 37.49904], [-121.85565, 37.49892], [-121.85582, 37.49136], [-121.85594, 37.48769], [-121.8603, 37.48777], [-121.86015, 37.49152], [-121.86477, 37.49128]]]]} | Restricted Access 2 | 23002 | San Francisco Watershed Lands | 24889 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | Alameda 17 | 19552.964 | San Francisco Watershed Lands | None 1015 | |||
11422 | 11422 | 11421 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | 22242 | Harrison Larry L/Tonya A | 19699 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.036 | Harrison Larry L/Tonya A | None 1012 | |||
11419 | 11419 | 11418 | {"type": "MultiPolygon", "coordinates": [[[[-121.17476, 38.47876], [-121.1741, 38.47839], [-121.17414, 38.47832], [-121.17425, 38.47823], [-121.1744, 38.47819], [-121.17462, 38.47819], [-121.1747, 38.47821], [-121.17479, 38.47825], [-121.17487, 38.47832], [-121.17491, 38.47838], [-121.17494, 38.47845], [-121.17494, 38.47852], [-121.17492, 38.47859], [-121.17488, 38.47866], [-121.17476, 38.47876]]], [[[-121.18136, 38.48039], [-121.17757, 38.48451], [-121.17626, 38.48377], [-121.17616, 38.48373], [-121.1764, 38.48358], [-121.17654, 38.48355], [-121.1767, 38.48368], [-121.17694, 38.48382], [-121.17721, 38.48387], [-121.17772, 38.48405], [-121.17783, 38.48404], [-121.17789, 38.4839], [-121.17787, 38.48367], [-121.17769, 38.48322], [-121.1774, 38.48282], [-121.17692, 38.48233], [-121.17676, 38.48229], [-121.17665, 38.4824], [-121.17654, 38.48285], [-121.17645, 38.48293], [-121.17635, 38.4829], [-121.17613, 38.48274], [-121.17599, 38.48253], [-121.17581, 38.48233], [-121.17552, 38.48218], [-121.17543, 38.48206], [-121.17538, 38.48181], [-121.17528, 38.48159], [-121.17534, 38.48144], [-121.17562, 38.48154], [-121.17575, 38.4815], [-121.17586, 38.4815], [-121.17602, 38.48147], [-121.17606, 38.48133], [-121.1764, 38.48101], [-121.17652, 38.48078], [-121.17658, 38.48057], [-121.17699, 38.48017], [-121.17716, 38.47992], [-121.17721, 38.47974], [-121.17708, 38.47969], [-121.17694, 38.47958], [-121.1769, 38.47949], [-121.17689, 38.47938], [-121.17685, 38.47928], [-121.17671, 38.4792], [-121.17666, 38.47914], [-121.17662, 38.47906], [-121.17661, 38.47899], [-121.17662, 38.47891], [-121.17666, 38.47882], [-121.17673, 38.47874], [-121.17688, 38.47867], [-121.17704, 38.47866], [-121.17717, 38.4787], [-121.17727, 38.47877], [-121.1774, 38.47883], [-121.17747, 38.4789], [-121.17752, 38.47901], [-121.17769, 38.47923], [-121.17773, 38.47937], [-121.17772, 38.47949], [-121.17809, 38.47959], [-121.17837, 38.47932], [-121.17837, 38.47916], [-121.17828, 38.479], [-121.17802, 38.47876], [-121.1773, 38.47844], [-121.1772, 38.47833], [-121.17719, 38.47824], [-121.17704, 38.47828], [-121.1768, 38.47827], [-121.17663, 38.47821], [-121.1765, 38.47812], [-121.17641, 38.47801], [-121.17635, 38.47791], [-121.17632, 38.47778], [-121.17632, 38.47771], [-121.17635, 38.47764], [-121.17648, 38.47752], [-121.17741, 38.47806], [-121.17733, 38.47817], [-121.1774, 38.47817], [-121.17763, 38.47827], [-121.18136, 38.48039]]]]} | Restricted Access 2 | 22235 | Silva Et Al | 25480 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 41.21 | Silva Et Al | None 1011 | |||
11418 | 11418 | 11417 | {"type": "Polygon", "coordinates": [[[-121.20133, 38.43685], [-121.20134, 38.43694], [-121.20132, 38.43704], [-121.20014, 38.43829], [-121.20013, 38.4383], [-121.20006, 38.4383], [-121.20003, 38.43827], [-121.20001, 38.43824], [-121.20036, 38.4379], [-121.20048, 38.43773], [-121.20071, 38.43749], [-121.20119, 38.43684], [-121.20129, 38.43682], [-121.20133, 38.43685]]]} | Restricted Access 2 | 22230 | John H Friend | 20444 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.684 | John H Friend | None 1010 | |||
11417 | 11417 | 11416 | {"type": "Polygon", "coordinates": [[[-121.14098, 38.78809], [-121.14088, 38.78839], [-121.14077, 38.78865], [-121.14032, 38.7885], [-121.14058, 38.78796], [-121.14065, 38.78802], [-121.14098, 38.78809]]]} | Open Access 1 | 22228 | Placer | 23762 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 0.628 | Placer | None 1009 | |||
11410 | 11410 | 11409 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | 22247 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.273 | Kenneth Way Drainage | None 1008 | |||
11405 | 11405 | 11404 | {"type": "MultiPolygon", "coordinates": [[[[-121.12189, 38.448], [-121.12205, 38.44809], [-121.12216, 38.44818], [-121.12227, 38.44831], [-121.12236, 38.44848], [-121.12238, 38.44862], [-121.12238, 38.4488], [-121.12234, 38.44893], [-121.12227, 38.44905], [-121.12217, 38.44916], [-121.12199, 38.44928], [-121.12184, 38.44934], [-121.12163, 38.44939], [-121.12143, 38.44941], [-121.12126, 38.44939], [-121.12109, 38.44935], [-121.12094, 38.44929], [-121.12081, 38.4492], [-121.12068, 38.44908], [-121.12056, 38.44893], [-121.1205, 38.44881], [-121.12047, 38.4486], [-121.1205, 38.44842], [-121.12058, 38.44827], [-121.12071, 38.44812], [-121.12055, 38.44804], [-121.12043, 38.44795], [-121.12031, 38.44782], [-121.12023, 38.4477], [-121.12017, 38.44754], [-121.12015, 38.4474], [-121.12018, 38.44722], [-121.12023, 38.44709], [-121.12032, 38.44698], [-121.12047, 38.44684], [-121.12066, 38.44674], [-121.12087, 38.44667], [-121.1211, 38.44665], [-121.12132, 38.44667], [-121.12154, 38.44672], [-121.12169, 38.44679], [-121.12186, 38.44691], [-121.12201, 38.44709], [-121.12208, 38.44721], [-121.12212, 38.44734], [-121.12212, 38.44748], [-121.12209, 38.44763], [-121.122, 38.4478], [-121.12183, 38.44796], [-121.12189, 38.448]]], [[[-121.12616, 38.44975], [-121.12493, 38.44976], [-121.12493, 38.44977], [-121.12538, 38.45016], [-121.12535, 38.45016], [-121.12506, 38.45015], [-121.12485, 38.45009], [-121.12463, 38.44997], [-121.12455, 38.44991], [-121.12445, 38.4498], [-121.1244, 38.44972], [-121.12435, 38.44959], [-121.12433, 38.44947], [-121.12434, 38.44932], [-121.12438, 38.44919], [-121.12447, 38.44901], [-121.12463, 38.44882], [-121.12446, 38.44867], [-121.12437, 38.44854], [-121.12431, 38.44837], [-121.12429, 38.44824], [-121.12431, 38.4481], [-121.12438, 38.44793], [-121.12446, 38.44781], [-121.12457, 38.44771], [-121.12475, 38.4476], [-121.12497, 38.44753], [-121.12537, 38.44747], [-121.1255, 38.44744], [-121.12581, 38.44739], [-121.12598, 38.44738], [-121.1262, 38.4474], [-121.12663, 38.44751], [-121.12682, 38.44761], [-121.12698, 38.44776], [-121.1271, 38.44795], [-121.12713, 38.44804], [-121.12714, 38.44817], [-121.12711, 38.44835], [-121.12701, 38.44854], [-121.12694, 38.44861], [-121.12681, 38.44872], [-121.12662, 38.44882], [-121.1264, 38.44888], [-121.12612, 38.44889], [-121.12627, 38.44913], [-121.12632, 38.44931], [-121.12631, 38.44944], [-121.12628, 38.44954], [-121.12624, 38.44963], [-121.12616, 38.44975]]]]} | Unknown Access 4 | 22224 | River City Aggragates | 24408 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 23.425 | River City Aggragates | None 1006 | |||
11396 | 11396 | 11395 | {"type": "Polygon", "coordinates": [[[-121.26213, 38.63445], [-121.26039, 38.63544], [-121.25986, 38.63483], [-121.26152, 38.63391], [-121.26213, 38.63445]]]} | Open Access 1 | 22209 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.612 | County Of Sacramento | None 1005 | |||
11395 | 11395 | 11394 | {"type": "Polygon", "coordinates": [[[-121.26439, 38.63395], [-121.26357, 38.63433], [-121.26303, 38.63368], [-121.26299, 38.63358], [-121.263, 38.63348], [-121.26304, 38.6334], [-121.26311, 38.63333], [-121.26365, 38.63302], [-121.26439, 38.63395]]]} | Open Access 1 | 22207 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.396 | County Of Sacramento | None 1004 | |||
11392 | 11392 | 11391 | {"type": "Polygon", "coordinates": [[[-121.06665, 38.48801], [-121.0665, 38.48803], [-121.06649, 38.4883], [-121.06662, 38.48833], [-121.0666, 38.48893], [-121.06601, 38.48906], [-121.06516, 38.48893], [-121.0642, 38.48821], [-121.06273, 38.4882], [-121.06281, 38.48584], [-121.06337, 38.48587], [-121.06379, 38.48587], [-121.06455, 38.48582], [-121.06477, 38.48646], [-121.06523, 38.48658], [-121.06538, 38.4864], [-121.06538, 38.48637], [-121.06577, 38.48631], [-121.06577, 38.48628], [-121.06593, 38.48617], [-121.06631, 38.48611], [-121.06638, 38.48641], [-121.06637, 38.48651], [-121.06643, 38.48659], [-121.06639, 38.48663], [-121.06635, 38.48686], [-121.06632, 38.48713], [-121.06623, 38.48716], [-121.06618, 38.48722], [-121.06619, 38.48727], [-121.06624, 38.48732], [-121.06619, 38.48737], [-121.06622, 38.48762], [-121.06642, 38.48761], [-121.06644, 38.48781], [-121.06663, 38.4878], [-121.06665, 38.48801]]]} | Unknown Access 4 | 22200 | Rancho Murieta Association | 24158 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 21.798 | Rancho Murieta Association | None 1003 | |||
11387 | 11387 | 11386 | {"type": "Polygon", "coordinates": [[[-121.21012, 38.71593], [-121.19786, 38.71505], [-121.19788, 38.71503], [-121.19789, 38.7142], [-121.19866, 38.71422], [-121.19889, 38.71491], [-121.1989, 38.71492], [-121.19896, 38.71447], [-121.19913, 38.71429], [-121.19965, 38.7143], [-121.19966, 38.71425], [-121.20007, 38.71425], [-121.20002, 38.71325], [-121.2011, 38.71327], [-121.20106, 38.71245], [-121.20702, 38.71259], [-121.20694, 38.71083], [-121.20884, 38.71088], [-121.20918, 38.7123], [-121.20934, 38.71225], [-121.20936, 38.71266], [-121.20928, 38.71267], [-121.20937, 38.71447], [-121.21003, 38.71449], [-121.21012, 38.71593]], [[-121.20323, 38.71287], [-121.20235, 38.71284], [-121.20238, 38.71341], [-121.20326, 38.71343], [-121.20323, 38.71287]]]} | Open Access 1 | 22197 | Indian Stone Corral | 20210 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 78.87 | Indian Stone Corral | None 1002 | |||
11386 | 11386 | 11385 | {"type": "Polygon", "coordinates": [[[-121.20158, 38.69514], [-121.20156, 38.69574], [-121.20155, 38.69578], [-121.20151, 38.69581], [-121.20151, 38.69567], [-121.20076, 38.69541], [-121.19937, 38.6953], [-121.19888, 38.69513], [-121.19834, 38.6949], [-121.19795, 38.69477], [-121.19761, 38.69473], [-121.19711, 38.69472], [-121.19713, 38.69437], [-121.19853, 38.6944], [-121.19854, 38.6945], [-121.19884, 38.69451], [-121.19885, 38.69441], [-121.19949, 38.69442], [-121.19948, 38.69492], [-121.2004, 38.69496], [-121.20158, 38.69514]]]} | Open Access 1 | 22192 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.168 | County Of Sacramento | None 1001 | |||
11376 | 11376 | 11375 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71543], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | 22186 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.539 | Atreule Et Al Community Plan | None 1000 | |||
11284 | 11284 | 11283 | {"type": "MultiPolygon", "coordinates": [[[[-121.23771, 38.39477], [-121.23757, 38.39462], [-121.23747, 38.39463], [-121.23734, 38.39473], [-121.23716, 38.39492], [-121.23692, 38.39511], [-121.23671, 38.39514], [-121.23657, 38.39513], [-121.23657, 38.39498], [-121.23684, 38.39482], [-121.2369, 38.39472], [-121.23691, 38.39464], [-121.23685, 38.3946], [-121.23657, 38.39463], [-121.23657, 38.39415], [-121.23771, 38.39416], [-121.23771, 38.39477]]], [[[-121.23771, 38.39567], [-121.23728, 38.39532], [-121.23731, 38.39527], [-121.2374, 38.39523], [-121.23758, 38.3952], [-121.23771, 38.39516], [-121.23771, 38.39567]]]]} | Unknown Access 4 | 21836 | Poole Tina/gary M | 23892 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.148 | Poole Tina/gary M | None 987 |
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]);