superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
247 rows where ACCESS_TYP = 1, MNG_AGENCY = 32 and MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 247 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
755 | 755 | 754 | {"type": "Polygon", "coordinates": [[[-121.76254, 37.23459], [-121.76238, 37.23464], [-121.76214, 37.23468], [-121.76176, 37.23467], [-121.76139, 37.2346], [-121.76113, 37.23452], [-121.76089, 37.23442], [-121.76079, 37.23435], [-121.76074, 37.23429], [-121.76057, 37.23396], [-121.76026, 37.23346], [-121.76025, 37.23341], [-121.76027, 37.23335], [-121.76055, 37.23309], [-121.7607, 37.23289], [-121.76079, 37.2328], [-121.76216, 37.23362], [-121.76225, 37.23369], [-121.76233, 37.23382], [-121.7625, 37.23451], [-121.76254, 37.23459]]]} | Open Access 1 | Metcalf Park | http://www.sanjoseca.gov/Facilities/Facility/Details/Metcalf-Park-155 | 11189 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.208 | Metcalf Park | |
834 | 834 | 833 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | San Antonio Tot Lot | https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | 33564 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.09 | San Antonio Tot Lot | |
1369 | 1369 | 1368 | {"type": "Polygon", "coordinates": [[[-121.86306, 37.37599], [-121.86238, 37.37595], [-121.86229, 37.3748], [-121.86297, 37.37489], [-121.86306, 37.37599]]]} | Open Access 1 | Berryessa Community Garden | 16035 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.84 | Berryessa Community Garden | ||
1750 | 1750 | 1749 | {"type": "Polygon", "coordinates": [[[-121.87741, 37.32001], [-121.87733, 37.32006], [-121.8769, 37.31949], [-121.8769, 37.31949], [-121.87741, 37.32001]]]} | Open Access 1 | Caldwallder Park | 16674 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.082 | Caldwallder Park | ||
1755 | 1755 | 1754 | {"type": "MultiPolygon", "coordinates": [[[[-121.81736, 37.31364], [-121.8153, 37.31502], [-121.81397, 37.31591], [-121.81404, 37.31557], [-121.81408, 37.31554], [-121.81431, 37.31549], [-121.81447, 37.31539], [-121.81459, 37.31525], [-121.81465, 37.31511], [-121.81476, 37.31501], [-121.81492, 37.31494], [-121.81519, 37.31489], [-121.81535, 37.31481], [-121.81609, 37.31431], [-121.81679, 37.31386], [-121.81692, 37.31374], [-121.81701, 37.31356], [-121.81708, 37.31349], [-121.81717, 37.31348], [-121.81725, 37.31354], [-121.81727, 37.31354], [-121.81736, 37.31364]]], [[[-121.8212, 37.31105], [-121.8176, 37.31346], [-121.8174, 37.31329], [-121.81739, 37.31326], [-121.81741, 37.31321], [-121.81755, 37.31312], [-121.81769, 37.31306], [-121.81803, 37.31296], [-121.8182, 37.31289], [-121.81946, 37.31205], [-121.81964, 37.31188], [-121.81983, 37.3116], [-121.82001, 37.31145], [-121.8202, 37.31136], [-121.82077, 37.31116], [-121.82105, 37.311], [-121.82113, 37.311], [-121.8212, 37.31105]]]]} | Open Access 1 | Barberry Pathway | 15808 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.881 | Barberry Pathway | ||
1934 | 1934 | 1933 | {"type": "Polygon", "coordinates": [[[-121.87386, 37.3113], [-121.87152, 37.31279], [-121.87136, 37.31263], [-121.87365, 37.31109], [-121.87386, 37.3113]]]} | Open Access 1 | Bellevue Park | 15987 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.763 | Bellevue Park | ||
2147 | 2147 | 2146 | {"type": "Polygon", "coordinates": [[[-121.8579, 37.34324], [-121.8574, 37.34356], [-121.85695, 37.3431], [-121.85708, 37.34304], [-121.8573, 37.34296], [-121.85745, 37.34288], [-121.8575, 37.34287], [-121.85754, 37.34289], [-121.8579, 37.34324]]]} | Open Access 1 | Bonita Park | 16263 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.825 | Bonita Park | ||
2255 | 2255 | 2254 | {"type": "Polygon", "coordinates": [[[-121.8035, 37.30682], [-121.80348, 37.30687], [-121.80342, 37.30691], [-121.80274, 37.30716], [-121.80239, 37.30728], [-121.80198, 37.30736], [-121.80174, 37.30745], [-121.80173, 37.30741], [-121.8018, 37.3073], [-121.80176, 37.30725], [-121.80189, 37.30719], [-121.80193, 37.30712], [-121.80193, 37.30707], [-121.80181, 37.30689], [-121.80211, 37.30675], [-121.80218, 37.30659], [-121.80224, 37.3065], [-121.80199, 37.30552], [-121.80308, 37.30536], [-121.80312, 37.30539], [-121.8035, 37.30682]]]} | Open Access 1 | Brigadoon Park | 16387 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.431 | Brigadoon Park | ||
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25097], [-121.93856, 37.25136], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93847, 37.25158], [-121.93834, 37.25157], [-121.93822, 37.25152], [-121.93802, 37.25154], [-121.93796, 37.25148], [-121.93794, 37.25145], [-121.93794, 37.25078], [-121.93797, 37.25073], [-121.93804, 37.2507], [-121.9386, 37.2507], [-121.9386, 37.25096]]]} | Open Access 1 | Carolyn Norris Park | 16888 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.303 | Carolyn Norris Park | ||
2707 | 2707 | 2706 | {"type": "Polygon", "coordinates": [[[-121.84745, 37.20134], [-121.84565, 37.20254], [-121.84563, 37.20249], [-121.84558, 37.20246], [-121.84551, 37.20245], [-121.84545, 37.20247], [-121.84542, 37.20251], [-121.84542, 37.20256], [-121.84544, 37.2026], [-121.84551, 37.20264], [-121.8452, 37.20285], [-121.84461, 37.20322], [-121.8433, 37.20177], [-121.84341, 37.20185], [-121.84347, 37.20186], [-121.84352, 37.20184], [-121.84355, 37.2018], [-121.84354, 37.20175], [-121.84342, 37.20169], [-121.84517, 37.20043], [-121.84539, 37.20021], [-121.84556, 37.19995], [-121.84566, 37.20001], [-121.84567, 37.20007], [-121.84573, 37.20011], [-121.84578, 37.20011], [-121.84589, 37.20008], [-121.84634, 37.20012], [-121.8466, 37.20018], [-121.84684, 37.20031], [-121.8472, 37.20066], [-121.84718, 37.20071], [-121.8472, 37.20078], [-121.84745, 37.20134]]]} | Open Access 1 | Cathedral Oaks Park | 16975 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 16.969 | Cathedral Oaks Park | ||
2857 | 2857 | 2856 | {"type": "Polygon", "coordinates": [[[-121.80092, 37.24396], [-121.80092, 37.24396], [-121.7994, 37.24355], [-121.7995, 37.24329], [-121.80074, 37.24363], [-121.80084, 37.24368], [-121.8009, 37.24376], [-121.80092, 37.24396]]]} | Open Access 1 | Charlotte Commons | 17148 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.001 | Charlotte Commons | ||
3124 | 3124 | 3123 | {"type": "MultiPolygon", "coordinates": [[[[-121.9093, 37.34496], [-121.9093, 37.34499], [-121.90788, 37.34598], [-121.9071, 37.34525], [-121.90708, 37.3452], [-121.90843, 37.34425], [-121.90847, 37.34424], [-121.90854, 37.34426], [-121.90928, 37.34492], [-121.9093, 37.34496]]], [[[-121.91054, 37.34412], [-121.90959, 37.34479], [-121.90952, 37.34481], [-121.90945, 37.34479], [-121.90871, 37.34414], [-121.90869, 37.34409], [-121.90872, 37.34405], [-121.90972, 37.34339], [-121.90975, 37.34339], [-121.91054, 37.34412]]]]} | Open Access 1 | Columbus Park | 17551 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.016 | Columbus Park | ||
3263 | 3263 | 3262 | {"type": "Polygon", "coordinates": [[[-121.86861, 37.32876], [-121.86825, 37.32896], [-121.8683, 37.3293], [-121.86784, 37.32956], [-121.86752, 37.32953], [-121.86745, 37.32955], [-121.86733, 37.3296], [-121.86707, 37.32975], [-121.86612, 37.33033], [-121.86517, 37.33096], [-121.8641, 37.33176], [-121.86176, 37.3332], [-121.86128, 37.33275], [-121.86155, 37.33211], [-121.86466, 37.3299], [-121.86398, 37.32817], [-121.86392, 37.32808], [-121.86373, 37.3281], [-121.86339, 37.32806], [-121.86324, 37.32814], [-121.86244, 37.32808], [-121.8616, 37.32794], [-121.86136, 37.32787], [-121.86175, 37.32769], [-121.8618, 37.3277], [-121.86324, 37.32704], [-121.86358, 37.32687], [-121.86417, 37.32662], [-121.86473, 37.32635], [-121.8647, 37.32633], [-121.86558, 37.32598], [-121.86562, 37.32619], [-121.86614, 37.32637], [-121.86631, 37.32641], [-121.86749, 37.32758], [-121.86836, 37.32846], [-121.86861, 37.32876]]]} | Open Access 1 | Coyote Creek Parkchain | 17739 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 48.997 | Coyote Creek Parkchain | ||
3272 | 3272 | 3271 | {"type": "Polygon", "coordinates": [[[-121.85504, 37.31493], [-121.85363, 37.31586], [-121.85394, 37.31607], [-121.8543, 37.31623], [-121.85453, 37.31642], [-121.85461, 37.31658], [-121.85445, 37.31665], [-121.85458, 37.31695], [-121.8546, 37.31739], [-121.85467, 37.31745], [-121.85459, 37.31752], [-121.85452, 37.31752], [-121.85442, 37.31764], [-121.8527, 37.31876], [-121.85175, 37.31941], [-121.85185, 37.31914], [-121.85188, 37.31865], [-121.85183, 37.31831], [-121.8516, 37.31773], [-121.85171, 37.31746], [-121.85158, 37.31703], [-121.8514, 37.31667], [-121.85079, 37.31652], [-121.84977, 37.31696], [-121.84901, 37.31766], [-121.84836, 37.31805], [-121.84693, 37.31777], [-121.84644, 37.3174], [-121.84633, 37.31727], [-121.84665, 37.31705], [-121.8465, 37.3166], [-121.84646, 37.3159], [-121.84642, 37.31575], [-121.8461, 37.31501], [-121.8459, 37.3143], [-121.84574, 37.31409], [-121.84536, 37.31386], [-121.84385, 37.31327], [-121.84309, 37.31261], [-121.84276, 37.31197], [-121.8424, 37.31155], [-121.84415, 37.31039], [-121.84419, 37.31049], [-121.84432, 37.31042], [-121.84442, 37.31062], [-121.84441, 37.31099], [-121.84452, 37.31122], [-121.8447, 37.31142], [-121.84459, 37.31149], [-121.84416, 37.31191], [-121.84409, 37.31207], [-121.84407, 37.3122], [-121.84411, 37.31234], [-121.84419, 37.31246], [-121.84437, 37.31257], [-121.84497, 37.31281], [-121.8452, 37.31294], [-121.84529, 37.31303], [-121.84533, 37.31299], [-121.84563, 37.31308], [-121.84574, 37.31317], [-121.8458, 37.31315], [-121.84602, 37.31327], [-121.8461, 37.31328], [-121.8462, 37.31332], [-121.84658, 37.31343], [-121.84692, 37.31356], [-121.84697, 37.31357], [-121.84766, 37.31475], [-121.84764, 37.31497], [-121.84771, 37.31508], [-121.84776, 37.31542], [-121.84775, 37.31559], [-121.84777, 37.31566], [-121.84775, 37.31568], [-121.84776, 37.31575], [-121.84775, 37.31581], [-121.84778, 37.31594], [-121.8479, 37.3161], [-121.84815, 37.31621], [-121.84838, 37.31626], [-121.84865, 37.31629], [-121.84892, 37.31627], [-121.84912, 37.31622], [-121.84939, 37.31605], [-121.84985, 37.31584], [-121.85023, 37.3156], [-121.85106, 37.31535], [-121.85176, 37.3151], [-121.85212, 37.31495], [-121.85245, 37.31494], [-121.85297, 37.31454], [-121.85402, 37.31395], [-121.85504, 37.31493]]]} | Open Access 1 | Coyote Creek Park | 17738 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 65.957 | Coyote Creek Park | ||
4173 | 4173 | 4172 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.304], [-121.7721, 37.30412], [-121.77199, 37.30358], [-121.77225, 37.30356], [-121.77279, 37.30349], [-121.77279, 37.30354], [-121.77283, 37.3036], [-121.77292, 37.304]]]} | Open Access 1 | Falls Creek Park | 18838 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.053 | Falls Creek Park | ||
4256 | 4256 | 4255 | {"type": "Polygon", "coordinates": [[[-121.81856, 37.37389], [-121.81827, 37.37437], [-121.81801, 37.37427], [-121.81798, 37.37424], [-121.81797, 37.37419], [-121.81809, 37.374], [-121.81822, 37.37388], [-121.81829, 37.37378], [-121.81856, 37.37389]]]} | Open Access 1 | Fleming Park | 18944 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.445 | Fleming Park | ||
4564 | 4564 | 4563 | {"type": "Polygon", "coordinates": [[[-121.96308, 37.29872], [-121.96265, 37.29819], [-121.96239, 37.29789], [-121.96265, 37.2979], [-121.96266, 37.29797], [-121.9628, 37.29824], [-121.96308, 37.29872]]]} | Open Access 1 | Gleason Park | 19311 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.215 | Gleason Park | ||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.89165, 37.39015], [-121.89165, 37.39019], [-121.89118, 37.39055], [-121.8907, 37.39015], [-121.89062, 37.39011], [-121.89063, 37.39006], [-121.89058, 37.39004], [-121.89058, 37.39001], [-121.89066, 37.38996], [-121.8907, 37.38986], [-121.891, 37.38967], [-121.89106, 37.38966], [-121.8911, 37.38967], [-121.89165, 37.39015]]]} | Open Access 1 | Gran Paradiso Park | 19416 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.238 | Gran Paradiso Park | ||
4728 | 4728 | 4727 | {"type": "Polygon", "coordinates": [[[-121.97282, 37.30461], [-121.97236, 37.30462], [-121.97234, 37.30457], [-121.97223, 37.30457], [-121.97221, 37.3038], [-121.97282, 37.3038], [-121.97282, 37.30461]]]} | Open Access 1 | Green Thumb Community Garden | 19467 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.174 | Green Thumb Community Garden | ||
4798 | 4798 | 4797 | {"type": "MultiPolygon", "coordinates": [[[[-121.90397, 37.34203], [-121.90269, 37.34294], [-121.90249, 37.34308], [-121.90226, 37.34254], [-121.90227, 37.34201], [-121.90224, 37.34179], [-121.90229, 37.3414], [-121.90234, 37.34138], [-121.9023, 37.34168], [-121.90264, 37.34146], [-121.90297, 37.34174], [-121.90337, 37.34147], [-121.90397, 37.34203]]], [[[-121.90391, 37.34388], [-121.90321, 37.34435], [-121.903, 37.34414], [-121.90284, 37.34392], [-121.90256, 37.34325], [-121.90293, 37.34299], [-121.90391, 37.34388]]], [[[-121.90512, 37.34306], [-121.90407, 37.34377], [-121.90308, 37.34288], [-121.90411, 37.34215], [-121.90512, 37.34306]]], [[[-121.90518, 37.34118], [-121.90413, 37.34192], [-121.90341, 37.34126], [-121.90339, 37.34122], [-121.9034, 37.34117], [-121.90344, 37.34114], [-121.90364, 37.34109], [-121.90415, 37.34099], [-121.90487, 37.3409], [-121.90518, 37.34118]]], [[[-121.90478, 37.34466], [-121.90413, 37.34511], [-121.9034, 37.34451], [-121.90409, 37.34404], [-121.90478, 37.34466]]], [[[-121.90598, 37.34384], [-121.90494, 37.34455], [-121.90425, 37.34393], [-121.9053, 37.34323], [-121.90598, 37.34384]]], [[[-121.90634, 37.34222], [-121.90528, 37.34296], [-121.90427, 37.34204], [-121.90532, 37.34131], [-121.90634, 37.34222]]], [[[-121.90587, 37.34564], [-121.90522, 37.34609], [-121.90516, 37.34604], [-121.90503, 37.34613], [-121.90482, 37.34598], [-121.90474, 37.34591], [-121.90467, 37.34581], [-121.90456, 37.34558], [-121.90447, 37.34544], [-121.90428, 37.34522], [-121.90492, 37.34478], [-121.90587, 37.34564]]], [[[-121.90708, 37.34484], [-121.90705, 37.34488], [-121.90603, 37.34554], [-121.90507, 37.34468], [-121.90612, 37.34396], [-121.90706, 37.34481], [-121.90708, 37.34484]]], [[[-121.90715, 37.34164], [-121.90652, 37.34209], [-121.90543, 37.34112], [-121.90579, 37.34087], [-121.90583, 37.34087], [-121.90621, 37.34121], [-121.90635, 37.34112], [-121.90667, 37.34141], [-121.90693, 37.34124], [-121.90707, 37.34137], [-121.90696, 37.34147], [-121.90715, 37.34164]]], [[[-121.90801, 37.34242], [-121.90751, 37.34279], [-121.90718, 37.34248], [-121.90703, 37.34257], [-121.9067, 37.34226], [-121.90721, 37.3419], [-121.90754, 37.3422], [-121.90768, 37.34212], [-121.90801, 37.34242]]]]} | Open Access 1 | Guadalupe River Park | 19558 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 31.418 | Guadalupe River 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]);