superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
139 rows where ACCESS_TYP = 1 and MNG_AGENCY = 27 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 119 ✖
ACCESS_TYP 1
- Open Access · 119 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2477 | 2477 | 2476 | {"type": "Polygon", "coordinates": [[[-118.35844, 34.12826], [-118.35816, 34.12829], [-118.35778, 34.12819], [-118.35737, 34.1283], [-118.35721, 34.12842], [-118.35729, 34.12852], [-118.3572, 34.12855], [-118.357, 34.12837], [-118.35633, 34.1287], [-118.35623, 34.12854], [-118.35641, 34.12844], [-118.35626, 34.12804], [-118.35678, 34.12806], [-118.35679, 34.12694], [-118.35496, 34.12692], [-118.35452, 34.12712], [-118.35418, 34.12695], [-118.35401, 34.12696], [-118.35403, 34.12666], [-118.35355, 34.12668], [-118.35355, 34.12658], [-118.35332, 34.12659], [-118.35333, 34.12656], [-118.35356, 34.12655], [-118.35358, 34.12643], [-118.3538, 34.12642], [-118.3538, 34.12633], [-118.35384, 34.12627], [-118.35486, 34.12551], [-118.35707, 34.12561], [-118.35844, 34.12826]]]} | Open Access 1 | Cahuenga Pass-Oakshire Open Space | 16658 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 17.014 | Cahuenga Pass-Oakshire OS | ||
2490 | 2490 | 2489 | {"type": "MultiPolygon", "coordinates": [[[[-118.64741, 34.12906], [-118.64387, 34.12905], [-118.64383, 34.12532], [-118.64738, 34.12533], [-118.64741, 34.12906]]], [[[-118.64813, 34.12927], [-118.64791, 34.12927], [-118.64791, 34.12906], [-118.64813, 34.12906], [-118.64813, 34.12927]]]]} | Open Access 1 | Calabasas Highlands Open Space | 16666 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 33.525 | Calabasas Highlands OS | ||
2683 | 2683 | 2682 | {"type": "Polygon", "coordinates": [[[-118.34398, 34.10983], [-118.34396, 34.10986], [-118.34393, 34.10999], [-118.34395, 34.1101], [-118.34376, 34.11029], [-118.34363, 34.10997], [-118.34368, 34.10981], [-118.34398, 34.10983]]]} | Open Access 1 | Castilian MRCA Open Space | 16949 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.278 | Castilian MRCA OS | ||
3181 | 3181 | 3180 | {"type": "Polygon", "coordinates": [[[-118.57098, 34.15161], [-118.5709, 34.1527], [-118.57041, 34.15261], [-118.57021, 34.15331], [-118.56909, 34.15367], [-118.56414, 34.15241], [-118.56436, 34.1514], [-118.56346, 34.15075], [-118.56364, 34.14998], [-118.566, 34.15044], [-118.57098, 34.15161]]]} | Open Access 1 | Corbin Canyon Open Space | 17634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 40.221 | Corbin 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 | ||
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 | ||
6029 | 6029 | 6028 | {"type": "Polygon", "coordinates": [[[-118.77646, 34.04802], [-118.77625, 34.04824], [-118.77619, 34.04837], [-118.77564, 34.04817], [-118.77587, 34.04802], [-118.77593, 34.04779], [-118.77646, 34.04802]]]} | Open Access 1 | Latigo Canyon - Malibu Vista | 21080 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.582 | Latigo Canyon - Malibu Vista | ||
6071 | 6071 | 6070 | {"type": "Polygon", "coordinates": [[[-118.87967, 34.10373], [-118.87858, 34.10373], [-118.87858, 34.10003], [-118.87967, 34.10005], [-118.87967, 34.10373]]]} | Open Access 1 | Lebow | 21127 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 10.164 | Lebow | ||
6072 | 6072 | 6071 | {"type": "MultiPolygon", "coordinates": [[[[-118.86601, 34.03617], [-118.86592, 34.03642], [-118.86581, 34.03643], [-118.86573, 34.03683], [-118.86572, 34.03685], [-118.86569, 34.03684], [-118.86578, 34.03639], [-118.8659, 34.03638], [-118.86597, 34.03617], [-118.86601, 34.03617]]], [[[-118.86946, 34.03654], [-118.86936, 34.03691], [-118.86885, 34.03681], [-118.86829, 34.03667], [-118.86709, 34.03629], [-118.86633, 34.0361], [-118.86629, 34.03604], [-118.86583, 34.03594], [-118.86592, 34.03571], [-118.86878, 34.03637], [-118.86946, 34.03654]]], [[[-118.86709, 34.03642], [-118.86702, 34.03661], [-118.86684, 34.03656], [-118.86691, 34.03636], [-118.86709, 34.03642]]]]} | Open Access 1 | Lechuza Beach | 21128 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 3.288 | Lechuza Beach | ||
6387 | 6387 | 6386 | {"type": "Polygon", "coordinates": [[[-118.22577, 34.08439], [-118.22566, 34.08489], [-118.22559, 34.0853], [-118.22555, 34.08575], [-118.22553, 34.08633], [-118.22551, 34.08637], [-118.22547, 34.08639], [-118.22539, 34.08637], [-118.22356, 34.08469], [-118.22387, 34.08445], [-118.22366, 34.08423], [-118.2238, 34.08412], [-118.22386, 34.08411], [-118.22391, 34.08411], [-118.22435, 34.08452], [-118.22478, 34.08421], [-118.22577, 34.08439]]]} | Open Access 1 | Los Angeles River Center and Gardens | 21500 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 6.713 | Los Angeles River Ctr. and Gardens |
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]);