units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where DES_TP = 2 and MNG_AGENCY = 56 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 99
MNG_AGENCY 1
- Oakland, City of · 99 ✖
DES_TP 1
- Local Park · 99 ✖
ACCESS_TYP 1
- Open Access 99
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6323 | 6323 | 6322 | {"type": "Polygon", "coordinates": [[[-122.22256, 37.7762], [-122.22252, 37.77649], [-122.22235, 37.77642], [-122.22253, 37.77619], [-122.22256, 37.7762]]]} | Open Access 1 | 13419 | 35th Avenue Plaza | 15195 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.074 | 35th Avenue Plaza | 0 | Local Park 2 | 4 | |
9374 | 9374 | 9373 | {"type": "Polygon", "coordinates": [[[-122.29722, 37.80377], [-122.29719, 37.80383], [-122.29678, 37.80373], [-122.2968, 37.80366], [-122.29722, 37.80377]]]} | Open Access 1 | 15671 | Cresent Park | 17799 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.075 | Cresent Park | 0 | Local Park 2 | 4 | |
5071 | 5071 | 5070 | {"type": "Polygon", "coordinates": [[[-122.27768, 37.82309], [-122.27768, 37.82309], [-122.27758, 37.82337], [-122.27747, 37.82304], [-122.27768, 37.82309]]]} | Open Access 1 | 13445 | St Andrews Plaza | 25761 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.078 | St Andrews Plaza | 0 | Local Park 2 | 4 | |
8520 | 8520 | 8519 | {"type": "Polygon", "coordinates": [[[-122.23329, 37.77571], [-122.23316, 37.77586], [-122.233, 37.77562], [-122.23306, 37.77558], [-122.23329, 37.77571]]]} | Open Access 1 | 13415 | Lasear Park | 21074 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.086 | Lasear Park | 0 | Local Park 2 | 4 | |
12591 | 12591 | 12590 | {"type": "Polygon", "coordinates": [[[-122.19359, 37.76393], [-122.19346, 37.76401], [-122.1932, 37.76376], [-122.19333, 37.76367], [-122.19359, 37.76393]]]} | Open Access 1 | 48775 | Tomas Melero-Smith Park | 33501 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | https://localwiki.org/oakland/Tomas_Melero-Smith_Park | Alameda 17 | 0.138 | Tomas Melero-Smith Park | 0 | Local Park 2 | 4 |
1576 | 1576 | 1575 | {"type": "Polygon", "coordinates": [[[-122.28067, 37.81793], [-122.28059, 37.81813], [-122.28026, 37.81805], [-122.28033, 37.81785], [-122.28067, 37.81793]]]} | Open Access 1 | 13449 | McClymonds Mini Park | 22003 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.176 | McClymonds MP | 0 | Local Park 2 | 4 | |
3404 | 3404 | 3403 | {"type": "Polygon", "coordinates": [[[-122.28292, 37.82599], [-122.2825, 37.82589], [-122.28278, 37.82555], [-122.28278, 37.82555], [-122.28292, 37.82599]]]} | Open Access 1 | 13249 | Union Plaza | 26658 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.211 | Union Plaza | 0 | Local Park 2 | 4 | |
14804 | 14804 | 14803 | {"type": "Polygon", "coordinates": [[[-122.30253, 37.80789], [-122.30246, 37.8081], [-122.3024, 37.80817], [-122.30212, 37.80803], [-122.30219, 37.80782], [-122.30253, 37.80789]]]} | Open Access 1 | 47998 | Bertha Port Park | 32420 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.218 | Bertha Port Park | 0 | Local Park 2 | 4 | |
9263 | 9263 | 9262 | {"type": "Polygon", "coordinates": [[[-122.28288, 37.82617], [-122.28288, 37.82617], [-122.28212, 37.82633], [-122.28239, 37.82603], [-122.28288, 37.82617]]]} | Open Access 1 | 15537 | Fitzgerald Park | 18930 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.225 | Fitzgerald Park | 0 | Local Park 2 | 4 | |
1771 | 1771 | 1770 | {"type": "Polygon", "coordinates": [[[-122.24362, 37.84525], [-122.24333, 37.84541], [-122.2431, 37.84557], [-122.24304, 37.84555], [-122.24291, 37.84531], [-122.24294, 37.84529], [-122.24336, 37.84527], [-122.24362, 37.84525]]]} | Open Access 1 | 13245 | Rockridge Park | 24533 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.248 | Rockridge Park | 0 | Local Park 2 | 4 | |
5428 | 5428 | 5427 | {"type": "Polygon", "coordinates": [[[-122.2734, 37.81151], [-122.27319, 37.81157], [-122.27305, 37.81166], [-122.27319, 37.81109], [-122.27321, 37.81107], [-122.27324, 37.81107], [-122.27326, 37.81109], [-122.2734, 37.81151]]]} | Open Access 1 | 24942 | Begin Plaza Park | 15954 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.248 | Begin Plaza Park | 0 | Local Park 2 | 4 | |
11167 | 11167 | 11166 | {"type": "Polygon", "coordinates": [[[-122.26122, 37.83814], [-122.26105, 37.83823], [-122.26092, 37.83834], [-122.26066, 37.83815], [-122.26104, 37.83796], [-122.26109, 37.83798], [-122.26122, 37.83814]]]} | Open Access 1 | 47996 | Redondo Park | 32418 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.25 | Redondo Park | 0 | Local Park 2 | 4 | |
1783 | 1783 | 1782 | {"type": "Polygon", "coordinates": [[[-122.22948, 37.76961], [-122.22949, 37.76963], [-122.22947, 37.76968], [-122.22925, 37.76996], [-122.22923, 37.76995], [-122.22916, 37.7696], [-122.22906, 37.76933], [-122.22948, 37.76961]]]} | Open Access 1 | 13417 | Fruitvale Bridge Park | 19137 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.269 | Fruitvale Bridge Park | 0 | Local Park 2 | 4 | |
5429 | 5429 | 5428 | {"type": "Polygon", "coordinates": [[[-122.24239, 37.81173], [-122.24125, 37.81277], [-122.24123, 37.81275], [-122.24228, 37.81165], [-122.24239, 37.81173]]]} | Open Access 1 | 24943 | Mandana Plaza Park | 21736 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.29 | Mandana Plaza Park | 0 | Local Park 2 | 4 | |
8534 | 8534 | 8533 | {"type": "Polygon", "coordinates": [[[-122.17361, 37.75533], [-122.17331, 37.75544], [-122.17312, 37.7551], [-122.1734, 37.755], [-122.17361, 37.75533]]]} | Open Access 1 | 13413 | 85th Avenue Mini Park | 15217 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.291 | 85th Avenue MP | 0 | Local Park 2 | 4 | |
9320 | 9320 | 9319 | {"type": "Polygon", "coordinates": [[[-122.26926, 37.83718], [-122.26926, 37.83718], [-122.26919, 37.8378], [-122.26883, 37.83723], [-122.26926, 37.83718]]]} | Open Access 1 | 15539 | Helen McGregor Plaza Park | 19798 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.317 | Helen McGregor Plaza Park | 0 | Local Park 2 | 4 | |
7449 | 7449 | 7448 | {"type": "Polygon", "coordinates": [[[-122.27229, 37.81853], [-122.27223, 37.81886], [-122.27181, 37.81879], [-122.2719, 37.81848], [-122.27229, 37.81853]]]} | Open Access 1 | 13447 | Durant Mini Park | 18311 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.32 | Durant MP | 0 | Local Park 2 | 4 | |
8501 | 8501 | 8500 | {"type": "Polygon", "coordinates": [[[-122.24847, 37.78886], [-122.24842, 37.78889], [-122.24833, 37.78889], [-122.24828, 37.78891], [-122.24824, 37.78895], [-122.24822, 37.78904], [-122.24818, 37.78906], [-122.24776, 37.78869], [-122.24771, 37.78862], [-122.24765, 37.78857], [-122.24765, 37.78854], [-122.24769, 37.78853], [-122.24778, 37.78857], [-122.24847, 37.78886]]]} | Open Access 1 | 13314 | Vantage Point Park | 26835 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.344 | Vantage Point Park | 0 | Local Park 2 | 4 | |
8524 | 8524 | 8523 | {"type": "Polygon", "coordinates": [[[-122.16902, 37.74457], [-122.16857, 37.74478], [-122.1684, 37.74454], [-122.16885, 37.74434], [-122.16902, 37.74457]]]} | Open Access 1 | 13383 | Hooly Mini Park | 20077 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.344 | Hooly MP | 0 | Local Park 2 | 4 | |
1772 | 1772 | 1771 | {"type": "Polygon", "coordinates": [[[-122.23771, 37.84106], [-122.23757, 37.84115], [-122.23742, 37.84121], [-122.2367, 37.84127], [-122.23653, 37.84132], [-122.2364, 37.84138], [-122.2364, 37.84135], [-122.23642, 37.84134], [-122.23663, 37.84122], [-122.23693, 37.84111], [-122.23724, 37.84105], [-122.23771, 37.84106]]]} | Open Access 1 | 13247 | Ostrander Park | 23239 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.351 | Ostrander Park | 0 | Local Park 2 | 4 |
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]);