units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 and MNG_AG_TYP = 2 sorted by ACRES descending
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 231
- Restricted Access 2
MNG_AG_TYP 1
- City Agency · 233 ✖
MNG_AGENCY 1
- San Jose, City of · 233 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6451 | 6451 | 6450 | {"type": "Polygon", "coordinates": [[[-121.87834, 37.35953], [-121.87826, 37.35958], [-121.87795, 37.35929], [-121.87664, 37.36016], [-121.87692, 37.36045], [-121.87668, 37.36061], [-121.87601, 37.36039], [-121.87538, 37.36015], [-121.8747, 37.35988], [-121.87397, 37.35955], [-121.87427, 37.35876], [-121.87405, 37.35604], [-121.87435, 37.35406], [-121.87456, 37.35424], [-121.87443, 37.35524], [-121.87498, 37.35558], [-121.87596, 37.35539], [-121.87636, 37.35567], [-121.87687, 37.35616], [-121.87698, 37.35629], [-121.87713, 37.35652], [-121.87749, 37.35687], [-121.877, 37.35719], [-121.8764, 37.35761], [-121.87668, 37.35791], [-121.87834, 37.35953]]]} | Open Access 1 | 1981 | Watson Park | 30905 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Facilities/Facility/Details/126 | Santa Clara 19 | 34.437 | Watson Park | 1976 | Local Park 2 | 4 |
9620 | 9620 | 9619 | {"type": "Polygon", "coordinates": [[[-121.76471, 37.29776], [-121.76452, 37.29773], [-121.76414, 37.29769], [-121.76375, 37.29769], [-121.76328, 37.29774], [-121.76297, 37.29775], [-121.76276, 37.29775], [-121.76234, 37.2977], [-121.76187, 37.29768], [-121.76116, 37.2977], [-121.76066, 37.29777], [-121.76037, 37.29785], [-121.76012, 37.29794], [-121.75978, 37.2981], [-121.75874, 37.29878], [-121.758, 37.29924], [-121.7578, 37.29934], [-121.75774, 37.29933], [-121.75763, 37.29921], [-121.75742, 37.29909], [-121.75726, 37.29905], [-121.75704, 37.29904], [-121.75694, 37.29901], [-121.75663, 37.29888], [-121.75651, 37.29836], [-121.7577, 37.29818], [-121.75776, 37.29838], [-121.75784, 37.29837], [-121.7579, 37.29842], [-121.758, 37.29843], [-121.75804, 37.2984], [-121.75813, 37.2983], [-121.75854, 37.29805], [-121.75876, 37.29797], [-121.75911, 37.2979], [-121.7593, 37.29785], [-121.7595, 37.29775], [-121.75996, 37.29749], [-121.76014, 37.29744], [-121.76065, 37.29735], [-121.7612, 37.29714], [-121.76136, 37.29709], [-121.76161, 37.29706], [-121.7618, 37.29705], [-121.76204, 37.29707], [-121.76294, 37.29721], [-121.76372, 37.29717], [-121.76504, 37.29721], [-121.7653, 37.29724], [-121.7677, 37.2977], [-121.76778, 37.29767], [-121.76783, 37.29762], [-121.76799, 37.2969], [-121.768, 37.29688], [-121.76843, 37.29676], [-121.769, 37.2965], [-121.76905, 37.29652], [-121.77087, 37.29895], [-121.77103, 37.29925], [-121.77104, 37.29929], [-121.771, 37.29934], [-121.77064, 37.29948], [-121.77039, 37.29955], [-121.77011, 37.2996], [-121.76972, 37.29963], [-121.76945, 37.29962], [-121.76919, 37.29959], [-121.76893, 37.29954], [-121.76869, 37.29947], [-121.76844, 37.29937], [-121.76823, 37.29927], [-121.76723, 37.29862], [-121.76692, 37.29844], [-121.76659, 37.29828], [-121.76622, 37.29814], [-121.76588, 37.29804], [-121.76471, 37.29776]]]} | Open Access 1 | 16205 | Evergreen | 18764 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 34.372 | Evergreen | 1966 | None 817 | ||
1420 | 1420 | 1419 | {"type": "Polygon", "coordinates": [[[-121.87631, 37.40276], [-121.87599, 37.40296], [-121.87594, 37.40287], [-121.87584, 37.40275], [-121.87572, 37.40268], [-121.87554, 37.4026], [-121.87545, 37.40254], [-121.87456, 37.40155], [-121.87443, 37.40145], [-121.87422, 37.40134], [-121.87407, 37.40129], [-121.87384, 37.40126], [-121.87369, 37.40126], [-121.87353, 37.40129], [-121.87332, 37.40137], [-121.87154, 37.40238], [-121.87135, 37.40245], [-121.87107, 37.40248], [-121.87083, 37.40256], [-121.87028, 37.40286], [-121.87021, 37.40285], [-121.86956, 37.40213], [-121.8695, 37.40209], [-121.86942, 37.40207], [-121.86929, 37.40208], [-121.86659, 37.40363], [-121.86648, 37.40364], [-121.86643, 37.40363], [-121.86638, 37.40358], [-121.86565, 37.4026], [-121.86496, 37.4016], [-121.86511, 37.40159], [-121.86516, 37.40165], [-121.86521, 37.40167], [-121.86528, 37.40166], [-121.86534, 37.40161], [-121.86534, 37.40154], [-121.86538, 37.4015], [-121.86584, 37.40127], [-121.8659, 37.40127], [-121.86596, 37.40131], [-121.86627, 37.40174], [-121.86641, 37.40187], [-121.86649, 37.40191], [-121.86665, 37.40199], [-121.8668, 37.40203], [-121.86696, 37.40206], [-121.8672, 37.40205], [-121.86743, 37.402], [-121.86766, 37.40189], [-121.86873, 37.40129], [-121.86887, 37.40123], [-121.86914, 37.40118], [-121.86929, 37.40114], [-121.8699, 37.4008], [-121.86996, 37.40082], [-121.87035, 37.40125], [-121.87054, 37.40138], [-121.87068, 37.40144], [-121.87092, 37.4015], [-121.87108, 37.40151], [-121.87124, 37.4015], [-121.8714, 37.40146], [-121.87162, 37.40137], [-121.87371, 37.40016], [-121.87375, 37.40013], [-121.87377, 37.40008], [-121.87386, 37.40009], [-121.87423, 37.39987], [-121.87494, 37.40039], [-121.87514, 37.40056], [-121.87531, 37.40075], [-121.87546, 37.40095], [-121.8757, 37.40137], [-121.87631, 37.40276]]]} | Open Access 1 | 9047 | Cataldi | 16968 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 32.695 | Cataldi | 1980 | None 120 | ||
5569 | 5569 | 5568 | {"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.90229, 37.34169], [-121.90264, 37.34146], [-121.90296, 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.90612, 37.34396], [-121.90706, 37.34481], [-121.90708, 37.34484], [-121.90705, 37.34488], [-121.90603, 37.34554], [-121.90507, 37.34468], [-121.90612, 37.34396]]], [[[-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.90668, 37.34142], [-121.90693, 37.34124], [-121.90707, 37.34137], [-121.90695, 37.34146], [-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.90755, 37.34221], [-121.90768, 37.34212], [-121.90801, 37.34242]]]]} | Open Access 1 | 29145 | Guadalupe River Park | 19558 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 31.407 | Guadalupe River Park | 0 | Local Park 2 | 4 | |
6077 | 6077 | 6076 | {"type": "Polygon", "coordinates": [[[-121.8399, 37.21622], [-121.83961, 37.2161], [-121.83965, 37.21605], [-121.83964, 37.21604], [-121.83923, 37.21594], [-121.83739, 37.21489], [-121.8362, 37.2147], [-121.83507, 37.21412], [-121.83433, 37.21407], [-121.83417, 37.21402], [-121.83305, 37.2138], [-121.83255, 37.21372], [-121.83138, 37.2133], [-121.82978, 37.2127], [-121.82883, 37.21165], [-121.82736, 37.2108], [-121.82611, 37.20976], [-121.8254, 37.2092], [-121.82373, 37.20715], [-121.82398, 37.20696], [-121.82419, 37.20722], [-121.82437, 37.20754], [-121.82451, 37.20773], [-121.82494, 37.20819], [-121.82558, 37.20884], [-121.82608, 37.20927], [-121.82631, 37.20944], [-121.82672, 37.2098], [-121.82767, 37.21065], [-121.82801, 37.21094], [-121.82817, 37.21104], [-121.82868, 37.21128], [-121.82899, 37.21148], [-121.82918, 37.21165], [-121.82933, 37.21183], [-121.82946, 37.21201], [-121.82962, 37.21219], [-121.82977, 37.21233], [-121.83008, 37.21252], [-121.83038, 37.21265], [-121.83067, 37.21273], [-121.83097, 37.21279], [-121.83133, 37.2128], [-121.83159, 37.21279], [-121.8319, 37.21274], [-121.83377, 37.21223], [-121.83403, 37.21219], [-121.83436, 37.21218], [-121.83476, 37.21223], [-121.83528, 37.2124], [-121.8356, 37.21254], [-121.83579, 37.21265], [-121.8358, 37.21271], [-121.83708, 37.21396], [-121.83744, 37.21429], [-121.83795, 37.2146], [-121.8395, 37.21541], [-121.83982, 37.21556], [-121.8399, 37.21622]]]} | Open Access 1 | 860 | Singer Park | 25518 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 31.405 | Singer Park | 1984 | Local Park 2 | 4 | |
15679 | 15679 | 15678 | {"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.85203, 37.34645], [-121.85208, 37.34643], [-121.85223, 37.34658], [-121.85228, 37.34656], [-121.8524, 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.34691], [-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.85312, 37.34721], [-121.85326, 37.34734], [-121.85346, 37.34721], [-121.85348, 37.34722], [-121.8538, 37.34703], [-121.85374, 37.34695], [-121.85377, 37.34692], [-121.85364, 37.34678], [-121.85372, 37.34673], [-121.85387, 37.34688], [-121.85508, 37.34613], [-121.8551, 37.34614], [-121.85528, 37.34603], [-121.85528, 37.34602], [-121.85468, 37.3454], [-121.85448, 37.34551], [-121.85444, 37.34546], [-121.85461, 37.34534], [-121.85417, 37.34488], [-121.85398, 37.34499], [-121.85399, 37.34488], [-121.85421, 37.34474], [-121.85383, 37.34435], [-121.85364, 37.34446], [-121.85358, 37.3444], [-121.85376, 37.34429], [-121.85373, 37.34425], [-121.85381, 37.34419], [-121.85356, 37.34394], [-121.85362, 37.3439], [-121.85362, 37.34389], [-121.85337, 37.34364], [-121.85335, 37.34364], [-121.85321, 37.3435], [-121.85323, 37.34348], [-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 | 13737 | Rancho del Pueblo Golf Course | 33035 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 30.551 | Rancho del Pueblo GC | 2001 | Local Recreation Area 3 | 4 | |
10395 | 10395 | 10394 | {"type": "Polygon", "coordinates": [[[-121.85742, 37.36514], [-121.85473, 37.36697], [-121.85203, 37.36421], [-121.85465, 37.36245], [-121.85472, 37.36244], [-121.85742, 37.36514]]]} | Open Access 1 | 18374 | Overfelt Botanical Gardens | 23270 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 29.813 | Overfelt Botanical Gardens | 1977 | Local Park 2 | 4 | |
9830 | 9830 | 9829 | {"type": "Polygon", "coordinates": [[[-121.77734, 37.33532], [-121.7775, 37.33536], [-121.77767, 37.33537], [-121.78, 37.33491], [-121.78007, 37.33492], [-121.7801, 37.33494], [-121.78071, 37.3368], [-121.7808, 37.337], [-121.78079, 37.33705], [-121.7806, 37.33716], [-121.78053, 37.33722], [-121.78019, 37.33766], [-121.78011, 37.33774], [-121.7793, 37.33844], [-121.77925, 37.33845], [-121.77523, 37.33574], [-121.77734, 37.33532]]]} | Open Access 1 | 16792 | Groesbeck Hill | 19527 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 25.426 | Groesbeck Hill | 1992 | None 851 | ||
5870 | 5870 | 5869 | {"type": "Polygon", "coordinates": [[[-121.86762, 37.40876], [-121.8673, 37.40914], [-121.86705, 37.40917], [-121.86399, 37.40917], [-121.86362, 37.40915], [-121.86337, 37.40916], [-121.863, 37.40924], [-121.86265, 37.4094], [-121.86231, 37.40952], [-121.86218, 37.40956], [-121.86184, 37.4096], [-121.86169, 37.40964], [-121.86155, 37.40971], [-121.86142, 37.4098], [-121.86128, 37.40993], [-121.86122, 37.40996], [-121.86119, 37.41], [-121.86101, 37.41017], [-121.86085, 37.41039], [-121.86069, 37.4107], [-121.86053, 37.41085], [-121.86026, 37.41105], [-121.86008, 37.41115], [-121.85954, 37.41138], [-121.85917, 37.41151], [-121.85895, 37.41163], [-121.85883, 37.41174], [-121.85854, 37.41212], [-121.85837, 37.41242], [-121.85817, 37.41268], [-121.85801, 37.41296], [-121.85746, 37.41395], [-121.85741, 37.4141], [-121.85738, 37.41423], [-121.85732, 37.41436], [-121.85723, 37.41449], [-121.85708, 37.41462], [-121.85698, 37.41475], [-121.85678, 37.41508], [-121.85672, 37.41513], [-121.85655, 37.41521], [-121.85633, 37.4156], [-121.85611, 37.41527], [-121.85724, 37.4133], [-121.85729, 37.41313], [-121.8575, 37.41286], [-121.8579, 37.41214], [-121.85814, 37.41177], [-121.85844, 37.41144], [-121.85879, 37.41114], [-121.85895, 37.41104], [-121.85941, 37.41081], [-121.85915, 37.41044], [-121.85829, 37.40994], [-121.85823, 37.40999], [-121.85769, 37.40992], [-121.85757, 37.41], [-121.85719, 37.40977], [-121.85797, 37.40946], [-121.85839, 37.40936], [-121.8588, 37.40923], [-121.86014, 37.40863], [-121.86019, 37.40864], [-121.86022, 37.40866], [-121.8607, 37.40934], [-121.86073, 37.40944], [-121.86081, 37.40948], [-121.86088, 37.40948], [-121.86091, 37.40951], [-121.86099, 37.40945], [-121.86144, 37.40924], [-121.86179, 37.40915], [-121.86219, 37.4091], [-121.8623, 37.40906], [-121.86258, 37.40891], [-121.86276, 37.40884], [-121.86297, 37.40878], [-121.86331, 37.40874], [-121.86363, 37.40875], [-121.8642, 37.40879], [-121.86683, 37.40879], [-121.86725, 37.40881], [-121.86762, 37.40876]]]} | Open Access 1 | 246 | Berryessa Creek | 16036 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 25.184 | Berryessa Creek | 1979 | Local Other or Unknown 14 | 4 | |
2382 | 2382 | 2381 | {"type": "Polygon", "coordinates": [[[-121.8149, 37.23239], [-121.81368, 37.23281], [-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.23314], [-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 | 17211 | La Colina Park and Garden | 20748 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 23.837 | La Colina Park and Garden | 1982 | Local Park 2 | 4 | |
7920 | 7920 | 7919 | {"type": "Polygon", "coordinates": [[[-121.82621, 37.22902], [-121.82609, 37.22903], [-121.82596, 37.22907], [-121.82581, 37.22918], [-121.82516, 37.22872], [-121.82423, 37.22874], [-121.824, 37.22889], [-121.82393, 37.22912], [-121.82384, 37.22914], [-121.82379, 37.22909], [-121.82302, 37.22908], [-121.82296, 37.22912], [-121.82289, 37.2291], [-121.82283, 37.22911], [-121.82278, 37.22913], [-121.82275, 37.22918], [-121.82205, 37.22899], [-121.82192, 37.22928], [-121.82184, 37.2293], [-121.8218, 37.22936], [-121.82181, 37.22943], [-121.8219, 37.22951], [-121.8219, 37.22962], [-121.82152, 37.22963], [-121.82153, 37.23028], [-121.82141, 37.23029], [-121.82132, 37.23032], [-121.82132, 37.23054], [-121.82111, 37.23048], [-121.82083, 37.23033], [-121.82063, 37.23027], [-121.82065, 37.23], [-121.82039, 37.22994], [-121.82019, 37.22983], [-121.82009, 37.22971], [-121.81999, 37.22949], [-121.81985, 37.22937], [-121.81967, 37.2293], [-121.81919, 37.22926], [-121.81908, 37.22923], [-121.81898, 37.22918], [-121.8184, 37.22859], [-121.81824, 37.22849], [-121.81803, 37.22841], [-121.81799, 37.22825], [-121.81792, 37.22813], [-121.81781, 37.22804], [-121.81768, 37.22798], [-121.81765, 37.22798], [-121.81748, 37.22821], [-121.81742, 37.22823], [-121.81738, 37.22828], [-121.81738, 37.22878], [-121.81735, 37.22895], [-121.8173, 37.22906], [-121.81721, 37.2292], [-121.81703, 37.22939], [-121.81698, 37.22942], [-121.81627, 37.22915], [-121.81639, 37.22894], [-121.81612, 37.2287], [-121.81599, 37.22855], [-121.81608, 37.22841], [-121.81615, 37.22821], [-121.81616, 37.22804], [-121.81614, 37.22792], [-121.81608, 37.22777], [-121.816, 37.22766], [-121.81586, 37.22754], [-121.81576, 37.22748], [-121.81562, 37.22744], [-121.81548, 37.22744], [-121.81535, 37.22747], [-121.81523, 37.22753], [-121.81489, 37.22788], [-121.81461, 37.22822], [-121.81432, 37.22822], [-121.81409, 37.22815], [-121.81424, 37.22795], [-121.81407, 37.22783], [-121.81395, 37.2277], [-121.8139, 37.22761], [-121.81379, 37.22735], [-121.81364, 37.22711], [-121.81345, 37.22694], [-121.81327, 37.22686], [-121.81305, 37.22685], [-121.81294, 37.22688], [-121.81282, 37.22694], [-121.81269, 37.22707], [-121.81254, 37.22738], [-121.81249, 37.22743], [-121.81241, 37.22747], [-121.81229, 37.22749], [-121.81185, 37.22747], [-121.81159, 37.22753], [-121.81159, 37.22777], [-121.81095, 37.22777], [-121.81094, 37.22749], [-121.81111, 37.22727], [-121.81114, 37.22712], [-121.81111, 37.22701], [-121.81105, 37.22692], [-121.811, 37.22688], [-121.8109, 37.22684], [-121.8108, 37.22684], [-121.8104, 37.22691], [-121.80977, 37.22689], [-121.80969, 37.22692], [-121.80965, 37.22696], [-121.80956, 37.22715], [-121.80951, 37.22719], [-121.80916, 37.2272], [-121.8089, 37.22718], [-121.80882, 37.22725], [-121.80876, 37.22723], [-121.80882, 37.22715], [-121.80863, 37.22699], [-121.80856, 37.22698], [-121.80789, 37.22745], [-121.80781, 37.22744], [-121.80772, 37.22747], [-121.80771, 37.2274], [-121.80756, 37.22737], [-121.80742, 37.22737], [-121.8069, 37.22759], [-121.8069, 37.22782], [-121.80642, 37.22782], [-121.80642, 37.22759], [-121.80635, 37.22752], [-121.80634, 37.22703], [-121.80667, 37.22672], [-121.80696, 37.22647], [-121.80765, 37.22592], [-121.80832, 37.22662], [-121.80871, 37.22656], [-121.80883, 37.2269], [-121.80912, 37.22698], [-121.80945, 37.22694], [-121.80984, 37.2267], [-121.81032, 37.22681], [-121.81081, 37.22668], [-121.81143, 37.22669], [-121.81153, 37.22701], [-121.81164, 37.22719], [-121.81182, 37.22724], [-121.81199, 37.22723], [-121.81212, 37.22723], [-121.81245, 37.22711], [-121.81289, 37.22685], [-121.81337, 37.22683], [-121.8136, 37.22697], [-121.81423, 37.22782], [-121.8146, 37.22793], [-121.81528, 37.22743], [-121.81539, 37.22739], [-121.81554, 37.22736], [-121.81569, 37.22737], [-121.81582, 37.22741], [-121.81609, 37.22759], [-121.8163, 37.22808], [-121.81639, 37.2282], [-121.81648, 37.2283], [-121.81654, 37.22834], [-121.81678, 37.22838], [-121.81682, 37.22841], [-121.81732, 37.22816], [-121.81744, 37.22785], [-121.81783, 37.22786], [-121.81806, 37.2281], [-121.81851, 37.22843], [-121.81904, 37.22851], [-121.81925, 37.22902], [-121.81954, 37.22905], [-121.82014, 37.22903], [-121.82035, 37.22959], [-121.82053, 37.22974], [-121.82099, 37.2299], [-121.82124, 37.2298], [-121.82147, 37.22942], [-121.82159, 37.22835], [-121.82162, 37.22823], [-121.82184, 37.22817], [-121.82211, 37.22826], [-121.8223, 37.22837], [-121.82261, 37.22857], [-121.82297, 37.22873], [-121.82325, 37.2288], [-121.82358, 37.22879], [-121.82377, 37.22872], [-121.82412, 37.22849], [-121.82455, 37.22833], [-121.8247, 37.22818], [-121.82496, 37.22811], [-121.82507, 37.22813], [-121.82515, 37.22845], [-121.82528, 37.22858], [-121.8255, 37.22867], [-121.82587, 37.22874], [-121.82604, 37.22875], [-121.82615, 37.22867], [-121.82621, 37.22902]]]} | Open Access 1 | 10484 | Century Oaks | 17076 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 23.07 | Century Oaks | 1976 | None 659 | ||
9833 | 9833 | 9832 | {"type": "MultiPolygon", "coordinates": [[[[-121.90925, 37.34333], [-121.90916, 37.3434], [-121.90913, 37.34339], [-121.90887, 37.3436], [-121.90847, 37.34388], [-121.9075, 37.34298], [-121.90857, 37.34223], [-121.90949, 37.34309], [-121.90948, 37.34314], [-121.90925, 37.34331], [-121.90925, 37.34333]]], [[[-121.9128, 37.35228], [-121.91234, 37.35264], [-121.91191, 37.3534], [-121.9114, 37.35387], [-121.91081, 37.35295], [-121.90954, 37.35053], [-121.90947, 37.35042], [-121.91082, 37.34945], [-121.91086, 37.34946], [-121.91123, 37.34978], [-121.91112, 37.34984], [-121.91122, 37.34994], [-121.91167, 37.3509], [-121.91219, 37.35054], [-121.91252, 37.35098], [-121.91199, 37.35129], [-121.91255, 37.35174], [-121.9128, 37.35228]]]]} | Restricted Access 2 | 16812 | Guadalupe Gardens | 19544 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 21.614 | Guadalupe Gardens | 0 | Local Park 2 | 4 | |
2107 | 2107 | 2106 | {"type": "Polygon", "coordinates": [[[-121.823, 37.2655], [-121.82273, 37.26566], [-121.82189, 37.26626], [-121.82172, 37.26633], [-121.82156, 37.26635], [-121.82143, 37.26634], [-121.82131, 37.2663], [-121.82003, 37.26559], [-121.8195, 37.26514], [-121.81947, 37.26509], [-121.81945, 37.26503], [-121.81942, 37.26502], [-121.81945, 37.26287], [-121.82135, 37.26289], [-121.82136, 37.26338], [-121.82176, 37.26351], [-121.82177, 37.26403], [-121.82155, 37.2643], [-121.82156, 37.26434], [-121.823, 37.2655]]]} | Open Access 1 | 15890 | Edenvale Garden | 18431 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 18.978 | Edenvale Garden | 1991 | Local Park 2 | 4 | |
9784 | 9784 | 9783 | {"type": "MultiPolygon", "coordinates": [[[[-121.87628, 37.23286], [-121.87578, 37.23287], [-121.87577, 37.23282], [-121.87321, 37.23281], [-121.87295, 37.23282], [-121.87269, 37.23294], [-121.87242, 37.23296], [-121.87191, 37.23295], [-121.87166, 37.23193], [-121.87209, 37.23197], [-121.87213, 37.23207], [-121.87223, 37.23213], [-121.87396, 37.23229], [-121.87403, 37.23228], [-121.8741, 37.23224], [-121.87414, 37.23219], [-121.87415, 37.23212], [-121.87449, 37.23215], [-121.87471, 37.23222], [-121.87509, 37.23205], [-121.87515, 37.23212], [-121.87526, 37.23215], [-121.87543, 37.23214], [-121.87642, 37.23214], [-121.87645, 37.23216], [-121.87647, 37.2322], [-121.87644, 37.23242], [-121.87639, 37.2326], [-121.87628, 37.23286]]], [[[-121.88411, 37.23228], [-121.8841, 37.23246], [-121.88396, 37.23247], [-121.88403, 37.23275], [-121.88391, 37.23278], [-121.88393, 37.23284], [-121.88365, 37.23288], [-121.88341, 37.23287], [-121.8828, 37.2328], [-121.88279, 37.23278], [-121.88254, 37.23274], [-121.88235, 37.23273], [-121.88202, 37.23279], [-121.88175, 37.23279], [-121.88169, 37.23282], [-121.88057, 37.23286], [-121.88021, 37.23293], [-121.87814, 37.2328], [-121.87794, 37.23275], [-121.87784, 37.23274], [-121.87694, 37.23278], [-121.87672, 37.23274], [-121.87668, 37.2327], [-121.87674, 37.23246], [-121.87678, 37.23222], [-121.87681, 37.23219], [-121.87688, 37.23217], [-121.87731, 37.23223], [-121.87869, 37.23224], [-121.87918, 37.23231], [-121.88066, 37.23232], [-121.88071, 37.2323], [-121.88072, 37.23226], [-121.88411, 37.23228]]]]} | Open Access 1 | 16731 | Golden Oaks | 19367 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 17.73 | Golden Oaks | 1989 | None 847 | ||
444 | 444 | 443 | {"type": "MultiPolygon", "coordinates": [[[[-121.88809, 37.23293], [-121.88443, 37.23292], [-121.88436, 37.2328], [-121.88432, 37.23268], [-121.88428, 37.23249], [-121.88427, 37.23234], [-121.88429, 37.23231], [-121.88433, 37.2323], [-121.88805, 37.23232], [-121.88808, 37.23234], [-121.8881, 37.23237], [-121.88809, 37.23293]]], [[[-121.8943, 37.23234], [-121.89418, 37.23251], [-121.89397, 37.23297], [-121.89231, 37.23296], [-121.89231, 37.2329], [-121.89229, 37.23286], [-121.89224, 37.23284], [-121.89219, 37.23282], [-121.89201, 37.23288], [-121.89035, 37.23287], [-121.89019, 37.23282], [-121.8901, 37.23284], [-121.89006, 37.2329], [-121.89007, 37.23301], [-121.89006, 37.23351], [-121.89005, 37.23355], [-121.89, 37.23358], [-121.88853, 37.23362], [-121.88844, 37.23359], [-121.88836, 37.23354], [-121.88832, 37.2335], [-121.88829, 37.23342], [-121.88831, 37.2323], [-121.89136, 37.23232], [-121.89157, 37.23209], [-121.89176, 37.23215], [-121.89197, 37.23217], [-121.89217, 37.23213], [-121.89241, 37.23201], [-121.89241, 37.23233], [-121.8943, 37.23234]]]]} | Open Access 1 | 1383 | T.J. Martin | 26157 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 17.459 | T.J. Martin | 1984 | None 46 | ||
9367 | 9367 | 9366 | {"type": "Polygon", "coordinates": [[[-121.86823, 37.33704], [-121.86811, 37.33728], [-121.868, 37.3374], [-121.86712, 37.338], [-121.86682, 37.3377], [-121.86706, 37.33752], [-121.86621, 37.33482], [-121.86543, 37.33468], [-121.86602, 37.33164], [-121.86772, 37.33066], [-121.86705, 37.33189], [-121.86683, 37.33212], [-121.86732, 37.33319], [-121.86711, 37.33392], [-121.86694, 37.33478], [-121.86697, 37.33548], [-121.86703, 37.33577], [-121.8674, 37.33676], [-121.86823, 37.33704]]]} | Open Access 1 | 15647 | Selma Olinder Park | 25292 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 17.112 | Selma Olinder Park | 0 | Local Park 2 | 4 | |
1803 | 1803 | 1802 | {"type": "Polygon", "coordinates": [[[-121.84745, 37.20134], [-121.84565, 37.20254], [-121.84563, 37.20249], [-121.84558, 37.20245], [-121.84551, 37.20245], [-121.84545, 37.20247], [-121.84542, 37.20251], [-121.84541, 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 | 13649 | Cathedral Oaks Park | 16975 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.969 | Cathedral Oaks Park | 0 | Local Park 2 | 4 | |
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.77 | Calabazas | 1978 | None 69 | ||
10081 | 10081 | 10080 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.22793], [-121.77207, 37.22885], [-121.77167, 37.22865], [-121.77123, 37.22848], [-121.7711, 37.22847], [-121.77096, 37.22853], [-121.77057, 37.22894], [-121.77054, 37.229], [-121.77054, 37.22905], [-121.77058, 37.22915], [-121.77049, 37.22913], [-121.77014, 37.22952], [-121.77021, 37.22965], [-121.77016, 37.22969], [-121.77013, 37.22973], [-121.76994, 37.22971], [-121.7696, 37.23009], [-121.76967, 37.23023], [-121.76963, 37.23026], [-121.7696, 37.2303], [-121.76942, 37.2303], [-121.76906, 37.23067], [-121.76914, 37.2308], [-121.76908, 37.23087], [-121.76887, 37.23087], [-121.76852, 37.23124], [-121.7686, 37.23137], [-121.76856, 37.23141], [-121.76853, 37.23146], [-121.76835, 37.23143], [-121.768, 37.23181], [-121.76808, 37.23195], [-121.76802, 37.23199], [-121.76799, 37.23204], [-121.76781, 37.23201], [-121.76747, 37.23239], [-121.76753, 37.23253], [-121.76749, 37.23257], [-121.76746, 37.2326], [-121.76727, 37.23259], [-121.7666, 37.23333], [-121.76653, 37.2333], [-121.76691, 37.23289], [-121.76683, 37.23275], [-121.76688, 37.23271], [-121.76691, 37.23266], [-121.7671, 37.23268], [-121.76745, 37.23231], [-121.76737, 37.23217], [-121.76744, 37.23209], [-121.76763, 37.2321], [-121.76798, 37.23173], [-121.76791, 37.2316], [-121.76796, 37.23156], [-121.76798, 37.23151], [-121.76817, 37.23153], [-121.76818, 37.23152], [-121.76852, 37.23115], [-121.76844, 37.23102], [-121.76849, 37.23098], [-121.76852, 37.23093], [-121.76871, 37.23094], [-121.76906, 37.23057], [-121.76897, 37.23044], [-121.76905, 37.23036], [-121.76923, 37.23039], [-121.76957, 37.23001], [-121.76951, 37.22986], [-121.76958, 37.22979], [-121.76977, 37.2298], [-121.77007, 37.22948], [-121.77003, 37.2293], [-121.77009, 37.22926], [-121.77012, 37.22921], [-121.77031, 37.22923], [-121.77043, 37.22909], [-121.7704, 37.22899], [-121.77141, 37.2279], [-121.76971, 37.22689], [-121.7693, 37.22691], [-121.76927, 37.22684], [-121.7692, 37.22678], [-121.76911, 37.22674], [-121.76863, 37.22647], [-121.76915, 37.22458], [-121.77016, 37.22475], [-121.7698, 37.22608], [-121.77292, 37.22793]]]} | Open Access 1 | 17452 | Los Paseos | 21526 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 15.225 | Los Paseos | 1972 | None 875 | ||
5880 | 5880 | 5879 | {"type": "Polygon", "coordinates": [[[-121.87433, 37.3454], [-121.87431, 37.34541], [-121.87413, 37.3459], [-121.87387, 37.34635], [-121.87387, 37.34678], [-121.8738, 37.34722], [-121.87341, 37.34738], [-121.8724, 37.34787], [-121.87134, 37.34646], [-121.87243, 37.34597], [-121.87186, 37.3452], [-121.8739, 37.34423], [-121.87425, 37.34471], [-121.87433, 37.3454]]]} | Open Access 1 | 272 | Roosevelt | 24592 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 15.014 | Roosevelt | 1978 | None 471 |
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]);