{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["About","Notes","Instructions","DatasetMetadata","FlowFeature","FieldList","DataValidTerms","ReviewComments"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":3,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"About","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Title","AASG Geothermal Data: VolcanicFlowFeature"]
[null,"Version","0.1"]
[null,"Description","This spreadsheet indicates the content for Volcanic Flow features. The model is based on the IUGS CGI interoperability working group. Note that volcanic flows require a geometry field that contains the geographic location of the flow trace (typically named 'shape' in ESRI feature classes). The actual template for deploying services must be a GIS feature class, thus cannot be implemented as an Excel spreadsheet. Design is focused on flows portrayed as polygons.  "]
[null,"Editors"]
[null,"Template History"]
[null,"Revision","Comment","Person","Date"]
[null,"0.1","Start with subset of fields from Volcanic Vent template, and edit from there","Diane Love","2011-10-13"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Data History"]
[null,"Date","Comment","Person"]

{"sheet":"Notes","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,5],[5,0,5,5],[11,0,11,5],[7,0,7,5],[8,0,8,5],[10,0,10,5],[6,0,6,5],[9,0,9,5]]}
[]
["This template defines the content model for a service that delivers basic information characterizing a geologic unit. The content model presented here is also intended to present key information necessary to query a formation and to evaluate it. Depending on the source data, it may be useful to compile multiple observations for a single unit in this table. "]
[]
[null,"required field; if no values are available, use 'missing', 'null' or leave blank."]
[]
["sheets in this workbook:"]
["About: contains brief  explanation of this workbook, workbook development history, and data revision history."]
["DatasetMetadata: contains information for name of agency and contacts for agency providing the information in this spreadsheet workbook."]
["FlowFeature contains fields for information used to describe volcanic flows."]
["ReviewerComments: provides a form to use for requesting additional data, clarify apparent confusion, and explain requirements of specific fields.  The form is meant to be initially used by the AZGS reviewer.  When returned to the state, a responder should make notes of data changes made.  If necessary, a followup review by AZGS will make additional notes."]
["FieldList Table has one row for each data element, along with scope notes on usage of that element. This view can be used to correlate the interchange format elements with content in existing databases at data providing agency as part of the data mapping preparation."]
["DataValidTerms: collection of example controlled vocabulary lists; as the project progresses these should converge on  vocabularies that can be used by all parties to achieve semantic interoperability. "]

{"sheet":"Instructions","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,6],[4,0,4,6],[6,0,6,6],[8,0,8,6]]}
["Instructions"]
[]
["This AASG data template defines a content model for volcanic flow features. This content model is presented in a table view on the FlowFeature tab, and as a list of fields in the FieldList tab. The 'Dataset metadata' tab contains fields for identifying the person or persons who created the feature dataset. This information will be propagated to the ISO metadata document describing the dataset that is inserted into the data system catalog. "]
[]
["This template addresses the use case in which an organization already has data compiled in some tabular form. The fields in the existing table that you already have need to be matched with corresponding fields in this template, and columns of information from the existing table copied into the corresponding column in this table. Only the pink-shaded columns are required to be  non-blank. In general, we expect that any useful data compilation will contain the minimum content requested here. If some required data are not available, put 'missing' in that field.  Other columns in the template that are not applicable or for which you have no information may be hidden to reduce clutter and make the table easier to work with. "]
[]
["The template worksheet may also be imported into a database management system (dbms) as a table and populated using database queries. For those who are comfortable with data manipulation in a dbms, this is generally an easier way to assemble the desired table. "]
[]
["If you have questions, please contact the project team at metadata@usgin.org."]

{"sheet":"DatasetMetadata","index":3,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["Dataset Metadata"]
["Contact information for the data provider shall be included with this template. \n"]
["Title of dataset"]
["Description of dataset"]
["Author name"]
["Author role"]
["Author organization affiliation name"]
["Author e-mail address"]
["Author telephone number"]
["Author postal Address"]
["Source citation"]
["Contact person name"]
["Contact position name "]
["Contact organization affiliation name"]
["Contact e-mail address"]
["Contact telephone number"]
["Contact postal Address"]
["Use Constraints"]
["Notes on conventions used in this dataset"]
["Data Entry Source"]

{"sheet":"FlowFeature","index":4,"n_rows":2,"n_cols":27,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["FeatureURI","VolcanicGroup","VolcVentName","Name","Label","Description","FeatureType","OtherID","County","State","LocationKeyword","PLSS_Meridians","SRS","LocationUncertaintyStatement","specificationURI","GeologicUnit","geologicHistory","YoungestAge","OldestAge","YoungestRadiometricAge_Ma","OldestRadiometricAge_Ma","AgeUncertainty_Ma","AgeSource","MaterialComposition","Notes","Source","MetadataURI"]
["WA:110700020000",null,"Mount St. Helens vent 12","Wanapum","Wanapum","Viscous  magma, containing much gas, erupted under reasonably low pressure, a glowing cloud containing ash  and pumice  were thrown into the air, this cloud fell back onto the earth like an avalanche before it can cool off. ","Nuees ardentes","WGS:34562","Hightop","WA","Hogback Mountain",null,"WGS 84","Plotted on topo map from aerial photos",null,"Lithostratigraphic Unit ","Miocene to Recent","Recent","Miocene",1.1999999999999999E-3,5.2,0.01,"K-Ar w.r. Damon et al., 1988","Andesite",null,"USGS, 2005. DM2540 WashingtonVolcanicFIeld, Blowup Quad, Washington, USA. Scale 1:25,000."]

{"sheet":"FieldList","index":5,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["Data Mapping Worksheet"]
["This sheet is designed to assist mapping from an existing dataset into the interchange data fields. Elements (a.k.a. fields, attributes) in the interchange format are listed down the left side. The Table and Field columns can be used to identify your existing table and the field in that table that contains content to map into the interchange element. The notes column can be used to indicate if any calculation or filtering is necessary on the existing field to transform to the interchange format."]
["Interchange Content Element","implementation","DataTypeName","Cardinality","Element Description","Element Instructions",null,"Element Notes"]
["FeatureURI","URI","URI",1,"Unique identifier for this  geologic unit record. This is the identifier that will be used to cross reference logs, samples, and other observations to the unit represented by the FeatureURI. ","If a name is given it should be used here, otherwise the featureURI should include one of the 'OtherID' values.","Text indication of  how the spatial extent of the feature was determined. ObservationMethod is a convenience property that provides a quick and dirty approach to observation metadata when data are reported using a feature view (as opposed to observation view). "]
["VolcanicGroup","free text","string","0..1","Name of volcanic Group – used if the vent is part of a grouping of volcanoes. E.g. “Wrangells” or “Cook Inlet”",null,"Name of the larger volcanic grouping"]
["VolcVentName","free text","string",1,"The name of the vent dentified by the FeatureURI.",null,"Volcanic vent recognized name or other identifier"]
["Name","string","free text",1,"Mandatory, one value.\nTerm from controlled vocabulary classifying kind of Geologic Unit. Vocabulary is included on DataValidTerms tab.  For GeoSciML thematic view, this will be mapped to a GeologicUnitTypeURI identifying the category concept in the CGI controlled vocabulary.","Mandatory (1..many)\nhuman-intelligible label for feature. May be multi-valued. Separate names with a pipe character ('|')."]
["Label","string","free text",1,"short text string to identify feature in map portrayals. Ideally should be unique in the scope of this dataset.  If feature represents all outcrops of a map unit in some area, this is the label that will be placed in polygons representing that unit.","Use geologic Unit name or abbreviation.","The Public Land Survey System (PLSS) uses a series of meridians and baselines as reference points for the determination of Township and Range.  A meridian is a specific line of longitude; a baseline is a specific line of latitude. \nA township is a 6x6 mile grid square that is divided into 1x1 mile sections.  Townships are measured by their distance from baselines and meridians.  In the PLSS grid, rows are called townships whilst columns are called ranges. Sometimes the surveyors got a little lost and the sections are not perfect 1 mile squares; also irregular sections result from periodic corrections in the grid to account for the Earth being a spheroid, not a plane."]
["Description","string","free text","0..1","Free text for describing the geologic unit, strike and dip, observation methods and other information regarding the feature.","Description of methods, observations and other information not included in the fields in this template.","Township is based on 6 mile intervals north or south of a baseline.  For example, a township of 4N (T4N or 4N) indicates the fourth 6x6 mile township north of a given baseline."]
["FeatureType","term","string",1,"Type of feature (\"StratoVolcano\" or \"Vent\" or \"Fissure\")",null,"Type of volcano and/or vent"]
["OtherID","string","free text","0…1","Other names associated with the geologic unit.","Other identifiers for the particular unit occurrence or a geologic unit classifier (from a lexicon) used to categorize the feature.","Each 6x6 mile PLSS township is divided into 1x1 mile sections, of which there are 36 per township.  Each section is individually numbered, from 1 to 36, starting at the NE corner, counting west (6 miles), then south (1 mile), then back east, then south, back west.... ziz-zagging to section 36 in the SE corner of the township."]
["County","string","free text",1,"County in which the observations of the feature took place.","The county in which the observations or measurements were made regarding the feature.","PLSS sections can be divided into quarters; in such cases, relevant quarters are listed by their relative location within the section: northwest, southwest, northeast, and southeast."]
["State","string","free text",1,"State in which the observations of the feature took place.","The state in which the observations or measurements were made regarding the feature.","A parcel is an \"area with some implication for landownership or land use.\" In some areas, sections are subdivided into parcels used for legal descriptions instead of quarter sections."]
["LocationKeyword","string","free text","0..1","Keyword for the location not listed in this template.",null,"Distance in meters east from UTM zone meridian "]
["PLSS_Meridians","string","free text","0..1","Baseline and meridian to which Township and Range are referenced.",null,"Distance in meters north from either the equator or the south pole"]
["SRS","string","free text",1,"The spatial reference system","It is recommended that an EPSG code be used to identify the SRS used to specify the location of the geologic unit identified by the featureURI.  If an EPSG code is used, identify it as such with the prefix 'EPSG:'    For common EPSG codes, see the Data Valid Terms tab.\n\nIt is recommended that the WGS 84 spatial reference system be used, so as to facilitate interoperability.","The UTM zone is one of 60 zones worldwide which are based on lines of longitude.\n\nA datum is a reference point against which measurements are made.  With regard to geocentric and spherical (geographic) coordinate systems, the datum defines the center of the earth and, usually, a rough approximation for the shape of the earth called a reference ellipsoid; both the center of the earth and the reference ellipsoid are used as references to determine the coordinates of an object on the earth's surface."]
["LocationUncertaintyStatement","string","free text",1,"Free text statement describing the uncertainty of the coordinates of the origin of the well that contains the borehole identified by the HeaderURI.","Provide information about how location was established and level of uncertainty"]
["specificationURI","http URI","string","0..1","Ideally an http URI that dereferences to a full complex feature representation. If the FeatureURI is an http URI that can be dereferenced to one or more representations, this URI is redundant.\nFor example the URI could refer to a GeoSciML ShearDisplacementStructure feature that describes the instance in detail. ",null,"This element describes the surface location of the feature, which is normally on the Earth surface."]
["GeologicUnit","free text","string","0..1","Geologic unit or units (separate multiple with a pipe \"|\" character).",null,"This element describes the surface location of the feature, which is normally on the Earth surface."]
["geologicHistory","Free text","string","1","Free text specifying age of feature",null,"Spatial reference systems specify a datum, a reference ellipsoid, and a coordinate system.\n\nMost known spatial reference systems are associated with an EPSG code number; EPSG stands for European Petroleum Survey Group."]
["YoungestAge","free text","string","0..1","Youngest age range of the feature."]
["OldestAge","free text","string","0..1","Oldest age range of the feature."]
["YoungestRadiometricAge_Ma","decimal","double","0..1","Youngest age range in millions of years.",null,"length units are same as those used for reporting depth"]
["OldestRadiometricAge_Ma","decimal","double","0..1","Oldest age range in millions of years.",null,"Information in the Element Notes column was derived from the following sources:\n1). Baker, Ron.  A Primer of Oil-Well Drilling.  Austin, TX.  Petroleum Extension Service, the University of Texas at Austin.  1979.\n2). International School of Well Drilling.  Drilling Methods.  http://welldrillingschool.com/courses/pdf/DrillingMethods.pdf\n3). Kimerling, A. Jon et al.  Map Use: Reading and Analysis.  6th Edition.  Redlands, CA.  ESRI Press Academic.  2009.\n4). Society of Petrophysicists and Well-Log Analysts (SPWLA).  API Numbering Guidelines.  http://www.spwla.org/technical/api-technical"]
["AgeUncertainty_Ma","decimal","double","0..1","Uncertainty of age readings in millions of years."]
["AgeSource","free text","string","0..1","Source of the age dating"]
["MaterialComposition","free text","string","0..1","Volcanic material descritption."]
["Notes","free text","string","0..1","Free text for any additional notes "]
["Source","string","free text",1,"Source or sources of information in this record.","Include bibliographic citations if appropriate."]
["MetadataURI","URI","URI","0..1","URI referring to a metadata record describing the provenance of data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"DataValidTerms","index":6,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,5,24,9],[17,5,17,9],[18,5,18,9],[19,5,19,9],[20,5,20,9],[21,5,21,9],[22,5,22,9],[23,5,23,9],[11,5,11,9],[12,5,12,9],[14,5,14,9],[15,5,15,9],[16,5,16,9]]}
[]
["Data Valid Terms"]
[]
["Spatial Reference Systems"]
["EPSG Code","Label"]
[4267,"NAD27"]
[4269,"NAD83"]
[4326,"WGS84"]
[]
["Geologic Unit type","Scope notes"]
["Allostratigraphic Unit ","Geologic unit defined by bounding surfaces. Not necessarily stratified. Donovon (2004, IUGS abstract Florence) makes good case for use of a noncommittal term for the bounding surface. While there may be no agreement that a given stratal boundary is a discontinuity, there is consensus that all the identified boundaries are stratal surfaces.â?\u009d Includes: 1. Unconformity bounded units (Salvador 1994), defined by bounding stratigraphic discontinuities ('significant unconformities'; unconformity is defined as surface of erosion in Salvador 1994). 2. Sequence stratigraphic unit, an allostratigraphic unit that is used to interpret the depositional origin of sedimentary strata and assumes, though this is not always stated, an implicit connection to base level change. It does this by establishing how the sequence of strata accumulated in order in the sedimentary section over a subdividing framework of surfaces.",null,"International Stratigraphic Chart Age terms"]
["Alteration Unit ","Geologic unit defined by alteration process.. ",null,"sort code","ordinal era name","URI"]
["Artificial Ground ","Geologic unit defined by genesis involving direct human action to deposit or modify material.. ",null,"1.0.0","Phanerozoic Eon ","urn:cgi:classifier:ICS:StratChart:2008:Phanerozoic"]
["Biostratigraphic Unit ","Geologic unit defined based on fossil content. Five kinds of biozones are recognized by the revised NACSN (Lenz et al., 2000, Note 64, a recommended complete replacement of Articles 48 through 54 of the North American Stratigraphic Code (NACSN, 1983) accepted for publication 2000.): range biozone, interval biozone, lineage biozone, assemblage biozone, and abundance biozone. These represent different approaches to defining and recognizing biozones.",null,"1.1.0","Cenozoic Era ","urn:cgi:classifier:ICS:StratChart:2008:Cenozoic"]
["Chronostratigraphic Unit ","Geologic unit that includes all rocks formed during a specific interval of geologic time. ",null,"1.1.1.1","Holocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Holocene"]
["Deformation Unit ","Lithotectonic unit defined by deformation style or characteristic geologic structure observable in outcrop.",null,"1.1.1.2","Pleistocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Pleistocene"]
["Excavation Unit ","Geologic unit defined by human-made genesis involving excavation. Not necessarily defined by landform (a hole...), as they could have been subsequently filled/landscaped etc. If the excavation is filled becomes an excavation with artificial ground wholly or partly superimposed on it. This sort of thing can become quite important in urban geology where an excavation can be filled and landscaped.. ",null,"1.1.1.2.1","Upper Pleistocene Age ","urn:cgi:classifier:ICS:StratChart:2008:UpperPleistocene"]
["Geologic Unit ","Type of geologic unit is unknown, unspecified, irrelevant, or some type not included in the vocabulary. Type makes no implication for required properties or cardinalities. This is the root concept for the type hierarchy.",null,"1.1.1.2.2","Ionian Age ","urn:cgi:classifier:ICS:StratChart:2008:Ionian"]
["Geomorphologic Unit ","Geologic unit defined by surface landform, e.g. hummocky moraine. ",null,"1.1.1.2.3","Calabrian Age ","urn:cgi:classifier:ICS:StratChart:2008:Calabrian"]
["Geophysical Unit ","Geologic unit defined by its geophysical characteristics. Denotes that the properties used to define the unit are measured by intrumental techniques, not directly observable by humans, e.g. density, magnetic susceptibility, magnetization, electrical conductivity.",null,"1.1.1.2.4","Gelasian Age ","urn:cgi:classifier:ICS:StratChart:2008:Gelasian"]
["Lithodemic Unit ","Lithostratigraphic unit that lacks stratification. ",null,"1.1.2","Neogene Period ","urn:cgi:classifier:ICS:StratChart:2008:Neogene"]
["Lithogenetic Unit ","Geologic unit defined by genesis. The genesis is manifested by material properties, but the material is not the defining property. Example-- alluvial deposits, glacial deposits.",null,"1.1.2.1","Pliocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Pliocene"]
["Lithologic Unit ","Geologic unit defined by lithology independent of relationships to other units. Denotes a 'kind' of rock body characterized by lithology, e.g. basaltic rocks.",null,"1.1.2.1.1","Piacenzian Age ","urn:cgi:classifier:ICS:StratChart:2008:Piacenzian"]
["Lithostratigraphic Unit ","Geologic unit defined on the basis of observable and distinctive lithologic properties or combination of lithologic properties and stratigraphic relationships. Denotes a particular body of rock.",null,"1.1.2.1.2","Zanclean Age ","urn:cgi:classifier:ICS:StratChart:2008:Zanclean"]
["Lithotectonic Unit ","Geologic unit defined defined on basis of structural or deformation features, mutual relations, origin or historical evolution. Contained material may be igneous, sedimentary, or metamorphic.",null,"1.1.2.2","Miocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Miocene"]
["Magnetostratigraphic Unit ","Geologic unit defined by magnetic characteristics.",null,"1.1.3","Paleogene Period ","urn:cgi:classifier:ICS:StratChart:2008:Paleogene"]
["Mass Movement Unit ","Geologic unit produced by gravity driven, down-slope displacemnt of material, and characterized by the type of movement giving rise to the deposit, and by how the individual movement types present in the deposit are related in time and space.",null,"1.1.3.1","Oligocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Oligocene"]
["Pedoderm ","Geologic unit defined based on soil development and character. Pedoderm is not a surface classification unit because soil classification requires knowledge of the soil profile, which always extends some distance beneath the surface.",null,"1.1.3.2","Eocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Eocene"]
["Pedostratigraphic Unit ","Geologic unit that represents a single pedologic horizon in a sequence of strata (consolidated or non-consolidated). The presence of an overlying geologic unit is required, but locally the soil horizon may be at the Earth surface (in which case is may be coincident with a Pedoderm). See discussion at https://www.seegrid.csiro.au/twiki/bin/view/CGIModel/PedostratigraphicUnit. ",null,"1.1.3.3","Paleocene Epoch ","urn:cgi:classifier:ICS:StratChart:2008:Paleocene"]
["Polarity Chronostratigraphic Unit ","Geologic unit defined by primary magnetic-polarity record imposed whien the rock was deposited or crystallized during a specific interval of geologic time. Kind of chronostratigraphic unit and kind of geophysical unit.",null,"1.2.0","Mesozoic Era ","urn:cgi:classifier:ICS:StratChart:2008:Mesozoic"]

{"sheet":"ReviewComments","index":7,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,0,5,3],[2,0,2,4]]}
["Other and General Information:"]
[]
["Please read the comments box in the Feature header for the column.  These feature headers cannot be changed or they are not interoperable and searchable online.  Everyone must use the same feature headers.  You may not have all the data for each column or you may have more which should likely be placed into another content model (say lithology).  If you have more features and want to include as necessary data, ask Steve Richards to add to the content model template so everyone has a chance to provide that data."]
[]
["Comments:"]
[]
["Tab","Column","Feature Header","Comment","AZGS Reviewer","Date","State Responder","Action Taken","Date"]