units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
204 rows where ACCESS_TYP = 4 and DES_TP = 14 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY 19
- Mountains Recreation and Conservation Authority 105
- Yuba County Water Agency 48
- Santa Barbara, City of 9
- Santa Barbara, County of 8
- Santa Barbara Flood Control and Water Conserv. District 4
- Los Angeles, City of 2
- Carpinteria, City of 2
- Ramona Municipal Water District 2
- San Diego, County of 1
- Clovis, City of 1
- Guadalupe, City of 1
- Sacramento, County of 1
- Rio Dell, City of 1
- Sacramento and San Joaquin Drainage District 1
- Orange County Water District 1
- Helix Water District 1
- Santa Ynez River Water Conservation District 1
- Western Riverside County Regional Conservation Authority 1
- North County Transit District 1
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 191 ✖
ACCESS_TYP 1
- Unknown Access · 191 ✖
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 | ||
14808 | 14808 | 14807 | {"type": "Polygon", "coordinates": [[[-117.00394, 33.01294], [-117.00388, 33.01486], [-117.00029, 33.01496], [-117.00055, 33.01283], [-117.00251, 33.0123], [-117.00285, 33.01294], [-117.00394, 33.01294]]]} | Unknown Access 4 | 45224 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 19.711 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14807 | 14807 | 14806 | {"type": "Polygon", "coordinates": [[[-116.93609, 33.0511], [-116.92755, 33.05108], [-116.92754, 33.04241], [-116.93205, 33.04305], [-116.93259, 33.04035], [-116.92753, 33.03962], [-116.92753, 33.03643], [-116.93601, 33.03655], [-116.93601, 33.04036], [-116.93609, 33.0511]]]} | Unknown Access 4 | 45223 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 283.724 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14774 | 14774 | 14773 | {"type": "MultiPolygon", "coordinates": [[[[-117.3104, 33.20185], [-117.31053, 33.20215], [-117.31063, 33.20246], [-117.31076, 33.20299], [-117.31074, 33.20304], [-117.31069, 33.20307], [-117.31012, 33.2032], [-117.30901, 33.2034], [-117.308, 33.20353], [-117.30733, 33.20359], [-117.30597, 33.20366], [-117.30496, 33.20366], [-117.30145, 33.20359], [-117.30076, 33.20359], [-117.30007, 33.20361], [-117.29904, 33.20369], [-117.29686, 33.20395], [-117.29686, 33.20297], [-117.30621, 33.20241], [-117.30709, 33.20231], [-117.30775, 33.20222], [-117.31037, 33.2018], [-117.3104, 33.20185]]], [[[-117.31023, 33.20153], [-117.3077, 33.20193], [-117.30618, 33.20213], [-117.29686, 33.2027], [-117.29686, 33.20126], [-117.3063, 33.20135], [-117.31012, 33.20136], [-117.31023, 33.20153]]]]} | Unknown Access 4 | 45152 | North County Transit District Mitigation | 22817 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 69.998 | North County Transit District Mitigation | 0 | Local Other or Unknown 14 | 4 | |
14716 | 14716 | 14715 | {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} | Unknown Access 4 | 47814 | Unnamed site - San Diego, County of | 31715 | 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 | 87.174 | 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]);