units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where AGNCY_NAME = 365, MNG_AGENCY = 361 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 2
MNG_AG_TYP 1
- City Agency · 34 ✖
MNG_AGENCY 1
- Union City, City of · 34 ✖
ACCESS_TYP 1
- Open Access 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1422 | 1422 | 1421 | {"type": "Polygon", "coordinates": [[[-122.0171, 37.59941], [-122.01689, 37.5995], [-122.0168, 37.59947], [-122.01672, 37.59947], [-122.01663, 37.59948], [-122.01658, 37.59951], [-122.01599, 37.59938], [-122.01595, 37.5994], [-122.01563, 37.59933], [-122.01576, 37.59887], [-122.01617, 37.5977], [-122.01742, 37.59798], [-122.01751, 37.59802], [-122.01754, 37.59812], [-122.0171, 37.59941]]]} | Open Access 1 | 12405 | Shorty Garcia Park | 25431 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 5.79 | Shorty Garcia Park | 0 | Local Park 2 | 4 | |
1441 | 1441 | 1440 | {"type": "Polygon", "coordinates": [[[-122.07092, 37.58343], [-122.07086, 37.58345], [-122.07013, 37.5834], [-122.07006, 37.58342], [-122.07001, 37.58347], [-122.07, 37.5835], [-122.07009, 37.58351], [-122.07001, 37.5836], [-122.07041, 37.58428], [-122.06975, 37.58504], [-122.06972, 37.58506], [-122.06966, 37.58505], [-122.06838, 37.58434], [-122.06877, 37.5839], [-122.06833, 37.58365], [-122.06891, 37.58315], [-122.06911, 37.58292], [-122.06883, 37.58275], [-122.06911, 37.58244], [-122.06919, 37.58244], [-122.07066, 37.58326], [-122.07092, 37.58343]]]} | Open Access 1 | 12481 | Contempo Park | 17606 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 8.19 | Contempo Park | 0 | Local Park 2 | 4 | |
1519 | 1519 | 1518 | {"type": "Polygon", "coordinates": [[[-122.06248, 37.57326], [-122.06228, 37.5735], [-122.06199, 37.57334], [-122.06219, 37.5731], [-122.06248, 37.57326]]]} | Open Access 1 | 47720 | Cerruti Park | 31508 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.246 | Cerruti Park | 0 | Local Park 2 | 4 | |
1628 | 1628 | 1627 | {"type": "Polygon", "coordinates": [[[-122.01104, 37.59599], [-122.01091, 37.59608], [-122.01086, 37.59604], [-122.01082, 37.59605], [-122.01077, 37.59603], [-122.01072, 37.59597], [-122.01065, 37.59594], [-122.01057, 37.59593], [-122.01049, 37.59595], [-122.01006, 37.59558], [-122.0101, 37.59553], [-122.01011, 37.59548], [-122.01043, 37.59526], [-122.01068, 37.59549], [-122.0107, 37.59555], [-122.01068, 37.59564], [-122.01073, 37.59571], [-122.01082, 37.59575], [-122.01093, 37.59572], [-122.01083, 37.5958], [-122.01104, 37.59599]]]} | Open Access 1 | 12416 | Willow Park | 27585 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.844 | Willow Park | 2008 | Local Park 2 | 4 | |
1630 | 1630 | 1629 | {"type": "Polygon", "coordinates": [[[-122.07539, 37.56562], [-122.07539, 37.5659], [-122.07504, 37.56589], [-122.07504, 37.56562], [-122.07539, 37.56562]]]} | Open Access 1 | 12442 | Ponderosa Park | 23889 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.234 | Ponderosa Park | 0 | Local Park 2 | 4 | |
1648 | 1648 | 1647 | {"type": "Polygon", "coordinates": [[[-122.02158, 37.60234], [-122.02107, 37.60272], [-122.02084, 37.60252], [-122.02135, 37.60214], [-122.02158, 37.60234]]]} | Open Access 1 | 12493 | Decoto Plaza Park | 17987 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.467 | Decoto Plaza Park | 0 | Local Park 2 | 4 | |
1650 | 1650 | 1649 | {"type": "Polygon", "coordinates": [[[-122.0779, 37.5845], [-122.07789, 37.58453], [-122.07765, 37.58481], [-122.07575, 37.58378], [-122.07474, 37.58493], [-122.07459, 37.58482], [-122.07436, 37.58469], [-122.07433, 37.58465], [-122.07434, 37.5846], [-122.07619, 37.58249], [-122.07625, 37.58246], [-122.0763, 37.58247], [-122.07693, 37.58281], [-122.07695, 37.58283], [-122.07695, 37.58287], [-122.07686, 37.58299], [-122.0768, 37.58313], [-122.07675, 37.58336], [-122.07676, 37.5835], [-122.07679, 37.58362], [-122.07686, 37.58377], [-122.07694, 37.58387], [-122.07705, 37.58399], [-122.07716, 37.58407], [-122.07788, 37.58447], [-122.0779, 37.5845]]]} | Open Access 1 | 12505 | Hall Ranch Park | 19608 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 7.211 | Hall Ranch Park | 0 | Local Park 2 | 4 | |
1652 | 1652 | 1651 | {"type": "MultiPolygon", "coordinates": [[[[-122.08366, 37.58804], [-122.0836, 37.58839], [-122.08265, 37.58876], [-122.08207, 37.58777], [-122.08206, 37.58774], [-122.08208, 37.58771], [-122.08212, 37.58769], [-122.08274, 37.58768], [-122.08327, 37.5876], [-122.08332, 37.58763], [-122.08355, 37.58799], [-122.0836, 37.58803], [-122.08366, 37.58804]]], [[[-122.08305, 37.58914], [-122.08296, 37.58917], [-122.08292, 37.58917], [-122.08288, 37.58915], [-122.08277, 37.58895], [-122.08291, 37.58889], [-122.08305, 37.58914]]], [[[-122.08449, 37.59158], [-122.0842, 37.59158], [-122.0842, 37.59137], [-122.08302, 37.58938], [-122.08302, 37.58935], [-122.08304, 37.58932], [-122.08317, 37.58927], [-122.08324, 37.58928], [-122.08326, 37.5893], [-122.08329, 37.58935], [-122.08331, 37.58957], [-122.08335, 37.58964], [-122.08449, 37.59158]]], [[[-122.0859, 37.59372], [-122.08576, 37.59379], [-122.08448, 37.59188], [-122.08447, 37.59176], [-122.08458, 37.59173], [-122.0859, 37.59372]]]]} | Open Access 1 | 12517 | Mariner Park | 21854 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 4.887 | Mariner Park | 0 | Local Park 2 | 4 | |
1661 | 1661 | 1660 | {"type": "Polygon", "coordinates": [[[-122.0843, 37.5973], [-122.08401, 37.59729], [-122.08397, 37.59702], [-122.08399, 37.59698], [-122.08405, 37.59696], [-122.08428, 37.59702], [-122.0843, 37.5973]]]} | Open Access 1 | 12562 | Courthouse Landing Park | 17717 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.225 | Courthouse Landing Park | 0 | Local Park 2 | 4 | |
1671 | 1671 | 1670 | {"type": "Polygon", "coordinates": [[[-122.07137, 37.57293], [-122.07053, 37.57389], [-122.07049, 37.57392], [-122.07044, 37.57391], [-122.07015, 37.57378], [-122.06979, 37.57365], [-122.06978, 37.57326], [-122.06972, 37.57298], [-122.06961, 37.5727], [-122.0695, 37.57253], [-122.06937, 37.57236], [-122.06937, 37.57232], [-122.06939, 37.57229], [-122.06982, 37.57208], [-122.07137, 37.57293]]]} | Open Access 1 | 12599 | Pioneer Park | 23735 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 4.684 | Pioneer Park | 0 | Local Park 2 | 4 | |
1682 | 1682 | 1681 | {"type": "Polygon", "coordinates": [[[-122.0369, 37.58934], [-122.03679, 37.58946], [-122.03652, 37.5893], [-122.0365, 37.58926], [-122.03659, 37.58916], [-122.0369, 37.58934]]]} | Open Access 1 | 12695 | Heritage Oak Park | 19838 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.139 | Heritage Oak Park | 2000 | Local Park 2 | 4 | |
3111 | 3111 | 3110 | {"type": "Polygon", "coordinates": [[[-122.07502, 37.59279], [-122.07482, 37.5928], [-122.07481, 37.59272], [-122.07469, 37.59272], [-122.07477, 37.59259], [-122.07489, 37.59264], [-122.075, 37.59267], [-122.07502, 37.59279]]]} | Open Access 1 | 48004 | Holly Community Center | 32427 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.098 | Holly Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
3175 | 3175 | 3174 | {"type": "Polygon", "coordinates": [[[-122.00577, 37.59279], [-122.00556, 37.59294], [-122.00534, 37.59277], [-122.00556, 37.59261], [-122.00577, 37.59279]]]} | Open Access 1 | 22005 | Windflower Park | 27626 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.175 | Windflower Park | 0 | Local Park 2 | 4 | |
3767 | 3767 | 3766 | {"type": "Polygon", "coordinates": [[[-122.07881, 37.59741], [-122.07881, 37.59746], [-122.07762, 37.59746], [-122.07762, 37.59685], [-122.07796, 37.59684], [-122.07796, 37.59657], [-122.0788, 37.59656], [-122.0788, 37.59704], [-122.07846, 37.59706], [-122.07847, 37.59741], [-122.07881, 37.59741]]]} | Open Access 1 | 34950 | Old Alvarado Park | 23081 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 2.059 | Old Alvarado Park | 1972 | Local Park 2 | 4 | |
5059 | 5059 | 5058 | {"type": "Polygon", "coordinates": [[[-122.006, 37.59045], [-122.00496, 37.59119], [-122.00455, 37.59082], [-122.00493, 37.59056], [-122.00518, 37.59046], [-122.00541, 37.59043], [-122.006, 37.59045]]]} | Open Access 1 | 12657 | Drigon Dog Park | 18273 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 1.236 | Drigon Dog Park | 0 | Local Park 2 | 4 | |
5206 | 5206 | 5205 | {"type": "Polygon", "coordinates": [[[-122.02374, 37.59788], [-122.02349, 37.59807], [-122.02325, 37.59787], [-122.02351, 37.59768], [-122.02374, 37.59788]]]} | Open Access 1 | 12669 | Fred Castro Park | 19073 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.232 | Fred Castro Park | 0 | Local Park 2 | 4 | |
7947 | 7947 | 7946 | {"type": "Polygon", "coordinates": [[[-122.00734, 37.58564], [-122.00734, 37.58564], [-122.00663, 37.58548], [-122.00668, 37.58535], [-122.00671, 37.58532], [-122.00677, 37.58531], [-122.0069, 37.58534], [-122.00714, 37.5854], [-122.00737, 37.5855], [-122.0074, 37.58556], [-122.00734, 37.58564]]]} | Open Access 1 | 47721 | Pacific Point Park | 31509 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.321 | Pacific Point Park | 0 | Local Park 2 | 4 | |
8187 | 8187 | 8186 | {"type": "MultiPolygon", "coordinates": [[[[-122.07796, 37.60271], [-122.07712, 37.60252], [-122.07701, 37.60246], [-122.077, 37.6024], [-122.07714, 37.60221], [-122.07718, 37.60203], [-122.07725, 37.60191], [-122.07724, 37.60182], [-122.07716, 37.60174], [-122.07475, 37.60054], [-122.07475, 37.60053], [-122.07506, 37.60059], [-122.07751, 37.60184], [-122.07766, 37.60198], [-122.07792, 37.60246], [-122.07796, 37.60271]]], [[[-122.07879, 37.60247], [-122.07835, 37.60252], [-122.0782, 37.60213], [-122.07801, 37.60185], [-122.07776, 37.60161], [-122.07727, 37.60127], [-122.07751, 37.60107], [-122.07759, 37.60125], [-122.0777, 37.60145], [-122.07782, 37.6016], [-122.07807, 37.60188], [-122.07825, 37.60215], [-122.07832, 37.6022], [-122.07841, 37.60223], [-122.07876, 37.6022], [-122.07879, 37.60247]]]]} | Open Access 1 | 12429 | Tidewater Park | 26350 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 2.424 | Tidewater Park | 0 | Local Park 2 | 4 | |
8203 | 8203 | 8202 | {"type": "Polygon", "coordinates": [[[-122.07762, 37.59701], [-122.07762, 37.59789], [-122.07755, 37.59815], [-122.07723, 37.59808], [-122.07698, 37.598], [-122.0767, 37.59788], [-122.0765, 37.59778], [-122.07649, 37.59772], [-122.07698, 37.59709], [-122.07698, 37.59703], [-122.07697, 37.59699], [-122.07691, 37.59694], [-122.07685, 37.59691], [-122.07699, 37.59691], [-122.07701, 37.59701], [-122.07762, 37.59701]]]} | Open Access 1 | 12469 | Cesar Chavez Park | 17100 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 2.247 | Cesar Chavez Park | 0 | Local Park 2 | 4 | |
8205 | 8205 | 8204 | {"type": "Polygon", "coordinates": [[[-122.06843, 37.59722], [-122.06819, 37.59728], [-122.06782, 37.59746], [-122.06783, 37.59729], [-122.0679, 37.59728], [-122.06796, 37.59726], [-122.068, 37.59721], [-122.06801, 37.59715], [-122.06799, 37.5971], [-122.06795, 37.59707], [-122.06785, 37.59704], [-122.0677, 37.5968], [-122.06759, 37.59657], [-122.06764, 37.59654], [-122.06768, 37.5965], [-122.06769, 37.59644], [-122.06768, 37.5964], [-122.06761, 37.59634], [-122.06751, 37.59633], [-122.06743, 37.59637], [-122.06738, 37.59645], [-122.06709, 37.59599], [-122.06714, 37.59592], [-122.06713, 37.59584], [-122.06682, 37.59535], [-122.06674, 37.59529], [-122.06675, 37.59524], [-122.06645, 37.59477], [-122.0664, 37.59474], [-122.06639, 37.59466], [-122.06607, 37.59417], [-122.06598, 37.59411], [-122.066, 37.59405], [-122.06586, 37.59381], [-122.06557, 37.59392], [-122.06542, 37.59367], [-122.0654, 37.59366], [-122.06543, 37.5936], [-122.06542, 37.59354], [-122.06509, 37.59302], [-122.06505, 37.59299], [-122.06499, 37.59297], [-122.06483, 37.593], [-122.06476, 37.59297], [-122.06469, 37.59284], [-122.0647, 37.59278], [-122.06475, 37.59271], [-122.06477, 37.59267], [-122.06476, 37.59261], [-122.06471, 37.59256], [-122.0648, 37.59243], [-122.06451, 37.59196], [-122.06443, 37.59194], [-122.06444, 37.59189], [-122.06442, 37.59185], [-122.0641, 37.59134], [-122.06405, 37.5913], [-122.064, 37.59129], [-122.06401, 37.59127], [-122.06392, 37.59103], [-122.06374, 37.59106], [-122.06358, 37.59057], [-122.06302, 37.59018], [-122.06319, 37.58995], [-122.06328, 37.58996], [-122.06336, 37.58994], [-122.06351, 37.59019], [-122.06373, 37.59039], [-122.06381, 37.59041], [-122.06381, 37.59049], [-122.06403, 37.59083], [-122.0642, 37.59102], [-122.06495, 37.59218], [-122.06498, 37.59218], [-122.06503, 37.59222], [-122.0651, 37.59224], [-122.06522, 37.59222], [-122.06537, 37.59247], [-122.06563, 37.59262], [-122.06573, 37.59263], [-122.06575, 37.59269], [-122.06581, 37.59274], [-122.06587, 37.59276], [-122.06596, 37.59274], [-122.0662, 37.59312], [-122.06615, 37.59315], [-122.06612, 37.5932], [-122.06612, 37.59324], [-122.06614, 37.5933], [-122.06621, 37.59335], [-122.06632, 37.59336], [-122.06641, 37.59357], [-122.06657, 37.59383], [-122.0667, 37.59384], [-122.06671, 37.5939], [-122.06685, 37.59416], [-122.06702, 37.59442], [-122.06709, 37.59446], [-122.06707, 37.59451], [-122.06738, 37.59499], [-122.06744, 37.59501], [-122.06745, 37.59509], [-122.06777, 37.59559], [-122.06785, 37.59565], [-122.06784, 37.59569], [-122.06814, 37.59617], [-122.06804, 37.59624], [-122.06802, 37.59629], [-122.06802, 37.59633], [-122.0683, 37.59677], [-122.06837, 37.59683], [-122.06832, 37.59692], [-122.06843, 37.59722]]]} | Open Access 1 | 12458 | Casa Verde Park | 16931 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 11.814 | Casa Verde Park | 0 | 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]);