units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
391 rows where DES_TP = 3 and MNG_AG_LEV = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 58
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- Conejo Recreation and Park District 14
- East Bay Municipal Utility District 13
- Sunrise Recreation and Park District 12
- Littlerock Creek Irrigation District 12
- Rancho Simi Recreation and Park District 11
- Valley-Wide Recreation and Park District 9
- Hayward Area Recreation and Park District 7
- Isla Vista Recreation and Park District 6
- Desert Recreation District 6
- Los Angeles County Flood Control District 6
- Kinneloa Irrigation District 5
- Southgate Recreation and Park District 5
- Monterey Peninsula Regional Park District 4
- Tuolumne Park and Recreation District 4
- Miraleste Recreation and Park District 4
- Pleasant Valley Recreation and Park District 3
- Marin Municipal Water District 3
- Apple Valley Recreation and Park District 3
- Pleasant Hill Recreation and Park District 3
- El Dorado Hills Community Service District 3
- Monterey County Water Resources Agency 3
- Nevada Irrigation District 3
- Durham Recreation and Park District 3
- Santa Barbara Flood Control and Water Conserv. District 2
- Barstow Recreation and Park District 2
- Port of Los Angeles 2
- …
MNG_AG_TYP 13
- Recreation/Parks District 164
- Open Space District 88
- Water District 69
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 292
- No Public Access 69
- Restricted Access 23
- Unknown Access 7
DES_TP 1
- Local Recreation Area · 391 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1274 | 1274 | 1273 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | 7201 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.02 | Compton Creek & Bike Path | 0 | Local Recreation Area 3 | 4 | |
9013 | 9013 | 9012 | {"type": "Polygon", "coordinates": [[[-118.65507, 34.12838], [-118.65499, 34.12848], [-118.65493, 34.12846], [-118.65501, 34.12835], [-118.65507, 34.12838]]]} | No Public Access 3 | 12414 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.022 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.025 | Pleasant Valley Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} | No Public Access 3 | 12421 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.034 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.67423, 34.13343], [-118.67408, 34.13345], [-118.67407, 34.13332], [-118.67422, 34.13331], [-118.67423, 34.13343]]]} | No Public Access 3 | 12423 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.05 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
16801 | 16801 | 16800 | {"type": "Polygon", "coordinates": [[[-119.86959, 34.41246], [-119.86959, 34.4126], [-119.86943, 34.41258], [-119.86943, 34.41245], [-119.86959, 34.41246]]]} | Open Access 1 | 13879 | Isla Vista Recreation and Park District | 20280 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.058 | Isla Vista Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
16805 | 16805 | 16804 | {"type": "Polygon", "coordinates": [[[-118.90091, 34.2165], [-118.90088, 34.21655], [-118.90042, 34.2164], [-118.90045, 34.21635], [-118.90091, 34.2165]]]} | Open Access 1 | 15583 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.068 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
986 | 986 | 985 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | 6696 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.082 | San Gabriel River & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.07801, 38.69279], [-121.07777, 38.69282], [-121.07777, 38.69263], [-121.07784, 38.69262], [-121.07786, 38.69264], [-121.07792, 38.69263], [-121.07799, 38.69273], [-121.07801, 38.69279]]]} | Open Access 1 | 47800 | New York Creek Nature Trail | 30318 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.eldoradohillscsd.org/images/park_detail_popups/new-york-creek/index.html | El Dorado 34 | 0.089 | New York Creek Nature Trail | 0 | Local Recreation Area 3 | 4 |
2066 | 2066 | 2065 | {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} | No Public Access 3 | 12422 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.103 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-118.79539, 34.10451], [-118.79505, 34.10457], [-118.79501, 34.10437], [-118.79516, 34.10434], [-118.79538, 34.10447], [-118.79539, 34.10451]]]} | No Public Access 3 | 12425 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.136 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
8361 | 8361 | 8360 | {"type": "MultiPolygon", "coordinates": [[[[-118.66634, 34.17078], [-118.66625, 34.17093], [-118.66609, 34.17094], [-118.66606, 34.17068], [-118.66634, 34.17078]]], [[[-118.741, 34.15444], [-118.74093, 34.15454], [-118.74084, 34.15445], [-118.74084, 34.15444], [-118.741, 34.15444]]]]} | No Public Access 3 | 12409 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.141 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
11316 | 11316 | 11315 | {"type": "Polygon", "coordinates": [[[-120.23983, 37.96099], [-120.23982, 37.96122], [-120.23954, 37.96122], [-120.23954, 37.96099], [-120.23983, 37.96099]]]} | Open Access 1 | 48052 | Bay Street Tot Lot | 32546 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.163 | Bay Street Tot Lot | 2011 | Local Recreation Area 3 | 4 |
16238 | 16238 | 16237 | {"type": "Polygon", "coordinates": [[[-118.59318, 34.11022], [-118.59279, 34.1103], [-118.59258, 34.11025], [-118.59278, 34.11018], [-118.59292, 34.11008], [-118.59301, 34.11007], [-118.59318, 34.11022]]]} | Open Access 1 | 46147 | Topanga Open Space | 26408 | 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.17 | Topanga OS | 0 | Local Recreation Area 3 | 4 | |
12482 | 12482 | 12481 | {"type": "Polygon", "coordinates": [[[-117.99345, 34.51866], [-117.9926, 34.51867], [-117.9926, 34.51859], [-117.99345, 34.51858], [-117.99345, 34.51866]]]} | No Public Access 3 | 12451 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.173 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
16603 | 16603 | 16602 | {"type": "Polygon", "coordinates": [[[-119.85461, 34.41319], [-119.85461, 34.41344], [-119.85433, 34.41344], [-119.85433, 34.41319], [-119.85461, 34.41319]]]} | Open Access 1 | 13888 | Isla Vista Recreation and Park District | 20280 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.178 | Isla Vista Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
8153 | 8153 | 8152 | {"type": "Polygon", "coordinates": [[[-118.08451, 34.18147], [-118.08446, 34.18154], [-118.08433, 34.18161], [-118.08405, 34.18134], [-118.08424, 34.18129], [-118.08446, 34.18139], [-118.08451, 34.18147]]]} | No Public Access 3 | 12344 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.194 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
9003 | 9003 | 9002 | {"type": "Polygon", "coordinates": [[[-117.98817, 34.54292], [-117.98816, 34.54299], [-117.98697, 34.54299], [-117.98701, 34.54293], [-117.98817, 34.54292]]]} | No Public Access 3 | 12439 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.2 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 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]);