units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 361 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
8245 | 8245 | 8244 | {"type": "Polygon", "coordinates": [[[-122.01486, 37.5871], [-122.01477, 37.58731], [-122.01473, 37.58734], [-122.01469, 37.58734], [-122.01457, 37.58728], [-122.01436, 37.58713], [-122.01433, 37.58709], [-122.01433, 37.58703], [-122.01435, 37.58696], [-122.01486, 37.5871]]]} | Open Access 1 | 12588 | Pride Rock Park | 23999 | 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.273 | Pride Rock 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 | |
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 | |
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 | |
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 | |
8234 | 8234 | 8233 | {"type": "Polygon", "coordinates": [[[-122.06613, 37.57192], [-122.06545, 37.57195], [-122.06538, 37.57193], [-122.06537, 37.5719], [-122.06537, 37.57182], [-122.06538, 37.57164], [-122.06542, 37.57148], [-122.0655, 37.57133], [-122.06582, 37.57146], [-122.06612, 37.57165], [-122.06613, 37.57192]]]} | Open Access 1 | 12610 | Union Landing Park | 26656 | 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.85 | Union Landing Park | 0 | Local Park 2 | 4 | |
11581 | 11581 | 11580 | {"type": "Polygon", "coordinates": [[[-122.02879, 37.58852], [-122.02857, 37.58904], [-122.02791, 37.58886], [-122.02787, 37.58884], [-122.02785, 37.58881], [-122.02789, 37.58858], [-122.02787, 37.58831], [-122.02788, 37.58819], [-122.02879, 37.58852]]]} | Open Access 1 | 23669 | Ralph and Mary Ruggieri Senior Center | 24096 | 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.215 | Ralph and Mary Ruggieri Senior Ctr. | 0 | Local Recreation Area 3 | 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 | |
8225 | 8225 | 8224 | {"type": "Polygon", "coordinates": [[[-122.07457, 37.60045], [-122.07457, 37.60048], [-122.07339, 37.60018], [-122.07235, 37.59975], [-122.07209, 37.59958], [-122.07188, 37.5994], [-122.07171, 37.59916], [-122.07158, 37.59888], [-122.07154, 37.59866], [-122.07152, 37.59822], [-122.07147, 37.59817], [-122.07142, 37.59789], [-122.07121, 37.59787], [-122.07133, 37.59699], [-122.07173, 37.59685], [-122.07176, 37.59697], [-122.07159, 37.59795], [-122.0716, 37.59865], [-122.07163, 37.59882], [-122.07167, 37.59897], [-122.07176, 37.59916], [-122.07184, 37.5993], [-122.07192, 37.59928], [-122.07207, 37.59943], [-122.07221, 37.59955], [-122.07235, 37.59963], [-122.07255, 37.59973], [-122.07343, 37.6001], [-122.07443, 37.60034], [-122.07457, 37.60045]]]} | Open Access 1 | 12540 | Sugar Mill Landing Park | 25943 | 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.922 | Sugar Mill Landing 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 | |
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 | |
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 | |
8223 | 8223 | 8222 | {"type": "Polygon", "coordinates": [[[-122.06376, 37.595], [-122.06316, 37.59525], [-122.06309, 37.59521], [-122.06299, 37.59521], [-122.06236, 37.59546], [-122.06228, 37.59552], [-122.06228, 37.5956], [-122.06164, 37.59586], [-122.06144, 37.59572], [-122.06121, 37.59561], [-122.06147, 37.59502], [-122.06162, 37.59494], [-122.06173, 37.59509], [-122.06202, 37.59496], [-122.06204, 37.59488], [-122.06214, 37.59486], [-122.06276, 37.59458], [-122.06281, 37.59454], [-122.06319, 37.59462], [-122.06348, 37.59449], [-122.06356, 37.59468], [-122.06376, 37.595]]]} | Open Access 1 | 12528 | San Andreas Park | 24823 | 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 | 3.918 | San Andreas 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]);