units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2 and MNG_AGENCY = 32 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 174
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 175
MNG_AGENCY 1
- San Jose, City of · 175 ✖
DES_TP 1
- Local Park · 175 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16326 | 16326 | 16325 | {"type": "MultiPolygon", "coordinates": [[[[-121.75865, 37.30849], [-121.75876, 37.3085], [-121.75884, 37.30857], [-121.75887, 37.30866], [-121.75882, 37.30875], [-121.75875, 37.30879], [-121.75842, 37.30886], [-121.75835, 37.30885], [-121.75829, 37.30881], [-121.75824, 37.30865], [-121.75827, 37.30859], [-121.75832, 37.30856], [-121.75865, 37.30849]]], [[[-121.76001, 37.3085], [-121.75964, 37.30868], [-121.75949, 37.30873], [-121.75899, 37.30867], [-121.75896, 37.30853], [-121.7595, 37.30831], [-121.75999, 37.30837], [-121.75999, 37.30843], [-121.76001, 37.3085]]], [[[-121.76171, 37.30805], [-121.76176, 37.30805], [-121.76182, 37.30807], [-121.76187, 37.30812], [-121.76189, 37.30817], [-121.76189, 37.30823], [-121.76187, 37.30827], [-121.76176, 37.30834], [-121.76032, 37.30856], [-121.76026, 37.30855], [-121.76019, 37.30853], [-121.76014, 37.3085], [-121.76011, 37.30844], [-121.76011, 37.30839], [-121.76013, 37.30834], [-121.76017, 37.3083], [-121.76024, 37.30827], [-121.76171, 37.30805]]]]} | Open Access 1 | 9105 | Pocket Park No. 2 | 23829 | 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 | 2.347 | PP No. 2 | 2004 | Local Park 2 | 4 | |
8196 | 8196 | 8195 | {"type": "MultiPolygon", "coordinates": [[[[-121.75909, 37.31125], [-121.75908, 37.31129], [-121.75903, 37.31135], [-121.75894, 37.31143], [-121.75879, 37.3115], [-121.75881, 37.31139], [-121.7588, 37.31118], [-121.7587, 37.3111], [-121.75843, 37.31101], [-121.758, 37.31101], [-121.75767, 37.31106], [-121.75771, 37.31101], [-121.75779, 37.31097], [-121.75801, 37.31095], [-121.75802, 37.31091], [-121.75822, 37.3109], [-121.75847, 37.31091], [-121.75859, 37.31093], [-121.75879, 37.31101], [-121.75901, 37.31116], [-121.75909, 37.31125]]], [[[-121.75906, 37.31205], [-121.75896, 37.31207], [-121.75881, 37.3116], [-121.75887, 37.31158], [-121.75906, 37.31205]]], [[[-121.75984, 37.31269], [-121.75981, 37.31281], [-121.75957, 37.31279], [-121.75949, 37.31283], [-121.75915, 37.31287], [-121.75902, 37.31229], [-121.75903, 37.31224], [-121.75907, 37.31221], [-121.75914, 37.31219], [-121.75928, 37.31243], [-121.75946, 37.31246], [-121.75954, 37.31264], [-121.75984, 37.31269]]]]} | Open Access 1 | 9073 | Pocket Park No. 17 | 23826 | 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 | 1.192 | PP No. 17 | 2004 | Local Park 2 | 4 | |
1232 | 1232 | 1231 | {"type": "MultiPolygon", "coordinates": [[[[-121.76247, 37.30719], [-121.76237, 37.30725], [-121.76225, 37.30735], [-121.76221, 37.30737], [-121.76214, 37.30736], [-121.76213, 37.30711], [-121.76208, 37.30692], [-121.76217, 37.30689], [-121.76213, 37.30674], [-121.76204, 37.30675], [-121.76196, 37.30638], [-121.76204, 37.30636], [-121.762, 37.3062], [-121.76192, 37.30621], [-121.76183, 37.30585], [-121.76192, 37.30582], [-121.76188, 37.30567], [-121.76179, 37.30568], [-121.76168, 37.30523], [-121.76197, 37.3051], [-121.76208, 37.30559], [-121.76204, 37.30563], [-121.76203, 37.30569], [-121.76206, 37.30574], [-121.76214, 37.30577], [-121.76228, 37.30637], [-121.76224, 37.30642], [-121.76223, 37.30647], [-121.76227, 37.30652], [-121.76231, 37.30655], [-121.76247, 37.30719]]], [[[-121.76232, 37.30871], [-121.76223, 37.30854], [-121.76217, 37.30835], [-121.76199, 37.30829], [-121.76201, 37.30822], [-121.76201, 37.30816], [-121.76199, 37.30809], [-121.76194, 37.30803], [-121.76208, 37.30793], [-121.76204, 37.30773], [-121.76208, 37.3075], [-121.76212, 37.30756], [-121.76209, 37.30773], [-121.76209, 37.30788], [-121.76222, 37.30838], [-121.76227, 37.30851], [-121.76236, 37.30865], [-121.76236, 37.30869], [-121.76232, 37.30871]]], [[[-121.76263, 37.3073], [-121.76256, 37.30759], [-121.76243, 37.30762], [-121.7625, 37.30796], [-121.76237, 37.30797], [-121.76232, 37.30794], [-121.76229, 37.30783], [-121.76229, 37.30773], [-121.76232, 37.30763], [-121.76236, 37.30753], [-121.76243, 37.30744], [-121.76252, 37.30736], [-121.76263, 37.3073]]], [[[-121.76283, 37.30873], [-121.76266, 37.30866], [-121.7625, 37.3085], [-121.76244, 37.30841], [-121.76241, 37.30832], [-121.76241, 37.30828], [-121.76243, 37.30824], [-121.76246, 37.30822], [-121.76255, 37.3082], [-121.76263, 37.30853], [-121.76278, 37.30852], [-121.76283, 37.30873]]], [[[-121.76371, 37.31256], [-121.76358, 37.31258], [-121.76361, 37.3127], [-121.76353, 37.31271], [-121.76263, 37.30883], [-121.76275, 37.30888], [-121.76289, 37.30892], [-121.76314, 37.30895], [-121.76314, 37.30904], [-121.76312, 37.30915], [-121.76296, 37.30932], [-121.76302, 37.30961], [-121.76299, 37.30965], [-121.76298, 37.3097], [-121.76301, 37.30974], [-121.76306, 37.30977], [-121.76319, 37.31034], [-121.76316, 37.31038], [-121.76316, 37.31043], [-121.76318, 37.31047], [-121.76323, 37.3105], [-121.76336, 37.31106], [-121.76333, 37.3111], [-121.76333, 37.31116], [-121.76336, 37.3112], [-121.7634, 37.31123], [-121.76353, 37.3118], [-121.7635, 37.31184], [-121.76349, 37.31188], [-121.76352, 37.31193], [-121.76357, 37.31196], [-121.76371, 37.31256]]]]} | Open Access 1 | 8918 | Falls Creek Linear Park | 18837 | 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 | 4.266 | Falls Creek Linear Park | 2004 | Local Park 2 | 4 | |
17062 | 17062 | 17061 | {"type": "MultiPolygon", "coordinates": [[[[-121.76611, 37.32191], [-121.76591, 37.32205], [-121.76582, 37.32206], [-121.76254, 37.32081], [-121.7625, 37.32079], [-121.76248, 37.32075], [-121.76251, 37.32068], [-121.76255, 37.32069], [-121.76252, 37.32071], [-121.76252, 37.32075], [-121.76264, 37.3208], [-121.76275, 37.32081], [-121.76562, 37.32189], [-121.76566, 37.32193], [-121.76575, 37.32197], [-121.76579, 37.32197], [-121.76581, 37.32196], [-121.76581, 37.32191], [-121.76595, 37.32167], [-121.76592, 37.32153], [-121.76602, 37.32154], [-121.76611, 37.32191]]], [[[-121.76598, 37.32139], [-121.76582, 37.32138], [-121.76585, 37.32123], [-121.76577, 37.32089], [-121.7656, 37.32091], [-121.76564, 37.32082], [-121.76572, 37.32075], [-121.76571, 37.32068], [-121.76566, 37.32065], [-121.76561, 37.32064], [-121.76556, 37.32066], [-121.76552, 37.3207], [-121.76566, 37.32037], [-121.76558, 37.3201], [-121.76539, 37.32005], [-121.76543, 37.32002], [-121.76552, 37.31999], [-121.76554, 37.31993], [-121.76513, 37.3182], [-121.76416, 37.31835], [-121.76396, 37.31844], [-121.76385, 37.31855], [-121.7638, 37.31837], [-121.76521, 37.31816], [-121.76598, 37.32139]]]]} | Open Access 1 | 9194 | Pocket Park No. 9 | 23839 | 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 | 1.933 | PP No. 9 | 0 | Local Park 2 | 4 | |
8195 | 8195 | 8194 | {"type": "MultiPolygon", "coordinates": [[[[-121.76711, 37.31382], [-121.76553, 37.31405], [-121.7655, 37.31394], [-121.76629, 37.31381], [-121.7663, 37.31384], [-121.76709, 37.31372], [-121.76708, 37.31377], [-121.76711, 37.31382]]], [[[-121.76796, 37.3137], [-121.76734, 37.31379], [-121.76734, 37.31373], [-121.76731, 37.31368], [-121.76793, 37.31359], [-121.76793, 37.31365], [-121.76796, 37.3137]]], [[[-121.7688, 37.31357], [-121.76819, 37.31366], [-121.76819, 37.3136], [-121.76816, 37.31355], [-121.76879, 37.31346], [-121.76878, 37.31351], [-121.7688, 37.31357]]], [[[-121.76968, 37.31344], [-121.76903, 37.31354], [-121.76904, 37.31348], [-121.76901, 37.31343], [-121.76966, 37.31333], [-121.76968, 37.31344]]]]} | Open Access 1 | 9046 | Pocket Park No. 15 | 23824 | 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 | 0.923 | PP No. 15 | 2004 | Local Park 2 | 4 | |
1415 | 1415 | 1414 | {"type": "MultiPolygon", "coordinates": [[[[-121.76776, 37.31275], [-121.76743, 37.31279], [-121.76713, 37.31286], [-121.76708, 37.31283], [-121.767, 37.31282], [-121.76693, 37.31285], [-121.7669, 37.31289], [-121.76658, 37.31288], [-121.76657, 37.31284], [-121.76616, 37.31274], [-121.76601, 37.31272], [-121.76564, 37.31277], [-121.76555, 37.31276], [-121.76549, 37.3128], [-121.76473, 37.31291], [-121.76467, 37.31266], [-121.76469, 37.31264], [-121.76589, 37.31246], [-121.76603, 37.31245], [-121.76628, 37.31247], [-121.76657, 37.31256], [-121.76671, 37.31258], [-121.76687, 37.31258], [-121.76765, 37.31251], [-121.76772, 37.31256], [-121.76776, 37.31275]]], [[[-121.7705, 37.31315], [-121.77014, 37.31317], [-121.7698, 37.31322], [-121.76982, 37.31314], [-121.76981, 37.31309], [-121.76976, 37.31305], [-121.76967, 37.31304], [-121.76963, 37.31294], [-121.76915, 37.31273], [-121.76885, 37.31278], [-121.76885, 37.31271], [-121.7688, 37.31267], [-121.76871, 37.31265], [-121.76864, 37.31269], [-121.76856, 37.31265], [-121.76795, 37.31274], [-121.76789, 37.31251], [-121.76794, 37.31247], [-121.76849, 37.31238], [-121.76881, 37.31239], [-121.76901, 37.31242], [-121.77002, 37.31283], [-121.77043, 37.31294], [-121.77046, 37.31297], [-121.7705, 37.31315]]], [[[-121.77291, 37.31277], [-121.77227, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31318], [-121.77068, 37.31313], [-121.77067, 37.31308], [-121.77069, 37.31303], [-121.77075, 37.31301], [-121.77124, 37.31305], [-121.77155, 37.31304], [-121.77186, 37.31299], [-121.77225, 37.31288], [-121.7728, 37.31265], [-121.77284, 37.31266], [-121.77291, 37.31277]]], [[[-121.77537, 37.31301], [-121.77534, 37.31303], [-121.77515, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77412, 37.31252], [-121.77381, 37.31251], [-121.7735, 37.31255], [-121.7732, 37.31263], [-121.77317, 37.31255], [-121.77319, 37.31252], [-121.77324, 37.31249], [-121.7736, 37.31241], [-121.77378, 37.3124], [-121.77414, 37.3124], [-121.77449, 37.31245], [-121.77474, 37.31252], [-121.7749, 37.31259], [-121.7752, 37.31276], [-121.7754, 37.31291], [-121.77541, 37.31297], [-121.77537, 37.31301]]]]} | Open Access 1 | 8906 | Cortona Park | 17666 | 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 | 5.315 | Cortona Park | 2004 | Local Park 2 | 4 | |
7813 | 7813 | 7812 | {"type": "MultiPolygon", "coordinates": [[[[-121.76927, 37.32324], [-121.76939, 37.32349], [-121.76936, 37.32353], [-121.76865, 37.32383], [-121.76826, 37.32394], [-121.76774, 37.32406], [-121.76759, 37.32411], [-121.7674, 37.32423], [-121.76718, 37.3245], [-121.76702, 37.32457], [-121.76698, 37.32457], [-121.76694, 37.32454], [-121.76682, 37.32403], [-121.76707, 37.32399], [-121.76783, 37.32372], [-121.76826, 37.32364], [-121.76848, 37.32357], [-121.76904, 37.32333], [-121.76927, 37.32324]]], [[[-121.77079, 37.32274], [-121.77061, 37.32286], [-121.77054, 37.32288], [-121.77044, 37.32302], [-121.77031, 37.32307], [-121.77009, 37.32311], [-121.77006, 37.32317], [-121.76992, 37.32325], [-121.76995, 37.32336], [-121.76965, 37.32342], [-121.76959, 37.32342], [-121.76956, 37.32339], [-121.76944, 37.32314], [-121.77044, 37.32257], [-121.77065, 37.32248], [-121.77073, 37.32247], [-121.77079, 37.32274]]], [[[-121.77416, 37.32174], [-121.77415, 37.32176], [-121.77392, 37.32178], [-121.77272, 37.32219], [-121.77251, 37.32219], [-121.77244, 37.32224], [-121.77186, 37.32238], [-121.77178, 37.32242], [-121.77123, 37.32252], [-121.77105, 37.32259], [-121.77096, 37.32267], [-121.77094, 37.32268], [-121.77092, 37.3226], [-121.7709, 37.32248], [-121.77089, 37.32235], [-121.77091, 37.32231], [-121.77095, 37.32228], [-121.77159, 37.32216], [-121.77171, 37.3221], [-121.77291, 37.3218], [-121.77338, 37.32163], [-121.77344, 37.32125], [-121.77417, 37.32113], [-121.77422, 37.32113], [-121.77427, 37.32115], [-121.77444, 37.32135], [-121.77446, 37.32142], [-121.77425, 37.32171], [-121.77416, 37.32174]]], [[[-121.7751, 37.32159], [-121.77483, 37.32161], [-121.77464, 37.32159], [-121.77469, 37.32154], [-121.77476, 37.32153], [-121.77494, 37.32155], [-121.77509, 37.32154], [-121.7751, 37.32159]]]]} | Open Access 1 | 8967 | Murillo Park | 22605 | 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 | 6.821 | Murillo Park | 2004 | Local Park 2 | 4 | |
1242 | 1242 | 1241 | {"type": "MultiPolygon", "coordinates": [[[[-121.77122, 37.32389], [-121.77105, 37.32387], [-121.77102, 37.32367], [-121.77098, 37.32363], [-121.77095, 37.32344], [-121.77113, 37.32346], [-121.77115, 37.32364], [-121.77119, 37.32368], [-121.77122, 37.32389]]], [[[-121.77133, 37.32443], [-121.77116, 37.32444], [-121.77111, 37.32402], [-121.77128, 37.32402], [-121.77133, 37.32443]]], [[[-121.77142, 37.32496], [-121.77125, 37.32498], [-121.77117, 37.32458], [-121.77135, 37.32456], [-121.77142, 37.32496]]]]} | Open Access 1 | 9136 | Pocket Park No. 4 | 23834 | 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 | 0.527 | PP No. 4 | 2004 | Local Park 2 | 4 | |
7821 | 7821 | 7820 | {"type": "MultiPolygon", "coordinates": [[[[-121.77933, 37.31566], [-121.7791, 37.31572], [-121.77901, 37.31526], [-121.77923, 37.31547], [-121.77933, 37.31563], [-121.77933, 37.31566]]], [[[-121.77976, 37.31553], [-121.77956, 37.31557], [-121.77951, 37.31556], [-121.77939, 37.31537], [-121.77917, 37.31515], [-121.77914, 37.3151], [-121.77915, 37.31507], [-121.77918, 37.31505], [-121.77928, 37.31503], [-121.77939, 37.31536], [-121.77966, 37.31535], [-121.77962, 37.31542], [-121.77963, 37.31547], [-121.77968, 37.31551], [-121.77976, 37.31553]]]]} | Open Access 1 | 9035 | Pocket Park No. 14 | 23823 | 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 | 0.346 | PP No. 14 | 2004 | Local Park 2 | 4 | |
1423 | 1423 | 1422 | {"type": "MultiPolygon", "coordinates": [[[[-121.78009, 37.31127], [-121.77989, 37.31137], [-121.77994, 37.31162], [-121.77991, 37.31167], [-121.77993, 37.31173], [-121.77978, 37.31181], [-121.78003, 37.31291], [-121.77984, 37.31293], [-121.7796, 37.31189], [-121.77937, 37.31162], [-121.77968, 37.31144], [-121.78008, 37.31124], [-121.78009, 37.31127]]], [[[-121.78054, 37.31411], [-121.77993, 37.31421], [-121.77983, 37.31377], [-121.78044, 37.31368], [-121.78054, 37.31411]]], [[[-121.7802, 37.31358], [-121.78, 37.31361], [-121.7799, 37.31318], [-121.7801, 37.31315], [-121.7802, 37.31358]]], [[[-121.78046, 37.31471], [-121.78026, 37.31474], [-121.78016, 37.3143], [-121.78036, 37.31427], [-121.78046, 37.31471]]]]} | Open Access 1 | 9205 | Tapestry Park | 26184 | 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 | 2.08 | Tapestry Park | 1984 | Local Park 2 | 4 | |
1806 | 1806 | 1805 | {"type": "MultiPolygon", "coordinates": [[[[-121.83002, 37.34971], [-121.82992, 37.34978], [-121.82949, 37.34934], [-121.82959, 37.34928], [-121.83002, 37.34971]]], [[[-121.83066, 37.3502], [-121.83045, 37.35034], [-121.83004, 37.34991], [-121.83014, 37.34984], [-121.83034, 37.35006], [-121.83045, 37.34999], [-121.83066, 37.3502]]]]} | Open Access 1 | 13706 | Our Park | 23268 | 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 | 0.437 | Our Park | 1971 | Local Park 2 | 4 | |
10602 | 10602 | 10601 | {"type": "MultiPolygon", "coordinates": [[[[-121.84854, 37.33749], [-121.84887, 37.3379], [-121.8491, 37.33822], [-121.84929, 37.33856], [-121.84935, 37.33868], [-121.84938, 37.33879], [-121.84943, 37.33902], [-121.84944, 37.33937], [-121.84938, 37.33971], [-121.84926, 37.34004], [-121.84918, 37.3402], [-121.84898, 37.3405], [-121.84872, 37.34077], [-121.84858, 37.3409], [-121.84842, 37.34101], [-121.84743, 37.3415], [-121.84717, 37.34166], [-121.84693, 37.34183], [-121.84657, 37.34214], [-121.84646, 37.34227], [-121.84626, 37.34255], [-121.84616, 37.3426], [-121.84605, 37.34258], [-121.84574, 37.34232], [-121.84535, 37.34196], [-121.84525, 37.34201], [-121.84372, 37.34042], [-121.84377, 37.34038], [-121.84366, 37.34027], [-121.84406, 37.34001], [-121.84375, 37.33969], [-121.84555, 37.33847], [-121.84561, 37.33847], [-121.84567, 37.33849], [-121.84612, 37.33894], [-121.84625, 37.33898], [-121.84637, 37.33895], [-121.84854, 37.33749]]], [[[-121.84725, 37.33818], [-121.84633, 37.33882], [-121.84629, 37.33883], [-121.84623, 37.33882], [-121.84617, 37.33879], [-121.84582, 37.33842], [-121.84579, 37.33838], [-121.8458, 37.33834], [-121.84582, 37.3383], [-121.84638, 37.3379], [-121.84671, 37.33763], [-121.84725, 37.33818]]]]} | Open Access 1 | 18900 | Emma Prusch Farm Park | 18630 | 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 | 41.775 | Emma Prusch Farm Park | 1983 | Local Park 2 | 4 | |
6121 | 6121 | 6120 | {"type": "MultiPolygon", "coordinates": [[[[-121.89071, 37.33999], [-121.88974, 37.33869], [-121.89053, 37.33832], [-121.89059, 37.33834], [-121.89151, 37.33957], [-121.89148, 37.33962], [-121.89071, 37.33999]], [[-121.891, 37.33929], [-121.891, 37.33928], [-121.89082, 37.33922], [-121.89078, 37.3393], [-121.89069, 37.33928], [-121.89076, 37.33909], [-121.89046, 37.33901], [-121.89038, 37.33919], [-121.89058, 37.33925], [-121.89053, 37.3394], [-121.89057, 37.33942], [-121.89052, 37.33957], [-121.8907, 37.33961], [-121.89068, 37.33968], [-121.89085, 37.33974], [-121.89087, 37.3397], [-121.89106, 37.33974], [-121.89119, 37.33943], [-121.89118, 37.33941], [-121.89097, 37.33936], [-121.891, 37.33929]]], [[[-121.89259, 37.33909], [-121.89183, 37.33945], [-121.89176, 37.33945], [-121.89084, 37.33823], [-121.89084, 37.33818], [-121.89086, 37.33815], [-121.89162, 37.33779], [-121.89259, 37.33909]]]]} | Open Access 1 | 1091 | St. James Park | 25766 | 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 | 6.283 | St. James Park | 0 | Local Park 2 | 4 | |
14019 | 14019 | 14018 | {"type": "MultiPolygon", "coordinates": [[[[-121.89295, 37.31787], [-121.89295, 37.31797], [-121.89085, 37.31787], [-121.89085, 37.31778], [-121.89295, 37.31787]]], [[[-121.89597, 37.31798], [-121.89596, 37.31807], [-121.89363, 37.31799], [-121.89363, 37.31789], [-121.89597, 37.31798]]], [[[-121.89742, 37.31803], [-121.89731, 37.31856], [-121.8972, 37.31855], [-121.89721, 37.31839], [-121.89724, 37.31838], [-121.89727, 37.31802], [-121.89742, 37.31803]]]]} | Open Access 1 | 38010 | Fuller Park | 28012 | 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 | 1.195 | Fuller Park | 0 | Local Park 2 | 4 | |
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 | |
8542 | 8542 | 8541 | {"type": "MultiPolygon", "coordinates": [[[[-121.90847, 37.34424], [-121.90854, 37.34426], [-121.90928, 37.34492], [-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.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 | 13459 | Columbus Park | 17551 | 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 | 8.017 | Columbus Park | 0 | Local Park 2 | 4 | |
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 | |
14418 | 14418 | 14417 | {"type": "MultiPolygon", "coordinates": [[[[-121.91174, 37.34327], [-121.91173, 37.34329], [-121.91145, 37.34349], [-121.91121, 37.34329], [-121.9111, 37.34338], [-121.91132, 37.34358], [-121.91074, 37.34398], [-121.9107, 37.34399], [-121.91066, 37.34397], [-121.90988, 37.34327], [-121.90986, 37.34322], [-121.90989, 37.34316], [-121.91078, 37.34262], [-121.91089, 37.34259], [-121.91099, 37.34263], [-121.91139, 37.34299], [-121.91174, 37.34327]]], [[[-121.9128, 37.34423], [-121.91279, 37.34426], [-121.91179, 37.34497], [-121.91088, 37.34414], [-121.91188, 37.34344], [-121.91191, 37.34343], [-121.91195, 37.34344], [-121.91237, 37.34383], [-121.91235, 37.34386], [-121.91245, 37.34395], [-121.91249, 37.34393], [-121.91279, 37.34421], [-121.9128, 37.34423]]], [[[-121.91161, 37.34509], [-121.9106, 37.3458], [-121.90973, 37.34504], [-121.90971, 37.34499], [-121.90974, 37.34494], [-121.9107, 37.34427], [-121.91161, 37.34509]]], [[[-121.91392, 37.34524], [-121.91289, 37.34598], [-121.91195, 37.34511], [-121.91294, 37.34441], [-121.91298, 37.3444], [-121.91301, 37.34441], [-121.91392, 37.34524]]], [[[-121.91176, 37.34524], [-121.91214, 37.34558], [-121.91215, 37.34564], [-121.91118, 37.34634], [-121.91075, 37.34595], [-121.91176, 37.34524]]], [[[-121.91129, 37.34644], [-121.91226, 37.34575], [-121.91234, 37.34577], [-121.91268, 37.34608], [-121.91266, 37.34614], [-121.91172, 37.3468], [-121.91167, 37.34679], [-121.91129, 37.34644]]], [[[-121.91044, 37.34596], [-121.90896, 37.34698], [-121.90804, 37.34612], [-121.90943, 37.34516], [-121.90949, 37.34515], [-121.90956, 37.34517], [-121.91044, 37.34596]]], [[[-121.91468, 37.34594], [-121.9143, 37.34621], [-121.91463, 37.34652], [-121.91399, 37.34697], [-121.91305, 37.34612], [-121.91408, 37.34539], [-121.91468, 37.34594]]], [[[-121.90582, 37.34668], [-121.90548, 37.34645], [-121.90684, 37.34536], [-121.90691, 37.34534], [-121.90745, 37.34584], [-121.90747, 37.34587], [-121.90744, 37.34591], [-121.90686, 37.34631], [-121.90679, 37.34639], [-121.90677, 37.34646], [-121.90677, 37.34656], [-121.9068, 37.34662], [-121.90713, 37.34695], [-121.90714, 37.34704], [-121.90718, 37.3471], [-121.90728, 37.34715], [-121.90738, 37.34714], [-121.90743, 37.34711], [-121.90747, 37.34706], [-121.90748, 37.34698], [-121.90745, 37.34693], [-121.9074, 37.3469], [-121.90726, 37.34686], [-121.90697, 37.34659], [-121.90694, 37.34653], [-121.90694, 37.34647], [-121.90699, 37.3464], [-121.90759, 37.346], [-121.90765, 37.34602], [-121.9088, 37.34709], [-121.90784, 37.34775], [-121.90762, 37.34757], [-121.90739, 37.34742], [-121.90714, 37.34728], [-121.90612, 37.34685], [-121.90582, 37.34668]]], [[[-121.91378, 37.34708], [-121.91366, 37.34716], [-121.91368, 37.34719], [-121.91303, 37.34764], [-121.913, 37.34762], [-121.91279, 37.34775], [-121.91274, 37.34776], [-121.9127, 37.34774], [-121.91189, 37.347], [-121.91188, 37.34696], [-121.91287, 37.34625], [-121.91378, 37.34708]]], [[[-121.91572, 37.34687], [-121.91546, 37.34704], [-121.9156, 37.34739], [-121.91536, 37.3477], [-121.91537, 37.34772], [-121.91506, 37.34794], [-121.9142, 37.34716], [-121.91421, 37.34714], [-121.91483, 37.34674], [-121.9151, 37.34654], [-121.91518, 37.34651], [-121.91527, 37.34652], [-121.91534, 37.34656], [-121.91537, 37.34654], [-121.91572, 37.34687]]], [[[-121.91153, 37.34696], [-121.90933, 37.34848], [-121.90929, 37.34848], [-121.90925, 37.34846], [-121.90893, 37.34814], [-121.90892, 37.3481], [-121.90894, 37.34806], [-121.90959, 37.34762], [-121.90949, 37.34752], [-121.90879, 37.34797], [-121.90873, 37.34795], [-121.90841, 37.34765], [-121.90842, 37.34762], [-121.90844, 37.34759], [-121.9106, 37.34611], [-121.91153, 37.34696]]], [[[-121.90885, 37.34879], [-121.90815, 37.34805], [-121.90799, 37.3479], [-121.90819, 37.34776], [-121.90827, 37.34776], [-121.90896, 37.3484], [-121.90909, 37.34855], [-121.90911, 37.3486], [-121.90885, 37.34879]]], [[[-121.91487, 37.34807], [-121.91384, 37.34878], [-121.91299, 37.34803], [-121.91298, 37.34799], [-121.91301, 37.34794], [-121.91399, 37.34727], [-121.91487, 37.34807]]], [[[-121.90953, 37.34914], [-121.90929, 37.34926], [-121.90919, 37.34916], [-121.90878, 37.34909], [-121.90926, 37.34876], [-121.90953, 37.34914]]], [[[-121.90982, 37.34953], [-121.90963, 37.34963], [-121.90942, 37.34941], [-121.90964, 37.34929], [-121.90982, 37.34953]]], [[[-121.91215, 37.34824], [-121.91182, 37.34846], [-121.91137, 37.34806], [-121.91125, 37.34816], [-121.91168, 37.34856], [-121.9114, 37.34875], [-121.91096, 37.34835], [-121.9107, 37.34853], [-121.9107, 37.34854], [-121.91114, 37.34895], [-121.91103, 37.34903], [-121.91057, 37.34862], [-121.91026, 37.34883], [-121.91026, 37.34884], [-121.91073, 37.34926], [-121.91013, 37.34969], [-121.9094, 37.34868], [-121.91169, 37.34711], [-121.91252, 37.34788], [-121.91253, 37.34793], [-121.9125, 37.34798], [-121.91215, 37.34822], [-121.91215, 37.34824]]], [[[-121.91442, 37.3496], [-121.91388, 37.34997], [-121.91358, 37.3497], [-121.91324, 37.34994], [-121.91295, 37.34967], [-121.91378, 37.3491], [-121.91381, 37.34909], [-121.91387, 37.3491], [-121.91442, 37.3496]]], [[[-121.91545, 37.35025], [-121.91399, 37.34893], [-121.91501, 37.34824], [-121.91509, 37.34826], [-121.91528, 37.34843], [-121.91539, 37.34891], [-121.91548, 37.34935], [-121.91553, 37.35006], [-121.91545, 37.35025]]]]} | Open Access 1 | 44528 | Guadalupe River Park and Gardens | 19559 | 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 | 66.55 | Guadalupe River Park and Gardens | 0 | Local Park 2 | 4 | |
8608 | 8608 | 8607 | {"type": "MultiPolygon", "coordinates": [[[[-121.91295, 37.32069], [-121.91197, 37.32074], [-121.91197, 37.32068], [-121.91209, 37.32069], [-121.91213, 37.3206], [-121.91223, 37.3205], [-121.91235, 37.32046], [-121.91247, 37.32044], [-121.9126, 37.32046], [-121.91268, 37.3205], [-121.91275, 37.32056], [-121.91281, 37.32065], [-121.91294, 37.32064], [-121.91295, 37.32069]]], [[[-121.9129, 37.32142], [-121.91239, 37.32141], [-121.91205, 37.32142], [-121.91202, 37.32096], [-121.9129, 37.32092], [-121.9129, 37.32142]]]]} | Open Access 1 | 13701 | O'Connor Park | 22945 | 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 | 1.412 | O'Connor Park | 2003 | Local Park 2 | 4 | |
8595 | 8595 | 8594 | {"type": "MultiPolygon", "coordinates": [[[[-121.92618, 37.33141], [-121.92528, 37.3321], [-121.92476, 37.33165], [-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 | 13672 | Hester Park | 19884 | 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 | 4.694 | Hester Park | 1996 | Local Park 2 | 4 |
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]);