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
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 | ||
3071 | 3071 | 3070 | {"type": "Polygon", "coordinates": [[[-118.65872, 34.1181], [-118.65875, 34.11954], [-118.65875, 34.12258], [-118.65825, 34.12362], [-118.65788, 34.12454], [-118.65762, 34.12537], [-118.65719, 34.12711], [-118.65578, 34.12716], [-118.65575, 34.12658], [-118.6557, 34.12636], [-118.65558, 34.12611], [-118.65547, 34.12595], [-118.65536, 34.12584], [-118.65651, 34.12484], [-118.65513, 34.1243], [-118.65576, 34.12316], [-118.65511, 34.12151], [-118.65413, 34.12123], [-118.65451, 34.12027], [-118.6545, 34.12025], [-118.65205, 34.12026], [-118.65206, 34.12208], [-118.65154, 34.12208], [-118.65153, 34.1222], [-118.65159, 34.12225], [-118.65173, 34.12241], [-118.6518, 34.12246], [-118.65205, 34.12249], [-118.65206, 34.12236], [-118.65273, 34.12262], [-118.65218, 34.12362], [-118.65248, 34.12468], [-118.65252, 34.12476], [-118.65226, 34.1249], [-118.65214, 34.125], [-118.65203, 34.12512], [-118.65194, 34.12508], [-118.65088, 34.12498], [-118.65014, 34.12534], [-118.65024, 34.11939], [-118.65025, 34.1181], [-118.65872, 34.1181]]]} | Open Access 1 | Cold Creek - Secret Valley | 17480 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 118.962 | Cold Creek - Secret Valley | 2011 | |
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 | ||
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 | |
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 |
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]);