units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 361 and MNG_AG_TYP = 2 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14258 | 14258 | 14257 | {"type": "Polygon", "coordinates": [[[-122.06149, 37.57931], [-122.06113, 37.57754], [-122.06116, 37.57753], [-122.06102, 37.57685], [-122.0621, 37.57746], [-122.06224, 37.57808], [-122.06228, 37.57814], [-122.06238, 37.57822], [-122.0624, 37.57825], [-122.06239, 37.57829], [-122.06149, 37.57931]]]} | Open Access 1 | 44177 | Accinelli Park | 15247 | 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.1 | Accinelli Park | 0 | Local Park 2 | 4 | |
9178 | 9178 | 9177 | {"type": "Polygon", "coordinates": [[[-122.01505, 37.58006], [-122.01496, 37.58031], [-122.01471, 37.58083], [-122.01457, 37.58124], [-122.01436, 37.5812], [-122.01427, 37.58146], [-122.01417, 37.58145], [-122.01402, 37.58187], [-122.01386, 37.58184], [-122.01377, 37.58209], [-122.01357, 37.58208], [-122.01339, 37.5821], [-122.01323, 37.58214], [-122.01307, 37.5822], [-122.01285, 37.58233], [-122.01268, 37.58249], [-122.01305, 37.58141], [-122.01237, 37.58147], [-122.01179, 37.58158], [-122.0105, 37.58127], [-122.01077, 37.58047], [-122.01105, 37.58063], [-122.01219, 37.58083], [-122.01318, 37.5807], [-122.01314, 37.58062], [-122.0133, 37.58059], [-122.01383, 37.58023], [-122.01403, 37.57973], [-122.01455, 37.57985], [-122.01453, 37.57994], [-122.01505, 37.58006]]]} | Open Access 1 | 15237 | Arroyo Park | 15619 | 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.549 | Arroyo 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 | |
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 | |
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 | |
8242 | 8242 | 8241 | {"type": "Polygon", "coordinates": [[[-122.02277, 37.59116], [-122.02184, 37.59328], [-122.02014, 37.59283], [-122.01998, 37.5927], [-122.01996, 37.59278], [-122.01978, 37.59273], [-122.01984, 37.59258], [-122.01988, 37.59261], [-122.01989, 37.5926], [-122.02051, 37.5908], [-122.02055, 37.59076], [-122.02061, 37.59075], [-122.02067, 37.59077], [-122.02102, 37.59099], [-122.0212, 37.59107], [-122.02229, 37.59137], [-122.02242, 37.59137], [-122.02256, 37.59134], [-122.02268, 37.59127], [-122.02277, 37.59116]]]} | Open Access 1 | 12577 | Charles F. Kennedy Park | 17138 | 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 | 10.506 | Charles F. Kennedy Park | 1971 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
8254 | 8254 | 8253 | {"type": "Polygon", "coordinates": [[[-122.00465, 37.58941], [-122.00431, 37.5891], [-122.00446, 37.58903], [-122.00461, 37.58901], [-122.00493, 37.58902], [-122.00509, 37.58905], [-122.0051, 37.58909], [-122.00508, 37.58911], [-122.00465, 37.58941]]]} | Open Access 1 | 12622 | Park Ridge Park | 23437 | 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.429 | Park Ridge 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 | |
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 |
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]);