superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 129 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8351 | 8351 | 8350 | {"type": "Polygon", "coordinates": [[[-117.02323, 33.03387], [-117.02274, 33.03451], [-117.02253, 33.03474], [-117.02131, 33.03575], [-117.02116, 33.03585], [-117.02103, 33.03592], [-117.02086, 33.03597], [-117.0205, 33.03603], [-117.02019, 33.03599], [-117.01962, 33.03585], [-117.01922, 33.0358], [-117.01917, 33.03576], [-117.01909, 33.03566], [-117.01898, 33.03562], [-117.01886, 33.03564], [-117.0188, 33.0357], [-117.01876, 33.03578], [-117.01872, 33.03582], [-117.01852, 33.03584], [-117.0187, 33.03328], [-117.02247, 33.03317], [-117.02249, 33.03358], [-117.02232, 33.03364], [-117.02187, 33.03382], [-117.0216, 33.03389], [-117.02024, 33.03403], [-117.02005, 33.03407], [-117.0199, 33.03413], [-117.01975, 33.03422], [-117.01953, 33.03442], [-117.0195, 33.0345], [-117.01919, 33.03449], [-117.01889, 33.03529], [-117.01998, 33.03546], [-117.02089, 33.03505], [-117.02144, 33.03483], [-117.02276, 33.03424], [-117.02286, 33.03373], [-117.02303, 33.03376], [-117.02318, 33.03382], [-117.02323, 33.03387]]]} | Open Access 1 | Poway holding 17 | 23940 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 16.15 | Poway holding 17 | ||
8368 | 8368 | 8367 | {"type": "Polygon", "coordinates": [[[-117.02354, 33.00205], [-117.02349, 33.0021], [-117.02338, 33.0021], [-117.02348, 33.00185], [-117.02347, 33.00124], [-117.02325, 33.00034], [-117.02352, 33.00034], [-117.02356, 33.00132], [-117.02356, 33.00176], [-117.02354, 33.00205]]]} | Open Access 1 | Poway holding 33 | 23958 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.629 | Poway holding 33 | ||
8343 | 8343 | 8342 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.00922], [-117.02368, 33.00986], [-117.02367, 33.01319], [-117.02363, 33.01325], [-117.02347, 33.01326], [-117.02353, 33.01299], [-117.02353, 33.01255], [-117.02357, 33.0112], [-117.02337, 33.01058], [-117.02331, 33.01021], [-117.02355, 33.00952], [-117.02355, 33.00938], [-117.02348, 33.00917], [-117.02366, 33.00918], [-117.02369, 33.00919], [-117.02371, 33.00922]]]} | Open Access 1 | Poway holding 12 | 23935 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1.944 | Poway holding 12 | ||
8367 | 8367 | 8366 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.01452], [-117.0236, 33.01454], [-117.02354, 33.01365], [-117.02349, 33.01341], [-117.02363, 33.01341], [-117.02368, 33.01347], [-117.02367, 33.01393], [-117.02371, 33.01452]]]} | Open Access 1 | Poway holding 31 | 23956 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.361 | Poway holding 31 | ||
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 | ||
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 | ||
8357 | 8357 | 8356 | {"type": "Polygon", "coordinates": [[[-117.02405, 33.00214], [-117.02394, 33.00214], [-117.02394, 33.00177], [-117.02401, 33.00177], [-117.02405, 33.00214]]]} | Open Access 1 | Poway holding 22 | 23946 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.091 | Poway holding 22 | ||
14531 | 14531 | 14530 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.0185], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 15.494 | Blue Sky ER | 1991 | |
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 | ||
8356 | 8356 | 8355 | {"type": "Polygon", "coordinates": [[[-117.02693, 33.00207], [-117.02671, 33.00227], [-117.02653, 33.0025], [-117.02693, 33.00285], [-117.02677, 33.00296], [-117.0267, 33.00296], [-117.02655, 33.00283], [-117.02615, 33.00258], [-117.0265, 33.00173], [-117.02682, 33.00172], [-117.02693, 33.00207]]]} | Open Access 1 | Poway holding 21 | 23945 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1.306 | Poway holding 21 | ||
8353 | 8353 | 8352 | {"type": "Polygon", "coordinates": [[[-117.02761, 33.01797], [-117.0268, 33.01789], [-117.02633, 33.01779], [-117.02581, 33.01761], [-117.02556, 33.0175], [-117.02533, 33.01736], [-117.02512, 33.01722], [-117.02493, 33.01706], [-117.02462, 33.01673], [-117.02435, 33.01626], [-117.0242, 33.01588], [-117.02413, 33.01561], [-117.02411, 33.01538], [-117.02404, 33.01406], [-117.02405, 33.00967], [-117.02421, 33.00752], [-117.02423, 33.00748], [-117.02427, 33.00746], [-117.02452, 33.00747], [-117.02444, 33.00763], [-117.02428, 33.00781], [-117.02427, 33.00824], [-117.02433, 33.00874], [-117.02453, 33.00876], [-117.02567, 33.00915], [-117.02558, 33.00927], [-117.02493, 33.00904], [-117.02432, 33.00886], [-117.02415, 33.00934], [-117.02414, 33.01027], [-117.02433, 33.01055], [-117.02416, 33.01078], [-117.02428, 33.01198], [-117.02412, 33.01289], [-117.02413, 33.0135], [-117.02423, 33.01492], [-117.02433, 33.01536], [-117.02454, 33.0158], [-117.02464, 33.01648], [-117.02518, 33.01699], [-117.02543, 33.01719], [-117.02575, 33.0174], [-117.0261, 33.01757], [-117.02641, 33.01769], [-117.02668, 33.01774], [-117.02694, 33.01776], [-117.02718, 33.01774], [-117.02748, 33.01768], [-117.02761, 33.01797]]]} | Open Access 1 | Poway holding 19 | 23942 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 5.906 | Poway holding 19 | ||
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 | ||
8345 | 8345 | 8344 | {"type": "Polygon", "coordinates": [[[-117.02825, 33.0206], [-117.02825, 33.02204], [-117.02771, 33.02203], [-117.0277, 33.02191], [-117.02771, 33.02146], [-117.02758, 33.02145], [-117.02758, 33.02065], [-117.02643, 33.02023], [-117.02648, 33.01995], [-117.0274, 33.01995], [-117.02825, 33.0206]]]} | Open Access 1 | Poway holding 14 | 23937 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 4.091 | Poway holding 14 | ||
8364 | 8364 | 8363 | {"type": "Polygon", "coordinates": [[[-117.02894, 33.01149], [-117.02839, 33.01226], [-117.0283, 33.01206], [-117.0279, 33.01182], [-117.02767, 33.01162], [-117.02781, 33.01138], [-117.02765, 33.01079], [-117.02712, 33.01022], [-117.0267, 33.00993], [-117.02621, 33.00987], [-117.02595, 33.00955], [-117.02569, 33.00944], [-117.02576, 33.00932], [-117.0259, 33.00914], [-117.02663, 33.00951], [-117.02678, 33.00925], [-117.0269, 33.00896], [-117.02702, 33.00866], [-117.02713, 33.00822], [-117.02757, 33.00777], [-117.02751, 33.00701], [-117.02768, 33.00696], [-117.02795, 33.00752], [-117.02735, 33.00867], [-117.02731, 33.00986], [-117.02804, 33.01051], [-117.02894, 33.01149]]]} | Open Access 1 | Poway holding 29 | 23953 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 8.579 | Poway holding 29 | ||
8350 | 8350 | 8349 | {"type": "Polygon", "coordinates": [[[-117.03068, 33.02743], [-117.03049, 33.02762], [-117.03026, 33.02759], [-117.02995, 33.02739], [-117.02999, 33.0271], [-117.0306, 33.02717], [-117.03068, 33.02743]]]} | Open Access 1 | Poway holding 16 | 23939 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.701 | Poway holding 16 | ||
8338 | 8338 | 8337 | {"type": "Polygon", "coordinates": [[[-117.03112, 33.0179], [-117.03112, 33.01828], [-117.03018, 33.0182], [-117.02981, 33.01779], [-117.03112, 33.0179]]]} | Open Access 1 | Poway holding 32 | 23957 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1.1 | Poway holding 32 | ||
8349 | 8349 | 8348 | {"type": "Polygon", "coordinates": [[[-117.03223, 33.02732], [-117.03223, 33.0274], [-117.0322, 33.02753], [-117.03215, 33.02762], [-117.03205, 33.02772], [-117.03127, 33.02818], [-117.03061, 33.02847], [-117.0306, 33.02849], [-117.03032, 33.02863], [-117.03001, 33.0288], [-117.02974, 33.029], [-117.02938, 33.0293], [-117.02869, 33.03006], [-117.02813, 33.0297], [-117.02657, 33.03019], [-117.02603, 33.02982], [-117.0251, 33.03029], [-117.02605, 33.0314], [-117.0269, 33.03161], [-117.02686, 33.03184], [-117.02659, 33.03256], [-117.02724, 33.033], [-117.02797, 33.03252], [-117.02827, 33.03267], [-117.02924, 33.03206], [-117.0295, 33.03206], [-117.02948, 33.03383], [-117.02838, 33.03472], [-117.02818, 33.03446], [-117.0279, 33.03436], [-117.02771, 33.03419], [-117.02742, 33.03411], [-117.02695, 33.0341], [-117.02667, 33.03402], [-117.02625, 33.03381], [-117.0261, 33.03365], [-117.02591, 33.03327], [-117.0258, 33.03295], [-117.02576, 33.03258], [-117.02564, 33.03202], [-117.02522, 33.03132], [-117.025, 33.03105], [-117.02385, 33.03105], [-117.02384, 33.03093], [-117.02385, 33.03065], [-117.02391, 33.03028], [-117.02402, 33.02997], [-117.02464, 33.02858], [-117.0247, 33.0283], [-117.02472, 33.02802], [-117.02485, 33.02804], [-117.02495, 33.02809], [-117.02502, 33.02815], [-117.02554, 33.02893], [-117.02562, 33.029], [-117.0257, 33.02903], [-117.02583, 33.02904], [-117.02616, 33.02969], [-117.02721, 33.02928], [-117.02638, 33.02771], [-117.02468, 33.02715], [-117.02468, 33.02703], [-117.02471, 33.02682], [-117.0248, 33.02653], [-117.02499, 33.02615], [-117.02518, 33.0259], [-117.02544, 33.02565], [-117.02558, 33.02549], [-117.02571, 33.02529], [-117.02582, 33.02506], [-117.02599, 33.02482], [-117.02616, 33.02465], [-117.0263, 33.02454], [-117.02641, 33.02447], [-117.02699, 33.02415], [-117.02723, 33.02395], [-117.02739, 33.02372], [-117.0276, 33.02315], [-117.02778, 33.02287], [-117.02823, 33.02236], [-117.02878, 33.02179], [-117.02904, 33.02156], [-117.0294, 33.02128], [-117.02955, 33.02114], [-117.02965, 33.02101], [-117.02975, 33.02084], [-117.02982, 33.02064], [-117.02983, 33.02055], [-117.03008, 33.02029], [-117.03024, 33.02009], [-117.03044, 33.02005], [-117.03062, 33.02005], [-117.03074, 33.02008], [-117.03085, 33.02012], [-117.03099, 33.02023], [-117.03117, 33.02048], [-117.03075, 33.02071], [-117.0303, 33.02441], [-117.03108, 33.02717], [-117.03195, 33.02699], [-117.03213, 33.02697], [-117.03223, 33.02732]], [[-117.02995, 33.02738], [-117.03026, 33.02759], [-117.03048, 33.02762], [-117.03068, 33.02742], [-117.0306, 33.02717], [-117.03001, 33.0271], [-117.02995, 33.02738]]]} | Open Access 1 | Poway holding 15 | 23938 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 119.195 | Poway holding 15 | ||
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 | |
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 | |
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 |
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]);