units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
155 rows where DES_TP = 14 and MNG_AG_TYP = 6 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY
ACCESS_TYP 4
MNG_AGENCY 3
MNG_AG_TYP 1
- Open Space District · 155 ✖
DES_TP 1
- Local Other or Unknown · 155 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4712 | 4712 | 4711 | {"type": "Polygon", "coordinates": [[[-118.3348, 34.47457], [-118.33031, 34.47454], [-118.33057, 34.47368], [-118.33068, 34.47342], [-118.33085, 34.47319], [-118.33177, 34.47219], [-118.33185, 34.47206], [-118.33189, 34.47193], [-118.33191, 34.47178], [-118.33188, 34.47164], [-118.33164, 34.47101], [-118.33169, 34.47099], [-118.33165, 34.47051], [-118.33145, 34.46989], [-118.33163, 34.46853], [-118.33139, 34.46785], [-118.33212, 34.46785], [-118.33211, 34.4674], [-118.33438, 34.46714], [-118.33437, 34.4673], [-118.3348, 34.47457]]]} | Unknown Access 4 | 46211 | Unnamed site - Santa Clarita Watershed Recreation and Conservation Authority | 29506 | 2390 | Santa Clarita Watershed Recreation and Conservation Authority 776 | Special District 4 | Recreation/Parks District 4 | http://smmc.ca.gov/SCWRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 58.139 | 0 | Local Other or Unknown 14 | 4 | ||
12230 | 12230 | 12229 | {"type": "Polygon", "coordinates": [[[-117.25793, 33.63037], [-117.25788, 33.63401], [-117.24921, 33.63405], [-117.24922, 33.63039], [-117.25793, 33.63037]]]} | Unknown Access 4 | 25434 | Rullo Property | 24729 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 80.657 | Rullo Property | 0 | Local Other or Unknown 14 | 4 | |
12231 | 12231 | 12230 | {"type": "MultiPolygon", "coordinates": [[[[-117.01207, 33.89306], [-117.00799, 33.89306], [-117.00392, 33.89308], [-117.0039, 33.88945], [-117.01204, 33.88947], [-117.01207, 33.89306]]], [[[-117.01712, 33.86029], [-117.01212, 33.86432], [-117.01211, 33.86385], [-117.00876, 33.86381], [-117.00888, 33.8632], [-117.00883, 33.86293], [-117.00883, 33.86274], [-117.00884, 33.86255], [-117.00889, 33.86234], [-117.00903, 33.86202], [-117.00962, 33.86102], [-117.00969, 33.8606], [-117.00985, 33.86032], [-117.01712, 33.86029]]], [[[-117.02922, 33.86478], [-117.01849, 33.87513], [-117.01632, 33.87516], [-117.01639, 33.86746], [-117.01212, 33.86747], [-117.01212, 33.86543], [-117.0185, 33.86028], [-117.0225, 33.86027], [-117.02922, 33.86478]]], [[[-117.04925, 33.8737], [-117.03855, 33.87392], [-117.0338, 33.86787], [-117.03376, 33.87467], [-117.02487, 33.87505], [-117.02495, 33.88948], [-117.01632, 33.88948], [-117.01639, 33.88239], [-117.01635, 33.87839], [-117.01978, 33.87511], [-117.02996, 33.86528], [-117.03062, 33.86572], [-117.03126, 33.86602], [-117.0333, 33.8668], [-117.03366, 33.86691], [-117.03409, 33.86698], [-117.03432, 33.86699], [-117.03472, 33.86697], [-117.03495, 33.86694], [-117.03521, 33.86689], [-117.03625, 33.86661], [-117.03763, 33.86615], [-117.03793, 33.86609], [-117.03815, 33.86607], [-117.03847, 33.86609], [-117.03878, 33.86616], [-117.03898, 33.86623], [-117.03927, 33.86639], [-117.04041, 33.86722], [-117.04227, 33.86874], [-117.0427, 33.86904], [-117.04318, 33.8693], [-117.04421, 33.86972], [-117.04453, 33.86988], [-117.04685, 33.87167], [-117.04741, 33.87209], [-117.04768, 33.8723], [-117.04925, 33.8737]]]]} | Restricted Access 2 | 25437 | Wolfskill-Driscoll Properties | 27673 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 1135.825 | Wolfskill-Driscoll Properties | 0 | Local Other or Unknown 14 | 4 | |
15589 | 15589 | 15588 | {"type": "Polygon", "coordinates": [[[-118.00977, 34.00681], [-118.00047, 34.02256], [-117.99322, 34.01961], [-117.99553, 34.01569], [-117.99582, 34.0158], [-117.99633, 34.01493], [-117.99605, 34.0148], [-118.00515, 33.99931], [-118.00592, 33.99969], [-118.00608, 33.99979], [-118.00624, 33.99992], [-118.00635, 34.00003], [-118.00702, 34.00098], [-118.00716, 34.00115], [-118.00742, 34.00135], [-118.00767, 34.00147], [-118.0079, 34.00193], [-118.00888, 34.00585], [-118.00977, 34.00681]]]} | Unknown Access 4 | 6546 | Hacienda Hills Open Space - Sanitation District | 29676 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 419.341 | Hacienda Hills OS - Sanitation District | 0 | Local Other or Unknown 14 | 4 | |
4600 | 4600 | 4599 | {"type": "Polygon", "coordinates": [[[-116.95429, 33.71487], [-116.94563, 33.71491], [-116.94558, 33.71136], [-116.95424, 33.71132], [-116.95429, 33.71487]]]} | No Public Access 3 | 35669 | Unnamed Site - Riverside County Habitat Conservation Agency | 18707 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | Riverside 10 | 78.203 | 0 | Local Other or Unknown 14 | 4 | ||
1046 | 1046 | 1045 | {"type": "Polygon", "coordinates": [[[-118.34139, 34.12342], [-118.34119, 34.12342], [-118.34101, 34.12338], [-118.34082, 34.12338], [-118.34041, 34.12313], [-118.34051, 34.12301], [-118.34068, 34.12311], [-118.34077, 34.12313], [-118.34087, 34.12313], [-118.341, 34.12307], [-118.34139, 34.12342]]]} | Open Access 1 | 6900 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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.464 | 0 | Local Other or Unknown 14 | 4 | ||
1066 | 1066 | 1065 | {"type": "Polygon", "coordinates": [[[-118.16257, 34.20755], [-118.16261, 34.2077], [-118.16261, 34.20779], [-118.16252, 34.20798], [-118.16232, 34.20798], [-118.16232, 34.20756], [-118.16257, 34.20755]]]} | Open Access 1 | 6963 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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.283 | 0 | Local Other or Unknown 14 | 4 | ||
1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | 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 | 201.929 | 0 | Local Other or Unknown 14 | 4 | ||
4474 | 4474 | 4473 | {"type": "Polygon", "coordinates": [[[-118.79355, 34.05992], [-118.79347, 34.06171], [-118.78758, 34.06172], [-118.78748, 34.05991], [-118.79355, 34.05992]], [[-118.78798, 34.06012], [-118.78789, 34.06023], [-118.78799, 34.06049], [-118.78817, 34.06057], [-118.78837, 34.06052], [-118.78844, 34.0604], [-118.78835, 34.06025], [-118.78816, 34.06007], [-118.78798, 34.06012]]]} | Open Access 1 | 2664 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 26.845 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | 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 | 14.94 | 0 | Local Other or Unknown 14 | 4 | ||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | 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 | 1.517 | 0 | Local Other or Unknown 14 | 4 | ||
4495 | 4495 | 4494 | {"type": "Polygon", "coordinates": [[[-118.43891, 34.09306], [-118.43861, 34.0933], [-118.43858, 34.0933], [-118.43856, 34.09326], [-118.43886, 34.09303], [-118.43891, 34.09306]]]} | Open Access 1 | 6391 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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.059 | 0 | Local Other or Unknown 14 | 4 | ||
4498 | 4498 | 4497 | {"type": "Polygon", "coordinates": [[[-118.634, 34.0408], [-118.63396, 34.04093], [-118.63385, 34.04103], [-118.63373, 34.04109], [-118.63327, 34.0412], [-118.63319, 34.04126], [-118.63316, 34.04135], [-118.63256, 34.04136], [-118.63187, 34.04073], [-118.63262, 34.04016], [-118.63324, 34.04077], [-118.63362, 34.04088], [-118.634, 34.0408]]]} | Open Access 1 | 6461 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 3.063 | 0 | Local Other or Unknown 14 | 4 | ||
4501 | 4501 | 4500 | {"type": "Polygon", "coordinates": [[[-118.37435, 34.11711], [-118.37403, 34.11705], [-118.37409, 34.11687], [-118.37412, 34.11683], [-118.37422, 34.1168], [-118.3743, 34.11685], [-118.37432, 34.11689], [-118.37435, 34.11711]]]} | Open Access 1 | 6903 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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.175 | 0 | Local Other or Unknown 14 | 4 | ||
4505 | 4505 | 4504 | {"type": "Polygon", "coordinates": [[[-118.37787, 34.11964], [-118.37787, 34.12193], [-118.37762, 34.12197], [-118.37744, 34.12203], [-118.37736, 34.12203], [-118.37713, 34.12195], [-118.37717, 34.11964], [-118.37787, 34.11964]]]} | Open Access 1 | 6888 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 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 | 4.289 | 0 | Local Other or Unknown 14 | 4 | ||
4506 | 4506 | 4505 | {"type": "MultiPolygon", "coordinates": [[[[-118.37478, 34.11664], [-118.37453, 34.11673], [-118.37446, 34.11661], [-118.37475, 34.1165], [-118.37478, 34.11664]]], [[[-118.37538, 34.11762], [-118.37508, 34.11773], [-118.37474, 34.11711], [-118.37503, 34.117], [-118.37538, 34.11762]]]]} | Open Access 1 | 6889 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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.668 | 0 | Local Other or Unknown 14 | 4 | ||
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | 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.191 | 0 | Local Other or Unknown 14 | 4 | ||
4508 | 4508 | 4507 | {"type": "Polygon", "coordinates": [[[-118.34372, 34.1194], [-118.34372, 34.11929], [-118.34358, 34.11895], [-118.34331, 34.11856], [-118.34283, 34.11838], [-118.34277, 34.11827], [-118.3425, 34.11819], [-118.34244, 34.11812], [-118.34226, 34.1181], [-118.34186, 34.11792], [-118.34163, 34.11776], [-118.34125, 34.11772], [-118.34131, 34.11719], [-118.33774, 34.11599], [-118.33761, 34.11579], [-118.33752, 34.11561], [-118.33746, 34.11542], [-118.33733, 34.11489], [-118.3373, 34.11488], [-118.33714, 34.11426], [-118.33668, 34.11316], [-118.3369, 34.11309], [-118.33688, 34.11302], [-118.33796, 34.11422], [-118.34016, 34.11581], [-118.34219, 34.11649], [-118.34209, 34.11665], [-118.34205, 34.11676], [-118.34206, 34.11695], [-118.34214, 34.11712], [-118.34228, 34.11726], [-118.34283, 34.11765], [-118.34385, 34.11885], [-118.34396, 34.11913], [-118.34397, 34.11923], [-118.34393, 34.1193], [-118.34388, 34.11935], [-118.3438, 34.11939], [-118.34372, 34.1194]]]} | Open Access 1 | 6894 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 20.897 | 0 | Local Other or Unknown 14 | 4 | ||
4509 | 4509 | 4508 | {"type": "Polygon", "coordinates": [[[-118.35605, 34.11531], [-118.35604, 34.11544], [-118.35595, 34.11553], [-118.35563, 34.11566], [-118.35575, 34.11594], [-118.35567, 34.1163], [-118.35515, 34.11646], [-118.35515, 34.11606], [-118.35543, 34.11557], [-118.35583, 34.11544], [-118.35588, 34.11538], [-118.35589, 34.11533], [-118.35605, 34.11531]]]} | Open Access 1 | 6896 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 1.11 | 0 | Local Other or Unknown 14 | 4 | ||
4514 | 4514 | 4513 | {"type": "Polygon", "coordinates": [[[-118.36336, 34.26205], [-118.36208, 34.26532], [-118.36242, 34.26582], [-118.36086, 34.2658], [-118.36086, 34.2641], [-118.36323, 34.26203], [-118.36336, 34.26205]]]} | Unknown Access 4 | 12349 | 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.984 | 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]);