superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where MNG_AGENCY = 422
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5160 | 5160 | 5159 | {"type": "Polygon", "coordinates": [[[-118.8858, 34.18809], [-118.88533, 34.18833], [-118.88386, 34.18707], [-118.88346, 34.18644], [-118.88482, 34.18601], [-118.88498, 34.18649], [-118.88498, 34.18732], [-118.88558, 34.18743], [-118.8858, 34.18809]]]} | Open Access 1 | Hillcrest Center | 19963 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 5.775 | Hillcrest Ctr. | ||
5822 | 5822 | 5821 | {"type": "Polygon", "coordinates": [[[-118.8615, 34.18768], [-118.85967, 34.18766], [-118.85966, 34.1829], [-118.86011, 34.18335], [-118.86033, 34.18412], [-118.86058, 34.18455], [-118.86139, 34.18635], [-118.86149, 34.18669], [-118.8615, 34.18768]]]} | Open Access 1 | La Jolla Open Space | 20767 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 14.257 | La Jolla OS | ||
6420 | 6420 | 6419 | {"type": "Polygon", "coordinates": [[[-118.87403, 34.17605], [-118.87392, 34.17677], [-118.87344, 34.17654], [-118.87161, 34.17616], [-118.87068, 34.17654], [-118.87028, 34.17645], [-118.87013, 34.1765], [-118.86918, 34.17644], [-118.86883, 34.17629], [-118.86837, 34.17631], [-118.86838, 34.17602], [-118.86857, 34.17599], [-118.86873, 34.17593], [-118.86897, 34.17582], [-118.86905, 34.17587], [-118.86906, 34.17595], [-118.86927, 34.17615], [-118.86988, 34.1762], [-118.87018, 34.17599], [-118.87021, 34.17577], [-118.87051, 34.17569], [-118.87057, 34.17566], [-118.87115, 34.17569], [-118.87121, 34.17566], [-118.87147, 34.1758], [-118.87185, 34.17594], [-118.87206, 34.17594], [-118.87226, 34.1756], [-118.87271, 34.17521], [-118.87341, 34.17581], [-118.87361, 34.17594], [-118.87383, 34.17602], [-118.87403, 34.17605]]]} | Open Access 1 | Los Padres Open Space | 21524 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 8.437 | Los Padres OS | ||
7463 | 7463 | 7462 | {"type": "Polygon", "coordinates": [[[-118.83534, 34.17548], [-118.83489, 34.17589], [-118.83416, 34.17534], [-118.83469, 34.17485], [-118.8349, 34.17502], [-118.83506, 34.17527], [-118.83534, 34.17548]]]} | Open Access 1 | North Ranch - Hillcrest Subarea | 22850 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 1.497 | North Ranch - Hillcrest Subarea | ||
8332 | 8332 | 8331 | {"type": "Polygon", "coordinates": [[[-118.93041, 34.17667], [-118.9304, 34.17835], [-118.93034, 34.17835], [-118.93034, 34.17803], [-118.93028, 34.17795], [-118.92996, 34.17791], [-118.92931, 34.17774], [-118.92932, 34.17667], [-118.93041, 34.17667]]]} | Open Access 1 | Potrero / Kelley Estates | 23920 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 3.38 | Potrero / Kelley Estates | ||
9816 | 9816 | 9815 | {"type": "MultiPolygon", "coordinates": [[[[-118.84516, 34.15749], [-118.8448, 34.15774], [-118.84459, 34.15835], [-118.84432, 34.15872], [-118.84346, 34.1589], [-118.84402, 34.16065], [-118.8439, 34.16087], [-118.8443, 34.16153], [-118.84349, 34.16187], [-118.84302, 34.16135], [-118.84302, 34.16089], [-118.84251, 34.15997], [-118.84234, 34.15985], [-118.84256, 34.15948], [-118.84234, 34.15932], [-118.8419, 34.15926], [-118.8416, 34.15894], [-118.84129, 34.15766], [-118.8415, 34.15757], [-118.84225, 34.15754], [-118.84252, 34.15795], [-118.8429, 34.15811], [-118.84334, 34.15803], [-118.84337, 34.15731], [-118.84407, 34.15694], [-118.845, 34.15705], [-118.84516, 34.15749]]], [[[-118.84639, 34.15954], [-118.84574, 34.16004], [-118.84511, 34.15952], [-118.84582, 34.15904], [-118.84639, 34.15954]]]]} | Open Access 1 | South Ranch Open Space | 25677 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 22.053 | South Ranch OS | ||
14594 | 14594 | 14593 | {"type": "Polygon", "coordinates": [[[-118.89023, 34.17543], [-118.89021, 34.18222], [-118.88817, 34.18143], [-118.88703, 34.18092], [-118.88471, 34.17986], [-118.8844, 34.17939], [-118.88268, 34.17879], [-118.8825, 34.17862], [-118.88238, 34.17869], [-118.8816, 34.17829], [-118.88157, 34.17813], [-118.88126, 34.17808], [-118.88038, 34.17773], [-118.87977, 34.17745], [-118.87847, 34.17704], [-118.87675, 34.17682], [-118.87676, 34.17658], [-118.87673, 34.17637], [-118.87703, 34.17631], [-118.87701, 34.17572], [-118.87692, 34.17536], [-118.87675, 34.17542], [-118.87658, 34.17514], [-118.87673, 34.17502], [-118.87687, 34.17483], [-118.87786, 34.17436], [-118.87799, 34.17416], [-118.87904, 34.17435], [-118.87895, 34.1747], [-118.87925, 34.17512], [-118.87941, 34.17505], [-118.87975, 34.17451], [-118.87988, 34.17452], [-118.88005, 34.17492], [-118.88088, 34.17558], [-118.88133, 34.17577], [-118.88152, 34.17573], [-118.88167, 34.17543], [-118.8824, 34.17574], [-118.88315, 34.17579], [-118.88356, 34.17598], [-118.88386, 34.17538], [-118.8843, 34.17557], [-118.88469, 34.17564], [-118.88578, 34.17518], [-118.88678, 34.17586], [-118.88726, 34.17551], [-118.8873, 34.17551], [-118.88737, 34.17548], [-118.88751, 34.17592], [-118.88825, 34.17587], [-118.88872, 34.17538], [-118.89023, 34.17543]]]} | Restricted Access 2 | Los Robles Golf Course | 33058 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 133.331 | Los Robles GC | ||
14860 | 14860 | 14859 | {"type": "MultiPolygon", "coordinates": [[[[-118.97303, 34.15625], [-118.97291, 34.15671], [-118.97289, 34.15694], [-118.97292, 34.157], [-118.972, 34.15735], [-118.97192, 34.15721], [-118.97006, 34.1571], [-118.96926, 34.15657], [-118.96828, 34.15657], [-118.96797, 34.15683], [-118.96788, 34.15697], [-118.96769, 34.15697], [-118.96751, 34.15719], [-118.96743, 34.15719], [-118.96763, 34.15623], [-118.97303, 34.15625]]], [[[-118.97535, 34.15619], [-118.97489, 34.15628], [-118.97456, 34.15638], [-118.97349, 34.15678], [-118.97343, 34.15649], [-118.97349, 34.15625], [-118.97421, 34.15625], [-118.97447, 34.1562], [-118.9748, 34.15617], [-118.97483, 34.15619], [-118.97535, 34.15619]]], [[[-118.98149, 34.16334], [-118.98089, 34.16357], [-118.98061, 34.1631], [-118.97936, 34.16348], [-118.97675, 34.16338], [-118.97699, 34.1622], [-118.97872, 34.16249], [-118.97978, 34.16186], [-118.98042, 34.16152], [-118.98117, 34.1613], [-118.98146, 34.16168], [-118.98123, 34.16169], [-118.98065, 34.16183], [-118.98035, 34.16208], [-118.98028, 34.16248], [-118.98083, 34.16281], [-118.98101, 34.16312], [-118.9811, 34.16304], [-118.98115, 34.16293], [-118.98116, 34.16281], [-118.98113, 34.16269], [-118.98149, 34.16334]]]]} | Open Access 1 | Dos Vientos Open Space | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Dos Vientos | 18233 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 24.161 | Dos Vientos OS | |
14915 | 14915 | 14914 | {"type": "Polygon", "coordinates": [[[-118.84857, 34.20049], [-118.8485, 34.2011], [-118.84724, 34.20143], [-118.84722, 34.20036], [-118.84745, 34.20039], [-118.84749, 34.2003], [-118.84744, 34.20008], [-118.84745, 34.20006], [-118.84728, 34.19975], [-118.84685, 34.19955], [-118.84673, 34.19941], [-118.84671, 34.19942], [-118.84671, 34.19949], [-118.84669, 34.19957], [-118.84649, 34.19985], [-118.8465, 34.19988], [-118.84456, 34.19942], [-118.84455, 34.19882], [-118.8436, 34.19818], [-118.84363, 34.19792], [-118.84389, 34.19712], [-118.84428, 34.19721], [-118.84449, 34.19734], [-118.84431, 34.19742], [-118.84417, 34.19812], [-118.84418, 34.19813], [-118.8453, 34.19789], [-118.84574, 34.19717], [-118.84592, 34.19738], [-118.84637, 34.19746], [-118.84643, 34.19718], [-118.84712, 34.19703], [-118.84728, 34.19721], [-118.84719, 34.19728], [-118.84716, 34.19737], [-118.84723, 34.19768], [-118.84738, 34.19799], [-118.84749, 34.19811], [-118.84718, 34.19839], [-118.84763, 34.19877], [-118.84803, 34.19925], [-118.84812, 34.19961], [-118.84823, 34.19991], [-118.84857, 34.20049]]]} | Open Access 1 | Old Meadows Open Space | 23090 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 23.374 | Old Meadows OS | ||
14936 | 14936 | 14935 | {"type": "MultiPolygon", "coordinates": [[[[-118.84248, 34.16526], [-118.84226, 34.16553], [-118.8418, 34.16546], [-118.84189, 34.1651], [-118.84211, 34.16517], [-118.84245, 34.16519], [-118.84247, 34.16522], [-118.84248, 34.16526]]], [[[-118.84252, 34.16433], [-118.84248, 34.16449], [-118.84189, 34.16446], [-118.84198, 34.16432], [-118.84252, 34.16433]]], [[[-118.8429, 34.16513], [-118.84278, 34.16536], [-118.84257, 34.16529], [-118.84258, 34.16524], [-118.84253, 34.16515], [-118.84239, 34.1651], [-118.84262, 34.16475], [-118.84282, 34.16499], [-118.8429, 34.16513]]], [[[-118.84478, 34.16503], [-118.84469, 34.16506], [-118.8446, 34.16518], [-118.84449, 34.16527], [-118.84439, 34.16531], [-118.8442, 34.16531], [-118.84414, 34.16532], [-118.84406, 34.16536], [-118.84398, 34.16546], [-118.84391, 34.16551], [-118.84371, 34.16556], [-118.84365, 34.16561], [-118.84364, 34.1657], [-118.84372, 34.16576], [-118.84392, 34.16588], [-118.84338, 34.16622], [-118.84343, 34.16627], [-118.84421, 34.16604], [-118.84427, 34.16611], [-118.84431, 34.16618], [-118.84432, 34.16627], [-118.84431, 34.16632], [-118.84348, 34.16631], [-118.84347, 34.16633], [-118.84349, 34.16635], [-118.84337, 34.16648], [-118.84301, 34.16648], [-118.84278, 34.16594], [-118.84287, 34.16589], [-118.84297, 34.1658], [-118.84307, 34.16565], [-118.84311, 34.16552], [-118.84313, 34.16539], [-118.8432, 34.16524], [-118.84348, 34.16536], [-118.84385, 34.16515], [-118.84432, 34.16501], [-118.8447, 34.16469], [-118.84478, 34.16472], [-118.84478, 34.16503]]], [[[-118.847, 34.16459], [-118.84646, 34.1651], [-118.84638, 34.16517], [-118.84627, 34.16522], [-118.84623, 34.16519], [-118.8462, 34.16512], [-118.84618, 34.16488], [-118.84619, 34.16472], [-118.84617, 34.16454], [-118.84616, 34.1645], [-118.8461, 34.16445], [-118.846, 34.16444], [-118.84593, 34.16446], [-118.84576, 34.16457], [-118.84562, 34.16469], [-118.84552, 34.16485], [-118.84548, 34.165], [-118.84537, 34.1652], [-118.84518, 34.16513], [-118.84496, 34.16522], [-118.84489, 34.16509], [-118.84517, 34.16488], [-118.84546, 34.16445], [-118.84596, 34.16411], [-118.84623, 34.16424], [-118.84638, 34.16403], [-118.84667, 34.16416], [-118.84662, 34.16433], [-118.847, 34.16459]]], [[[-118.8485, 34.16653], [-118.84822, 34.1667], [-118.84793, 34.16695], [-118.84786, 34.16711], [-118.84776, 34.16722], [-118.84754, 34.16734], [-118.84734, 34.16743], [-118.84718, 34.16746], [-118.84666, 34.16746], [-118.84632, 34.16742], [-118.84615, 34.16744], [-118.84576, 34.16753], [-118.84538, 34.16668], [-118.84562, 34.16663], [-118.84578, 34.16705], [-118.84624, 34.16698], [-118.84611, 34.16658], [-118.84623, 34.16658], [-118.84636, 34.16656], [-118.8465, 34.16695], [-118.84696, 34.16688], [-118.8468, 34.16637], [-118.84693, 34.16629], [-118.8473, 34.16677], [-118.84748, 34.16659], [-118.84702, 34.16623], [-118.84715, 34.16611], [-118.84764, 34.16648], [-118.84776, 34.16634], [-118.84731, 34.16598], [-118.84761, 34.16573], [-118.84801, 34.16614], [-118.8481, 34.16611], [-118.8485, 34.16653]]], [[[-118.84852, 34.16592], [-118.84816, 34.16608], [-118.84778, 34.16563], [-118.84811, 34.16545], [-118.84852, 34.16592]]], [[[-118.85001, 34.16574], [-118.84998, 34.1658], [-118.84976, 34.16597], [-118.84938, 34.16617], [-118.84924, 34.16628], [-118.84883, 34.16581], [-118.84886, 34.16579], [-118.84888, 34.16532], [-118.84934, 34.16531], [-118.84971, 34.16533], [-118.84992, 34.16529], [-118.84996, 34.16532], [-118.84996, 34.16553], [-118.85001, 34.16567], [-118.85001, 34.16574]]]]} | Open Access 1 | Skyline Open Space | 25540 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 15.297 | Skyline OS | ||
15006 | 15006 | 15005 | {"type": "Polygon", "coordinates": [[[-118.9419, 34.21156], [-118.94126, 34.21217], [-118.9399, 34.21229], [-118.93949, 34.21228], [-118.93944, 34.21233], [-118.93877, 34.21239], [-118.93816, 34.21187], [-118.93715, 34.21253], [-118.93554, 34.21268], [-118.93489, 34.21376], [-118.93502, 34.21405], [-118.93165, 34.22497], [-118.92665, 34.22498], [-118.92455, 34.21957], [-118.92331, 34.21766], [-118.92379, 34.21444], [-118.92347, 34.21178], [-118.92586, 34.21123], [-118.92782, 34.21143], [-118.92758, 34.21004], [-118.92638, 34.20872], [-118.92342, 34.20869], [-118.92218, 34.21012], [-118.92184, 34.21046], [-118.92099, 34.2097], [-118.921, 34.20597], [-118.92113, 34.20595], [-118.92305, 34.20594], [-118.92337, 34.20574], [-118.92446, 34.20573], [-118.92421, 34.20619], [-118.92422, 34.20621], [-118.92917, 34.20849], [-118.93946, 34.20761], [-118.94046, 34.20903], [-118.94091, 34.20981], [-118.94062, 34.21006], [-118.94109, 34.21014], [-118.9419, 34.21156]]]} | Open Access 1 | Conejo Canyons Open Space | http://www.conejo-openspace.org/open-space.html | 30795 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 490.511 | Conejo Canyons OS |
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]);