superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 361 sorted by map
This data as json, copyable, CSV (advanced)
Link | rowid | id | map ▼ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10359 | 10359 | 10358 | {"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 | Tidewater Park | 26350 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 2.424 | Tidewater Park | ||
6678 | 6678 | 6677 | {"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 | Mariner Park | 21854 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 4.887 | Mariner Park | ||
9526 | 9526 | 9525 | {"type": "Polygon", "coordinates": [[[-122.00075, 37.59239], [-121.99918, 37.59352], [-121.99776, 37.59254], [-121.99828, 37.59211], [-122.00075, 37.59239]]]} | Open Access 1 | Seven Hills Park | 25325 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 5.284 | Seven Hills Park | ||
7952 | 7952 | 7951 | {"type": "Polygon", "coordinates": [[[-122.0051, 37.58909], [-122.00465, 37.58941], [-122.00431, 37.5891], [-122.00446, 37.58903], [-122.00462, 37.58901], [-122.00494, 37.58902], [-122.00509, 37.58905], [-122.0051, 37.58909]]]} | Open Access 1 | Park Ridge Park | 23437 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.423 | Park Ridge Park | ||
11318 | 11318 | 11317 | {"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 | Windflower Park | 27626 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.175 | Windflower Park | ||
3709 | 3709 | 3708 | {"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 | Drigon Dog Park | 18273 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1.236 | Drigon Dog Park | ||
14072 | 14072 | 14071 | {"type": "Polygon", "coordinates": [[[-122.0074, 37.58556], [-122.00734, 37.58564], [-122.00663, 37.58548], [-122.00668, 37.58535], [-122.00671, 37.58532], [-122.00677, 37.58531], [-122.00714, 37.5854], [-122.00737, 37.5855], [-122.0074, 37.58556]]]} | Open Access 1 | Pacific Point Park | 31509 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.318 | Pacific Point Park | ||
11282 | 11282 | 11281 | {"type": "Polygon", "coordinates": [[[-122.01104, 37.59599], [-122.01091, 37.59608], [-122.01086, 37.59604], [-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.01072, 37.59571], [-122.01082, 37.59575], [-122.01093, 37.59572], [-122.01084, 37.59581], [-122.01104, 37.59599]]]} | Open Access 1 | Willow Park | 27585 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.845 | Willow Park | 2008 | |
8407 | 8407 | 8406 | {"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 | Pride Rock Park | 23999 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.273 | Pride Rock Park | ||
1599 | 1599 | 1598 | {"type": "Polygon", "coordinates": [[[-122.01505, 37.58006], [-122.01496, 37.58031], [-122.01471, 37.58083], [-122.01457, 37.58124], [-122.01436, 37.58121], [-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.01304, 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.01317, 37.5807], [-122.01314, 37.58062], [-122.01331, 37.58059], [-122.01383, 37.58023], [-122.01403, 37.57973], [-122.01455, 37.57985], [-122.01454, 37.57994], [-122.01505, 37.58006]]]} | Open Access 1 | Arroyo Park | 15619 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 11.57 | Arroyo Park | ||
9625 | 9625 | 9624 | {"type": "Polygon", "coordinates": [[[-122.01754, 37.59812], [-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.016, 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]]]} | Open Access 1 | Shorty Garcia Park | 25431 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 5.79 | Shorty Garcia Park | ||
3500 | 3500 | 3499 | {"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 | Decoto Plaza Park | 17987 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.467 | Decoto Plaza Park | ||
2847 | 2847 | 2846 | {"type": "Polygon", "coordinates": [[[-122.02277, 37.59116], [-122.02184, 37.59328], [-122.02014, 37.59283], [-122.01999, 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 | Charles F. Kennedy Park | 17138 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 10.507 | Charles F. Kennedy Park | 1971 | |
4369 | 4369 | 4368 | {"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 | Fred Castro Park | 19073 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.232 | Fred Castro Park | ||
11242 | 11242 | 11241 | {"type": "Polygon", "coordinates": [[[-122.02826, 37.58658], [-122.02821, 37.58672], [-122.02825, 37.58679], [-122.02771, 37.58803], [-122.02766, 37.58832], [-122.02766, 37.58857], [-122.02758, 37.58875], [-122.02421, 37.58783], [-122.02495, 37.5861], [-122.02512, 37.58604], [-122.02537, 37.58599], [-122.02565, 37.586], [-122.02826, 37.58658]]]} | Open Access 1 | William Cann Civic Center Park | 27539 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 17.787 | William Cann Civic Ctr. Park | 1979 | |
8483 | 8483 | 8482 | {"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 | Ralph and Mary Ruggieri Senior Center | 24096 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1.214 | Ralph and Mary Ruggieri Senior Ctr. | ||
5048 | 5048 | 5047 | {"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 | Heritage Oak Park | 19838 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.139 | Heritage Oak Park | 2000 | |
11243 | 11243 | 11242 | {"type": "Polygon", "coordinates": [[[-122.04737, 37.58934], [-122.04736, 37.58978], [-122.0473, 37.5897], [-122.04722, 37.58966], [-122.04493, 37.58904], [-122.04485, 37.58903], [-122.04475, 37.58906], [-122.04425, 37.58892], [-122.04426, 37.58805], [-122.04515, 37.58785], [-122.04519, 37.58784], [-122.04524, 37.58794], [-122.04589, 37.58778], [-122.04615, 37.58798], [-122.04671, 37.58904], [-122.04737, 37.58934]]]} | Open Access 1 | William Cann Memorial Park | 27540 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 7.582 | William Cann Memorial Park | ||
10420 | 10420 | 10419 | {"type": "Polygon", "coordinates": [[[-122.0554, 37.59912], [-122.05534, 37.59948], [-122.05526, 37.5995], [-122.05517, 37.59956], [-122.05492, 37.59957], [-122.05453, 37.59967], [-122.05441, 37.59965], [-122.05433, 37.59968], [-122.05424, 37.59959], [-122.05395, 37.59957], [-122.05393, 37.59965], [-122.05352, 37.59978], [-122.05341, 37.59964], [-122.05327, 37.59951], [-122.05308, 37.59941], [-122.05285, 37.59935], [-122.05291, 37.59907], [-122.05175, 37.59906], [-122.05169, 37.59898], [-122.05159, 37.59893], [-122.05121, 37.59893], [-122.0512, 37.59793], [-122.05131, 37.59791], [-122.05148, 37.59782], [-122.05293, 37.59782], [-122.05295, 37.59779], [-122.05394, 37.59779], [-122.05394, 37.5989], [-122.05458, 37.5989], [-122.05476, 37.59894], [-122.0554, 37.59912]]]} | Open Access 1 | Town Estates Park | 26488 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 11.662 | Town Estates Park | ||
1399 | 1399 | 1398 | {"type": "Polygon", "coordinates": [[[-122.0624, 37.57825], [-122.06239, 37.57829], [-122.06149, 37.57931], [-122.06113, 37.57754], [-122.06116, 37.57752], [-122.06102, 37.57685], [-122.0621, 37.57746], [-122.06224, 37.57808], [-122.06228, 37.57814], [-122.06238, 37.57821], [-122.0624, 37.57825]]]} | Open Access 1 | Accinelli Park | 15247 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 4.1 | Accinelli Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);