superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by SUID_NMA descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10045 | 10045 | 10044 | {"type": "Polygon", "coordinates": [[[-122.19977, 37.82048], [-122.19936, 37.82094], [-122.19938, 37.82098], [-122.19928, 37.82103], [-122.19889, 37.82132], [-122.19882, 37.82144], [-122.19875, 37.82171], [-122.19871, 37.82178], [-122.19864, 37.82183], [-122.19856, 37.82187], [-122.19847, 37.82189], [-122.19843, 37.82188], [-122.19842, 37.82184], [-122.19854, 37.82149], [-122.19859, 37.8214], [-122.19871, 37.82126], [-122.19894, 37.8211], [-122.19907, 37.82097], [-122.19915, 37.82085], [-122.19933, 37.82044], [-122.19942, 37.82031], [-122.19945, 37.82028], [-122.19977, 37.82048]]]} | Open Access 1 | Sulfur Springs Park | 25947 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.102 | Sulfur Springs Park | ||
10000 | 10000 | 9999 | {"type": "Polygon", "coordinates": [[[-122.17595, 37.73669], [-122.1741, 37.73813], [-122.17386, 37.73782], [-122.1751, 37.73686], [-122.17502, 37.73674], [-122.17482, 37.73661], [-122.17463, 37.73664], [-122.17449, 37.73644], [-122.17449, 37.73639], [-122.1747, 37.73626], [-122.1752, 37.73597], [-122.17568, 37.73635], [-122.17561, 37.73642], [-122.17595, 37.73669]]]} | Open Access 1 | Stonehurst Park | 25890 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.475 | Stonehurst Park | ||
9564 | 9564 | 9563 | {"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 | St Andrews Plaza | 25761 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.078 | St Andrews Plaza | ||
9858 | 9858 | 9857 | {"type": "Polygon", "coordinates": [[[-122.24828, 37.81065], [-122.24821, 37.81073], [-122.24813, 37.81081], [-122.24789, 37.81123], [-122.24786, 37.81123], [-122.2478, 37.81119], [-122.2476, 37.81094], [-122.24756, 37.81081], [-122.24751, 37.81058], [-122.24749, 37.81051], [-122.24738, 37.81039], [-122.24747, 37.81042], [-122.24776, 37.81058], [-122.24792, 37.81064], [-122.24804, 37.81067], [-122.24828, 37.81065]]]} | Open Access 1 | Splash Pad Park | 25726 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.705 | Splash Pad Park | ||
9815 | 9815 | 9814 | {"type": "Polygon", "coordinates": [[[-122.30053, 37.80331], [-122.30039, 37.80354], [-122.29548, 37.80242], [-122.29654, 37.80233], [-122.29877, 37.80267], [-122.30053, 37.80331]]]} | Open Access 1 | South Prescott Park | 25676 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.268 | South Prescott Park | ||
9752 | 9752 | 9751 | {"type": "Polygon", "coordinates": [[[-122.17764, 37.72612], [-122.17735, 37.72742], [-122.17733, 37.72744], [-122.17726, 37.72744], [-122.17601, 37.72728], [-122.17597, 37.72726], [-122.17595, 37.72722], [-122.1762, 37.72594], [-122.17764, 37.72612]]]} | Open Access 1 | Sobrante Park | 25587 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.682 | Sobrante Park | ||
9749 | 9749 | 9748 | {"type": "Polygon", "coordinates": [[[-122.26527, 37.8064], [-122.26438, 37.80782], [-122.26436, 37.80783], [-122.26403, 37.80765], [-122.26391, 37.80756], [-122.26381, 37.80745], [-122.26359, 37.8071], [-122.26427, 37.806], [-122.26527, 37.8064]]]} | Open Access 1 | Snow Park | 25584 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.986 | Snow Park | ||
9598 | 9598 | 9597 | {"type": "MultiPolygon", "coordinates": [[[[-122.19936, 37.82584], [-122.19917, 37.82609], [-122.199, 37.82594], [-122.19853, 37.82587], [-122.19831, 37.82559], [-122.19801, 37.82546], [-122.19786, 37.82564], [-122.19758, 37.8256], [-122.19729, 37.82562], [-122.19726, 37.82559], [-122.19736, 37.82553], [-122.19793, 37.82537], [-122.19818, 37.82532], [-122.19836, 37.82531], [-122.19845, 37.82534], [-122.19855, 37.82546], [-122.19866, 37.82552], [-122.19875, 37.82553], [-122.19886, 37.82551], [-122.19906, 37.82551], [-122.19916, 37.82554], [-122.19922, 37.8256], [-122.19936, 37.82584]]], [[[-122.20188, 37.82431], [-122.20182, 37.82454], [-122.20184, 37.82475], [-122.20191, 37.82496], [-122.20204, 37.82517], [-122.20209, 37.82529], [-122.20224, 37.82591], [-122.20224, 37.82612], [-122.20218, 37.82644], [-122.20218, 37.82661], [-122.20221, 37.82683], [-122.2022, 37.82698], [-122.20216, 37.82714], [-122.20194, 37.82763], [-122.2016, 37.82826], [-122.2014, 37.82856], [-122.20118, 37.82881], [-122.20087, 37.82862], [-122.20092, 37.82854], [-122.201, 37.82834], [-122.20117, 37.82809], [-122.20118, 37.82798], [-122.20112, 37.82785], [-122.20111, 37.8278], [-122.20113, 37.82775], [-122.20123, 37.82764], [-122.20124, 37.82754], [-122.20122, 37.82749], [-122.20109, 37.82732], [-122.20102, 37.82728], [-122.20086, 37.82722], [-122.20084, 37.82719], [-122.20101, 37.827], [-122.20117, 37.82694], [-122.20129, 37.82688], [-122.2014, 37.82679], [-122.20144, 37.82672], [-122.20144, 37.82663], [-122.20137, 37.82653], [-122.20127, 37.82645], [-122.20111, 37.82636], [-122.20105, 37.82629], [-122.20107, 37.82619], [-122.2012, 37.82608], [-122.20125, 37.82599], [-122.20126, 37.8259], [-122.2012, 37.82579], [-122.20076, 37.82541], [-122.20059, 37.82534], [-122.20039, 37.82531], [-122.20021, 37.82534], [-122.20003, 37.82542], [-122.19993, 37.8255], [-122.19978, 37.82569], [-122.19966, 37.82581], [-122.19962, 37.82583], [-122.19958, 37.82583], [-122.19952, 37.8258], [-122.19935, 37.8255], [-122.19921, 37.82541], [-122.19909, 37.82538], [-122.19879, 37.82537], [-122.19875, 37.82535], [-122.19871, 37.82527], [-122.19866, 37.82522], [-122.19857, 37.82518], [-122.19848, 37.82516], [-122.19805, 37.8252], [-122.19764, 37.8253], [-122.19752, 37.82502], [-122.19772, 37.82486], [-122.19786, 37.82479], [-122.198, 37.82476], [-122.19825, 37.82474], [-122.19842, 37.82468], [-122.19854, 37.82461], [-122.19868, 37.82446], [-122.19884, 37.8244], [-122.19916, 37.82418], [-122.19923, 37.82415], [-122.19942, 37.82411], [-122.19957, 37.82447], [-122.19972, 37.82443], [-122.19965, 37.8241], [-122.19972, 37.82415], [-122.19979, 37.82417], [-122.19987, 37.82418], [-122.19994, 37.82416], [-122.20004, 37.82439], [-122.20034, 37.82433], [-122.20024, 37.82401], [-122.20029, 37.82399], [-122.20055, 37.82399], [-122.20064, 37.82396], [-122.20091, 37.82424], [-122.20142, 37.82393], [-122.20188, 37.82431]]], [[[-122.20072, 37.82856], [-122.20067, 37.82861], [-122.20051, 37.82868], [-122.2004, 37.82877], [-122.20033, 37.82886], [-122.20028, 37.82899], [-122.20023, 37.82905], [-122.19996, 37.8292], [-122.19964, 37.82941], [-122.19958, 37.82946], [-122.19949, 37.8296], [-122.19934, 37.82967], [-122.19893, 37.82998], [-122.19885, 37.83005], [-122.19878, 37.8302], [-122.19868, 37.83029], [-122.19848, 37.83037], [-122.1982, 37.82998], [-122.19835, 37.82991], [-122.19871, 37.82954], [-122.19961, 37.82885], [-122.20019, 37.82851], [-122.2003, 37.8284], [-122.20072, 37.82856]]], [[[-122.20115, 37.82883], [-122.20091, 37.82905], [-122.20057, 37.82929], [-122.19975, 37.8297], [-122.19971, 37.8297], [-122.19968, 37.82968], [-122.19968, 37.8296], [-122.19974, 37.82952], [-122.20006, 37.82931], [-122.20035, 37.82915], [-122.20043, 37.82907], [-122.20049, 37.82892], [-122.20055, 37.82884], [-122.20061, 37.8288], [-122.20077, 37.82872], [-122.20086, 37.82865], [-122.20115, 37.82883]]], [[[-122.20127, 37.82668], [-122.20126, 37.82671], [-122.20114, 37.82679], [-122.20094, 37.82687], [-122.20088, 37.8269], [-122.2007, 37.82709], [-122.20066, 37.82717], [-122.20067, 37.82723], [-122.20071, 37.8273], [-122.20078, 37.82735], [-122.20095, 37.82741], [-122.20107, 37.82756], [-122.20107, 37.8276], [-122.20097, 37.8277], [-122.20094, 37.82778], [-122.20095, 37.82787], [-122.20101, 37.828], [-122.201, 37.82807], [-122.20084, 37.82829], [-122.20073, 37.82853], [-122.20032, 37.82838], [-122.20044, 37.82825], [-122.20054, 37.82788], [-122.20049, 37.82771], [-122.2002, 37.8274], [-122.20006, 37.82742], [-122.20025, 37.82706], [-122.20065, 37.82658], [-122.20121, 37.82659], [-122.20127, 37.82668]]], [[[-122.20352, 37.82221], [-122.20326, 37.82242], [-122.20333, 37.82334], [-122.20314, 37.8234], [-122.20292, 37.82386], [-122.20261, 37.82413], [-122.20219, 37.82473], [-122.20243, 37.82513], [-122.20245, 37.8253], [-122.20259, 37.82586], [-122.20247, 37.82625], [-122.20244, 37.82626], [-122.20243, 37.82624], [-122.20246, 37.82599], [-122.20243, 37.82579], [-122.20229, 37.82524], [-122.20223, 37.82511], [-122.20211, 37.8249], [-122.20205, 37.82475], [-122.20203, 37.82462], [-122.20204, 37.8245], [-122.20209, 37.82435], [-122.20217, 37.82421], [-122.20285, 37.82358], [-122.20291, 37.82346], [-122.20299, 37.82319], [-122.20288, 37.82322], [-122.20279, 37.82317], [-122.20271, 37.82343], [-122.20266, 37.8235], [-122.20204, 37.82408], [-122.20189, 37.82428], [-122.20145, 37.82392], [-122.2019, 37.82367], [-122.20251, 37.82291], [-122.20225, 37.82267], [-122.20201, 37.82238], [-122.20194, 37.82221], [-122.20221, 37.82167], [-122.20267, 37.8217], [-122.20276, 37.82172], [-122.20329, 37.82203], [-122.20352, 37.82221]]]]} | Open Access 1 | Shepherd Canyon Park | 25390 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 33.088 | Shepherd Canyon Park | ||
9581 | 9581 | 9580 | {"type": "Polygon", "coordinates": [[[-122.13519, 37.73486], [-122.13502, 37.73508], [-122.13467, 37.73497], [-122.13464, 37.73502], [-122.13371, 37.73467], [-122.13363, 37.73477], [-122.13324, 37.73463], [-122.13349, 37.73412], [-122.13443, 37.73429], [-122.13485, 37.73432], [-122.13486, 37.7344], [-122.135, 37.73447], [-122.13484, 37.7347], [-122.13519, 37.73486]]]} | Open Access 1 | Sheffield Village Park | 25383 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.447 | Sheffield Village Park | ||
9242 | 9242 | 9241 | {"type": "Polygon", "coordinates": [[[-122.22637, 37.78087], [-122.226, 37.78126], [-122.22441, 37.78073], [-122.22462, 37.78033], [-122.22637, 37.78087]]]} | Open Access 1 | Sanborn Park | 25005 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.968 | Sanborn Park | 2000 | |
9153 | 9153 | 9152 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.79003], [-122.24099, 37.79152], [-122.23911, 37.7904], [-122.24053, 37.78891], [-122.24241, 37.79003]]]} | Open Access 1 | San Antonio Park | 24832 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 10.618 | San Antonio Park | ||
8872 | 8872 | 8871 | {"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 | Rockridge Park | 24533 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.248 | Rockridge Park | ||
8466 | 8466 | 8465 | {"type": "Polygon", "coordinates": [[[-122.29549, 37.81605], [-122.29454, 37.81724], [-122.29214, 37.81603], [-122.29309, 37.81485], [-122.29549, 37.81605]]]} | Open Access 1 | Raimondi Park | 24081 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.659 | Raimondi Park | ||
8307 | 8307 | 8306 | {"type": "Polygon", "coordinates": [[[-122.28464, 37.82278], [-122.28462, 37.82284], [-122.2835, 37.82424], [-122.2833, 37.82419], [-122.28387, 37.82261], [-122.28464, 37.82278]]]} | Open Access 1 | Poplar Park | 23893 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.036 | Poplar Park | ||
8171 | 8171 | 8170 | {"type": "Polygon", "coordinates": [[[-122.17517, 37.79591], [-122.17479, 37.79667], [-122.17463, 37.79685], [-122.17459, 37.79689], [-122.17386, 37.79706], [-122.1738, 37.79704], [-122.1739, 37.7965], [-122.17369, 37.796], [-122.17347, 37.79585], [-122.17326, 37.79579], [-122.17315, 37.79564], [-122.1737, 37.79569], [-122.17396, 37.79587], [-122.17462, 37.79574], [-122.17488, 37.79576], [-122.17517, 37.79591]]]} | Open Access 1 | Pinto Park | 23708 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.421 | Pinto Park | 1961 | |
8147 | 8147 | 8146 | {"type": "Polygon", "coordinates": [[[-122.25431, 37.80143], [-122.25437, 37.80161], [-122.25436, 37.80178], [-122.25413, 37.80225], [-122.25408, 37.80231], [-122.254, 37.80238], [-122.25392, 37.80242], [-122.2538, 37.80244], [-122.2537, 37.80244], [-122.2536, 37.80242], [-122.25338, 37.8023], [-122.25319, 37.80214], [-122.25378, 37.80196], [-122.25365, 37.80159], [-122.25431, 37.80143]]]} | Open Access 1 | Pine Knoll Park | 23681 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.512 | Pine Knoll Park | ||
6879 | 6879 | 6878 | {"type": "Polygon", "coordinates": [[[-122.26083, 37.79699], [-122.26049, 37.79764], [-122.26059, 37.79773], [-122.26034, 37.79816], [-122.25893, 37.7976], [-122.25923, 37.79742], [-122.25918, 37.79672], [-122.25933, 37.79648], [-122.25931, 37.79641], [-122.25951, 37.7963], [-122.25963, 37.79638], [-122.25966, 37.7965], [-122.26083, 37.79699]]]} | Open Access 1 | Peralta Park | 23606 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.695 | Peralta Park | ||
8088 | 8088 | 8087 | {"type": "Polygon", "coordinates": [[[-122.21827, 37.78703], [-122.21759, 37.78792], [-122.21721, 37.78774], [-122.21707, 37.78791], [-122.21677, 37.78776], [-122.21691, 37.78758], [-122.21691, 37.78755], [-122.21686, 37.78754], [-122.21679, 37.78753], [-122.21672, 37.78756], [-122.21668, 37.78759], [-122.21634, 37.78742], [-122.21601, 37.78783], [-122.21591, 37.78778], [-122.21611, 37.78751], [-122.21583, 37.78727], [-122.21609, 37.78707], [-122.21607, 37.78703], [-122.21646, 37.78673], [-122.21639, 37.78664], [-122.21667, 37.78643], [-122.21681, 37.78654], [-122.21684, 37.78653], [-122.21697, 37.78659], [-122.21684, 37.78678], [-122.21733, 37.78702], [-122.2176, 37.7867], [-122.21827, 37.78703]]]} | Open Access 1 | Peralta Hacienda Park | 23605 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.513 | Peralta Hacienda Park | ||
7947 | 7947 | 7946 | {"type": "Polygon", "coordinates": [[[-122.24759, 37.80067], [-122.24699, 37.80102], [-122.24645, 37.80127], [-122.24607, 37.80138], [-122.24606, 37.80136], [-122.24737, 37.80046], [-122.24759, 37.80067]]]} | Open Access 1 | Park Boulevard Plaza Park | 23426 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.789 | Park Boulevard Plaza Park | ||
7788 | 7788 | 7787 | {"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 | Ostrander Park | 23239 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.35 | Ostrander 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]);