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 rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14955 | 14955 | 14954 | {"type": "Polygon", "coordinates": [[[-117.08418, 32.96087], [-117.07554, 32.96077], [-117.07544, 32.95335], [-117.08186, 32.95344], [-117.0818, 32.94971], [-117.08397, 32.94974], [-117.08418, 32.96087]]]} | Open Access 1 | Van Dam Peak Open Space | 26824 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 184.267 | Van Dam Peak OS | ||
14949 | 14949 | 14948 | {"type": "Polygon", "coordinates": [[[-117.04655, 32.98981], [-117.04644, 32.99002], [-117.04624, 32.98988], [-117.04549, 32.99], [-117.04438, 32.98961], [-117.04432, 32.98956], [-117.04366, 32.98955], [-117.04282, 32.99048], [-117.04281, 32.99102], [-117.04207, 32.99065], [-117.04174, 32.99079], [-117.04172, 32.99156], [-117.04071, 32.99164], [-117.04066, 32.98935], [-117.04001, 32.98937], [-117.03979, 32.9893], [-117.03874, 32.9893], [-117.03872, 32.98932], [-117.0387, 32.98932], [-117.03452, 32.98928], [-117.03447, 32.98902], [-117.03441, 32.98896], [-117.03432, 32.98895], [-117.03425, 32.98881], [-117.03424, 32.98875], [-117.03456, 32.98881], [-117.03497, 32.98871], [-117.03501, 32.9882], [-117.03501, 32.98798], [-117.0346, 32.98742], [-117.03455, 32.98718], [-117.03413, 32.98665], [-117.03405, 32.9862], [-117.03378, 32.98578], [-117.03374, 32.98563], [-117.03632, 32.98566], [-117.03638, 32.9884], [-117.04065, 32.98844], [-117.04062, 32.98567], [-117.04493, 32.98579], [-117.04495, 32.98938], [-117.04639, 32.98941], [-117.04636, 32.98975], [-117.04655, 32.98981]]]} | Open Access 1 | Twin Peaks Open Space | http://powaytrails.com/trails/TwinPeaksTrail/ | 26620 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 81.721 | Twin Peaks 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 | ||
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 | ||
12697 | 12697 | 12696 | {"type": "Polygon", "coordinates": [[[-116.9986, 32.96095], [-116.99776, 32.96117], [-116.99758, 32.96085], [-116.99794, 32.96067], [-116.9981, 32.96063], [-116.99835, 32.96059], [-116.99841, 32.96063], [-116.9985, 32.96081], [-116.9986, 32.96095]]]} | Open Access 1 | Sycamore Creek Neighborhood Park - East | 31380 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.91 | Sycamore Creek Neighborhood Park - East | ||
12696 | 12696 | 12695 | {"type": "Polygon", "coordinates": [[[-117.00188, 32.95969], [-117.0015, 32.95981], [-117.00141, 32.95964], [-117.00186, 32.95949], [-117.00188, 32.95969]]]} | Open Access 1 | Sycamore Creek Neighborhood Park - West | 31379 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.215 | Sycamore Creek Neighborhood Park - West | ||
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 | |
12178 | 12178 | 12177 | {"type": "Polygon", "coordinates": [[[-117.036, 32.97054], [-117.03563, 32.97054], [-117.03563, 32.9703], [-117.036, 32.9703], [-117.036, 32.97054]]]} | Open Access 1 | Veteran's Park | http://poway.org/538/Veterans-Park | 29158 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.229 | Veteran's Park | |
12177 | 12177 | 12176 | {"type": "Polygon", "coordinates": [[[-117.04737, 32.9529], [-117.04734, 32.95404], [-117.04654, 32.95403], [-117.04656, 32.95289], [-117.04737, 32.9529]]]} | Open Access 1 | Valley Soccer Field | http://poway.org/Facilities/Facility/Details/Valley-Soccer-Field-56 | 29157 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 2.335 | Valley Soccer Field | |
12176 | 12176 | 12175 | {"type": "Polygon", "coordinates": [[[-117.06741, 32.94582], [-117.06611, 32.94579], [-117.06614, 32.94569], [-117.06613, 32.94558], [-117.06599, 32.94508], [-117.066, 32.94497], [-117.06604, 32.94487], [-117.0661, 32.94481], [-117.06617, 32.94477], [-117.06647, 32.94467], [-117.06665, 32.94462], [-117.06687, 32.94461], [-117.06698, 32.94458], [-117.06741, 32.94582]]]} | Open Access 1 | The Pond | 29156 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 3.291 | The Pond | ||
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 | |
11543 | 11543 | 11542 | {"type": "MultiPolygon", "coordinates": [[[[-116.97064, 32.98874], [-116.97048, 32.99571], [-116.97003, 32.99569], [-116.96974, 32.9957], [-116.96935, 32.99576], [-116.96907, 32.99583], [-116.96869, 32.99598], [-116.96747, 32.99662], [-116.96603, 32.99716], [-116.96572, 32.99726], [-116.96537, 32.99735], [-116.965, 32.99742], [-116.9641, 32.99752], [-116.96408, 32.99739], [-116.96193, 32.99737], [-116.96202, 32.99245], [-116.95777, 32.99241], [-116.95776, 32.9887], [-116.96204, 32.98869], [-116.97064, 32.98874]]], [[[-116.97043, 32.99718], [-116.97037, 33.00014], [-116.96611, 33.0001], [-116.96618, 32.99841], [-116.96646, 32.99827], [-116.968, 32.99778], [-116.96936, 32.99733], [-116.97043, 32.99718]]]]} | Open Access 1 | Rock Haven Spring Open Space | 24509 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 244.039 | Rock Haven Spring OS | ||
9935 | 9935 | 9934 | {"type": "Polygon", "coordinates": [[[-117.0528, 32.96429], [-117.05273, 32.96441], [-117.05225, 32.96502], [-117.05154, 32.96467], [-117.05071, 32.96559], [-117.04956, 32.96596], [-117.04946, 32.96586], [-117.04827, 32.96584], [-117.04826, 32.96581], [-117.04818, 32.96581], [-117.04818, 32.9658], [-117.04935, 32.9658], [-117.04935, 32.96401], [-117.04938, 32.96259], [-117.04985, 32.96205], [-117.05113, 32.96208], [-117.0521, 32.9619], [-117.05252, 32.96197], [-117.05254, 32.96199], [-117.05251, 32.96222], [-117.05229, 32.96331], [-117.05228, 32.96352], [-117.05234, 32.96373], [-117.05243, 32.96389], [-117.05251, 32.96399], [-117.05262, 32.96409], [-117.05266, 32.9642], [-117.0528, 32.96429]]]} | Open Access 1 | Starridge Neighborhood Park | http://powaygis.poway.org/websites/CityOfPowayParks/ | 25809 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 26.131 | Starridge Neighborhood Park | |
9687 | 9687 | 9686 | {"type": "Polygon", "coordinates": [[[-117.05157, 32.9804], [-117.05138, 32.98085], [-117.05133, 32.98094], [-117.05131, 32.981], [-117.05132, 32.98106], [-117.05102, 32.98153], [-117.04857, 32.98177], [-117.04856, 32.98156], [-117.04845, 32.98133], [-117.04846, 32.98125], [-117.04842, 32.98112], [-117.04839, 32.98059], [-117.04839, 32.98037], [-117.04841, 32.98015], [-117.04845, 32.98], [-117.04851, 32.97983], [-117.04992, 32.9802], [-117.05087, 32.98035], [-117.05157, 32.9804]]]} | Open Access 1 | Silverset Neighborhood Park | http://powaygis.poway.org/websites/CityOfPowayParks/ | 25499 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 11.031 | Silverset 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 | |
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 | |
8378 | 8378 | 8377 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.95986], [-117.02155, 32.95994], [-117.02103, 32.95994], [-117.02095, 32.96008], [-117.02096, 32.96039], [-117.02106, 32.96047], [-117.02091, 32.96064], [-117.02085, 32.96074], [-117.0208, 32.96091], [-117.0208, 32.96142], [-117.02082, 32.96161], [-117.0209, 32.96194], [-117.02088, 32.96203], [-117.02077, 32.96215], [-117.02066, 32.96218], [-117.02019, 32.96218], [-117.02019, 32.96179], [-117.02008, 32.96109], [-117.02, 32.96079], [-117.01987, 32.96057], [-117.01968, 32.96061], [-117.01969, 32.96053], [-117.01966, 32.96046], [-117.01972, 32.96041], [-117.01971, 32.95999], [-117.01905, 32.95999], [-117.01906, 32.96152], [-117.0189, 32.96152], [-117.01889, 32.95985], [-117.02155, 32.95986]]]} | Open Access 1 | Poway holding 8 | 23967 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 6.403 | Poway holding 8 | ||
8377 | 8377 | 8376 | {"type": "Polygon", "coordinates": [[[-117.02384, 33.00745], [-117.02372, 33.00902], [-117.0237, 33.00904], [-117.02343, 33.00903], [-117.0236, 33.00876], [-117.02364, 33.0079], [-117.02322, 33.00746], [-117.02384, 33.00745]]]} | Open Access 1 | Poway holding 7 | 23966 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.962 | Poway holding 7 | ||
8376 | 8376 | 8375 | {"type": "Polygon", "coordinates": [[[-117.02163, 33.04292], [-117.0212, 33.04359], [-117.02138, 33.0441], [-117.02079, 33.04412], [-117.02078, 33.04317], [-117.01906, 33.04209], [-117.01646, 33.04278], [-117.01645, 33.04412], [-117.01413, 33.04412], [-117.01409, 33.04239], [-117.01591, 33.04236], [-117.01638, 33.04216], [-117.01783, 33.04196], [-117.01829, 33.04176], [-117.01925, 33.04139], [-117.01935, 33.04108], [-117.01954, 33.0411], [-117.01974, 33.04109], [-117.0199, 33.04104], [-117.02017, 33.04092], [-117.02021, 33.04094], [-117.02042, 33.04111], [-117.02055, 33.04119], [-117.02083, 33.04128], [-117.021, 33.04138], [-117.02114, 33.04151], [-117.02127, 33.04169], [-117.02146, 33.04247], [-117.02147, 33.04256], [-117.02155, 33.04271], [-117.02156, 33.04281], [-117.02163, 33.04292]]]} | Open Access 1 | Poway holding 6 | 23965 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 25.021 | Poway holding 6 | ||
8375 | 8375 | 8374 | {"type": "Polygon", "coordinates": [[[-117.02617, 33.00623], [-117.02578, 33.00626], [-117.0255, 33.0061], [-117.02515, 33.00568], [-117.02487, 33.00565], [-117.0244, 33.00576], [-117.0243, 33.00715], [-117.02459, 33.0073], [-117.02428, 33.0073], [-117.02425, 33.00729], [-117.02423, 33.00725], [-117.02422, 33.00722], [-117.02427, 33.00658], [-117.02428, 33.00627], [-117.02427, 33.00577], [-117.02425, 33.00555], [-117.02388, 33.00376], [-117.02386, 33.00356], [-117.02384, 33.0031], [-117.02388, 33.00235], [-117.0239, 33.00232], [-117.02394, 33.0023], [-117.02404, 33.00229], [-117.02402, 33.00268], [-117.0247, 33.00289], [-117.02451, 33.00337], [-117.02431, 33.00428], [-117.02428, 33.00459], [-117.02444, 33.00473], [-117.02482, 33.00514], [-117.02562, 33.00557], [-117.02562, 33.00587], [-117.02572, 33.00597], [-117.02616, 33.00603], [-117.02617, 33.00623]]]} | Open Access 1 | Poway holding 4 | 23964 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 6.009 | Poway holding 4 |
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]);