superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
241 rows where MNG_AG_TYP = 6 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY 7
- Mountains Recreation and Conservation Authority 166
- Conejo Open Space Conservation Agency 38
- Riverside County Habitat Conservation Agency 8
- Western Riverside County Regional Conservation Authority 3
- Solano Tri-City and County Cooperative Planning Group 2
- Rancho Simi Open Space Conservation Agency 2
- San Dieguito River Park Joint Powers Authority 2
ACCESS_TYP 4
- Open Access 166
- Unknown Access 35
- No Public Access 14
- Restricted Access 6
MNG_AG_TYP 1
- Open Space District · 221 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL ▼ | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3345 | 3345 | 3344 | {"type": "Polygon", "coordinates": [[[-118.44985, 34.49555], [-118.44095, 34.49537], [-118.44088, 34.48111], [-118.44536, 34.48112], [-118.44538, 34.48475], [-118.44984, 34.48473], [-118.44985, 34.49555]]]} | Unknown Access 4 | Texas Canyon Open Space | 29702 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 281.452 | Texas Canyon OS | ||
3354 | 3354 | 3353 | {"type": "MultiPolygon", "coordinates": [[[[-118.27963, 34.43891], [-118.27942, 34.44], [-118.27919, 34.43986], [-118.27895, 34.43975], [-118.27854, 34.4396], [-118.27563, 34.4389], [-118.27528, 34.43884], [-118.27503, 34.43882], [-118.27478, 34.43883], [-118.27453, 34.43886], [-118.27415, 34.43895], [-118.2739, 34.43904], [-118.27307, 34.43944], [-118.27278, 34.43957], [-118.27249, 34.43966], [-118.27218, 34.43973], [-118.27214, 34.43775], [-118.27694, 34.43776], [-118.27882, 34.43867], [-118.2793, 34.43883], [-118.27963, 34.43891]]], [[[-118.27986, 34.44135], [-118.27222, 34.44131], [-118.2722, 34.44029], [-118.2726, 34.44021], [-118.27309, 34.44005], [-118.2734, 34.43992], [-118.27412, 34.43956], [-118.27445, 34.43944], [-118.2748, 34.43938], [-118.27503, 34.43937], [-118.27527, 34.43939], [-118.27822, 34.44009], [-118.27858, 34.44021], [-118.27891, 34.44037], [-118.27921, 34.44059], [-118.27947, 34.44086], [-118.27986, 34.44135]]]]} | Open Access 1 | Bird's Nest | 33245 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 51.382 | Bird's Nest | 2018 | |
3422 | 3422 | 3421 | {"type": "Polygon", "coordinates": [[[-118.80384, 34.13634], [-118.80042, 34.13935], [-118.78741, 34.13631], [-118.777, 34.13531], [-118.77703, 34.1303], [-118.77642, 34.13028], [-118.77627, 34.13026], [-118.77606, 34.13018], [-118.77593, 34.1301], [-118.77583, 34.13001], [-118.77548, 34.12953], [-118.77573, 34.1294], [-118.77599, 34.12923], [-118.77622, 34.12905], [-118.77644, 34.12884], [-118.77663, 34.12862], [-118.77679, 34.12839], [-118.77694, 34.12813], [-118.77704, 34.12788], [-118.77712, 34.12763], [-118.77717, 34.12737], [-118.77785, 34.12235], [-118.77798, 34.12189], [-118.77811, 34.1216], [-118.77826, 34.12131], [-118.77855, 34.12091], [-118.77877, 34.12065], [-118.77951, 34.12141], [-118.79034, 34.12722], [-118.79411, 34.13556], [-118.80384, 34.13634]]]} | Unknown Access 4 | Truinfo Canyon Open Space | 29730 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 525.543 | Truinfo Canyon OS | ||
3423 | 3423 | 3422 | {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} | Unknown Access 4 | Holser Canyon Open Space | 29737 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 345.905 | Holser Canyon OS | ||
3504 | 3504 | 3503 | {"type": "Polygon", "coordinates": [[[-118.97218, 34.08094], [-118.96782, 34.08094], [-118.96786, 34.08027], [-118.96938, 34.08025], [-118.96951, 34.08007], [-118.97, 34.08001], [-118.97217, 34.08], [-118.97218, 34.08094]]]} | Open Access 1 | Deer Creek - Denman | 17992 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 9.161 | Deer Creek - Denman | ||
3509 | 3509 | 3508 | {"type": "MultiPolygon", "coordinates": [[[[-118.59473, 34.28578], [-118.59293, 34.28578], [-118.59293, 34.285], [-118.59312, 34.285], [-118.59312, 34.28575], [-118.59472, 34.28575], [-118.59473, 34.28578]]], [[[-118.59361, 34.28526], [-118.59361, 34.28556], [-118.59351, 34.28556], [-118.59352, 34.28526], [-118.59361, 34.28526]]], [[[-118.59668, 34.28578], [-118.59486, 34.28578], [-118.59486, 34.28575], [-118.59668, 34.28575], [-118.59668, 34.28578]]], [[[-118.60597, 34.28577], [-118.60597, 34.28579], [-118.59688, 34.28578], [-118.59688, 34.28575], [-118.60597, 34.28577]]], [[[-118.60374, 34.28244], [-118.60374, 34.28248], [-118.60327, 34.28222], [-118.59971, 34.28221], [-118.59971, 34.28219], [-118.60328, 34.28219], [-118.60374, 34.28244]]], [[[-118.60598, 34.2846], [-118.6054, 34.2846], [-118.60471, 34.2841], [-118.60429, 34.28329], [-118.6043, 34.28325], [-118.60474, 34.28409], [-118.60541, 34.28457], [-118.60598, 34.28457], [-118.60598, 34.2846]]]]} | Open Access 1 | Deer Lake Highlands | 17998 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.803 | Deer Lake Highlands | ||
3623 | 3623 | 3622 | {"type": "MultiPolygon", "coordinates": [[[[-118.52781, 34.12892], [-118.52765, 34.12897], [-118.52752, 34.12899], [-118.52699, 34.12889], [-118.5269, 34.12887], [-118.52682, 34.12882], [-118.52674, 34.12872], [-118.52724, 34.12879], [-118.52781, 34.12892]]], [[[-118.52963, 34.12976], [-118.52948, 34.12986], [-118.5294, 34.12995], [-118.52935, 34.12974], [-118.52925, 34.12956], [-118.52963, 34.12976]]]]} | Open Access 1 | Dirt Mulholland | 18160 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.435 | Dirt Mulholland | ||
3970 | 3970 | 3969 | {"type": "Polygon", "coordinates": [[[-118.50435, 34.35233], [-118.50411, 34.3598], [-118.50187, 34.35977], [-118.50122, 34.35577], [-118.50113, 34.35579], [-118.50065, 34.35976], [-118.49677, 34.35971], [-118.49673, 34.35931], [-118.49638, 34.35751], [-118.49516, 34.35161], [-118.4988, 34.35155], [-118.49896, 34.35224], [-118.50417, 34.35214], [-118.50435, 34.35233]]]} | Open Access 1 | Elsmere Canyon Park | 18606 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 155.062 | Elsmere Canyon Park | ||
3971 | 3971 | 3970 | {"type": "MultiPolygon", "coordinates": [[[[-118.22626, 34.10083], [-118.2251, 34.10204], [-118.2248, 34.10191], [-118.2246, 34.10211], [-118.2248, 34.10235], [-118.22469, 34.10246], [-118.22448, 34.10225], [-118.22414, 34.10259], [-118.22434, 34.10283], [-118.22328, 34.10393], [-118.22546, 34.10544], [-118.22513, 34.10557], [-118.2228, 34.10398], [-118.22289, 34.10389], [-118.22288, 34.10387], [-118.22041, 34.10391], [-118.22088, 34.1022], [-118.22161, 34.10217], [-118.22172, 34.10212], [-118.2218, 34.10203], [-118.22179, 34.10197], [-118.22173, 34.10193], [-118.22175, 34.10164], [-118.22162, 34.10134], [-118.2215, 34.10138], [-118.22152, 34.10147], [-118.22133, 34.10152], [-118.22133, 34.10135], [-118.22132, 34.10134], [-118.22045, 34.1016], [-118.22027, 34.1012], [-118.22067, 34.10102], [-118.2211, 34.10072], [-118.22167, 34.10122], [-118.22188, 34.10015], [-118.2227, 34.10039], [-118.22367, 34.10062], [-118.22387, 34.10034], [-118.22417, 34.10045], [-118.2244, 34.1001], [-118.22503, 34.10036], [-118.22514, 34.10036], [-118.22626, 34.10083]]], [[[-118.2272, 34.10176], [-118.22703, 34.10209], [-118.22661, 34.10185], [-118.22601, 34.10163], [-118.22614, 34.10138], [-118.2272, 34.10176]]], [[[-118.22675, 34.10103], [-118.22654, 34.10144], [-118.22607, 34.10127], [-118.22603, 34.10123], [-118.22605, 34.10118], [-118.22635, 34.10087], [-118.22675, 34.10103]]]]} | Open Access 1 | Elyria Canyon Park | 18607 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 37.644 | Elyria Canyon Park | ||
3972 | 3972 | 3971 | {"type": "MultiPolygon", "coordinates": [[[[-118.24291, 34.10283], [-118.2429, 34.10308], [-118.2429, 34.10308], [-118.24276, 34.10294], [-118.24291, 34.10283]]], [[[-118.24334, 34.103], [-118.24304, 34.10321], [-118.24295, 34.10313], [-118.24296, 34.1028], [-118.24306, 34.10272], [-118.24334, 34.103]]]]} | Open Access 1 | Elysian Valley Gateway Park | 18608 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.321 | Elysian Valley Gateway Park | ||
3974 | 3974 | 3973 | {"type": "Polygon", "coordinates": [[[-118.37324, 34.11776], [-118.3732, 34.11779], [-118.37306, 34.11784], [-118.37297, 34.11789], [-118.37269, 34.11772], [-118.37302, 34.11751], [-118.37319, 34.11773], [-118.37324, 34.11776]]]} | Open Access 1 | Elrita Bowl Adjacent Open Space | 18600 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.261 | Elrita Bowl Adjacent OS | ||
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-118.32897, 34.10547], [-118.32877, 34.10597], [-118.32865, 34.10616], [-118.32806, 34.1056], [-118.32807, 34.10559], [-118.32819, 34.10555], [-118.32853, 34.1055], [-118.32891, 34.10541], [-118.32895, 34.10543], [-118.32897, 34.10547]]]} | Open Access 1 | Franklin Ivar Park | 19059 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.862 | Franklin Ivar Park | ||
4401 | 4401 | 4400 | {"type": "Polygon", "coordinates": [[[-118.87495, 34.0908], [-118.87495, 34.09139], [-118.87424, 34.09139], [-118.87424, 34.0908], [-118.87495, 34.0908]]]} | Open Access 1 | Freeman Donation | 19090 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.05 | Freeman Donation | ||
4432 | 4432 | 4431 | {"type": "Polygon", "coordinates": [[[-118.65026, 34.11082], [-118.65026, 34.11446], [-118.63785, 34.11446], [-118.63676, 34.11386], [-118.63676, 34.11084], [-118.6411, 34.11084], [-118.65026, 34.11082]]]} | Open Access 1 | Fritz & Alma Meier Natural Use Area | 19126 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 123.024 | Fritz & Alma Meier Natural Use Area | ||
5010 | 5010 | 5009 | {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21135, 34.11055], [-118.21099, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21116, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} | Open Access 1 | Heidelberg Park | 19791 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 18.763 | Heidelberg Park | ||
5853 | 5853 | 5852 | {"type": "Polygon", "coordinates": [[[-118.87531, 34.20277], [-118.8746, 34.20316], [-118.87384, 34.2035], [-118.87306, 34.20327], [-118.87173, 34.20299], [-118.87011, 34.20208], [-118.86977, 34.20202], [-118.86977, 34.20128], [-118.87009, 34.20089], [-118.87049, 34.20068], [-118.8705, 34.20045], [-118.87138, 34.20058], [-118.87227, 34.20084], [-118.87308, 34.20101], [-118.87397, 34.20157], [-118.87375, 34.20181], [-118.87375, 34.20183], [-118.87445, 34.2023], [-118.8749, 34.20224], [-118.87531, 34.20277]]]} | Unknown Access 4 | Labisco Hill Open Space | 20815 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 23.902 | Labisco Hill OS | ||
5891 | 5891 | 5890 | {"type": "MultiPolygon", "coordinates": [[[[-118.58536, 34.37309], [-118.58501, 34.37311], [-118.58501, 34.37384], [-118.58474, 34.37372], [-118.58451, 34.37352], [-118.58428, 34.3737], [-118.58413, 34.37367], [-118.58393, 34.37354], [-118.58391, 34.37323], [-118.58371, 34.3731], [-118.58347, 34.37331], [-118.58335, 34.37347], [-118.58331, 34.37362], [-118.58326, 34.37363], [-118.5832, 34.37367], [-118.58317, 34.37372], [-118.58317, 34.37376], [-118.58271, 34.37408], [-118.58263, 34.37427], [-118.58266, 34.37444], [-118.5827, 34.37452], [-118.58287, 34.37454], [-118.58286, 34.37458], [-118.58273, 34.37456], [-118.58215, 34.37455], [-118.58215, 34.37467], [-118.58277, 34.37507], [-118.58274, 34.3754], [-118.58195, 34.37539], [-118.58193, 34.37574], [-118.5814, 34.37587], [-118.58139, 34.37427], [-118.58108, 34.37426], [-118.58101, 34.37074], [-118.58532, 34.37075], [-118.58536, 34.37309]]], [[[-118.59396, 34.37062], [-118.59325, 34.37056], [-118.59308, 34.3706], [-118.59305, 34.37054], [-118.59297, 34.3705], [-118.5929, 34.3705], [-118.59285, 34.37052], [-118.59275, 34.37046], [-118.59255, 34.37043], [-118.59241, 34.37045], [-118.59231, 34.37057], [-118.59228, 34.37085], [-118.59228, 34.37129], [-118.59226, 34.37143], [-118.59063, 34.37142], [-118.58965, 34.37239], [-118.58961, 34.36807], [-118.58962, 34.36713], [-118.59392, 34.36708], [-118.59396, 34.37062]]]]} | Unknown Access 4 | Laing - Brookfield | 20873 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 81.718 | Laing - Brookfield | ||
5945 | 5945 | 5944 | {"type": "Polygon", "coordinates": [[[-118.33232, 34.11518], [-118.33231, 34.11561], [-118.33188, 34.11561], [-118.33189, 34.11558], [-118.33202, 34.11557], [-118.33203, 34.11518], [-118.33232, 34.11518]]]} | Open Access 1 | Lake Hollywood MRCA Open Space | 20946 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.324 | Lake Hollywood MRCA OS | ||
5952 | 5952 | 5951 | {"type": "Polygon", "coordinates": [[[-122.03765, 38.49876], [-122.03721, 38.49835], [-122.03564, 38.49724], [-122.03484, 38.49684], [-122.03469, 38.4967], [-122.03412, 38.4963], [-122.03368, 38.49607], [-122.03339, 38.49582], [-122.03212, 38.49502], [-122.03075, 38.49442], [-122.03003, 38.49422], [-122.02894, 38.49368], [-122.02811, 38.4932], [-122.02771, 38.493], [-122.02722, 38.49292], [-122.02461, 38.49263], [-122.02426, 38.49248], [-122.02391, 38.49215], [-122.02324, 38.49176], [-122.02279, 38.4914], [-122.02207, 38.49109], [-122.02168, 38.49098], [-122.02141, 38.49063], [-122.02107, 38.49048], [-122.02081, 38.49028], [-122.02032, 38.48997], [-122.02062, 38.48927], [-122.02073, 38.48883], [-122.02125, 38.48913], [-122.02143, 38.48916], [-122.02174, 38.48929], [-122.02201, 38.48943], [-122.02279, 38.48968], [-122.02314, 38.48984], [-122.02384, 38.49003], [-122.02431, 38.49022], [-122.02482, 38.49053], [-122.02565, 38.49095], [-122.02623, 38.49028], [-122.02608, 38.48995], [-122.02557, 38.48914], [-122.0262, 38.4891], [-122.02719, 38.48912], [-122.0285, 38.48911], [-122.0294, 38.48918], [-122.03036, 38.48919], [-122.03016, 38.48966], [-122.03006, 38.49023], [-122.02969, 38.49069], [-122.02974, 38.49095], [-122.02965, 38.49127], [-122.03049, 38.49266], [-122.03086, 38.49287], [-122.0312, 38.49324], [-122.03198, 38.49353], [-122.03288, 38.49373], [-122.03315, 38.49382], [-122.03415, 38.49464], [-122.03447, 38.49508], [-122.03474, 38.49528], [-122.0362, 38.49588], [-122.0364, 38.49603], [-122.03667, 38.49668], [-122.03679, 38.49718], [-122.03681, 38.49739], [-122.03708, 38.49793], [-122.03765, 38.49876]]]} | Open Access 1 | Lake Solano County Park | 20965 | 2187 | Solano Tri-City and County Cooperative Planning Group 72 | Special District 4 | Open Space District 6 | Special District 4 | 90.677 | Lake Solano County Park | 2000 | ||
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.54326, 34.04416], [-118.54305, 34.04417], [-118.54302, 34.0442], [-118.54286, 34.04405], [-118.54306, 34.04392], [-118.54313, 34.04389], [-118.54316, 34.04389], [-118.54323, 34.04403], [-118.54326, 34.04416]]]} | Unknown Access 4 | Las Casas - Grenola | 21045 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.186 | Las Casas - Grenola |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);