superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 361 sorted by MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9428 | 9428 | 9427 | {"type": "Polygon", "coordinates": [[[-122.08479, 37.57859], [-122.08414, 37.57879], [-122.08397, 37.57847], [-122.0839, 37.57841], [-122.08381, 37.57838], [-122.08371, 37.57837], [-122.08254, 37.57848], [-122.08249, 37.57847], [-122.08247, 37.57845], [-122.08217, 37.57719], [-122.08212, 37.57703], [-122.08394, 37.5769], [-122.08479, 37.57859]]]} | Open Access 1 | Sea Breeze Park | 25229 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 7.711 | Sea Breeze 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 | ||
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 | ||
10042 | 10042 | 10041 | {"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 | Sugar Mill Landing Park | 25943 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1.924 | Sugar Mill Landing Park | ||
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 | ||
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 | ||
10557 | 10557 | 10556 | {"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 | Union Landing Park | 26656 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.85 | Union Landing 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 | |
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 | ||
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 | |
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 | ||
12465 | 12465 | 12464 | {"type": "Polygon", "coordinates": [[[-122.07502, 37.59279], [-122.07482, 37.5928], [-122.0748, 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 | Holly Community Center | 32427 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.098 | Holly Community Ctr. | ||
14071 | 14071 | 14070 | {"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 | Cerruti Park | 31508 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.246 | Cerruti 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 |
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]);