Skip to main content
SpringerLink
Log in

GEOCITY: a drill-hole database as a tool to assess geological hazard in Napoli urban area

  • Original Article
  • Published:
Environmental Geology

An Erratum to this article was published on 11 August 2005

Abstract

The geological investigations of Napoli city, which represent the basic data source for geological hazard assessment, are characterized by the absence of well exposed and continuous outcrops, mainly due to the development of the urbanized area occurred in the last 50 years. In order to increase the set of available geological information, a database named GEOCITY has been realized on the base of 900 drill holes with stratigraphies reflecting the main drill-hole surveys performed during the last century. The true key moments in its construction were the homogenisation of different data and the identification of the geological formations. A detailed analysis of the drill-hole raw data allowed us to define the database entities, while the features of the deposits, the distribution of products and the reference drill holes were used to identify the geological formation. The analysis performed using the GEOCITY database made it possible to better assess volcanic hazard from Campi Flegrei and Somma-Vesuvio and the hazard related to alluvial phenomena that Napoli city is exposed to.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9

Similar content being viewed by others

References

  • Alberico I, Lirer L, Petrosino P, Zeni G (2001) Geomorfologia e geologia dell’area urbana di Napoli. Geoitalia 3° Forum FIST 2001

  • Alberico I, Lirer L, Petrosino P, Scandone R (2002) A methodology for the evaluation of long-term volcanic risk from pyroclastic flows in Campi Flegrei (Italy). J Volcanol Geoth Res 116:63–78

    Article  Google Scholar 

  • Alberico I, Lirer L, Petrosino P (2003) A drill-hole database as a tool to investigate geological hazard in Napoli urban area. EGS-AGU-EUG Joint Assembly, Nizza 2003. Geophys Res Abstr 5:14228

    Google Scholar 

  • Alberico I, Caiazzo S, Dal Piaz S, Lirer L, Petrosino P, Scandone R (2004) Volcanic risk and evolution of the territorial system in the active volcanic areas of Campania. EGU 2004. Geophys Res Abstr 6:02738

    Google Scholar 

  • Alessio M, Bella F, Improta S, Belluomini G, Cortesi C, Turi B (1973) University of Rome Carbon-14dates X. Radiocarbon 15:165–178

    Google Scholar 

  • ArcView Spatial Analystv® (1996) Copyright 1996 Esri, printed in the United State of America

  • ArcView® GIS (1996) Copyright 1996 Esri, printed in the United State of America

  • Bain KA, Giles JRA (1993) The BGS digital map production system. Overview of the Logical Data Model: British Geological Survey Technical Report, WO/93/20R. Keyworth, p 17

    Google Scholar 

  • Bain KA, Giles JRA (1997) A standard model for storage of geological map data. Comput Geosci 23(6):613–620

    Article  Google Scholar 

  • Bellucci F (1994) Nuove conoscenza stratigrafiche sui depositi vulcanici del sottosuolo del settore meridionale della Piana Campana Boll. Soc Geol It 113:395–420

    Google Scholar 

  • Bernknopf RL, Brookshire DS, Soller DR, McKee MJ, Sutter JF, Matti JC, Campbell RH (1993) Societal value of geologic maps: Washington, DC. U.S. Geological Survey Circular, vol 1111, p 53

    Google Scholar 

  • Deino AL, Orsi G, de Vita S, Piochi M (2004) The age of the Neapolitan Yellow Tuff caldera-forming eruption (Campi Flegrei caldera—Italy) assessed by 40Ar/39Ar dating method. J Volcanol Geoth Res 133(1/4):157–170

    Article  Google Scholar 

  • Di Filippo G, Lirer L, Maraffi S, Capuano M (1991) L’eruzione di Astroni nell’attività recente dei Campi Flegrei. Boll Soc Geol It 110:309–331

    Google Scholar 

  • Di Girolamo P, Ghiara MR, Lirer L, Munno R, Rolandi G, Stanzione D (1984) Vulcanologia e Petrologia dei Campi Flegrei. Boll Soc Geol It 103(2):349–413

    Google Scholar 

  • Flores RM (1999) Database creation and resource evaluation methodology. U.S. Geological Survey Professional Paper 1625-A, p 16

  • Gautier DL (1999) Data model for single geological maps: an application of the National Geological Map Data Model. In U.S. Geological Survey Open File Report, pp 99–386

    Google Scholar 

  • Giles JRA, Lowe DJ, Bain KA (1997) Geological dctionaries-citical elements of every geological database. Comput Geosci 23(6):621–626

    Article  Google Scholar 

  • Johnston K, Ver Hoef JM, Krivoruchko K, Lucas N (2001) Geostatistical analyst manual. Copyright 2001 Esri, printed in the United State of America

  • Laxton JL, Becken K (1996) The design and implementation of a spatial database for the production of geological maps. Comput Geosci 22(77):723–733

    Article  Google Scholar 

  • Lirer L, Luongo G, Scandone R (1987) On the volcanological evolution of Campi Flegrei. Eos 68:226–324

    Google Scholar 

  • Lirer L, Di Vito M, Giacomelli L, Scandone R, Vinci A (1990) Contributo delle analisi granulometriche alla ricostruzione della dinamica dell’eruzione di Averno (Campi Flegrei). Boll Soc Geol It 109:583–597

    Google Scholar 

  • Lirer L, Vinci A, Alberico I, Gifuni T, Bellucci F, Petrosino P, Tinterri R (2001a) Occurrence of inter-eruption debris flow and hyperconcentrated flood-flow deposits on Vesuvio volcano, Italy. Sediment Geol 139:151–167

    Article  Google Scholar 

  • Lirer L, Petrosino P, Alberico I (2001b) Hazard assessment at volcanic fields: the Campi Flegrei case history. J Volcanol Geoth Res 112:53–73

    Article  Google Scholar 

  • Lirer L, Petrosino P, Alberico I, Postiglione I (2001c) Long-term volcanic hazard forecasts based on Somma-Vesuvio past eruptive activity. Bull Volcanol 63:45–60

    Article  Google Scholar 

  • de Riso R, Lirer L (1999) Piano Territoriale di Coordinamento PTCP 99 Provincia di Napoli, pp 63–70

  • RockWork® v (2002) Manual. Copyright 1983–2001 by RockWare, Inc. Printed in the United State of America

  • Rolandi G, Maraffi S, Petrosino P, Lirer L (1993) The Ottaviano eruption of Somma-Vesuvio (8000 y B.P.): a magmatic fall and flow-forming eruption. J Volcanol Geoth Res 58:43–65

    Article  Google Scholar 

  • Rosi M, Sbrana A (1987) Phlegrean Fields, Progetto Finalizzato Geodinamica, Quaderni della Ricerca Scientifica 114. CNR, Roma, p 175

  • Russo F, Calderoni G, Lombardo M (1998) Evoluzione geomorfologica della depressione Bagnoli-Fuorigrotta: periferia urbana della città di Napoli. Boll Soc Geol It 117:21–33

    Google Scholar 

  • Santacroce R (1987) Somma-Vesuvius. Progetto Finalizzato Geodinamica , Quaderni della Ricerca Scientifica 114. CNR, Roma, p 225

  • Scherillo A, Franco E (1967) Introduzione alla carta stratigrafica del territorio comunale di Napoli. Atti Acc Pontaniana, Napoli 16:27–37

    Google Scholar 

  • de Vita S, Orsi G, Civetta L, Caradente A, D’Antonio M, Deino A, di Cesare T, Di Vito MA, Fisher RV, Isaia R, Marotta E, Necco A, Ort M, Pappalardo L, Piochi M, Southon J (1999) The Agnano-Monte Spina eruption (4100 years BP) in the restless Campi Flegrei caldera (Italy). J Volcanol Geoth Res 91:269–301

    Article  Google Scholar 

