superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where ACCESS_TYP = 1, MNG_AGENCY = 129 and MNG_AG_TYP = 2 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
535 | 535 | 534 | {"type": "Polygon", "coordinates": [[[-117.06598, 32.98269], [-117.06585, 32.98274], [-117.06419, 32.9827], [-117.06299, 32.98277], [-117.06287, 32.98236], [-117.06594, 32.98244], [-117.06598, 32.98269]]]} | Open Access 1 | Adobe Ridge Neighborhood Park | http://poway.org/Facilities/Facility/Details/Adobe-Ridge-Neighborhood-Park-51 | 15273 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 2.549 | Adobe Ridge Neighborhood Park | |
12186 | 12186 | 12185 | {"type": "Polygon", "coordinates": [[[-117.06088, 32.97759], [-117.06089, 32.97768], [-117.06085, 32.97788], [-117.06086, 32.97808], [-117.0608, 32.97822], [-117.06076, 32.97828], [-117.06079, 32.97845], [-117.06078, 32.97858], [-117.06075, 32.97861], [-117.06059, 32.97867], [-117.06062, 32.9786], [-117.06061, 32.97846], [-117.06058, 32.97832], [-117.06048, 32.97801], [-117.06045, 32.97768], [-117.0605, 32.9775], [-117.06054, 32.97747], [-117.06059, 32.97744], [-117.06071, 32.97746], [-117.06076, 32.9775], [-117.06085, 32.97754], [-117.06088, 32.97759]]]} | Open Access 1 | Arbolitos Mini Park | http://poway.org/Facilities/Facility/Details/Arbolitos-Mini-Park-59 | 29150 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.904 | Arbolitos MP | |
12175 | 12175 | 12174 | {"type": "Polygon", "coordinates": [[[-117.06234, 32.97546], [-117.06232, 32.97691], [-117.06225, 32.97693], [-117.06223, 32.97788], [-117.0613, 32.97786], [-117.0613, 32.97764], [-117.06135, 32.9775], [-117.06136, 32.9771], [-117.06132, 32.97698], [-117.06131, 32.97586], [-117.06151, 32.97583], [-117.06157, 32.97545], [-117.06234, 32.97546]]]} | Open Access 1 | Arbolitos Sports Field | http://poway.org/Facilities/Facility/Details/Arbolitos-Sports-Fields-54 | 29149 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 5.821 | Arbolitos Sports Field | |
1657 | 1657 | 1656 | {"type": "Polygon", "coordinates": [[[-117.03828, 32.97303], [-117.03824, 32.97304], [-117.03825, 32.97329], [-117.03774, 32.97329], [-117.03772, 32.9732], [-117.03628, 32.9732], [-117.03627, 32.97203], [-117.03699, 32.97202], [-117.03699, 32.97174], [-117.03723, 32.97173], [-117.03723, 32.97121], [-117.03822, 32.97121], [-117.03824, 32.97284], [-117.03827, 32.97286], [-117.03828, 32.97303]]]} | Open Access 1 | Aubrey Park | http://poway.org/Facilities/Facility/Details/Aubrey-Park-58 | 15683 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 8.294 | Aubrey Park | |
1985 | 1985 | 1984 | {"type": "Polygon", "coordinates": [[[-117.06676, 32.94232], [-117.06643, 32.94283], [-117.06594, 32.94275], [-117.06601, 32.94232], [-117.06676, 32.94232]]]} | Open Access 1 | Bette Bendixen Park | http://poway.org/Facilities/Facility/Details/Bette-Bendixen-Park-60 | 16050 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.773 | Bette Bendixen Park | |
14840 | 14840 | 14839 | {"type": "MultiPolygon", "coordinates": [[[[-117.0238, 32.94716], [-117.02334, 32.94716], [-117.02334, 32.94677], [-117.02334, 32.94677], [-117.0238, 32.94716]]], [[[-117.02744, 32.94658], [-117.02719, 32.94638], [-117.02698, 32.94608], [-117.02686, 32.94597], [-117.02666, 32.94591], [-117.02636, 32.94586], [-117.02634, 32.94595], [-117.02591, 32.94584], [-117.02519, 32.94576], [-117.02517, 32.94566], [-117.02466, 32.94565], [-117.02464, 32.94555], [-117.02432, 32.94554], [-117.0241, 32.94551], [-117.02409, 32.94572], [-117.02373, 32.94561], [-117.02335, 32.94552], [-117.02335, 32.94532], [-117.02743, 32.94536], [-117.02744, 32.94658]]]]} | Open Access 1 | City of Poway Open Space | 17328 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 5.1 | City of Poway OS | ||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-117.01089, 32.95821], [-117.01062, 32.95821], [-117.01045, 32.95824], [-117.00995, 32.95767], [-117.00893, 32.95625], [-117.00912, 32.95625], [-117.00913, 32.95623], [-117.00912, 32.95621], [-117.01057, 32.95622], [-117.01055, 32.95793], [-117.01064, 32.95795], [-117.01089, 32.95821]]], [[[-117.01245, 32.95986], [-117.01195, 32.95986], [-117.01144, 32.95939], [-117.01055, 32.95838], [-117.01102, 32.95836], [-117.0117, 32.95914], [-117.01245, 32.95986]]]]} | Open Access 1 | Garden Road Neighborhood Park | http://poway.org/Facilities/Facility/Details/Garden-Road-Neighborhood-Park-61 | 19203 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 6.745 | Garden Road Neighborhood Park | |
5159 | 5159 | 5158 | {"type": "Polygon", "coordinates": [[[-117.04327, 32.96018], [-117.04305, 32.96054], [-117.0429, 32.96068], [-117.04276, 32.96076], [-117.04254, 32.96116], [-117.04239, 32.96125], [-117.04205, 32.96163], [-117.04186, 32.96179], [-117.04183, 32.96185], [-117.04171, 32.96187], [-117.04174, 32.96197], [-117.04159, 32.96217], [-117.04144, 32.9623], [-117.04115, 32.96273], [-117.04119, 32.96292], [-117.04117, 32.96301], [-117.041, 32.96314], [-117.04094, 32.96323], [-117.04088, 32.96365], [-117.04093, 32.96387], [-117.04068, 32.96386], [-117.04065, 32.96266], [-117.04069, 32.96108], [-117.04074, 32.96014], [-117.04327, 32.96018]]]} | Open Access 1 | Hilleary Park | http://poway.org/Facilities/Facility/Details/Hilleary-Park-62 | 19972 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 11.023 | Hilleary Park | |
661 | 661 | 660 | {"type": "Polygon", "coordinates": [[[-116.9621, 32.96655], [-116.96206, 32.97747], [-116.95777, 32.97762], [-116.95777, 32.98135], [-116.95346, 32.98146], [-116.95344, 32.9887], [-116.94488, 32.98869], [-116.94483, 32.98514], [-116.94043, 32.9852], [-116.94037, 32.97069], [-116.94486, 32.97075], [-116.95347, 32.97048], [-116.95351, 32.96324], [-116.9578, 32.9631], [-116.95781, 32.9667], [-116.9621, 32.96655]]]} | Open Access 1 | Iron Mountain Open Space | http://powaytrails.com/trails/IronMountainPeakTrail/index.html | 8834 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 884.915 | Iron Mtn. OS | |
14875 | 14875 | 14874 | {"type": "MultiPolygon", "coordinates": [[[[-117.01745, 32.97317], [-117.01673, 32.97377], [-117.01616, 32.97367], [-117.0147, 32.97437], [-117.01469, 32.97117], [-117.01603, 32.9703], [-117.01612, 32.97046], [-117.01672, 32.97243], [-117.01677, 32.97256], [-117.01688, 32.97275], [-117.01705, 32.97293], [-117.01726, 32.97308], [-117.01745, 32.97317]]], [[[-117.02324, 32.97449], [-117.02117, 32.97444], [-117.0206, 32.97421], [-117.02056, 32.97425], [-117.01967, 32.97394], [-117.01919, 32.97374], [-117.01744, 32.97297], [-117.01714, 32.97277], [-117.01698, 32.97256], [-117.01694, 32.97247], [-117.01632, 32.97046], [-117.01634, 32.97024], [-117.01633, 32.97019], [-117.01676, 32.9699], [-117.01863, 32.96989], [-117.01857, 32.96994], [-117.01835, 32.97001], [-117.01819, 32.9701], [-117.01809, 32.97017], [-117.01791, 32.97039], [-117.01781, 32.9707], [-117.01781, 32.97085], [-117.01785, 32.971], [-117.01792, 32.97115], [-117.01801, 32.97128], [-117.01814, 32.97139], [-117.01829, 32.97149], [-117.01829, 32.97223], [-117.01854, 32.97243], [-117.01914, 32.97247], [-117.01989, 32.97239], [-117.02069, 32.97245], [-117.02147, 32.97268], [-117.02213, 32.97268], [-117.02273, 32.97236], [-117.02272, 32.9717], [-117.02324, 32.97153], [-117.02323, 32.9728], [-117.02324, 32.97449]]]]} | Open Access 1 | Kent Hill Open Space | 20617 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 50.697 | Kent Hill OS | ||
5795 | 5795 | 5794 | {"type": "Polygon", "coordinates": [[[-117.05671, 32.95304], [-117.05614, 32.95389], [-117.05578, 32.95413], [-117.05577, 32.95408], [-117.05583, 32.954], [-117.05584, 32.95393], [-117.05578, 32.95385], [-117.05569, 32.95383], [-117.05559, 32.95385], [-117.05553, 32.95393], [-117.05553, 32.954], [-117.0556, 32.95414], [-117.05469, 32.95412], [-117.05472, 32.95331], [-117.05527, 32.95331], [-117.05529, 32.95302], [-117.05671, 32.95304]]]} | Open Access 1 | Kumeyaay-Ipai Interpretive Center | http://poway.org/369/Kumeyaay-Ipai-Interpretive-Center-at-Pau | 20730 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 3.979 | Kumeyaay-Ipai Interpretive Ctr. | |
5950 | 5950 | 5949 | {"type": "Polygon", "coordinates": [[[-117.01594, 33.00726], [-117.01592, 33.0074], [-117.01518, 33.0073], [-117.01499, 33.00722], [-117.01462, 33.00698], [-117.01391, 33.00721], [-117.01373, 33.00681], [-117.01355, 33.0068], [-117.01322, 33.00711], [-117.01271, 33.00748], [-117.01258, 33.00747], [-117.01255, 33.00742], [-117.01302, 33.00707], [-117.01321, 33.00685], [-117.01312, 33.00668], [-117.013, 33.00661], [-117.01283, 33.00659], [-117.01252, 33.00648], [-117.01222, 33.00624], [-117.012, 33.006], [-117.01182, 33.00566], [-117.01165, 33.00521], [-117.01146, 33.00478], [-117.0117, 33.00453], [-117.01208, 33.00455], [-117.01219, 33.00453], [-117.0125, 33.00436], [-117.01277, 33.00428], [-117.01328, 33.00425], [-117.01365, 33.00411], [-117.01429, 33.00438], [-117.01433, 33.00461], [-117.01466, 33.00484], [-117.01486, 33.00487], [-117.01581, 33.00526], [-117.01583, 33.00551], [-117.01569, 33.00573], [-117.0159, 33.00639], [-117.01584, 33.00649], [-117.01594, 33.00726]]]} | Open Access 1 | Lake Poway Park | http://poway.org/401/Lake-Poway | 20962 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 24.584 | Lake Poway Park | |
660 | 660 | 659 | {"type": "Polygon", "coordinates": [[[-117.02024, 33.0132], [-117.01973, 33.01329], [-117.0196, 33.01327], [-117.01881, 33.01276], [-117.01799, 33.01241], [-117.01699, 33.01269], [-117.01603, 33.01335], [-117.0148, 33.01197], [-117.01092, 33.01197], [-117.01053, 33.01217], [-117.01035, 33.01452], [-117.00984, 33.01458], [-117.00983, 33.01471], [-117.00833, 33.01476], [-117.00624, 33.01481], [-117.00661, 33.00841], [-117.00447, 33.0083], [-117.0041, 33.00787], [-117.00411, 33.00748], [-117.0041, 33.00747], [-116.99613, 33.00752], [-116.99177, 33.00753], [-116.99176, 33.00755], [-116.9918, 33.01127], [-116.98319, 33.01121], [-116.98315, 33.01495], [-116.97885, 33.01493], [-116.97017, 33.01493], [-116.9702, 33.0112], [-116.97879, 33.01115], [-116.97875, 33.00754], [-116.9793, 33.00015], [-116.99639, 33.00024], [-117.00082, 33.0003], [-117.00071, 33.00386], [-117.00072, 33.00387], [-117.00323, 33.00388], [-117.00335, 33.00307], [-117.00395, 33.00205], [-117.00488, 33.00136], [-117.00515, 33.00128], [-117.0052, 33.00035], [-117.00982, 33.00045], [-117.01302, 33.00155], [-117.01301, 33.0022], [-117.01471, 33.00223], [-117.01512, 33.00498], [-117.01486, 33.00487], [-117.01466, 33.00484], [-117.01433, 33.00461], [-117.01428, 33.00438], [-117.01365, 33.00411], [-117.01328, 33.00425], [-117.01278, 33.00428], [-117.0125, 33.00436], [-117.01219, 33.00453], [-117.01208, 33.00455], [-117.0117, 33.00454], [-117.01147, 33.00478], [-117.01182, 33.00566], [-117.012, 33.006], [-117.01223, 33.00624], [-117.01252, 33.00648], [-117.01283, 33.00659], [-117.01299, 33.0066], [-117.01312, 33.00668], [-117.01322, 33.00686], [-117.01302, 33.00707], [-117.01262, 33.00736], [-117.01255, 33.00743], [-117.01259, 33.00747], [-117.01271, 33.00748], [-117.01322, 33.00711], [-117.01354, 33.0068], [-117.01373, 33.0068], [-117.01388, 33.00715], [-117.01392, 33.00721], [-117.01462, 33.00698], [-117.01499, 33.00722], [-117.01517, 33.0073], [-117.01536, 33.00733], [-117.01538, 33.00741], [-117.01711, 33.00742], [-117.01753, 33.00747], [-117.01811, 33.00749], [-117.01833, 33.00748], [-117.01751, 33.00817], [-117.01851, 33.00899], [-117.01915, 33.009], [-117.01873, 33.01011], [-117.0188, 33.01052], [-117.01946, 33.01161], [-117.01963, 33.01217], [-117.01992, 33.01273], [-117.02024, 33.0132]]]} | Open Access 1 | Lake Poway Recreation Area | http://poway.org/401/Lake-Poway | 8838 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1034.222 | Lake Poway Rec. Area | |
7656 | 7656 | 7655 | {"type": "Polygon", "coordinates": [[[-117.03743, 32.96938], [-117.03742, 32.97105], [-117.03627, 32.97104], [-117.03628, 32.96938], [-117.03743, 32.96938]]]} | Open Access 1 | Old Poway Park and Railroad | http://poway.org/452/Old-Poway-Park | 23098 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 4.927 | Old Poway Park and Railroad | |
8339 | 8339 | 8338 | {"type": "Polygon", "coordinates": [[[-117.04961, 32.95128], [-117.04959, 32.95259], [-117.0487, 32.95287], [-117.04862, 32.95274], [-117.04857, 32.9527], [-117.04834, 32.95276], [-117.0483, 32.95283], [-117.04836, 32.95299], [-117.04851, 32.95333], [-117.04861, 32.95344], [-117.04865, 32.95345], [-117.04875, 32.9534], [-117.04894, 32.95339], [-117.04899, 32.9534], [-117.04958, 32.95322], [-117.04955, 32.95486], [-117.04763, 32.95485], [-117.04716, 32.95525], [-117.04715, 32.95541], [-117.04684, 32.95541], [-117.04686, 32.95479], [-117.04733, 32.95477], [-117.04732, 32.95467], [-117.04737, 32.95287], [-117.04735, 32.95228], [-117.04717, 32.95207], [-117.04717, 32.95198], [-117.04733, 32.95189], [-117.04754, 32.95181], [-117.04772, 32.95176], [-117.04803, 32.95181], [-117.04818, 32.95178], [-117.0492, 32.95134], [-117.04961, 32.95128]]]} | Open Access 1 | Poway Community Park | http://poway.org/307/Community-Park | 23930 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 17.561 | Poway Community Park | |
8379 | 8379 | 8378 | {"type": "Polygon", "coordinates": [[[-117.06245, 32.94818], [-117.06243, 32.94856], [-117.06232, 32.94841], [-117.06194, 32.94833], [-117.06196, 32.94802], [-117.06206, 32.94804], [-117.06216, 32.948], [-117.06245, 32.94818]]]} | Open Access 1 | Poway Oaks Neighborhood Park | http://powaygis.poway.org/websites/CityOfPowayParks/ | 23968 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.44 | Poway Oaks Neighborhood Park | |
8380 | 8380 | 8379 | {"type": "Polygon", "coordinates": [[[-117.04283, 32.94251], [-117.04283, 32.94256], [-117.04241, 32.94346], [-117.04238, 32.9435], [-117.04228, 32.94355], [-117.04224, 32.94361], [-117.04223, 32.94367], [-117.04225, 32.94372], [-117.0423, 32.94378], [-117.04236, 32.9438], [-117.04177, 32.94509], [-117.04098, 32.94491], [-117.04098, 32.94399], [-117.03967, 32.94268], [-117.03975, 32.9425], [-117.03997, 32.94165], [-117.03999, 32.94162], [-117.04003, 32.94159], [-117.04008, 32.94159], [-117.04097, 32.94187], [-117.04281, 32.94247], [-117.04283, 32.94251]]]} | Open Access 1 | Poway Sportsplex | http://www.sportsplexusa.com/content.cfm?n=poway | 23969 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 15.192 | Poway Sportsplex | |
7097 | 7097 | 7096 | {"type": "Polygon", "coordinates": [[[-117.02379, 33.00511], [-117.02377, 33.00515], [-117.02368, 33.00518], [-117.02366, 33.00476], [-117.02327, 33.00289], [-117.02341, 33.00257], [-117.0234, 33.00228], [-117.02348, 33.00229], [-117.02352, 33.00233], [-117.02348, 33.00314], [-117.0235, 33.00363], [-117.02379, 33.00511]]]} | Open Access 1 | Poway holding 1 | 23932 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.739 | Poway holding 1 | ||
8341 | 8341 | 8340 | {"type": "Polygon", "coordinates": [[[-117.02815, 33.00388], [-117.02776, 33.00411], [-117.02767, 33.0045], [-117.02736, 33.00465], [-117.02745, 33.00503], [-117.02729, 33.00571], [-117.02741, 33.00617], [-117.02719, 33.00647], [-117.02748, 33.00684], [-117.02709, 33.00695], [-117.02685, 33.00632], [-117.02636, 33.00622], [-117.02635, 33.00607], [-117.02637, 33.00592], [-117.02701, 33.00604], [-117.02713, 33.00529], [-117.02715, 33.00465], [-117.02718, 33.0044], [-117.02746, 33.00417], [-117.02761, 33.00355], [-117.02726, 33.00317], [-117.02684, 33.00317], [-117.02684, 33.00313], [-117.02686, 33.00309], [-117.02727, 33.00279], [-117.02813, 33.00347], [-117.02815, 33.00388]]]} | Open Access 1 | Poway holding 10 | 23933 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 4.581 | Poway holding 10 | ||
8342 | 8342 | 8341 | {"type": "Polygon", "coordinates": [[[-117.05962, 32.93512], [-117.05625, 32.93698], [-117.05427, 32.93557], [-117.05391, 32.93515], [-117.05962, 32.93512]]]} | Open Access 1 | Poway holding 11 | 23934 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 13.922 | Poway holding 11 |
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]);