units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 153
- San Diego, County of 116
- Santa Barbara, County of 114
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 59
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- Sacramento, County of 46
- El Dorado, County of 42
- Riverside, County of 37
- San Luis Obispo, County of 30
- Placer, County of 27
- 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
- Tulare, County of 15
- Merced, 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
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- State Conservation Area 1
- National Recreation Area 1
- None 1
- Local Resource Management 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
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,121
- Restricted Access 60
- Unknown Access 33
- No Public Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3367 | 3367 | 3366 | {"type": "Polygon", "coordinates": [[[-120.03019, 41.82727], [-120.03008, 41.83089], [-120.02524, 41.8308], [-120.02535, 41.82718], [-120.03019, 41.82727]]]} | Open Access 1 | 24348 | County Government Land | 17712 | 341 | Modoc, County of 629 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | Modoc 56 | 39.993 | County Government Land | None 276 | |||
3493 | 3493 | 3492 | {"type": "Polygon", "coordinates": [[[-119.84774, 36.85682], [-119.84773, 36.85954], [-119.84741, 36.8595], [-119.84434, 36.86227], [-119.84328, 36.8623], [-119.84113, 36.86119], [-119.8391, 36.85984], [-119.83905, 36.85717], [-119.84175, 36.85772], [-119.84229, 36.85626], [-119.8449, 36.85685], [-119.84774, 36.85682]]]} | Open Access 1 | 25924 | Scout Island | 25217 | 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 | 88.577 | Scout Island | None 291 | |||
3753 | 3753 | 3752 | {"type": "Polygon", "coordinates": [[[-119.69543, 34.43397], [-119.69509, 34.43541], [-119.69424, 34.43536], [-119.69419, 34.43629], [-119.69257, 34.4363], [-119.69256, 34.43377], [-119.69278, 34.4335], [-119.6928, 34.43343], [-119.69302, 34.43324], [-119.69368, 34.43246], [-119.69391, 34.43263], [-119.69364, 34.43294], [-119.69351, 34.43319], [-119.69331, 34.43328], [-119.69335, 34.43335], [-119.69344, 34.43332], [-119.69346, 34.43333], [-119.69364, 34.43368], [-119.69373, 34.43372], [-119.69382, 34.43371], [-119.69382, 34.43374], [-119.69527, 34.43376], [-119.69515, 34.43396], [-119.69543, 34.43397]]]} | Unknown Access 4 | 467 | Santa Barbara Bowl | 25038 | 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 | 16.55 | Santa Barbara Bowl | None 315 | |||
3863 | 3863 | 3862 | {"type": "Polygon", "coordinates": [[[-121.02867, 38.67828], [-121.02866, 38.67981], [-121.02866, 38.68191], [-121.0275, 38.68192], [-121.02633, 38.68375], [-121.02633, 38.6846], [-121.02169, 38.68456], [-121.01836, 38.67788], [-121.01832, 38.67709], [-121.01842, 38.67699], [-121.01883, 38.67516], [-121.0189, 38.67498], [-121.01899, 38.67485], [-121.01914, 38.67478], [-121.0193, 38.67476], [-121.0195, 38.67479], [-121.01975, 38.67492], [-121.02138, 38.67628], [-121.02188, 38.67638], [-121.02234, 38.67651], [-121.02373, 38.67707], [-121.02408, 38.67719], [-121.02444, 38.67728], [-121.02488, 38.67735], [-121.02524, 38.67738], [-121.02568, 38.67737], [-121.02617, 38.67701], [-121.02624, 38.67689], [-121.02625, 38.67681], [-121.02636, 38.67682], [-121.02635, 38.67829], [-121.02867, 38.67828]]]} | Open Access 1 | 35604 | Bass Lake | 15855 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 152.098 | Bass Lake | None 330 | |||
3874 | 3874 | 3873 | {"type": "Polygon", "coordinates": [[[-121.01029, 38.67025], [-121.00859, 38.67106], [-121.00596, 38.67107], [-121.00591, 38.67096], [-121.00832, 38.67042], [-121.0086, 38.67009], [-121.00799, 38.66978], [-121.00808, 38.66966], [-121.00871, 38.66997], [-121.00918, 38.6694], [-121.01029, 38.67025]]]} | Open Access 1 | 35657 | Cameron Park-Shingle Springs 1 | 16762 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 6.395 | Cameron Park-Shingle Springs 1 | None 331 | |||
3899 | 3899 | 3898 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | 45847 | San Dimas Staging Area | 28895 | 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/San_Dimas_Staging_Area | Los Angeles 6 | 0.247 | San Dimas Staging Area | None 334 | ||
4205 | 4205 | 4204 | {"type": "Polygon", "coordinates": [[[-120.91483, 39.93803], [-120.91232, 39.93808], [-120.91216, 39.93828], [-120.91089, 39.93831], [-120.91086, 39.93744], [-120.91281, 39.93744], [-120.91293, 39.93722], [-120.91326, 39.93721], [-120.91325, 39.93651], [-120.91482, 39.93651], [-120.91483, 39.93803]]]} | Open Access 1 | 48871 | Quincy Skatepark | 33592 | 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 | 10.115 | Quincy Skatepark | None 367 | |||
4291 | 4291 | 4290 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | 14646 | Talbert Marsh | 26170 | 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 | 34.691 | Talbert Marsh | None 375 | |||
4300 | 4300 | 4299 | {"type": "Polygon", "coordinates": [[[-118.65766, 34.07478], [-118.65661, 34.07478], [-118.65657, 34.07158], [-118.65675, 34.0718], [-118.65699, 34.072], [-118.65748, 34.07234], [-118.65765, 34.0724], [-118.65766, 34.07478]]]} | No Public Access 3 | 48151 | Saddle Peak | 32682 | 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 | Los Angeles 6 | 7.314 | Saddle Peak | None 378 | |||
4371 | 4371 | 4370 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.9282], [-118.24572, 33.9282], [-118.24571, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784], [-118.24611, 33.9282]]]]} | Unknown Access 4 | 45850 | 117th and Compton | 28898 | 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 | 2.884 | 117th and Compton | None 387 | |||
4391 | 4391 | 4390 | {"type": "Polygon", "coordinates": [[[-116.36536, 33.23412], [-116.36466, 33.23413], [-116.3643, 33.23433], [-116.36296, 33.23237], [-116.3634, 33.23211], [-116.36371, 33.23196], [-116.36404, 33.23184], [-116.36438, 33.23175], [-116.36473, 33.23167], [-116.36508, 33.23163], [-116.36526, 33.23161], [-116.3653, 33.23163], [-116.36533, 33.23167], [-116.36536, 33.23412]]]} | Open Access 1 | 45996 | Borrego Springs Park Site Dedication | 29191 | 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 | 11.154 | Borrego Springs Park Site Dedication | None 392 | |||
4845 | 4845 | 4844 | {"type": "Polygon", "coordinates": [[[-119.84133, 34.45093], [-119.84062, 34.45098], [-119.84059, 34.45044], [-119.84067, 34.45043], [-119.84073, 34.45041], [-119.84077, 34.45036], [-119.84079, 34.4503], [-119.84075, 34.4497], [-119.84072, 34.44964], [-119.84067, 34.4496], [-119.84055, 34.44958], [-119.84054, 34.44941], [-119.84028, 34.44897], [-119.84057, 34.44897], [-119.84115, 34.44969], [-119.84132, 34.44997], [-119.84133, 34.45093]]]} | Open Access 1 | 1110 | Stonebridge | 25878 | 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 | 2.613 | Stonebridge | None 406 | |||
5030 | 5030 | 5029 | {"type": "Polygon", "coordinates": [[[-120.4125, 41.2052], [-120.40765, 41.20523], [-120.40742, 41.19433], [-120.41231, 41.19432], [-120.41247, 41.20322], [-120.41243, 41.20313], [-120.4122, 41.20285], [-120.41184, 41.20254], [-120.41143, 41.2023], [-120.41105, 41.20211], [-120.40983, 41.20157], [-120.40956, 41.20148], [-120.40941, 41.20141], [-120.40907, 41.20115], [-120.40882, 41.20084], [-120.40849, 41.20038], [-120.40818, 41.2], [-120.40796, 41.19977], [-120.40792, 41.19975], [-120.40785, 41.19975], [-120.40781, 41.19977], [-120.4078, 41.19982], [-120.40833, 41.20045], [-120.40849, 41.20065], [-120.40866, 41.20091], [-120.40893, 41.20123], [-120.40929, 41.20152], [-120.40948, 41.20161], [-120.40974, 41.20169], [-120.41095, 41.20222], [-120.41132, 41.20241], [-120.41171, 41.20264], [-120.41206, 41.20294], [-120.41227, 41.20319], [-120.41248, 41.20372], [-120.4125, 41.2052]]]} | Open Access 1 | 24347 | West Valley Reservation Area | 27378 | 341 | Modoc, County of 629 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | Modoc 56 | 119.952 | West Valley Reservation Area | None 415 | |||
5212 | 5212 | 5211 | {"type": "Polygon", "coordinates": [[[-123.7721, 39.56968], [-123.77167, 39.5697], [-123.77145, 39.56927], [-123.771, 39.56816], [-123.77128, 39.56814], [-123.77136, 39.56839], [-123.77169, 39.56866], [-123.77174, 39.56906], [-123.77185, 39.56918], [-123.7721, 39.56968]]]} | Open Access 1 | 46783 | Coastal View Point | 30237 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | Mendocino 24 | 1.451 | Coastal View Point | None 422 | |||
5339 | 5339 | 5338 | {"type": "Polygon", "coordinates": [[[-121.76487, 36.22671], [-121.76455, 36.22693], [-121.76407, 36.227], [-121.76385, 36.22719], [-121.76369, 36.22707], [-121.76348, 36.22697], [-121.76368, 36.22607], [-121.76441, 36.22592], [-121.76478, 36.22637], [-121.76487, 36.22671]]]} | Unknown Access 4 | 15853 | First Growth | 18915 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 2.843 | First Growth | None 434 | |||
5597 | 5597 | 5596 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | 631 | Santa Ynez River | 25145 | 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 | 1.884 | Santa Ynez River | None 451 | |||
5638 | 5638 | 5637 | {"type": "Polygon", "coordinates": [[[-122.06767, 37.07161], [-122.06612, 37.07145], [-122.06525, 37.07244], [-122.06498, 37.0733], [-122.06239, 37.07328], [-122.06241, 37.06957], [-122.06378, 37.06958], [-122.06746, 37.07014], [-122.06767, 37.07161]]]} | Open Access 1 | 29800 | Quail Hollow Quarry Conservation Areas | 24044 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 34.79 | Quail Hollow Quarry Conservation Areas | None 456 | |||
5986 | 5986 | 5985 | {"type": "Polygon", "coordinates": [[[-120.1236, 34.60253], [-120.12359, 34.60288], [-120.12353, 34.60288], [-120.12353, 34.60258], [-120.12298, 34.60278], [-120.12308, 34.60299], [-120.12289, 34.60309], [-120.12231, 34.60349], [-120.12213, 34.60366], [-120.12199, 34.60387], [-120.12138, 34.60522], [-120.12135, 34.60537], [-120.12135, 34.60551], [-120.12041, 34.60677], [-120.12006, 34.60677], [-120.1204, 34.60648], [-120.12062, 34.60616], [-120.12062, 34.60585], [-120.12072, 34.60567], [-120.12064, 34.60526], [-120.12075, 34.60503], [-120.12119, 34.60489], [-120.12117, 34.60452], [-120.12148, 34.60432], [-120.12159, 34.60385], [-120.1212, 34.60323], [-120.12158, 34.60313], [-120.12283, 34.60232], [-120.12284, 34.60236], [-120.12279, 34.60252], [-120.1228, 34.60253], [-120.1236, 34.60253]]]} | Open Access 1 | 587 | Alamo Pintado Creek (Solvang area) | 15320 | 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 | 6.784 | Alamo Pintado Creek (Solvang area) | None 481 | |||
6006 | 6006 | 6005 | {"type": "Polygon", "coordinates": [[[-117.12554, 33.55661], [-117.12553, 33.5568], [-117.12529, 33.55681], [-117.12524, 33.55678], [-117.12519, 33.55681], [-117.12506, 33.55681], [-117.12505, 33.55686], [-117.125, 33.55686], [-117.125, 33.5569], [-117.12496, 33.55692], [-117.12494, 33.55695], [-117.12496, 33.55699], [-117.125, 33.55701], [-117.125, 33.55709], [-117.12504, 33.55709], [-117.12505, 33.5572], [-117.12522, 33.5572], [-117.12523, 33.55718], [-117.12525, 33.55718], [-117.12526, 33.5572], [-117.12545, 33.5572], [-117.12546, 33.55724], [-117.12553, 33.55724], [-117.12552, 33.55745], [-117.12403, 33.55744], [-117.12404, 33.55702], [-117.12365, 33.55701], [-117.12365, 33.55667], [-117.12363, 33.55663], [-117.12358, 33.55661], [-117.1234, 33.55662], [-117.12335, 33.55664], [-117.12292, 33.55701], [-117.12262, 33.55696], [-117.12249, 33.55684], [-117.12272, 33.55671], [-117.12299, 33.55661], [-117.12313, 33.55657], [-117.12342, 33.55654], [-117.12549, 33.55657], [-117.12554, 33.55661]]]} | Open Access 1 | 48874 | Central Park Community Park Murrieta | 33595 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.887 | Central Park Community Park Murrieta | None 485 | |||
6136 | 6136 | 6135 | {"type": "Polygon", "coordinates": [[[-116.38064, 33.25292], [-116.3793, 33.25356], [-116.37899, 33.25374], [-116.37872, 33.25392], [-116.37866, 33.25393], [-116.3784, 33.25375], [-116.37788, 33.25326], [-116.37753, 33.25281], [-116.37726, 33.25241], [-116.37712, 33.25213], [-116.37694, 33.2517], [-116.37682, 33.25124], [-116.37676, 33.2508], [-116.37759, 33.25077], [-116.37785, 33.25082], [-116.37806, 33.25092], [-116.37822, 33.25101], [-116.3789, 33.25157], [-116.38064, 33.25292]]]} | Open Access 1 | 1161 | Borrego Springs Holding | 29228 | 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 | 15.939 | Borrego Springs Holding | None 494 |
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]);