superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 146
- Restricted Access 5
MNG_AG_TYP 1
- City Agency 151
MNG_AGENCY 1
- San Jose, City of · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5071 | 5071 | 5070 | {"type": "Polygon", "coordinates": [[[-121.90826, 37.34403], [-121.90825, 37.34406], [-121.90731, 37.34471], [-121.90726, 37.34472], [-121.90722, 37.3447], [-121.90628, 37.34386], [-121.90732, 37.34314], [-121.90825, 37.34399], [-121.90826, 37.34403]]]} | Open Access 1 | Heritage Rose Garden | 19864 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.935 | Heritage Rose Garden | ||
5088 | 5088 | 5087 | {"type": "MultiPolygon", "coordinates": [[[[-121.92618, 37.33141], [-121.92528, 37.3321], [-121.92477, 37.33166], [-121.92456, 37.33181], [-121.92442, 37.33181], [-121.92369, 37.33118], [-121.92368, 37.33108], [-121.92405, 37.33081], [-121.92415, 37.33082], [-121.92427, 37.33089], [-121.9246, 37.33088], [-121.92479, 37.33103], [-121.92494, 37.33102], [-121.92533, 37.33071], [-121.92618, 37.33141]]], [[[-121.92624, 37.33214], [-121.92612, 37.33223], [-121.92576, 37.33193], [-121.92588, 37.33184], [-121.92624, 37.33214]]]]} | Open Access 1 | Hester Park | 19884 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.697 | Hester Park | 1996 | |
5189 | 5189 | 5188 | {"type": "Polygon", "coordinates": [[[-121.90718, 37.34301], [-121.90614, 37.34373], [-121.90546, 37.34312], [-121.90653, 37.3424], [-121.90718, 37.34301]]]} | Open Access 1 | Historic Orchard | 20007 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.746 | Historic Orchard | ||
5263 | 5263 | 5262 | {"type": "Polygon", "coordinates": [[[-121.94376, 37.2564], [-121.94373, 37.25649], [-121.94321, 37.25706], [-121.94309, 37.25721], [-121.943, 37.2574], [-121.94296, 37.25752], [-121.94294, 37.25764], [-121.94292, 37.25789], [-121.94181, 37.2579], [-121.94179, 37.25647], [-121.94054, 37.25646], [-121.94054, 37.25582], [-121.94051, 37.25566], [-121.9405, 37.25537], [-121.94076, 37.25537], [-121.94127, 37.25542], [-121.94178, 37.25552], [-121.94227, 37.25557], [-121.9426, 37.25557], [-121.94293, 37.2555], [-121.943, 37.25552], [-121.94325, 37.25587], [-121.94352, 37.25614], [-121.94371, 37.25629], [-121.94376, 37.2564]]]} | Open Access 1 | Houge | 20107 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 11.686 | Houge | 1986 | |
5288 | 5288 | 5287 | {"type": "Polygon", "coordinates": [[[-121.91488, 37.26568], [-121.91464, 37.26579], [-121.9143, 37.2652], [-121.91456, 37.26513], [-121.91488, 37.26568]]]} | Open Access 1 | Huerta Tot Lot | 20137 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.427 | Huerta Tot Lot | 2002 | |
5300 | 5300 | 5299 | {"type": "Polygon", "coordinates": [[[-121.89793, 37.31439], [-121.89792, 37.31475], [-121.89747, 37.31474], [-121.89748, 37.31438], [-121.89793, 37.31439]]]} | Open Access 1 | Hummingbird Park | 20150 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.388 | Hummingbird Park | 2003 | |
5389 | 5389 | 5388 | {"type": "Polygon", "coordinates": [[[-121.8864, 37.31025], [-121.88595, 37.31039], [-121.8854, 37.30953], [-121.8861, 37.3094], [-121.8864, 37.31025]], [[-121.88615, 37.3097], [-121.88616, 37.30968], [-121.88607, 37.30946], [-121.88591, 37.3095], [-121.88599, 37.30973], [-121.88615, 37.3097]]]} | Open Access 1 | J.Frey/Willow Community Garden | 20293 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.216 | J.Frey/Willow Community Garden | 1961 | |
5433 | 5433 | 5432 | {"type": "Polygon", "coordinates": [[[-121.89024, 37.36141], [-121.88965, 37.36147], [-121.88895, 37.36154], [-121.89005, 37.36072], [-121.89015, 37.36081], [-121.89024, 37.36141]]]} | Open Access 1 | Luna Park | 21595 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.178 | Luna Park | ||
5685 | 5685 | 5684 | {"type": "Polygon", "coordinates": [[[-121.86436, 37.32449], [-121.86277, 37.32544], [-121.86265, 37.32553], [-121.86248, 37.32557], [-121.86223, 37.32554], [-121.86213, 37.32557], [-121.86205, 37.32555], [-121.86197, 37.32556], [-121.86167, 37.32565], [-121.86133, 37.32587], [-121.86139, 37.32606], [-121.86102, 37.32624], [-121.861, 37.32635], [-121.86093, 37.32652], [-121.861, 37.32662], [-121.86058, 37.3271], [-121.8609, 37.32761], [-121.86112, 37.32772], [-121.85953, 37.32881], [-121.85297, 37.32221], [-121.85255, 37.32176], [-121.85209, 37.32147], [-121.85155, 37.32086], [-121.85073, 37.32013], [-121.8527, 37.31876], [-121.85442, 37.31764], [-121.85452, 37.31752], [-121.85459, 37.31753], [-121.85456, 37.31756], [-121.85453, 37.31781], [-121.85598, 37.31917], [-121.85403, 37.31875], [-121.85358, 37.31878], [-121.85293, 37.31909], [-121.85295, 37.3193], [-121.85337, 37.31946], [-121.85374, 37.31951], [-121.85506, 37.31936], [-121.85577, 37.31971], [-121.85625, 37.31956], [-121.85664, 37.31937], [-121.85688, 37.31921], [-121.85731, 37.31911], [-121.85852, 37.3184], [-121.86171, 37.32174], [-121.86436, 37.32449]]]} | Open Access 1 | Kelley Park | 20576 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 164.335 | Kelley Park | 1962 | |
5802 | 5802 | 5801 | {"type": "Polygon", "coordinates": [[[-121.8149, 37.23239], [-121.81368, 37.23282], [-121.81369, 37.23392], [-121.81364, 37.23398], [-121.81363, 37.23404], [-121.81363, 37.23446], [-121.81364, 37.23453], [-121.81369, 37.23461], [-121.8137, 37.23499], [-121.81156, 37.23502], [-121.81124, 37.23471], [-121.81128, 37.23466], [-121.81129, 37.2346], [-121.81124, 37.23451], [-121.81121, 37.23433], [-121.81117, 37.23422], [-121.81106, 37.23396], [-121.81063, 37.23325], [-121.81059, 37.23313], [-121.81053, 37.23282], [-121.81054, 37.23278], [-121.81058, 37.23275], [-121.81076, 37.23272], [-121.81096, 37.23267], [-121.8111, 37.2326], [-121.81125, 37.23251], [-121.8124, 37.23151], [-121.81267, 37.2317], [-121.81292, 37.23149], [-121.81306, 37.23141], [-121.81359, 37.23123], [-121.81376, 37.23155], [-121.8142, 37.23141], [-121.8143, 37.23152], [-121.81449, 37.23165], [-121.8149, 37.23239]]]} | Open Access 1 | La Colina Park and Garden | 20748 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 23.847 | La Colina Park and Garden | 1982 | |
5876 | 5876 | 5875 | {"type": "Polygon", "coordinates": [[[-121.85663, 37.3456], [-121.85604, 37.34604], [-121.85601, 37.3461], [-121.85601, 37.34615], [-121.85607, 37.34627], [-121.85226, 37.34926], [-121.85206, 37.34901], [-121.85125, 37.34807], [-121.85017, 37.34696], [-121.85017, 37.34693], [-121.85019, 37.3469], [-121.85087, 37.34649], [-121.85104, 37.34645], [-121.85138, 37.34648], [-121.85155, 37.34647], [-121.85172, 37.34642], [-121.8519, 37.34631], [-121.85202, 37.34645], [-121.85208, 37.34643], [-121.85223, 37.34658], [-121.85228, 37.34656], [-121.85239, 37.34668], [-121.85248, 37.34669], [-121.85249, 37.34675], [-121.85254, 37.34679], [-121.8526, 37.34681], [-121.85264, 37.3468], [-121.85274, 37.3469], [-121.85282, 37.34687], [-121.85296, 37.34701], [-121.85302, 37.34702], [-121.85302, 37.34707], [-121.85305, 37.34711], [-121.85313, 37.34714], [-121.85313, 37.34721], [-121.85326, 37.34734], [-121.85346, 37.34721], [-121.85348, 37.34722], [-121.85379, 37.34703], [-121.85374, 37.34695], [-121.85377, 37.34691], [-121.85364, 37.34678], [-121.85372, 37.34673], [-121.85387, 37.34687], [-121.85508, 37.34613], [-121.8551, 37.34614], [-121.85528, 37.34603], [-121.85528, 37.34601], [-121.85468, 37.3454], [-121.85448, 37.34551], [-121.85444, 37.34546], [-121.85461, 37.34533], [-121.85417, 37.34488], [-121.85398, 37.34499], [-121.85399, 37.34488], [-121.8542, 37.34473], [-121.85383, 37.34435], [-121.85364, 37.34446], [-121.85358, 37.3444], [-121.85375, 37.3443], [-121.85373, 37.34425], [-121.85381, 37.34419], [-121.85356, 37.34394], [-121.85362, 37.3439], [-121.85362, 37.34388], [-121.85338, 37.34364], [-121.85335, 37.34364], [-121.85321, 37.3435], [-121.85322, 37.34347], [-121.85313, 37.34338], [-121.85427, 37.34267], [-121.85501, 37.3434], [-121.85521, 37.34357], [-121.85486, 37.34379], [-121.85486, 37.34381], [-121.85663, 37.3456]]]} | Restricted Access 2 | Rancho del Pueblo Golf Course | 33035 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 30.571 | Rancho del Pueblo GC | 2001 | |
5887 | 5887 | 5886 | {"type": "Polygon", "coordinates": [[[-121.7652, 37.21623], [-121.76511, 37.21642], [-121.76504, 37.21667], [-121.76485, 37.21669], [-121.7647, 37.21673], [-121.76448, 37.21683], [-121.76434, 37.21692], [-121.76414, 37.21708], [-121.76405, 37.21726], [-121.76398, 37.21734], [-121.76343, 37.21761], [-121.76308, 37.21798], [-121.7629, 37.2181], [-121.76267, 37.21815], [-121.76249, 37.21813], [-121.76209, 37.218], [-121.76195, 37.21791], [-121.76164, 37.2179], [-121.7616, 37.21783], [-121.76151, 37.2178], [-121.76143, 37.21782], [-121.76138, 37.21787], [-121.761, 37.21775], [-121.76007, 37.21808], [-121.75921, 37.21766], [-121.75965, 37.21744], [-121.76021, 37.21764], [-121.7605, 37.21754], [-121.7606, 37.21723], [-121.7606, 37.21703], [-121.76075, 37.2169], [-121.76103, 37.21675], [-121.76111, 37.21674], [-121.76135, 37.21687], [-121.76143, 37.21712], [-121.76198, 37.21749], [-121.76218, 37.21776], [-121.76227, 37.21783], [-121.76249, 37.21789], [-121.76265, 37.21789], [-121.7628, 37.21782], [-121.76289, 37.21773], [-121.76293, 37.21762], [-121.76285, 37.21737], [-121.76313, 37.21703], [-121.76332, 37.21667], [-121.7642, 37.21645], [-121.76465, 37.21612], [-121.76479, 37.21591], [-121.7652, 37.21623]]]} | Open Access 1 | Laguna Seca Community Garden | 20867 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.784 | Laguna Seca Community Garden | ||
5936 | 5936 | 5935 | {"type": "Polygon", "coordinates": [[[-121.99104, 37.31833], [-121.99006, 37.31807], [-121.98956, 37.31796], [-121.98887, 37.31783], [-121.98886, 37.31751], [-121.9889, 37.31748], [-121.98891, 37.31744], [-121.98887, 37.3173], [-121.98888, 37.31598], [-121.9893, 37.31588], [-121.9898, 37.31567], [-121.98986, 37.31569], [-121.9901, 37.31583], [-121.99032, 37.3159], [-121.99057, 37.31593], [-121.99093, 37.31593], [-121.99095, 37.31828], [-121.99104, 37.3183], [-121.99104, 37.31833]]]} | Open Access 1 | Mise | 22290 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 10.989 | Mise | 1968 | |
6182 | 6182 | 6181 | {"type": "Polygon", "coordinates": [[[-121.82996, 37.36133], [-121.82978, 37.36141], [-121.82971, 37.36133], [-121.82965, 37.36131], [-121.82992, 37.36119], [-121.8299, 37.36125], [-121.82996, 37.36133]]]} | Open Access 1 | Nancy Lane Plaza | 22625 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.075 | Nancy Lane Plaza | ||
6185 | 6185 | 6184 | {"type": "Polygon", "coordinates": [[[-121.89002, 37.29009], [-121.88954, 37.29029], [-121.88929, 37.28992], [-121.88919, 37.28988], [-121.88868, 37.29008], [-121.88841, 37.28969], [-121.8894, 37.28934], [-121.88947, 37.28933], [-121.88952, 37.28936], [-121.89002, 37.29009]]]} | Open Access 1 | Lincoln Glen Park | 21249 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.856 | Lincoln Glen Park | ||
6239 | 6239 | 6238 | {"type": "MultiPolygon", "coordinates": [[[[-121.89541, 37.37943], [-121.89427, 37.37943], [-121.89269, 37.38197], [-121.8899, 37.37992], [-121.88744, 37.38246], [-121.88659, 37.38185], [-121.88541, 37.38076], [-121.88537, 37.38074], [-121.88537, 37.38072], [-121.88526, 37.38062], [-121.88521, 37.38053], [-121.88521, 37.38051], [-121.88453, 37.37987], [-121.88736, 37.37696], [-121.88571, 37.37551], [-121.88156, 37.37982], [-121.88142, 37.37967], [-121.88134, 37.37955], [-121.88131, 37.37944], [-121.88131, 37.37918], [-121.88142, 37.3789], [-121.88145, 37.37874], [-121.88145, 37.37859], [-121.8814, 37.37841], [-121.88133, 37.37826], [-121.88121, 37.37811], [-121.88109, 37.37801], [-121.88083, 37.37784], [-121.88082, 37.37781], [-121.88084, 37.37775], [-121.88072, 37.37768], [-121.8857, 37.3726], [-121.88699, 37.37171], [-121.88727, 37.37166], [-121.88755, 37.37144], [-121.88849, 37.37243], [-121.88866, 37.37235], [-121.88949, 37.37327], [-121.8897, 37.37398], [-121.88949, 37.37414], [-121.88976, 37.37467], [-121.89069, 37.37628], [-121.89054, 37.3768], [-121.89386, 37.37757], [-121.89432, 37.37694], [-121.8944, 37.37697], [-121.89454, 37.37694], [-121.89449, 37.37699], [-121.89448, 37.37703], [-121.89448, 37.37706], [-121.89453, 37.37712], [-121.8946, 37.37714], [-121.89468, 37.37713], [-121.89481, 37.37704], [-121.89517, 37.37697], [-121.89523, 37.37698], [-121.89525, 37.37701], [-121.89534, 37.37741], [-121.8954, 37.37782], [-121.89544, 37.3783], [-121.89545, 37.37859], [-121.89545, 37.37896], [-121.89541, 37.37943]]], [[[-121.89521, 37.37684], [-121.89516, 37.37689], [-121.89478, 37.37696], [-121.89463, 37.37692], [-121.8952, 37.37682], [-121.89521, 37.37684]]]]} | Restricted Access 2 | San Jose Municipal Golf Course | 33028 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 169.667 | San Jose Municipal GC | 2000 | |
6283 | 6283 | 6282 | {"type": "Polygon", "coordinates": [[[-121.92579, 37.34618], [-121.92523, 37.34688], [-121.92464, 37.34658], [-121.92459, 37.34652], [-121.92451, 37.3465], [-121.92532, 37.34595], [-121.92579, 37.34618]]]} | Open Access 1 | Newhall Park | 22725 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.428 | Newhall Park | ||
6314 | 6314 | 6313 | {"type": "Polygon", "coordinates": [[[-121.83923, 37.359], [-121.83914, 37.35909], [-121.83875, 37.35927], [-121.83871, 37.35928], [-121.83867, 37.35926], [-121.83633, 37.35687], [-121.83565, 37.35587], [-121.83599, 37.35588], [-121.83665, 37.3566], [-121.83681, 37.35652], [-121.83923, 37.359]]]} | Open Access 1 | Lo Bue Park | 21390 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.834 | Lo Bue Park | 1984 | |
6349 | 6349 | 6348 | {"type": "Polygon", "coordinates": [[[-121.82987, 37.29701], [-121.82983, 37.29708], [-121.82949, 37.29702], [-121.82873, 37.29701], [-121.82859, 37.29678], [-121.82926, 37.29636], [-121.82917, 37.29644], [-121.82911, 37.29654], [-121.82913, 37.29667], [-121.82917, 37.29674], [-121.82927, 37.29681], [-121.82953, 37.29688], [-121.82987, 37.29701]]]} | Open Access 1 | Lone Bluff Park | 21436 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.778 | Lone Bluff Park | ||
6354 | 6354 | 6353 | {"type": "Polygon", "coordinates": [[[-121.91257, 37.24638], [-121.91193, 37.24639], [-121.91168, 37.24645], [-121.91158, 37.24641], [-121.91143, 37.24648], [-121.91143, 37.24653], [-121.9114, 37.24657], [-121.91116, 37.24668], [-121.91031, 37.24549], [-121.91017, 37.24517], [-121.90953, 37.24426], [-121.91011, 37.244], [-121.91017, 37.24399], [-121.91021, 37.24401], [-121.91111, 37.24526], [-121.91129, 37.24543], [-121.91151, 37.24556], [-121.91177, 37.24564], [-121.91196, 37.24566], [-121.91256, 37.24566], [-121.91257, 37.24638]]]} | Open Access 1 | Lone Hill Park | 21438 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 7.081 | Lone Hill Park | 1984 |
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]);