units_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, YR_EST, GAP_STS
DES_TP 10
- Local Other or Unknown 35
- Local Park 13
- Local Recreation Area 12
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 67 ✖
MNG_AGENCY 1
- Poway, City of · 67 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13572 | 13572 | 13571 | {"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 | 35891 | Poway holding 22 | 23946 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.091 | Poway holding 22 | 0 | Local Other or Unknown 14 | 4 | |
7623 | 7623 | 7622 | {"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 | 47638 | Sycamore Creek Neighborhood Park - West | 31379 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.215 | Sycamore Creek Neighborhood Park - West | None 636 | |||
4390 | 4390 | 4389 | {"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 | 45989 | Veteran's Park | 29158 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/538/Veterans-Park | San Diego 4 | 0.229 | Veteran's Park | 0 | Local Park 2 | 4 |
13527 | 13527 | 13526 | {"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 | 35824 | Poway holding 31 | 23956 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.361 | Poway holding 31 | 0 | Local Other or Unknown 14 | 4 | |
14758 | 14758 | 14757 | {"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 | 45136 | Poway Oaks Neighborhood Park | 23968 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaygis.poway.org/websites/CityOfPowayParks/ | San Diego 4 | 0.44 | Poway Oaks Neighborhood Park | 0 | Local Park 2 | 4 |
13992 | 13992 | 13991 | {"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 | 36674 | Poway holding 33 | 23958 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.628 | Poway holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13571 | 13571 | 13570 | {"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 | 35890 | Poway holding 16 | 23939 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.701 | Poway holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13409 | 13409 | 13408 | {"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 | 35556 | Poway holding 1 | 23932 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.739 | Poway holding 1 | 0 | Local Other or Unknown 14 | 4 | |
1586 | 1586 | 1585 | {"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 | 12145 | Bette Bendixen Park | 16050 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Bette-Bendixen-Park-60 | San Diego 4 | 0.774 | Bette Bendixen Park | 0 | Local Park 2 | 4 |
8112 | 8112 | 8111 | {"type": "Polygon", "coordinates": [[[-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.97802], [-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], [-117.06089, 32.97768], [-117.06085, 32.97788], [-117.06086, 32.97808], [-117.0608, 32.97822], [-117.06076, 32.97827], [-117.06079, 32.97845], [-117.06078, 32.97858]]]} | Open Access 1 | 45982 | Arbolitos Mini Park | 29150 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Arbolitos-Mini-Park-59 | San Diego 4 | 0.904 | Arbolitos MP | 0 | Local Park 2 | 4 |
5282 | 5282 | 5281 | {"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 | 47639 | Sycamore Creek Neighborhood Park - East | 31380 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.91 | Sycamore Creek Neighborhood Park - East | None 426 | |||
13433 | 13433 | 13432 | {"type": "Polygon", "coordinates": [[[-117.02384, 33.00745], [-117.02372, 33.00902], [-117.0237, 33.00904], [-117.02343, 33.00903], [-117.0236, 33.00877], [-117.02364, 33.0079], [-117.02322, 33.00746], [-117.02384, 33.00745]]]} | Open Access 1 | 35558 | Poway holding 7 | 23966 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.96 | Poway holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13526 | 13526 | 13525 | {"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 | 35823 | Poway holding 32 | 23957 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.1 | Poway holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13573 | 13573 | 13572 | {"type": "Polygon", "coordinates": [[[-117.02693, 33.00207], [-117.02671, 33.00227], [-117.02652, 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 | 35892 | Poway holding 21 | 23945 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.303 | Poway holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13401 | 13401 | 13400 | {"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 | 35513 | Poway holding 27 | 23951 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.662 | Poway holding 27 | 0 | Local Other or Unknown 14 | 4 | |
13541 | 13541 | 13540 | {"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.013], [-117.02353, 33.01255], [-117.02357, 33.01119], [-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 | 35853 | Poway holding 12 | 23935 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.944 | Poway holding 12 | 0 | Local Other or Unknown 14 | 4 | |
15124 | 15124 | 15123 | {"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 | 45988 | Valley Soccer Field | 29157 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Valley-Soccer-Field-56 | San Diego 4 | 2.335 | Valley Soccer Field | 0 | Local Recreation Area 3 | 4 |
10509 | 10509 | 10508 | {"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 | 18648 | Adobe Ridge Neighborhood Park | 15273 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/Facilities/Facility/Details/Adobe-Ridge-Neighborhood-Park-51 | San Diego 4 | 2.549 | Adobe Ridge Neighborhood Park | 0 | Local Park 2 | 4 |
13523 | 13523 | 13522 | {"type": "Polygon", "coordinates": [[[-117.06423, 32.94261], [-117.06344, 32.94237], [-117.0629, 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 | 35820 | Poway holding 35 | 23960 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 2.641 | Poway holding 35 | 0 | Local Other or Unknown 14 | 4 | |
4389 | 4389 | 4388 | {"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 | 45987 | The Pond | 29156 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 3.291 | The Pond | None 391 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);