Download references

Acknowledgments

The authors would like to thank Ing. G. Lombardi and Geol. P. Miraglino of Ufficio Difesa Suolo of Napoli Municipality Office for the support in the surveys collection. An anonymous reviewer is gratefully thanked for the useful revision, which greatly improved the manuscript.

Author information

Authors and Affiliations

  1. C.I.R.AM. Centro Interdipartimentale di Ricerca Ambiente, University of Napoli Federico II, via Mezzocannone 16, 80134, Napoli, Italy

    I Alberico & L Lirer

  2. Dipartimento di Scienze della Terra, University of Napoli Federico II, L.go San Marcellino 10, 80138, Napoli, Italy

    P Petrosino, G Zeni, F D’Andrea & L Lirer

Authors
  1. I Alberico
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. P Petrosino
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. G Zeni
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. F D’Andrea
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. L Lirer
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to P Petrosino.

Additional information

An erratum to this article is available at http://dx.doi.org/10.1007/s00254-005-0034-y.

Appendix

Appendix

The entities of the GEOCITY database fall in three groups: the first group has no spatial component and contains entities, which can be regarded as dictionaries; the second group comprises entities having both a spatial and an aspatial component, and the third group has no spatial component and contains only attributes.

The drill-hole survey table, which isreferred to the third group (entities with only attributes), contains:

  • Primary key to identify one drill-hole survey

  • Foreign key used to link this table with the drill-hole table

  • Start data

  • End data

  • Public or private owner

  • Drill-hole company.

The drill-hole table, which isreferred to the second group (entities with a spatial and an aspatial component), contains the following main attributes:

  • Primary key used to identify each drill hole

  • Foreign key used to link this table with the drill-hole survey table

  • Old code used to link the data recorded in the database with the original reports

  • Geocoding address used to indicate the address where one or more drill holes fall

  • Municipal code used to know in which building block the drill holes fall

  • X, Y coordinates (UTM; Gauss-Boaga; Monte Mario, Rome) used to place each drill hole in the space by geographic coordinates

  • IGM map code of map at scale 1:25.000 used to know the drill-hole location

  • Type of drill used to distinguish the different kinds of drilling: percussion drill or rotary drill.

The stratigraphy table, which is referred to the second group (entities with a spatial and an aspatial component), contains the following main attributes:

  • Primary key used to identify one stratigraphic unit

  • Foreign key used to link this table with the drill-hole table

  • Upper bed boundary (depth absolute value) used to identify the top of one stratigraphic unit

  • Lower bed boundary (depth absolute value) used to identify the bottom of one stratigraphic unit

  • Upper bed boundary (relative depth to the field plain) used to identify the top of one stratigraphic unit

  • Lower bed boundary (relative depth to the field plain) used to identify the bottom of one stratigraphic unit

  • Lithologic description contains the raw description of drill-hole report

  • Stratigraphic code, is the foreign key used to link this table to the stratigraphic code table, which contains descriptive information about the litostratigraphy.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Alberico, I., Petrosino, P., Zeni, G. et al. GEOCITY: a drill-hole database as a tool to assess geological hazard in Napoli urban area. Environ Geol 47, 751–762 (2005). https://doi.org/10.1007/s00254-004-1199-5

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00254-004-1199-5

Keywords

Search

Navigation