units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 138
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Los Angeles County Flood Control District 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Los Angeles, County of 10
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 660
- County Agency 213
- Open Space District 141
- Water District 78
- Flood District 31
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Community Services District 2
- Sanitation District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 855
- Unknown Access 191
- No Public Access 94
- Restricted Access 30
DES_TP 1
- Local Other or Unknown · 1,170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15503 | 15503 | 15502 | {"type": "Polygon", "coordinates": [[[-118.47407, 34.73484], [-118.47296, 34.73485], [-118.47295, 34.73393], [-118.47405, 34.73392], [-118.47407, 34.73484]]]} | Unknown Access 4 | 46177 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.554 | 0 | Local Other or Unknown 14 | 4 | ||
15502 | 15502 | 15501 | {"type": "Polygon", "coordinates": [[[-118.4125, 34.76981], [-118.41144, 34.76983], [-118.41144, 34.76892], [-118.41249, 34.7689], [-118.4125, 34.76981]]]} | Unknown Access 4 | 46176 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.407 | 0 | Local Other or Unknown 14 | 4 | ||
15501 | 15501 | 15500 | {"type": "Polygon", "coordinates": [[[-118.65299, 34.22381], [-118.65275, 34.22399], [-118.65269, 34.22392], [-118.65241, 34.2235], [-118.65281, 34.2235], [-118.65285, 34.22366], [-118.65299, 34.22381]]]} | Unknown Access 4 | 46175 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.371 | 0 | Local Other or Unknown 14 | 4 | ||
15500 | 15500 | 15499 | {"type": "Polygon", "coordinates": [[[-118.65573, 34.05073], [-118.65459, 34.05115], [-118.65458, 34.05125], [-118.65465, 34.05133], [-118.65432, 34.05117], [-118.65389, 34.05104], [-118.65345, 34.05094], [-118.65334, 34.05084], [-118.65325, 34.0508], [-118.65317, 34.05079], [-118.6531, 34.05081], [-118.65302, 34.05086], [-118.65305, 34.0509], [-118.65295, 34.0509], [-118.65289, 34.05086], [-118.65287, 34.05075], [-118.6529, 34.05069], [-118.65341, 34.05007], [-118.65347, 34.05009], [-118.65388, 34.05008], [-118.65387, 34.04921], [-118.65572, 34.0492], [-118.65573, 34.05073]]]} | Unknown Access 4 | 46174 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.178 | 0 | Local Other or Unknown 14 | 4 | ||
15498 | 15498 | 15497 | {"type": "MultiPolygon", "coordinates": [[[[-117.67592, 34.70488], [-117.67154, 34.70488], [-117.67152, 34.69753], [-117.67591, 34.69753], [-117.67592, 34.70488]]], [[[-117.71928, 34.6964], [-117.71928, 34.69731], [-117.71818, 34.6973], [-117.71819, 34.69639], [-117.71928, 34.6964]]]]} | Unknown Access 4 | 46173 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 83.481 | 0 | Local Other or Unknown 14 | 4 | ||
15497 | 15497 | 15496 | {"type": "Polygon", "coordinates": [[[-118.50642, 34.77443], [-118.50533, 34.77443], [-118.50532, 34.77365], [-118.50642, 34.77365], [-118.50642, 34.77443]]]} | Unknown Access 4 | 46172 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.123 | 0 | Local Other or Unknown 14 | 4 | ||
15496 | 15496 | 15495 | {"type": "Polygon", "coordinates": [[[-118.21315, 34.10672], [-118.21311, 34.10678], [-118.21276, 34.10672], [-118.21276, 34.10658], [-118.21315, 34.10672]]]} | Unknown Access 4 | 46171 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.095 | 0 | Local Other or Unknown 14 | 4 | ||
15495 | 15495 | 15494 | {"type": "Polygon", "coordinates": [[[-118.66761, 34.11812], [-118.66761, 34.11957], [-118.66491, 34.11956], [-118.66492, 34.11868], [-118.6639, 34.11868], [-118.66391, 34.11811], [-118.66761, 34.11812]]]} | Unknown Access 4 | 46169 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 11.277 | 0 | Local Other or Unknown 14 | 4 | ||
15494 | 15494 | 15493 | {"type": "MultiPolygon", "coordinates": [[[[-118.65511, 34.44077], [-118.6551, 34.4409], [-118.6542, 34.44088], [-118.6542, 34.44074], [-118.65511, 34.44077]]], [[[-118.65551, 34.44387], [-118.65551, 34.44387], [-118.6555, 34.44464], [-118.65533, 34.44456], [-118.65534, 34.44378], [-118.65539, 34.44374], [-118.65551, 34.44387]]], [[[-118.65737, 34.44004], [-118.65736, 34.44014], [-118.65709, 34.44012], [-118.65711, 34.43996], [-118.65737, 34.44004]]]]} | Unknown Access 4 | 46168 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.757 | 0 | Local Other or Unknown 14 | 4 | ||
15493 | 15493 | 15492 | {"type": "Polygon", "coordinates": [[[-117.90663, 34.63311], [-117.90661, 34.63403], [-117.90551, 34.63401], [-117.90553, 34.63309], [-117.90663, 34.63311]]]} | Unknown Access 4 | 46162 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.558 | 0 | Local Other or Unknown 14 | 4 | ||
15492 | 15492 | 15491 | {"type": "Polygon", "coordinates": [[[-117.8138, 34.73502], [-117.81378, 34.73671], [-117.81322, 34.73671], [-117.81324, 34.73502], [-117.8138, 34.73502]]]} | Unknown Access 4 | 46161 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.366 | 0 | Local Other or Unknown 14 | 4 | ||
15491 | 15491 | 15490 | {"type": "Polygon", "coordinates": [[[-117.82325, 34.4706], [-117.82215, 34.47059], [-117.82215, 34.46969], [-117.82325, 34.4697], [-117.82325, 34.4706]]]} | Unknown Access 4 | 46159 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.509 | 0 | Local Other or Unknown 14 | 4 | ||
15490 | 15490 | 15489 | {"type": "Polygon", "coordinates": [[[-118.17873, 34.49175], [-118.17696, 34.49222], [-118.17422, 34.49274], [-118.17245, 34.4927], [-118.17104, 34.4923], [-118.17014, 34.49187], [-118.17873, 34.49175]]]} | Unknown Access 4 | 46156 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 12.546 | 0 | Local Other or Unknown 14 | 4 | ||
15489 | 15489 | 15488 | {"type": "Polygon", "coordinates": [[[-118.32033, 34.23499], [-118.32019, 34.2351], [-118.32013, 34.23505], [-118.32027, 34.23494], [-118.32033, 34.23499]]]} | Unknown Access 4 | 46153 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.034 | 0 | Local Other or Unknown 14 | 4 | ||
15488 | 15488 | 15487 | {"type": "MultiPolygon", "coordinates": [[[[-118.29404, 34.28609], [-118.29404, 34.28614], [-118.29343, 34.287], [-118.29327, 34.28712], [-118.29133, 34.28712], [-118.29144, 34.28648], [-118.29153, 34.28628], [-118.29168, 34.28609], [-118.29404, 34.28609]]], [[[-118.29514, 34.28609], [-118.29514, 34.28712], [-118.29333, 34.28712], [-118.29346, 34.28702], [-118.29408, 34.28615], [-118.29408, 34.28609], [-118.29514, 34.28609]]]]} | Unknown Access 4 | 44398 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.506 | 0 | Local Other or Unknown 14 | 4 | ||
15486 | 15486 | 15485 | {"type": "Polygon", "coordinates": [[[-118.57212, 34.76235], [-118.56882, 34.76236], [-118.56881, 34.76115], [-118.57212, 34.76113], [-118.57212, 34.76235]]]} | Unknown Access 4 | 44396 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.068 | 0 | Local Other or Unknown 14 | 4 | ||
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 4 | ||
15483 | 15483 | 15482 | {"type": "Polygon", "coordinates": [[[-121.7569, 36.77289], [-121.75622, 36.77347], [-121.75458, 36.77228], [-121.75464, 36.77222], [-121.75547, 36.77222], [-121.75581, 36.77227], [-121.75598, 36.77233], [-121.75612, 36.77239], [-121.7569, 36.77289]]]} | Open Access 1 | 43083 | Unnamed site - North County Recreation and Park District | 28720 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.303 | 0 | Local Other or Unknown 14 | 4 | ||
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
15480 | 15480 | 15479 | {"type": "Polygon", "coordinates": [[[-120.41207, 34.8736], [-120.41185, 34.87358], [-120.41131, 34.87341], [-120.41098, 34.87337], [-120.41098, 34.87234], [-120.41206, 34.87233], [-120.41207, 34.8736]]]} | No Public Access 3 | 43077 | Unnamed site - Santa Barbara Flood Control and Water Conserv. District | 28664 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 3.135 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);