Serramazzoni

Serramazzoni (Serramazzonese: La Sèra) is a comune (municipality) in the Province of Modena in the Italian region Emilia-Romagna, located about 45 kilometres (28 mi) west of Bologna and about 30 kilometres (19 mi) southwest of Modena.

Serramazzoni
Comune
Comune di Serramazzoni
Coat of arms
Location of Serramazzoni
Serramazzoni
Location of Serramazzoni in Italy
Serramazzoni
Serramazzoni (Emilia-Romagna)
Coordinates: 44°25′N 10°48′E
CountryItaly
RegionEmilia-Romagna
ProvinceModena (MO)
FrazioniFaeto, Ligorzano, Monfestino, Montagnana, Pazzano, Pompeano, Riccò, Rocca Santa Maria, San Dalmazio, Selva, Valle e Varana, Banzuola Nuova, Ca' Pasetti, Campofiore, Casa Amareto, Casa Bartolacelli-Stella, Casa Bizzarri, Casa Iaccheri, Casa Salvatori, Cerreto, Cornazzano, L'Edera, La Barbona, Malandrone-Sassatello, Montagnana Di Sopra, Montardone, Monte Tagliata, Mulino Del Berto, Pazzano Di Sopra, Pescarola, Pradello, San Dalmazio-Crocetta, San Rocco-Pazzano Sotto, Selva-Casa Martini, Varana Sassi, Villaggio Casellette
Government
 • MayorClaudio Bartolacelli
Area
 • Total93.96 km2 (36.28 sq mi)
Elevation
791 m (2,595 ft)
Population
 (1-1-2019)[2]
 • Total8,430
 • Density90/km2 (230/sq mi)
Demonym(s)Serramazzonese(i)
Time zoneUTC+1 (CET)
 • Summer (DST)UTC+2 (CEST)
Postal code
41028
Dialing code0536
Patron saintBlessed Virgin of the Rosary
Saint dayMay 8
WebsiteOfficial website

Serramazzoni borders the following municipalities: Fiorano Modenese, Maranello, Marano sul Panaro, Pavullo nel Frignano, Polinago, Prignano sulla Secchia, Sassuolo.

History

The first historical mention of Serramazzoni dates to 1327, when it was called Serra de Legorzano.

Main sights
  • Falls of Rio delle Borre
  • Via Vandelli
  • Sasso delle Streghe
  • Salsa della Cintora
  • Falls of Bucamante
  • National Museum of Antic Rose
  • Romanesque Church of Santa Maria Assunta

Districts

Serramazzoni is divided into the districts: Faeto, Ligorzano, Monfestino, Montagnana, Pazzano, Pompeano, Rocca Santa Maria, Riccò, San Dalmazio, Selva, Stella, Valle, Varana.

People
gollark: What? Why does it say it's doing a sequential scan now? Æ all is bee.
gollark: Slower, even.
gollark: Oops, it turns out I'm accidentally sorting by it instead of the rank, but it's equally slow after fixing that.
gollark: ```nonlocality=# EXPLAIN ANALYZE SELECT url, ts_rank(fts, query), ts_headline(fts::text, query, 'MaxWords=60') AS rank FROM pages, websearch_to_tsquery('bee') query WHERE fts @@ query ORDER BY rank LIMIT 1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=860.92..860.92 rows=1 width=96) (actual time=8506.425..8506.427 rows=1 loops=1) -> Sort (cost=860.92..861.05 rows=52 width=96) (actual time=8506.423..8506.425 rows=1 loops=1) Sort Key: (ts_headline((pages.fts)::text, query.query, 'MaxWords=60'::text)) Sort Method: top-N heapsort Memory: 25kB -> Nested Loop (cost=688.65..860.66 rows=52 width=96) (actual time=1.362..8505.403 rows=348 loops=1) -> Function Scan on websearch_to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.023..0.025 rows=1 loops=1) -> Bitmap Heap Scan on pages (cost=688.40..846.49 rows=52 width=142) (actual time=0.353..1.502 rows=348 loops=1) Recheck Cond: (fts @@ query.query) Heap Blocks: exact=231 -> Bitmap Index Scan on page_search_index (cost=0.00..688.39 rows=52 width=0) (actual time=0.320..0.320 rows=387 loops=1) Index Cond: (fts @@ query.query) Planning Time: 0.190 ms Execution Time: 8506.463 ms(13 rows)```
gollark: It's not a condition, it's an extra row on the output, and I can see exactly what it does via `EXPLAIN ANALYZE`.

References
  1. "Superficie di Comuni Province e Regioni italiane al 9 ottobre 2011". Istat. Retrieved 16 March 2019.
  2. All demographics and other statistics: Italian statistical institute Istat.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.