units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 32 and YR_EST = 2004
This data as json, copyable, CSV (advanced)
DES_TP 2
- Local Park 23
- None 1
MNG_AG_TYP 1
- City Agency 24
MNG_AGENCY 1
- San Jose, City of · 24 ✖
ACCESS_TYP 1
- Open Access 24
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123]]]} | Open Access 1 | 8894 | Classico Park | 17392 | 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.476 | Classico Park | 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 | |
1234 | 1234 | 1233 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76446, 37.31478], [-121.7643, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | 8930 | Fowler Creek Community Park | 19029 | 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 | 12.449 | Fowler Creek Community 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 | |
1405 | 1405 | 1404 | {"type": "Polygon", "coordinates": [[[-121.76494, 37.31564], [-121.7648, 37.3157], [-121.76466, 37.31572], [-121.7645, 37.3157], [-121.76436, 37.31564], [-121.76425, 37.31555], [-121.76419, 37.31544], [-121.76418, 37.31531], [-121.76422, 37.31518], [-121.76429, 37.3151], [-121.76435, 37.31505], [-121.76445, 37.315], [-121.76457, 37.31497], [-121.76477, 37.31498], [-121.76496, 37.31506], [-121.76504, 37.31513], [-121.76508, 37.31519], [-121.76511, 37.31526], [-121.76512, 37.31535], [-121.76511, 37.31543], [-121.76506, 37.31552], [-121.76494, 37.31564]]]} | Open Access 1 | 9014 | Pocket Park No. 11 | 23822 | 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.329 | PP No. 11 | 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 | |
1427 | 1427 | 1426 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | 9084 | Pocket Park No. 18 | 23827 | 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.285 | PP No. 18 | 2004 | Local Park 2 | 4 | |
7207 | 7207 | 7206 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | 9025 | Evergreen Village Park | 18768 | 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.806 | Evergreen Village Park | 2004 | Local Park 2 | 4 | |
7529 | 7529 | 7528 | {"type": "Polygon", "coordinates": [[[-121.77462, 37.32204], [-121.77446, 37.3223], [-121.77438, 37.32256], [-121.77431, 37.32259], [-121.77427, 37.32264], [-121.77426, 37.32269], [-121.7743, 37.32281], [-121.77426, 37.32325], [-121.77424, 37.32328], [-121.77419, 37.32331], [-121.77412, 37.32332], [-121.77382, 37.32324], [-121.77363, 37.32317], [-121.7736, 37.3231], [-121.77361, 37.32305], [-121.77423, 37.32204], [-121.77429, 37.322], [-121.77435, 37.32198], [-121.77462, 37.32204]]]} | Open Access 1 | 9172 | Pocket Park No. 7 | 23837 | 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.501 | PP No. 7 | 2004 | Local Park 2 | 4 | |
7790 | 7790 | 7789 | {"type": "Polygon", "coordinates": [[[-121.76995, 37.32073], [-121.76992, 37.32078], [-121.76987, 37.3208], [-121.76953, 37.32076], [-121.76868, 37.31766], [-121.76873, 37.31765], [-121.76879, 37.31791], [-121.76891, 37.31796], [-121.76892, 37.31801], [-121.76897, 37.31805], [-121.76902, 37.31824], [-121.76906, 37.31824], [-121.76911, 37.31845], [-121.76908, 37.31848], [-121.76906, 37.31853], [-121.76908, 37.31857], [-121.76911, 37.31861], [-121.76909, 37.31889], [-121.7692, 37.31889], [-121.76921, 37.31914], [-121.76928, 37.31919], [-121.76927, 37.31925], [-121.7693, 37.3193], [-121.76921, 37.31936], [-121.76936, 37.31991], [-121.76944, 37.31997], [-121.76944, 37.32001], [-121.76947, 37.32005], [-121.76953, 37.32009], [-121.7695, 37.32033], [-121.76958, 37.32035], [-121.76957, 37.32068], [-121.76995, 37.32073]]]} | Open Access 1 | 9002 | Pocket Park No. 10 | 23821 | 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.008 | PP No. 10 | 2004 | Local Park 2 | 4 | |
7812 | 7812 | 7811 | {"type": "Polygon", "coordinates": [[[-121.75822, 37.31075], [-121.75822, 37.31063], [-121.75835, 37.31052], [-121.75835, 37.3102], [-121.75832, 37.3101], [-121.75788, 37.30937], [-121.75761, 37.30857], [-121.75794, 37.30839], [-121.7582, 37.30916], [-121.75845, 37.30964], [-121.75856, 37.31004], [-121.75856, 37.31025], [-121.75855, 37.31038], [-121.75849, 37.31059], [-121.75843, 37.31072], [-121.75837, 37.31075], [-121.75822, 37.31075]]]} | Open Access 1 | 8990 | Pocket Park No.1 | 23840 | 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.827 | PP No.1 | 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 | |
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 | |
7875 | 7875 | 7874 | {"type": "Polygon", "coordinates": [[[-121.94096, 37.40636], [-121.94091, 37.40636], [-121.94082, 37.40642], [-121.9408, 37.40647], [-121.93892, 37.40768], [-121.93888, 37.40767], [-121.93854, 37.40733], [-121.93855, 37.40728], [-121.94044, 37.4061], [-121.94048, 37.4061], [-121.94057, 37.40604], [-121.94058, 37.40601], [-121.94162, 37.40537], [-121.94169, 37.40537], [-121.94173, 37.4054], [-121.9422, 37.40604], [-121.94218, 37.4061], [-121.94197, 37.40619], [-121.94185, 37.4062], [-121.9416, 37.40617], [-121.94139, 37.40618], [-121.9412, 37.40623], [-121.94096, 37.40636]]]} | Open Access 1 | 9665 | Moitozo Park | 22348 | 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.125 | Moitozo Park | 2004 | Local Park 2 | 4 | |
8194 | 8194 | 8193 | {"type": "Polygon", "coordinates": [[[-121.77639, 37.32081], [-121.77611, 37.3212], [-121.77631, 37.32163], [-121.77624, 37.32153], [-121.77614, 37.32145], [-121.77603, 37.32139], [-121.77586, 37.32132], [-121.77569, 37.3213], [-121.77558, 37.3213], [-121.77505, 37.3214], [-121.77494, 37.3214], [-121.77473, 37.32136], [-121.77464, 37.32132], [-121.77452, 37.32123], [-121.77444, 37.32112], [-121.7744, 37.32104], [-121.77425, 37.32017], [-121.77413, 37.31974], [-121.77374, 37.31908], [-121.77368, 37.31894], [-121.77366, 37.31879], [-121.77368, 37.3186], [-121.77376, 37.31843], [-121.77386, 37.3183], [-121.77402, 37.31818], [-121.77403, 37.31818], [-121.77409, 37.31816], [-121.77418, 37.31816], [-121.77424, 37.31822], [-121.77434, 37.31857], [-121.7743, 37.31864], [-121.7743, 37.3187], [-121.77433, 37.31874], [-121.77437, 37.31876], [-121.77436, 37.31882], [-121.77482, 37.3196], [-121.77485, 37.3199], [-121.775, 37.32023], [-121.77516, 37.32092], [-121.77594, 37.32081], [-121.77594, 37.32078], [-121.77599, 37.32075], [-121.77602, 37.32072], [-121.77607, 37.32073], [-121.77623, 37.32072], [-121.77624, 37.32077], [-121.77627, 37.32081], [-121.77633, 37.32082], [-121.77639, 37.32081]]]} | Open Access 1 | 9156 | Pocket Park No. 6 | 23836 | 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.786 | PP No. 6 | 2004 | 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 | |
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 | |
8197 | 8197 | 8196 | {"type": "Polygon", "coordinates": [[[-121.75759, 37.30772], [-121.75723, 37.3079], [-121.7574, 37.30815], [-121.75736, 37.30818], [-121.7573, 37.30817], [-121.75713, 37.30796], [-121.75708, 37.30783], [-121.75703, 37.30764], [-121.75707, 37.30757], [-121.75706, 37.3075], [-121.75702, 37.30746], [-121.75694, 37.30744], [-121.75688, 37.30733], [-121.75718, 37.30743], [-121.7573, 37.30749], [-121.75744, 37.30758], [-121.75759, 37.30772]]]} | Open Access 1 | 9095 | Pocket Park No. 19 | 23828 | 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.52 | PP No. 19 | 2004 | Local Park 2 | 4 | |
8584 | 8584 | 8583 | {"type": "Polygon", "coordinates": [[[-121.90575, 37.3289], [-121.90546, 37.32891], [-121.9054, 37.32894], [-121.90536, 37.32899], [-121.90535, 37.32904], [-121.90539, 37.32905], [-121.90543, 37.32964], [-121.90462, 37.32968], [-121.90458, 37.32909], [-121.9046, 37.32908], [-121.9046, 37.32904], [-121.90456, 37.32899], [-121.90449, 37.32896], [-121.90424, 37.32896], [-121.90419, 37.32828], [-121.90509, 37.32824], [-121.9051, 37.32842], [-121.90563, 37.3284], [-121.90573, 37.32842], [-121.90575, 37.3289]]]} | Open Access 1 | 13641 | Cahill Park | 16656 | 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 | 3.71 | Cahill Park | 2004 | Local Park 2 | 4 | |
8594 | 8594 | 8593 | {"type": "Polygon", "coordinates": [[[-121.87021, 37.35546], [-121.86975, 37.35577], [-121.86972, 37.35574], [-121.8697, 37.35568], [-121.86965, 37.35565], [-121.86965, 37.35564], [-121.8697, 37.35564], [-121.86975, 37.35561], [-121.86978, 37.35557], [-121.86979, 37.35553], [-121.87014, 37.3553], [-121.87021, 37.35546]]]} | Open Access 1 | 13670 | Hacienda Park | 19589 | 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.228 | Hacienda Park | 2004 | 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]);