superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3967 | 3967 | 3966 | {"type": "Polygon", "coordinates": [[[-122.17538, 37.74328], [-122.17464, 37.74363], [-122.17402, 37.74281], [-122.17476, 37.74246], [-122.17538, 37.74328]]]} | Open Access 1 | Elmhurst Plaza | 18598 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.01 | Elmhurst Plaza | ||
4075 | 4075 | 4074 | {"type": "Polygon", "coordinates": [[[-122.2692, 37.78832], [-122.26784, 37.7905], [-122.26674, 37.79006], [-122.26651, 37.79041], [-122.26597, 37.79022], [-122.26578, 37.79011], [-122.26541, 37.79026], [-122.26406, 37.79116], [-122.26367, 37.7911], [-122.26364, 37.79113], [-122.2627, 37.79097], [-122.26272, 37.79082], [-122.26329, 37.79083], [-122.26769, 37.78754], [-122.26822, 37.78774], [-122.2692, 37.78832]]]} | Open Access 1 | Estuary Park | 18732 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 20.671 | Estuary Park | ||
4251 | 4251 | 4250 | {"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 | Fitzgerald Park | 18930 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.225 | Fitzgerald Park | ||
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19032, 37.73605], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} | Open Access 1 | Ira Jenkins Park | 20226 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 15.164 | Ira Jenkins Park | ||
4384 | 4384 | 4383 | {"type": "Polygon", "coordinates": [[[-122.24868, 37.79278], [-122.24791, 37.79333], [-122.24715, 37.79266], [-122.24792, 37.79211], [-122.24868, 37.79278]]]} | Open Access 1 | Franklin Park | 19063 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.247 | Franklin Park | ||
4399 | 4399 | 4398 | {"type": "Polygon", "coordinates": [[[-122.23485, 37.78563], [-122.23432, 37.7862], [-122.23352, 37.78576], [-122.23411, 37.78532], [-122.23485, 37.78563]]]} | Open Access 1 | Garfield Park | 19213 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.445 | Garfield Park | ||
4444 | 4444 | 4443 | {"type": "Polygon", "coordinates": [[[-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], [-122.22949, 37.76963]]]} | Open Access 1 | Fruitvale Bridge Park | 19137 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.269 | Fruitvale Bridge Park | ||
4477 | 4477 | 4476 | {"type": "Polygon", "coordinates": [[[-122.24086, 37.86105], [-122.2407, 37.86115], [-122.24054, 37.86122], [-122.23942, 37.86156], [-122.23912, 37.86183], [-122.2385, 37.86195], [-122.2379, 37.86217], [-122.23746, 37.86261], [-122.23669, 37.86293], [-122.23628, 37.86296], [-122.23574, 37.86316], [-122.23532, 37.86319], [-122.23511, 37.86136], [-122.23714, 37.86126], [-122.23726, 37.86127], [-122.23739, 37.86124], [-122.24086, 37.86105]]]} | Open Access 1 | Garber Park | 19189 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 13.847 | Garber Park | ||
4520 | 4520 | 4519 | {"type": "MultiPolygon", "coordinates": [[[[-122.22488, 37.85002], [-122.22487, 37.85037], [-122.22479, 37.85056], [-122.22471, 37.85063], [-122.22424, 37.8507], [-122.22404, 37.851], [-122.22409, 37.85133], [-122.22453, 37.85173], [-122.22447, 37.8518], [-122.22419, 37.85183], [-122.22365, 37.85195], [-122.22346, 37.85216], [-122.22344, 37.85262], [-122.22355, 37.85292], [-122.224, 37.85341], [-122.22399, 37.85345], [-122.22339, 37.85357], [-122.22299, 37.85382], [-122.223, 37.85416], [-122.2232, 37.8546], [-122.2233, 37.85488], [-122.22344, 37.85497], [-122.22335, 37.85498], [-122.2232, 37.85495], [-122.22293, 37.85478], [-122.22262, 37.85474], [-122.22227, 37.85488], [-122.22198, 37.85486], [-122.22162, 37.85509], [-122.22121, 37.85495], [-122.22117, 37.85484], [-122.22153, 37.85474], [-122.22182, 37.85462], [-122.22214, 37.85445], [-122.22243, 37.85426], [-122.22262, 37.8541], [-122.22282, 37.8539], [-122.22309, 37.85354], [-122.22332, 37.8536], [-122.22356, 37.85315], [-122.22331, 37.85305], [-122.22337, 37.85278], [-122.22339, 37.85252], [-122.22337, 37.85213], [-122.22332, 37.85192], [-122.22326, 37.85173], [-122.22331, 37.85158], [-122.22339, 37.85144], [-122.22418, 37.8504], [-122.22433, 37.85027], [-122.22447, 37.85018], [-122.2247, 37.85008], [-122.22488, 37.85002]]], [[[-122.22657, 37.85004], [-122.22654, 37.85009], [-122.22647, 37.85014], [-122.22631, 37.85019], [-122.22568, 37.85012], [-122.22565, 37.84991], [-122.22584, 37.8499], [-122.22606, 37.84992], [-122.22653, 37.85], [-122.22657, 37.85004]]]]} | Open Access 1 | Gateway Gardens | 19235 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.656 | Gateway Gardens | ||
4588 | 4588 | 4587 | {"type": "MultiPolygon", "coordinates": [[[[-122.25241, 37.82454], [-122.25213, 37.82477], [-122.25186, 37.82458], [-122.25215, 37.82436], [-122.25241, 37.82454]]], [[[-122.25329, 37.82402], [-122.25266, 37.82457], [-122.25238, 37.82435], [-122.25268, 37.82406], [-122.25276, 37.82412], [-122.25309, 37.82386], [-122.25329, 37.82402]]]]} | Open Access 1 | Glen Echo Park | 19320 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.897 | Glen Echo Park | ||
4624 | 4624 | 4623 | {"type": "Polygon", "coordinates": [[[-122.28429, 37.8453], [-122.28401, 37.84534], [-122.28346, 37.84522], [-122.28281, 37.8452], [-122.28279, 37.84516], [-122.28227, 37.84523], [-122.28208, 37.84463], [-122.284, 37.8444], [-122.28429, 37.8453]]]} | Open Access 1 | Golden Gate Recreation Center | 19360 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.496 | Golden Gate Rec. Ctr. | ||
4742 | 4742 | 4741 | {"type": "Polygon", "coordinates": [[[-122.19545, 37.76061], [-122.19446, 37.76127], [-122.19282, 37.75967], [-122.1938, 37.759], [-122.19545, 37.76061]]]} | Open Access 1 | Greenman Field | 19482 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.433 | Greenman Field | ||
4779 | 4779 | 4778 | {"type": "MultiPolygon", "coordinates": [[[[-122.26828, 37.82304], [-122.26803, 37.82378], [-122.2678, 37.82373], [-122.26765, 37.82361], [-122.26722, 37.82337], [-122.26718, 37.82326], [-122.26743, 37.82313], [-122.26754, 37.82287], [-122.26828, 37.82304]]], [[[-122.26978, 37.82379], [-122.26952, 37.8249], [-122.26929, 37.82574], [-122.26889, 37.82573], [-122.26877, 37.82584], [-122.26874, 37.82598], [-122.26863, 37.82624], [-122.26834, 37.82621], [-122.26843, 37.82585], [-122.26847, 37.82562], [-122.26845, 37.82533], [-122.26847, 37.8252], [-122.26902, 37.82323], [-122.2697, 37.82339], [-122.26961, 37.82373], [-122.26978, 37.82379]]]]} | Open Access 1 | Grove Shafter | 19535 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 7.03 | Grove Shafter | ||
4884 | 4884 | 4883 | {"type": "Polygon", "coordinates": [[[-122.24942, 37.80932], [-122.24938, 37.80939], [-122.24931, 37.80946], [-122.24928, 37.80945], [-122.2488, 37.80985], [-122.2487, 37.8099], [-122.24861, 37.80991], [-122.24845, 37.8099], [-122.24794, 37.80972], [-122.24743, 37.80959], [-122.24735, 37.80954], [-122.24733, 37.80948], [-122.24734, 37.80941], [-122.2474, 37.80935], [-122.24844, 37.80887], [-122.24857, 37.80883], [-122.24867, 37.80882], [-122.24882, 37.80883], [-122.24898, 37.80888], [-122.24937, 37.80917], [-122.24941, 37.80923], [-122.24942, 37.80932]]]} | Open Access 1 | Lakeshore Park | 20973 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.388 | Lakeshore Park | ||
4908 | 4908 | 4907 | {"type": "Polygon", "coordinates": [[[-122.25812, 37.842], [-122.25806, 37.84208], [-122.25715, 37.84239], [-122.25706, 37.84226], [-122.25722, 37.84209], [-122.25728, 37.84206], [-122.2574, 37.84191], [-122.25746, 37.84176], [-122.25754, 37.8418], [-122.2576, 37.84174], [-122.25812, 37.842]]]} | Open Access 1 | Hardy Dog Park | 19677 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.788 | Hardy Dog Park | ||
5006 | 5006 | 5005 | {"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 | Lasear Park | 21074 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.085 | Lasear Park | ||
5015 | 5015 | 5014 | {"type": "Polygon", "coordinates": [[[-122.26926, 37.83718], [-122.26919, 37.8378], [-122.26919, 37.8378], [-122.26883, 37.83723], [-122.26926, 37.83718]]]} | Open Access 1 | Helen McGregor Plaza Park | 19798 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.317 | Helen McGregor Plaza Park | ||
5034 | 5034 | 5033 | {"type": "Polygon", "coordinates": [[[-122.14328, 37.74591], [-122.14195, 37.74665], [-122.14191, 37.74665], [-122.14189, 37.74663], [-122.14177, 37.74666], [-122.14117, 37.74669], [-122.14076, 37.74681], [-122.14056, 37.74658], [-122.1402, 37.74669], [-122.13981, 37.7464], [-122.13983, 37.74622], [-122.13976, 37.74603], [-122.1392, 37.7457], [-122.13899, 37.7455], [-122.13879, 37.74543], [-122.13889, 37.74485], [-122.13872, 37.74464], [-122.14026, 37.7439], [-122.14035, 37.74468], [-122.14109, 37.74459], [-122.14156, 37.74496], [-122.14192, 37.74504], [-122.14328, 37.74591]]]} | Open Access 1 | Hellman Recreation Area | 19807 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 16.584 | Hellman Rec. Area | ||
5244 | 5244 | 5243 | {"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 | Hooly Mini Park | 20077 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.344 | Hooly MP | ||
5479 | 5479 | 5478 | {"type": "Polygon", "coordinates": [[[-122.26763, 37.79791], [-122.26733, 37.7984], [-122.26639, 37.79803], [-122.2667, 37.79755], [-122.26763, 37.79791]]]} | Open Access 1 | Madison Square | 21660 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.377 | Madison Square |
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]);