units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,178 rows where LAYER = 3 and MNG_AG_TYP = 3 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- 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
- 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 634
- Local Other or Unknown 214
- Local Recreation Area 108
- Local Conservation Area 95
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,064
- Restricted Access 53
- Unknown Access 36
- No Public Access 25
MNG_AG_TYP 1
- County Agency · 1,178 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 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 | http://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
782 | 782 | 781 | {"type": "Polygon", "coordinates": [[[-122.14918, 37.24376], [-122.14913, 37.24377], [-122.14907, 37.24375], [-122.14904, 37.24355], [-122.14916, 37.24355], [-122.14915, 37.24358], [-122.14919, 37.2437], [-122.14918, 37.24376]]]} | Open Access 1 | 5057 | Castle Rock State Park | 16955 | 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 | http://www.parks.ca.gov/?page_id=538 | Santa Cruz 5 | 0.063 | Castle Rock SP | 1968 | None 72 | |
1088 | 1088 | 1087 | {"type": "Polygon", "coordinates": [[[-118.66774, 34.09258], [-118.6677, 34.09531], [-118.66548, 34.0953], [-118.66549, 34.09463], [-118.66547, 34.09257], [-118.66774, 34.09258]]]} | Open Access 1 | 6487 | Cold Creek Canyon | 29017 | 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 | 15.438 | Cold Creek Canyon | None 99 | |||
1400 | 1400 | 1399 | {"type": "Polygon", "coordinates": [[[-119.87288, 34.43682], [-119.8723, 34.43682], [-119.87211, 34.43667], [-119.872, 34.43654], [-119.87193, 34.43639], [-119.8719, 34.43628], [-119.87195, 34.43605], [-119.87205, 34.43605], [-119.87221, 34.43614], [-119.87248, 34.4365], [-119.87277, 34.43651], [-119.87288, 34.43682]]]} | Open Access 1 | 16492 | Glen Annie at Del Norte | 19314 | 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 | 0.987 | Glen Annie at Del Norte | None 119 | |||
1584 | 1584 | 1583 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | 12140 | French Valley Conservation Area, Expansion 1 | 19108 | 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 | 38.849 | French Valley Conservation Area, Expansion 1 | None 128 | |||
1614 | 1614 | 1613 | {"type": "Polygon", "coordinates": [[[-118.65024, 34.1181], [-118.65024, 34.11939], [-118.6502, 34.12172], [-118.64565, 34.1217], [-118.64568, 34.1181], [-118.65024, 34.1181]]]} | Open Access 1 | 12332 | Secret Valley | 32667 | 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 | 41.753 | Secret Valley | None 129 | |||
2071 | 2071 | 2070 | {"type": "MultiPolygon", "coordinates": [[[[-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.88821, 34.43768], [-119.88786, 34.43766], [-119.88737, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88746, 34.43904], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88961, 34.437], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884]]], [[[-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44124], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44058], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143]]]]} | Open Access 1 | 15735 | Evergreen Acres | 18765 | 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 | 28.758 | Evergreen Acres | None 163 | |||
2408 | 2408 | 2407 | {"type": "Polygon", "coordinates": [[[-121.0023, 37.25798], [-121.00198, 37.25807], [-121.00186, 37.25773], [-121.00217, 37.25766], [-121.0023, 37.25798]]]} | Open Access 1 | 17242 | Library | 21216 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 0.28 | Library | None 201 | |||
2467 | 2467 | 2466 | {"type": "Polygon", "coordinates": [[[-118.22632, 33.89521], [-118.22505, 33.89528], [-118.22499, 33.89426], [-118.22564, 33.89422], [-118.22561, 33.89372], [-118.22622, 33.89369], [-118.22632, 33.89521]]]} | Open Access 1 | 6275 | Martin Luther King Jr. Memorial | 21909 | 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 | 4.068 | Martin Luther King Jr. Memorial | 0 | None 204 | ||
2535 | 2535 | 2534 | {"type": "Polygon", "coordinates": [[[-119.88382, 34.43947], [-119.88316, 34.43948], [-119.88316, 34.43906], [-119.88317, 34.43903], [-119.8832, 34.43902], [-119.88379, 34.43902], [-119.88381, 34.43905], [-119.88382, 34.43947]]]} | Open Access 1 | 17758 | Bella Vista III | 15978 | 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 | 0.76 | Bella Vista III | None 208 | |||
2752 | 2752 | 2751 | {"type": "Polygon", "coordinates": [[[-121.26584, 38.41176], [-121.26406, 38.41179], [-121.26392, 38.41155], [-121.26373, 38.41107], [-121.26365, 38.41082], [-121.2645, 38.41003], [-121.26465, 38.41], [-121.26491, 38.41005], [-121.26516, 38.4102], [-121.26531, 38.41033], [-121.2654, 38.41046], [-121.26549, 38.41072], [-121.26554, 38.41094], [-121.26582, 38.41152], [-121.26584, 38.41165], [-121.26584, 38.41176]]]} | Unknown Access 4 | 21481 | Green Rd Subdivision Map | 19466 | 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.621 | Green Rd Subdivision Map | None 230 | |||
2870 | 2870 | 2869 | {"type": "Polygon", "coordinates": [[[-121.26253, 38.63482], [-121.26223, 38.63496], [-121.26189, 38.63458], [-121.26213, 38.63445], [-121.26232, 38.63458], [-121.26253, 38.63482]]]} | Open Access 1 | 22211 | 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 | 0.387 | County Of Sacramento | None 238 | |||
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-121.35463, 38.5704], [-121.35403, 38.57048], [-121.35403, 38.57049], [-121.35418, 38.57064], [-121.35335, 38.57103], [-121.35193, 38.56789], [-121.3508, 38.56544], [-121.35129, 38.5652], [-121.35141, 38.56534], [-121.35162, 38.56568], [-121.35254, 38.56755], [-121.35262, 38.56769], [-121.35291, 38.56809], [-121.35322, 38.56887], [-121.35369, 38.5699], [-121.35378, 38.57004], [-121.354, 38.57024], [-121.35417, 38.57033], [-121.3544, 38.5704], [-121.35463, 38.5704]]]} | Open Access 1 | 22213 | 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 | 10.921 | County Of Sacramento | None 239 | |||
2876 | 2876 | 2875 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | 22243 | Schnabel Tentative Parcel Map | 25185 | 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.366 | Schnabel Tentative Parcel Map | None 240 | |||
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.42359], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | 22244 | Preston Hanford | 23996 | 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.909 | Preston Hanford | None 241 | |||
2916 | 2916 | 2915 | {"type": "Polygon", "coordinates": [[[-117.6896, 33.88394], [-117.68375, 33.88034], [-117.68317, 33.87542], [-117.68394, 33.87576], [-117.68402, 33.8764], [-117.68761, 33.87755], [-117.68832, 33.87765], [-117.68955, 33.87758], [-117.6896, 33.88394]]]} | Open Access 1 | 19015 | Chino Hills State Park | 17209 | 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.parks.ca.gov/?page_id=648 | Orange 3 | 77.249 | Chino Hills SP | 1981 | None 242 | |
3103 | 3103 | 3102 | {"type": "Polygon", "coordinates": [[[-121.19386, 38.68632], [-121.1938, 38.68658], [-121.19368, 38.68675], [-121.19349, 38.68696], [-121.19364, 38.68726], [-121.19279, 38.68725], [-121.19296, 38.68688], [-121.19322, 38.68659], [-121.19337, 38.68648], [-121.19386, 38.68632]]]} | Open Access 1 | 21437 | Hennemen | 19819 | 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 | 1.241 | Hennemen | None 252 | |||
3104 | 3104 | 3103 | {"type": "Polygon", "coordinates": [[[-121.21365, 38.69062], [-121.21364, 38.69096], [-121.21285, 38.69062], [-121.21281, 38.69064], [-121.21278, 38.69063], [-121.21279, 38.6906], [-121.21277, 38.69058], [-121.21265, 38.69053], [-121.21197, 38.69046], [-121.21179, 38.69018], [-121.21179, 38.68988], [-121.21132, 38.68988], [-121.21132, 38.68978], [-121.21179, 38.68979], [-121.21215, 38.69], [-121.21225, 38.69001], [-121.21238, 38.69011], [-121.21327, 38.69049], [-121.21365, 38.69062]]]} | Open Access 1 | 21439 | Country Rose Estates | 17703 | 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 | 1.779 | Country Rose Estates | None 253 | |||
3105 | 3105 | 3104 | {"type": "Polygon", "coordinates": [[[-121.07628, 38.89266], [-121.07612, 38.89269], [-121.07591, 38.89206], [-121.07581, 38.89192], [-121.07522, 38.89193], [-121.07519, 38.89128], [-121.07542, 38.89125], [-121.07618, 38.89131], [-121.07614, 38.89251], [-121.07628, 38.89266]]]} | Open Access 1 | 21440 | Bernhard House | 16030 | 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 | 1.81 | Bernhard House | None 254 |
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]);