units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, YR_EST
MNG_AGENCY >30
- Los Angeles, County of 175
- San Diego, County of 123
- Santa Barbara, County of 119
- Orange, County of 95
- Lake, County of 56
- Sacramento, County of 56
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- …
DES_TP >30
- Local Park 651
- Local Other or Unknown 214
- Local Recreation Area 117
- Local Conservation Area 103
- Local Historic or Cultural Area 21
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,098
- Restricted Access 59
- Unknown Access 36
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,219 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15741 | 15741 | 15740 | {"type": "Polygon", "coordinates": [[[-117.67117, 33.83107], [-117.66201, 33.83106], [-117.66204, 33.81651], [-117.67006, 33.81655], [-117.67117, 33.83107]]]} | Open Access 1 | 17813 | Cleveland National Forest, Exp 1 | 8049 | 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 | Orange 3 | 316.667 | Cleveland NF, Exp 1 | None 1368 | |||
15253 | 15253 | 15252 | {"type": "Polygon", "coordinates": [[[-117.83699, 34.08985], [-117.83673, 34.08994], [-117.83653, 34.08996], [-117.83639, 34.08993], [-117.83584, 34.08976], [-117.83566, 34.08974], [-117.83549, 34.08978], [-117.83504, 34.08995], [-117.83494, 34.09], [-117.83486, 34.09007], [-117.83466, 34.09033], [-117.83457, 34.0904], [-117.83461, 34.09043], [-117.8346, 34.09048], [-117.8345, 34.09064], [-117.83412, 34.09094], [-117.83411, 34.09105], [-117.83404, 34.09105], [-117.83392, 34.09111], [-117.83371, 34.09097], [-117.83288, 34.09149], [-117.83288, 34.09151], [-117.83312, 34.09166], [-117.83266, 34.09198], [-117.83208, 34.09179], [-117.83371, 34.09078], [-117.83396, 34.09098], [-117.83404, 34.09095], [-117.83405, 34.09078], [-117.83451, 34.09034], [-117.83467, 34.0901], [-117.83486, 34.08988], [-117.83536, 34.08953], [-117.8357, 34.08948], [-117.83608, 34.08955], [-117.83627, 34.08953], [-117.83661, 34.08973], [-117.83687, 34.08962], [-117.83699, 34.08985]]]} | Open Access 1 | 46302 | Valley Center Staging Area | 29586 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.239 | Valley Ctr. Staging Area | None 1343 | |||
15246 | 15246 | 15245 | {"type": "Polygon", "coordinates": [[[-117.84926, 34.08602], [-117.84835, 34.08657], [-117.84776, 34.08715], [-117.84678, 34.08702], [-117.8469, 34.08751], [-117.84639, 34.08764], [-117.84612, 34.0873], [-117.8453, 34.08752], [-117.84539, 34.08772], [-117.84528, 34.08799], [-117.84507, 34.08831], [-117.84442, 34.08851], [-117.84404, 34.08774], [-117.84443, 34.08765], [-117.84478, 34.08726], [-117.84618, 34.08684], [-117.84717, 34.08673], [-117.84857, 34.08591], [-117.84917, 34.08485], [-117.84905, 34.08586], [-117.84926, 34.08602]]]} | Open Access 1 | 46289 | Lyman Staging Area | 29581 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3DDMwNDfQLsh0VASikIj4!/ | Los Angeles 6 | 8.522 | Lyman Staging Area | None 1341 | |||
15086 | 15086 | 15085 | {"type": "Polygon", "coordinates": [[[-118.59334, 34.29692], [-118.59288, 34.29636], [-118.59275, 34.29613], [-118.59187, 34.29638], [-118.5913, 34.29686], [-118.59115, 34.29672], [-118.5903, 34.29651], [-118.58963, 34.29617], [-118.59055, 34.2929], [-118.59249, 34.29293], [-118.59294, 34.2935], [-118.593, 34.29362], [-118.59302, 34.29375], [-118.59298, 34.29408], [-118.59299, 34.29418], [-118.5931, 34.29447], [-118.59311, 34.29458], [-118.5931, 34.29469], [-118.59291, 34.29525], [-118.59332, 34.29526], [-118.59334, 34.29692]]]} | Unknown Access 4 | 45869 | Browns Canyon | 28917 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 27.196 | Browns Canyon | None 1309 | |||
15084 | 15084 | 15083 | {"type": "Polygon", "coordinates": [[[-118.25293, 33.92759], [-118.25261, 33.92765], [-118.25157, 33.92387], [-118.2519, 33.92387], [-118.25293, 33.92759]]]} | Open Access 1 | 45866 | Compton Creek Walking Path Phase I | 28915 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.181 | Compton Creek Walking Path Phase I | None 1308 | |||
15081 | 15081 | 15080 | {"type": "MultiPolygon", "coordinates": [[[[-118.18119, 34.01648], [-118.18066, 34.01648], [-118.18065, 34.01554], [-118.18118, 34.01554], [-118.18119, 34.01648]]], [[[-118.1819, 34.01593], [-118.18139, 34.01594], [-118.18139, 34.01566], [-118.1819, 34.01566], [-118.1819, 34.01593]]]]} | Open Access 1 | 45861 | Parque de los Suenos | 28908 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Parque_de_los_Suenos | Los Angeles 6 | 1.61 | Parque de los Suenos | None 1307 | ||
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.819 | Casa Del Caballero | None 1306 | |||
14937 | 14937 | 14936 | {"type": "Polygon", "coordinates": [[[-118.24398, 33.98243], [-118.24382, 33.9825], [-118.24369, 33.98261], [-118.24358, 33.98273], [-118.24352, 33.98286], [-118.24352, 33.98212], [-118.24397, 33.98212], [-118.24398, 33.98243]]]} | Open Access 1 | 45533 | El Parque Nuestro | 28364 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/El_Parque_Nuestro | Los Angeles 6 | 0.536 | El Parque Nuestro | None 1288 | ||
14690 | 14690 | 14689 | {"type": "MultiPolygon", "coordinates": [[[[-118.07693, 33.72934], [-118.0768, 33.72967], [-118.07605, 33.7304], [-118.06997, 33.73039], [-118.071, 33.72955], [-118.07185, 33.72959], [-118.07242, 33.72965], [-118.07248, 33.72963], [-118.07273, 33.72967], [-118.07272, 33.72961], [-118.07273, 33.72957], [-118.07283, 33.72939], [-118.07291, 33.7293], [-118.07302, 33.72921], [-118.07321, 33.72907], [-118.07344, 33.72896], [-118.07363, 33.72888], [-118.07386, 33.72881], [-118.0741, 33.72877], [-118.07429, 33.729], [-118.07423, 33.72927], [-118.07389, 33.72947], [-118.07379, 33.7298], [-118.07483, 33.72994], [-118.07603, 33.72987], [-118.07624, 33.7297], [-118.07617, 33.7294], [-118.07616, 33.72921], [-118.0763, 33.72904], [-118.07693, 33.72934]]], [[[-118.08125, 33.72954], [-118.08108, 33.72965], [-118.08084, 33.72973], [-118.08082, 33.72994], [-118.08091, 33.73], [-118.08074, 33.73008], [-118.08067, 33.7302], [-118.08049, 33.73035], [-118.08026, 33.73039], [-118.07999, 33.73038], [-118.07968, 33.7304], [-118.07691, 33.7304], [-118.07732, 33.73003], [-118.07773, 33.72887], [-118.0786, 33.72857], [-118.07912, 33.72844], [-118.08014, 33.72894], [-118.08047, 33.7293], [-118.08064, 33.72946], [-118.08073, 33.72938], [-118.08114, 33.72944], [-118.08125, 33.72954]]]]} | Open Access 1 | 45012 | Sunset Harbor | 26046 | 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 | Orange 3 | 27.07 | Sunset Harbor | None 1259 | |||
14635 | 14635 | 14634 | {"type": "Polygon", "coordinates": [[[-117.10501, 33.01145], [-117.10485, 33.01158], [-117.10476, 33.01169], [-117.10473, 33.01183], [-117.10471, 33.01203], [-117.10476, 33.01243], [-117.10474, 33.01289], [-117.1046, 33.01309], [-117.1044, 33.01313], [-117.10431, 33.01325], [-117.1041, 33.01314], [-117.10388, 33.01304], [-117.10297, 33.01276], [-117.10268, 33.01265], [-117.10215, 33.01241], [-117.10125, 33.01195], [-117.09931, 33.01118], [-117.09888, 33.011], [-117.09844, 33.0108], [-117.09802, 33.01057], [-117.09748, 33.01024], [-117.09709, 33.00997], [-117.09672, 33.00969], [-117.0966, 33.00959], [-117.09698, 33.00811], [-117.1048, 33.00837], [-117.10477, 33.00869], [-117.10481, 33.00874], [-117.10454, 33.00943], [-117.10481, 33.00975], [-117.10482, 33.01], [-117.10492, 33.01018], [-117.10484, 33.01029], [-117.1048, 33.01076], [-117.1047, 33.01099], [-117.10468, 33.01115], [-117.10469, 33.01122], [-117.10471, 33.01127], [-117.10475, 33.01131], [-117.105, 33.01142], [-117.10501, 33.01145]], [[-117.10204, 33.01004], [-117.10213, 33.01005], [-117.10226, 33.01004], [-117.10237, 33.01001], [-117.10247, 33.00996], [-117.10255, 33.00989], [-117.10262, 33.0098], [-117.10265, 33.0097], [-117.10266, 33.0096], [-117.10261, 33.00944], [-117.10255, 33.00937], [-117.10247, 33.0093], [-117.10235, 33.00924], [-117.10222, 33.00922], [-117.10207, 33.00922], [-117.10198, 33.00925], [-117.10193, 33.00914], [-117.10174, 33.00924], [-117.10161, 33.00939], [-117.10154, 33.00955], [-117.10153, 33.0098], [-117.10156, 33.00992], [-117.10162, 33.01005], [-117.10168, 33.01013], [-117.10183, 33.01027], [-117.10191, 33.01037], [-117.10192, 33.01036], [-117.10204, 33.01004]]]} | Open Access 1 | 44867 | Christopher Hill Holding | 29230 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 69.353 | Christopher Hill Holding | None 1248 | |||
14465 | 14465 | 14464 | {"type": "Polygon", "coordinates": [[[-121.1883, 38.72061], [-121.18821, 38.72077], [-121.18793, 38.72141], [-121.18783, 38.72158], [-121.18709, 38.72158], [-121.18709, 38.72083], [-121.1883, 38.72061]]]} | Open Access 1 | 47083 | Baldwin Reservoir Trailhead | 30737 | 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 | http://www.placer.ca.gov/departments/facility/parks/parks-content/trails/baldwin-reservoir-trail | Placer 35 | 1.941 | Baldwin Reservoir Trailhead | None 1232 | ||
14423 | 14423 | 14422 | {"type": "Polygon", "coordinates": [[[-118.89503, 35.43798], [-118.8932, 35.43744], [-118.8921, 35.43698], [-118.89108, 35.43666], [-118.88971, 35.43648], [-118.88774, 35.43601], [-118.88634, 35.43587], [-118.8853, 35.43568], [-118.88447, 35.43566], [-118.88384, 35.43552], [-118.88345, 35.43532], [-118.88285, 35.43512], [-118.8823, 35.43512], [-118.88181, 35.43521], [-118.88064, 35.43561], [-118.87884, 35.43595], [-118.87878, 35.43599], [-118.87872, 35.436], [-118.87859, 35.4361], [-118.87849, 35.43613], [-118.87832, 35.43627], [-118.87806, 35.4364], [-118.87778, 35.43659], [-118.87743, 35.43674], [-118.87721, 35.43681], [-118.87713, 35.4368], [-118.87708, 35.43682], [-118.87701, 35.43694], [-118.8769, 35.43695], [-118.87683, 35.437], [-118.8768, 35.43705], [-118.87664, 35.43711], [-118.87656, 35.43717], [-118.87648, 35.43722], [-118.87638, 35.43724], [-118.87625, 35.43734], [-118.87623, 35.43739], [-118.87605, 35.43746], [-118.87595, 35.43756], [-118.87576, 35.43766], [-118.87559, 35.43768], [-118.87553, 35.43767], [-118.87541, 35.43771], [-118.87532, 35.43785], [-118.87517, 35.43791], [-118.87508, 35.43799], [-118.87493, 35.43804], [-118.87444, 35.4383], [-118.87429, 35.43835], [-118.87399, 35.43851], [-118.87393, 35.43852], [-118.87375, 35.43861], [-118.87368, 35.43867], [-118.87354, 35.43872], [-118.87335, 35.43885], [-118.87325, 35.43889], [-118.87313, 35.439], [-118.87291, 35.43912], [-118.87277, 35.43913], [-118.87248, 35.43931], [-118.87229, 35.43937], [-118.87152, 35.43985], [-118.87145, 35.43988], [-118.87128, 35.44002], [-118.87106, 35.4401], [-118.87095, 35.44019], [-118.87085, 35.44021], [-118.87072, 35.44029], [-118.87053, 35.44045], [-118.87019, 35.44063], [-118.86968, 35.44099], [-118.86945, 35.44112], [-118.86932, 35.44123], [-118.86906, 35.44134], [-118.86895, 35.44143], [-118.86885, 35.44145], [-118.86875, 35.44151], [-118.8677, 35.44167], [-118.86747, 35.4419], [-118.86394, 35.44271], [-118.86275, 35.44311], [-118.86178, 35.44324], [-118.86038, 35.44326], [-118.8596, 35.44317], [-118.85867, 35.44332], [-118.8579, 35.44322], [-118.85729, 35.4433], [-118.8594, 35.44002], [-118.85983, 35.4394], [-118.86002, 35.43896], [-118.86016, 35.4381], [-118.86048, 35.43724], [-118.86031, 35.43629], [-118.86022, 35.43526], [-118.85964, 35.43288], [-118.86038, 35.43265], [-118.86056, 35.43256], [-118.86067, 35.43249], [-118.8608, 35.43236], [-118.86089, 35.43221], [-118.86095, 35.43204], [-118.86099, 35.43182], [-118.86108, 35.432], [-118.86119, 35.43216], [-118.86133, 35.43231], [-118.8614, 35.43232], [-118.8614, 35.43253], [-118.86408, 35.43304], [-118.86534, 35.43316], [-118.86558, 35.43321], [-118.86576, 35.43326], [-118.86597, 35.43336], [-118.86725, 35.43416], [-118.8674, 35.43424], [-118.86756, 35.43429], [-118.86785, 35.43433], [-118.86986, 35.43433], [-118.87018, 35.43437], [-118.87037, 35.43443], [-118.87054, 35.43452], [-118.87154, 35.4353], [-118.87178, 35.43542], [-118.87199, 35.43542], [-118.87434, 35.43556], [-118.87453, 35.43553], [-118.8747, 35.43547], [-118.87484, 35.43537], [-118.87493, 35.43526], [-118.87499, 35.43512], [-118.87518, 35.43422], [-118.87523, 35.43411], [-118.87532, 35.43399], [-118.87706, 35.43257], [-118.87726, 35.43245], [-118.87745, 35.43238], [-118.87884, 35.43214], [-118.88119, 35.43152], [-118.88136, 35.43149], [-118.88157, 35.43149], [-118.88183, 35.43153], [-118.88199, 35.43159], [-118.88242, 35.43183], [-118.88258, 35.4319], [-118.8828, 35.43195], [-118.88302, 35.43196], [-118.88371, 35.43187], [-118.88569, 35.43167], [-118.88774, 35.43136], [-118.88827, 35.43089], [-118.88977, 35.43097], [-118.8905, 35.43106], [-118.89101, 35.43118], [-118.8915, 35.43133], [-118.89386, 35.43222], [-118.89387, 35.43251], [-118.89375, 35.4332], [-118.89361, 35.4339], [-118.89361, 35.43438], [-118.89384, 35.43522], [-118.8939, 35.43612], [-118.89446, 35.43696], [-118.89497, 35.4379], [-118.89503, 35.43798]]]} | Open Access 1 | 44539 | Lake Ming | 20954 | 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 | http://www.co.kern.ca.us/parks/ming.asp | Kern 36 | 496.587 | Lake Ming | None 1227 | ||
14360 | 14360 | 14359 | {"type": "Polygon", "coordinates": [[[-118.15988, 34.03624], [-118.15906, 34.03626], [-118.15743, 34.03622], [-118.15728, 34.03626], [-118.15722, 34.03383], [-118.15715, 34.03383], [-118.15715, 34.03355], [-118.15977, 34.03352], [-118.15977, 34.03385], [-118.15987, 34.03386], [-118.15988, 34.03624]]]} | Open Access 1 | 44425 | Belvedere Park Lake | 16000 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 17.954 | Belvedere Park Lake | None 1215 | |||
13276 | 13276 | 13275 | {"type": "Polygon", "coordinates": [[[-120.63883, 34.95912], [-120.63659, 34.95879], [-120.63662, 34.9577], [-120.6378, 34.9583], [-120.63834, 34.95875], [-120.63883, 34.95912]]]} | Open Access 1 | 45324 | Rancho Guadalupe Dunes | 24146 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.499 | Rancho Guadalupe Dunes | None 1151 | |||
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 | ||
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 |
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]);