superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
171 rows where MNG_AGENCY = 16 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
606 | 606 | 605 | {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03777, 33.94223]]]} | Open Access 1 | Adventure Park | 15277 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 14.562 | Adventure Park | ||
651 | 651 | 650 | {"type": "Polygon", "coordinates": [[[-118.46707, 34.3301], [-118.46689, 34.33699], [-118.44933, 34.3374], [-118.44942, 34.32994], [-118.46482, 34.33008], [-118.46481, 34.33011], [-118.46429, 34.3302], [-118.46422, 34.33041], [-118.46386, 34.33059], [-118.46412, 34.33168], [-118.46384, 34.33173], [-118.46383, 34.33175], [-118.46393, 34.33219], [-118.46417, 34.33245], [-118.46391, 34.3328], [-118.46431, 34.33309], [-118.46458, 34.33243], [-118.46458, 34.332], [-118.46516, 34.33138], [-118.46517, 34.33076], [-118.46563, 34.33072], [-118.46564, 34.33048], [-118.46525, 34.33044], [-118.46531, 34.33009], [-118.46707, 34.3301]]]} | Open Access 1 | Rim of the Valley County Parkland | 6072 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 311.913 | Rim of the Valley County Parkland | ||
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-118.21741, 34.23745], [-118.21722, 34.24452], [-118.21284, 34.2442], [-118.21294, 34.24101], [-118.21292, 34.241], [-118.20853, 34.24092], [-118.20841, 34.24387], [-118.20398, 34.24355], [-118.20426, 34.23723], [-118.20431, 34.23366], [-118.2065, 34.23369], [-118.2083, 34.23106], [-118.20982, 34.22811], [-118.21083, 34.22869], [-118.21091, 34.22868], [-118.21098, 34.22864], [-118.21133, 34.22834], [-118.21139, 34.22827], [-118.21146, 34.22812], [-118.21187, 34.22837], [-118.21208, 34.22824], [-118.21233, 34.22814], [-118.21242, 34.22809], [-118.21258, 34.22789], [-118.21276, 34.22776], [-118.2129, 34.22771], [-118.21311, 34.22768], [-118.21319, 34.22762], [-118.21328, 34.22765], [-118.21332, 34.22758], [-118.21332, 34.22747], [-118.21328, 34.2274], [-118.21321, 34.22733], [-118.21319, 34.22729], [-118.21321, 34.22707], [-118.21362, 34.22719], [-118.21387, 34.22687], [-118.21432, 34.22655], [-118.21681, 34.22656], [-118.21613, 34.22701], [-118.21663, 34.22744], [-118.21527, 34.22884], [-118.21313, 34.23019], [-118.2131, 34.23379], [-118.21162, 34.23378], [-118.21159, 34.23733], [-118.21741, 34.23745]]]} | Open Access 1 | Winery Canyon Open Space | 6117 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 343.012 | Winery Canyon OS | ||
665 | 665 | 664 | {"type": "Polygon", "coordinates": [[[-118.44648, 33.97594], [-118.44644, 33.97736], [-118.44573, 33.9777], [-118.44549, 33.97734], [-118.44394, 33.97806], [-118.44347, 33.97739], [-118.44648, 33.97594]]]} | Open Access 1 | Burton W. Chace Park | http://www.chacepark.com/index.htm | 16535 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 7.377 | Burton W. Chace Park | |
685 | 685 | 684 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88725], [-118.34029, 33.88725], [-118.34013, 33.88558], [-118.34366, 33.88545], [-118.34366, 33.88725]]]} | Open Access 1 | Alondra Community Regional Park | 15402 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.212 | Alondra Community RP | ||
1224 | 1224 | 1223 | {"type": "Polygon", "coordinates": [[[-117.96354, 34.0398], [-117.96255, 34.04072], [-117.96092, 34.03957], [-117.96193, 34.03862], [-117.96354, 34.0398]]]} | Open Access 1 | Allen J Martin Park | 15378 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 6.796 | Allen J Martin Park | ||
1249 | 1249 | 1248 | {"type": "Polygon", "coordinates": [[[-118.45619, 33.96552], [-118.45317, 33.967], [-118.45309, 33.9669], [-118.45614, 33.96543], [-118.45619, 33.96552]]]} | Open Access 1 | Aubrey E. Austin Jr. Park and North Jetty | https://beaches.lacounty.gov/?s=Aubrey+E.+Austin+Jr.+Park+and+North+Jetty | 15682 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.965 | Aubrey E. Austin Jr. Park and North Jetty | |
1466 | 1466 | 1465 | {"type": "Polygon", "coordinates": [[[-118.70661, 34.02967], [-118.70628, 34.02966], [-118.70561, 34.02975], [-118.70526, 34.02983], [-118.70503, 34.03003], [-118.70481, 34.03012], [-118.70419, 34.03031], [-118.70382, 34.03037], [-118.70373, 34.03036], [-118.70346, 34.03042], [-118.70316, 34.03054], [-118.70299, 34.0305], [-118.70275, 34.03058], [-118.70225, 34.03072], [-118.70199, 34.03075], [-118.70161, 34.03085], [-118.70144, 34.03079], [-118.70127, 34.03077], [-118.70101, 34.0309], [-118.7003, 34.03111], [-118.70019, 34.03118], [-118.69989, 34.03128], [-118.69944, 34.03147], [-118.69944, 34.03155], [-118.69921, 34.0316], [-118.69916, 34.03149], [-118.69885, 34.03153], [-118.69884, 34.03154], [-118.69891, 34.03167], [-118.69846, 34.03179], [-118.69837, 34.03173], [-118.69826, 34.03179], [-118.69825, 34.03188], [-118.69792, 34.03201], [-118.69769, 34.03212], [-118.69763, 34.03207], [-118.69732, 34.03223], [-118.6972, 34.03217], [-118.69697, 34.03227], [-118.69681, 34.03228], [-118.69627, 34.0325], [-118.69582, 34.03263], [-118.69571, 34.03238], [-118.69614, 34.03228], [-118.69686, 34.03216], [-118.69835, 34.0316], [-118.69939, 34.03133], [-118.69992, 34.0311], [-118.70058, 34.03087], [-118.70138, 34.03063], [-118.70161, 34.0306], [-118.70178, 34.03062], [-118.70227, 34.03055], [-118.70288, 34.03032], [-118.70426, 34.03001], [-118.70525, 34.02965], [-118.70589, 34.0295], [-118.70651, 34.02923], [-118.70661, 34.02967]]]} | Open Access 1 | Amarillo Beach | 15438 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.783 | Amarillo Beach | ||
1474 | 1474 | 1473 | {"type": "Polygon", "coordinates": [[[-118.05172, 33.93163], [-118.05126, 33.93164], [-118.05124, 33.93161], [-118.0496, 33.93161], [-118.04959, 33.92815], [-118.05097, 33.92917], [-118.05171, 33.92968], [-118.05172, 33.93163]]]} | Open Access 1 | Amelia Mayberry Park | 15446 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 14.436 | Amelia Mayberry Park | ||
1498 | 1498 | 1497 | {"type": "Polygon", "coordinates": [[[-118.08333, 34.20101], [-118.0833, 34.20282], [-118.0787, 34.20281], [-118.07873, 34.201], [-118.08333, 34.20101]]]} | Open Access 1 | Angeles National Forest | 15491 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 21.075 | Angeles NF | 1908 | |
1553 | 1553 | 1552 | {"type": "MultiPolygon", "coordinates": [[[[-118.0383, 34.1366], [-118.03704, 34.13795], [-118.03692, 34.1379], [-118.03674, 34.1381], [-118.03674, 34.13812], [-118.03683, 34.13817], [-118.03527, 34.13986], [-118.0351, 34.13987], [-118.03504, 34.13992], [-118.0316, 34.13997], [-118.03151, 34.13565], [-118.03198, 34.13576], [-118.03227, 34.13601], [-118.03259, 34.13624], [-118.03292, 34.13634], [-118.03343, 34.13635], [-118.03405, 34.13627], [-118.0349, 34.13614], [-118.03571, 34.13614], [-118.03624, 34.13619], [-118.03681, 34.13613], [-118.03775, 34.13635], [-118.0383, 34.1366]]], [[[-118.04112, 34.13356], [-118.04112, 34.13356], [-118.04099, 34.1337], [-118.04109, 34.13358], [-118.04112, 34.13356]]]]} | Open Access 1 | Arcadia Community Regional Park | 15565 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 50.673 | Arcadia Community RP | ||
1642 | 1642 | 1641 | {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91876], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} | Open Access 1 | Athens Park | 15666 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 18.721 | Athens Park | ||
1649 | 1649 | 1648 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15502, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.951 | Atlantic Avenue Park | ||
1796 | 1796 | 1795 | {"type": "Polygon", "coordinates": [[[-117.98854, 34.05187], [-117.98765, 34.05279], [-117.98644, 34.05198], [-117.98629, 34.05211], [-117.98513, 34.05133], [-117.98614, 34.05027], [-117.98854, 34.05187]]]} | Open Access 1 | Bassett Park | 15856 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.79 | Bassett Park | ||
1945 | 1945 | 1944 | {"type": "Polygon", "coordinates": [[[-118.15988, 34.03624], [-118.15906, 34.03626], [-118.15743, 34.03622], [-118.15728, 34.03626], [-118.15722, 34.03384], [-118.15715, 34.03383], [-118.15715, 34.03355], [-118.15977, 34.03352], [-118.15977, 34.03385], [-118.15987, 34.03386], [-118.15988, 34.03624]]]} | Open Access 1 | Belvedere Park Lake | 16000 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 17.955 | Belvedere Park Lake | ||
2005 | 2005 | 2004 | {"type": "Polygon", "coordinates": [[[-118.62491, 34.03758], [-118.6246, 34.03769], [-118.62402, 34.03776], [-118.62328, 34.0378], [-118.62269, 34.0378], [-118.62242, 34.03779], [-118.62218, 34.0377], [-118.62193, 34.03765], [-118.62107, 34.03764], [-118.62025, 34.03753], [-118.61966, 34.0375], [-118.61937, 34.03744], [-118.61881, 34.03741], [-118.61666, 34.03722], [-118.61634, 34.03716], [-118.61595, 34.03704], [-118.61566, 34.03701], [-118.61535, 34.03694], [-118.61516, 34.03692], [-118.6148, 34.03692], [-118.61451, 34.03695], [-118.61391, 34.03695], [-118.61311, 34.03689], [-118.61289, 34.03691], [-118.61253, 34.03691], [-118.61234, 34.03688], [-118.61197, 34.03679], [-118.6119, 34.03683], [-118.61168, 34.03679], [-118.61022, 34.03651], [-118.60983, 34.03648], [-118.60949, 34.03654], [-118.60912, 34.03666], [-118.60906, 34.03649], [-118.60955, 34.03616], [-118.60993, 34.03612], [-118.61164, 34.03655], [-118.61233, 34.03669], [-118.61421, 34.03668], [-118.61548, 34.03682], [-118.61679, 34.03701], [-118.61735, 34.03698], [-118.61856, 34.03714], [-118.61901, 34.03728], [-118.61992, 34.03734], [-118.62085, 34.03746], [-118.62219, 34.03757], [-118.62289, 34.03761], [-118.62384, 34.0376], [-118.62484, 34.03749], [-118.62491, 34.03758]]]} | Open Access 1 | Big Rock Beach | 16086 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 8.357 | Big Rock Beach | ||
2111 | 2111 | 2110 | {"type": "Polygon", "coordinates": [[[-118.3351, 33.89621], [-118.33509, 33.89639], [-118.33509, 33.89752], [-118.33391, 33.89739], [-118.33392, 33.89724], [-118.33319, 33.89717], [-118.33315, 33.89718], [-118.33305, 33.89734], [-118.33158, 33.89734], [-118.33196, 33.89699], [-118.33221, 33.89672], [-118.33335, 33.89514], [-118.33409, 33.89545], [-118.33411, 33.89592], [-118.33482, 33.89592], [-118.33483, 33.8962], [-118.3351, 33.89621]]]} | Open Access 1 | Bodger Park | 16222 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 11.874 | Bodger Park | ||
2621 | 2621 | 2620 | {"type": "Polygon", "coordinates": [[[-118.67635, 34.03704], [-118.67555, 34.03741], [-118.67476, 34.03766], [-118.67481, 34.0378], [-118.67421, 34.03796], [-118.6731, 34.03833], [-118.67205, 34.03848], [-118.67185, 34.03853], [-118.67144, 34.03857], [-118.67137, 34.03871], [-118.67127, 34.03874], [-118.67122, 34.03872], [-118.67085, 34.03876], [-118.67075, 34.03884], [-118.67039, 34.03885], [-118.67035, 34.03875], [-118.67001, 34.03876], [-118.66988, 34.0388], [-118.66945, 34.03884], [-118.66921, 34.03881], [-118.6684, 34.03883], [-118.6682, 34.03886], [-118.66739, 34.03893], [-118.66734, 34.03909], [-118.66661, 34.03908], [-118.66654, 34.03896], [-118.66626, 34.03895], [-118.66409, 34.03909], [-118.66362, 34.03906], [-118.66324, 34.03906], [-118.66221, 34.03901], [-118.66136, 34.0389], [-118.66047, 34.03885], [-118.65997, 34.03878], [-118.65982, 34.03885], [-118.65873, 34.03879], [-118.65846, 34.03872], [-118.65774, 34.03872], [-118.65759, 34.03868], [-118.65617, 34.03852], [-118.65475, 34.03841], [-118.65425, 34.03831], [-118.65375, 34.03826], [-118.65313, 34.03815], [-118.65102, 34.03789], [-118.65109, 34.03761], [-118.65227, 34.03777], [-118.65334, 34.03795], [-118.65496, 34.03819], [-118.6568, 34.03837], [-118.65812, 34.03841], [-118.66, 34.03853], [-118.66038, 34.03854], [-118.66107, 34.0386], [-118.66209, 34.03864], [-118.66379, 34.03879], [-118.66522, 34.03882], [-118.66588, 34.0388], [-118.66629, 34.03876], [-118.6677, 34.03876], [-118.66784, 34.03874], [-118.66832, 34.03874], [-118.66862, 34.03868], [-118.66976, 34.03857], [-118.67077, 34.03849], [-118.671, 34.03853], [-118.67124, 34.0385], [-118.67166, 34.03846], [-118.67249, 34.03825], [-118.67326, 34.03808], [-118.67344, 34.03795], [-118.6741, 34.03774], [-118.67483, 34.03754], [-118.67571, 34.03725], [-118.67629, 34.03695], [-118.67635, 34.03704]]]} | Open Access 1 | Carbon Beach | http://www.coastal.ca.gov/access/Carbon_Beach_Access.pdf | 16843 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 15.413 | Carbon Beach | |
2626 | 2626 | 2625 | {"type": "MultiPolygon", "coordinates": [[[[-117.70252, 34.62762], [-117.70249, 34.63864], [-117.69592, 34.63871], [-117.69593, 34.63688], [-117.69482, 34.63688], [-117.69483, 34.63504], [-117.69374, 34.63504], [-117.69369, 34.63873], [-117.69146, 34.63875], [-117.69147, 34.63693], [-117.69137, 34.63691], [-117.69036, 34.63692], [-117.69035, 34.63876], [-117.68478, 34.63881], [-117.68481, 34.63143], [-117.68927, 34.63139], [-117.68928, 34.62771], [-117.69374, 34.62767], [-117.69376, 34.624], [-117.69823, 34.62397], [-117.69822, 34.62764], [-117.70252, 34.62762]]], [[[-117.70248, 34.64227], [-117.70247, 34.64598], [-117.69364, 34.64598], [-117.69366, 34.64235], [-117.70248, 34.64227]]]]} | Open Access 1 | Carl O. Gerhardy Wildlife Sanctuary | http://parks.lacounty.gov/wps/portal/dpr/Parks/Carl_O_Gerhardy_Wildlife_Sanctuary | 16854 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 552.415 | Carl O. Gerhardy Wildlife Sanctuary | |
2684 | 2684 | 2683 | {"type": "Polygon", "coordinates": [[[-118.61656, 34.48907], [-118.6132, 34.48908], [-118.61156, 34.48447], [-118.61157, 34.48188], [-118.61216, 34.48188], [-118.61218, 34.48184], [-118.61371, 34.48184], [-118.61372, 34.4819], [-118.61391, 34.48191], [-118.61407, 34.48241], [-118.61404, 34.48242], [-118.61406, 34.48249], [-118.61412, 34.48252], [-118.61473, 34.48408], [-118.6155, 34.48581], [-118.61579, 34.48675], [-118.61601, 34.4873], [-118.61656, 34.48907]]]} | Open Access 1 | Castaic Sports Complex | 16946 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 58.014 | Castaic Sports Complex |
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]);