superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 129 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
8363 | 8363 | 8362 | {"type": "Polygon", "coordinates": [[[-117.06276, 32.93262], [-117.06259, 32.93285], [-117.06243, 32.93294], [-117.06232, 32.93308], [-117.06211, 32.93322], [-117.06207, 32.93368], [-117.06184, 32.93365], [-117.06165, 32.93359], [-117.06148, 32.93352], [-117.06123, 32.93336], [-117.06172, 32.93277], [-117.06228, 32.93288], [-117.06276, 32.93262]]]} | Open Access 1 | Poway holding 27 | 23951 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1.663 | Poway holding 27 | ||
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 | ||
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 | |
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 | |
8370 | 8370 | 8369 | {"type": "Polygon", "coordinates": [[[-117.06423, 32.94261], [-117.06344, 32.94237], [-117.06291, 32.94227], [-117.06287, 32.94234], [-117.06251, 32.94227], [-117.06244, 32.94228], [-117.06202, 32.94219], [-117.06208, 32.94207], [-117.06213, 32.94202], [-117.06229, 32.94198], [-117.06305, 32.94195], [-117.06315, 32.94193], [-117.06323, 32.94189], [-117.0633, 32.94183], [-117.06335, 32.94176], [-117.06336, 32.94166], [-117.064, 32.94171], [-117.06418, 32.94234], [-117.06423, 32.94261]]]} | Open Access 1 | Poway holding 35 | 23960 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 2.642 | Poway holding 35 | ||
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 |
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]);