Transcription
Flood Insurance Rate Map (FIRM)Database Technical ReferencePreparing Flood Insurance Rate Map DatabasesFebruary 2019
FIRM Database Technical ReferenceFor more information, please visit the FEMA Guidelines and Standards for Flood RiskAnalysis and Mapping webpage odrisk-analysis-and-mapping)). Copies of the Standards for Flood Risk Analysis andMapping policy, related guidance, technical references, and other information about theguidelines and standards development process are all available here. You can also searchdirectly by document title at www.fema.gov/library.Implementation InstructionsThis version of the Technical Reference must be used on projects as described below.Generally, the changes in this version may also be implemented on any project, incoordination with the FEMA Project and Contracting Officer’s Representative.Revision DateFebruary 2019ImplementationImplemented for all projects beginning Data Development afterMarch 1, 2019Table of RevisionsThe following summary of changes details revisions to this document subsequent to itsmost recent version in February 2018.Affected Sectionor SubsectionRevisionDateSections 3, 4, 8and 9February2019Guidelines and Standards forFlood Risk Analysis and MappingRevision DescriptionRemoved S CBRS and added newLEVEE AN TYP field in S LeveePage iFIRM Database Technical Reference
FIRM Database Technical ReferenceTable of ContentsFlood Insurance Rate Map (FIRM) Database Technical Reference . iPreparing Flood Insurance Rate Map Databases . iFIRM Database Technical Reference . 11.FIRM Database Overview . 22.File Formats and Setup . 23.Table Descriptions . 24.FIRM Database Table Deliverables by MIP Data Capture Task . 65.Field Specifications . 95.1Field Types . 95.1.1GDB Field Specifics .95.1.2Shapefile Field Specifics . 105.1.3Primary Key Fields . 105.2Field Domains . 105.3Acceptable Null Values . 116.Metadata and Sources . 117.Spatial Reference Systems . 138.Topology Rules . 139.FIRM Database Tables . 19Table: S Alluvial Fan . 19Table: S Base Index . 22Table: S BFE. 23Table: S Cst Gage. 26Table: S Cst Tsct Ln . 29Table: S Datum Conv Pt . 36Table: S FIRM Pan . 38Table: S Fld Haz Ar . 41Table: S Fld Haz Ln . 47Table: S Gage . 48Table: S Gen Struct. 50Guidelines and Standards forFlood Risk Analysis and MappingPage iiFIRM Database Technical Reference
FIRM Database Technical ReferenceTable: S HWM. 52Table: S Hydro Reach . 54Table: S Label Ld . 55Table: S Label Pt. 56Table: S Levee . 59Table: S LiMWA . 62Table: S LOMR . 63Table: S Nodes . 64Table: S PFD Ln. 66Table: S PLSS Ar . 67Table: S Pol Ar . 69Table: S Profil Basln . 72Table: S Riv Mrk. 75Table: S Stn Start . 77Table: S Subbasins . 78Table: S Submittal Info . 80Table: S Topo Confidence . 83Table: S Trnsport Ln . 85Table: S Tsct Basln . 87Table: S Wtr Ar . 89Table: S Wtr Ln . 90Table: S XS . 92Table: Study Info . 95Table: L Comm Info. 100Table: L Comm Revis . 104Table: L Cst Model . 105Table: L Cst Struct . 111Table L Cst Tsct Elev . 112Table: L ManningsN . 114Table: L Meetings. 115Guidelines and Standards forFlood Risk Analysis and MappingPage iiiFIRM Database Technical Reference
FIRM Database Technical ReferenceTable: L MT2 LOMR . 116Table: L Mtg POC . 118Table: L Pan Revis . 120Table: L Pol FHBM . 121Table: L Profil Bkwtr El . 122Table: L Profil Label . 124Table: L Profil Panel . 125Table: L Source Cit . 128Table: L Summary Discharges . 130Table: L Summary Elevations. 132Table: L Survey Pt. 134Table: L XS Elev . 137Table: L XS Struct . 14210.National Flood Hazard Layer . 14410.1 NFHL Field Changes . 14510.2 NFHL Spatial Reference Systems . 145List of TablesTable 1: FIRM Database Table Summary . 2Table 2: FIRM Database Submittal Table . 7Table 3: Source Citation Abbreviations. 12Table 4: Topology Rules . 14Table 5: S Alluvial Fan . 21Table 6: S Base Index . 23Table 7: S BFE Requirements . 24Table 8: S BFE .25Table 9: S Cst Gage . 29Table 10: S Cst Tsct Ln . 35Table 11: S Datum Conv Pt . 38Guidelines and Standards forFlood Risk Analysis and MappingPage ivFIRM Database Technical Reference
FIRM Database Technical ReferenceTable 12: S FIRM Pan . 41Table 13: S Fld Haz Ar . 45Table 14: Flood Zone and Zone Subtype Cross-Walk . 45Table 15: S Fld Haz Ln . 48Table 16: S Gage . 50Table 17: S Gen Struct . 52Table 18: S HWM . 54Table 19: S Hydro Reach . 55Table 20: S Label Ld . 56Table 21: S Label Pt . 58Table 22: S Levee . 61Table 23: S LiMWA . 63Table 24: S LOMR. 64Table 25: S Nodes. 66Table 26: S PFD Ln . 67Table 27: S PLSS Ar . 69Table 28: S Pol Ar . 72Table 29: S Profil Basln . 75Table 30: S Riv Mrk . 76Table 31: S Stn Start . 78Table 32: S Subbasins . 79Table 33: S Submittal Info . 83Table 34: S Topo Confidence . 84Table 35: S Trnsport Ln . 86Table 36: S Tsct Basln . 88Table 37: S Wtr Ar . 90Table 38: S Wtr Ln . 91Table 39: S XS .94Table 40: Study Info . 99Table 41: L Comm Info . 103Guidelines and Standards forFlood Risk Analysis and MappingPage vFIRM Database Technical Reference
FIRM Database Technical ReferenceTable 42: L Comm Revis . 105Table 43: L Cst Model . 110Table 44: L Cst Struct. 112Table 45: L Cst Tsct Elev . 113Table 46: L ManningsN . 115Table 47: L Meetings . 116Table 48: L MT2 LOMR . 118Table 49: L Mtg POC. 119Table 50: L Pan Revis . 121Table 51: L Pol FHBM . 122Table 52: L Profil Bkwtr El . 123Table 53: L Profil Label . 125Table 54: L Profil Panel . 127Table 55: L Source Cit. 130Table 56: L Summary Discharges . 132Table 57: L Summary Elevations . 134Table 58: L Survey Pt . 136Table 59: L XS Elev. 142Table 60: L XS Struct . 144Guidelines and Standards forFlood Risk Analysis and MappingPage viFIRM Database Technical Reference
FIRM Database Technical ReferenceFIRM Database Technical ReferenceThe purpose of this Technical Reference is to provide guidance to the Mapping Partnerthat prepares the Preliminary and Final Flood Insurance Rate Map (FIRM) Databasesdelivered to the Federal Emergency Management Agency (FEMA). This TechnicalReference is not intended to specify in-process compilation or digitizing procedures but topresent standards and requirements for outputs and deliverables.Although occasional guidance (or best practices) have been included where necessarythroughout this Technical Reference, the majority of the content in this TechnicalReference represent standards to be used in preparing the Preliminary and Final FIRMDatabases.Due to the dynamic nature of some aspects of digital Geographic Information System(GIS) data, certain requirements are specified in documents outside of this TechnicalReference. The following documents are also referenced in this Technical Reference: FIRM Database Verification Tool (DVT) – Topology Verification Guidelines FIRM Panel Technical Reference Flood Insurance Study (FIS) Report Technical Reference Domain Tables Technical Reference Metadata Profiles Technical ReferenceThe most current version of these documents can be obtained from the FEMA Guidelinesand Standards for Flood Risk Analysis and Mapping webpage.Guidelines and Standards forFlood Risk Analysis and MappingPage 1FIRM Database Technical Reference
FIRM Database Technical Reference1. FIRM Database OverviewThe FEMA FIRM Database will store the digital GIS data used in the map productionprocess, as well as tabular information inside the Flood Insurance Study (FIS) report. TheDatabase will provide a standard, systematic method for FEMA to distributecomprehensive details of flood hazard identification studies to the public and others in adigital format.Additional guidance on individual FIRM Database elements may be found in the FIRMDatabase Guidance document.2. File Formats and SetupAll of the submitted GIS layers and tables must be in the same GIS file format. Therequirements for production FIRM Databases and FIRM Database Submittals aredescribed below. FIRM Database Submittals shall be delivered in the Environmental SystemsResearch Institute (Esri) Shapefile (SHP). In the production GDB the single FIRM Database feature dataset must be named“FIRM Spatial Layers”. In the production GDB, non-spatial tables shall exist outside of the“FIRM Spatial Layers” feature dataset, but inside the GDB. In the FIRM Database Submittal (SHP) deliverable, the FIRM Database Submittalnon-spatial tables must be in DBF files.3. Table DescriptionsA summary of the FIRM Database tables is provided in Table 1, along with a descriptionof the feature class purpose.Table 1: FIRM Database Table SummaryFIRM Table NameTable TypeTable DescriptionS Alluvial FanSpatialLocation and attributes of alluvial fan studies.S Base IndexSpatialLocation and attributes of the raster base mapfiles used for the FIRM.S BFESpatialLocation and attributes for Base Flood Elevationslines shown on FIRM.S Cst GageSpatialLocation and attributes of coastal gages.S Cst Tsct LnSpatialLocation and attributes for coastal transect linesshown on the FIRM.Guidelines and Standards forFlood Risk Analysis and MappingPage 2FIRM Database Technical Reference
FIRM Database Technical ReferenceFIRM Table NameTable TypeTable DescriptionS Datum Conv PtSpatialInformation regarding the location of points usedto determine the datum conversion factorperformed as part of this Flood Risk Project.S FIRM PanSpatialLocation and attributes for FIRM hardcopy mappanels.S Fld Haz ArSpatialLocation and attributes for flood insurance riskzones on the FIRM.S Fld Haz LnSpatialLocation and attributes for boundaries of floodinsurance risk zones on the FIRM.S GageSpatialInformation about gage locations used in thisFlood Risk Project.S Gen StructSpatialLocation and attributes for flood control structuresshown on the flood profile and FIRM.S HWMSpatialLocation of high water marks.S Hydro ReachSpatialLocation of hydrologic reach between nodes.S Label LdSpatialLocation and attributes for label leader linesshown on the FIRM.S Label PtSpatialLocation and attributes for labels shown on theFIRM.S LeveeSpatialLocation of levee centerlines, floodwalls, andclosure structures protecting accredited andprovisionally accredited levees.S LiMWASpatialLocation of Limit of Moderate Wave Actionboundary.S LOMRSpatialLocation and attributes for LOMRs not yetincorporated on the FIRM. Used only as part ofthe National Flood Hazard Layer (NFHL).S NodesSpatialLocation and attributes of points used to definethe topology of the hydrologic network.S PFD LnSpatialLocation and attributes for the primary frontaldune features for the coastal Flood Risk Projectarea.S PLSS ArSpatialLocation and attributes of sections, townships,and ranges on the FIRM.S Pol ArSpatialLocation and attributes for political jurisdictionsshown on the FIRM.S Profil BaslnSpatialLocation and attributes for profile baseline andstream centerline features for the Flood RiskProject area.Guidelines and Standards forFlood Risk Analysis and MappingPage 3FIRM Database Technical Reference
FIRM Database Technical ReferenceFIRM Table NameTable TypeTable DescriptionS Riv MrkSpatialLocation and attributes for river mile markersshown on the FIRM.S Stn StartSpatialLocation and attributes for starting points forstream distance measurements.S SubbasinsSpatialLocation and attributes for subbasins in thehydrologic analysis.S Submittal InfoSpatialLocation of areas updated in this Flood RiskProject along with attributes associated with eachsubmittal.S Topo ConfidenceSpatialLocation of topographic low confidence areasrequired by Procedure Memorandum 61.S Trnsport LnSpatialLocation and attributes for roads, railroads, andother transportation features shown on the FIRM.S Tsct BaslnSpatialLocation of mapped coastal transect baselinesand associated attribute information.S Wtr ArSpatialLocation and attributes for hydrography featuresshown on FIRM as areas.S Wtr LnSpatialLocation and attributes for hydrography featuresshown on FIRM as lines.S XSSpatialLocation and attributes for cross section lines inthe area covered by the FIRM. This layer mustcontain all cross sections in a model, not just thelettered cross sections.Study InfoNon-SpatialGeneral information about the FIRM.L Comm InfoLookupInformation about each community on the FIRM.L Comm RevisLookupInformation about revisions to each community’smaps used in the FIS Community Map Historytable.L Cst ModelLookupInformation about the coastal model used duringthe engineering analysis. It is used to create therespective table(s) in the FIS Report text.L Cst StructLookupInformation about coastal structures that affectlocal topography and flood hazards. It is used tocreate the respective table(s) in the FIS Reporttext.L Cst Tsct ElevLookupInformation about the coastal model elevations ateach mapped transect and those transectsreferenced in the FIS Report.L ManningsNLookupInformation regarding Manning’s “n” values shownin the FIS Report.Guidelines and Standards forFlood Risk Analysis and MappingPage 4FIRM Database Technical Reference
FIRM Database Technical ReferenceFIRM Table NameTable TypeTable DescriptionLookupInformation regarding the scoping and finalcommunity meetings that occur during the FloodRisk Project. It is used to create the respectivetable(s) in the FIS Report text.LookupInformation regarding LOMRs incorporated into orsuperseded by the FIRM. It is used to create therespective table(s) in the FIS Report text.L Mtg POCLookupInformation regarding the scoping and finalcommunity meetings that occur during the FloodRisk Project. It is used to create the respectivetable(s) in the FIS Report text.L Pan RevisLookupInformation about revisions to each FIRM panel.L Pol FHBMLookupInformation listing communities that have ever hadrevisions to their historic FHBM maps.LookupInformation about the backwater elevations foreach flood frequency by stream. This table is onlyrequired if RASPLOT v.3 or higher was used togenerate the FIS profiles.LookupThis table stores the labels needed for FIS profilesby stream when the labels are not associated withspecific cross sections or structures. This table isonly required if RASPLOT v.3 or higher was usedto generate the FIS profiles.LookupInformation to allow for defining panels for FISprofiles by stream. This table is only required ifRASPLOT v.3 or higher was used to generate theFIS profiles.L Source CitLookupListing and description of the sources ofinformation used in the FIRM or referenced in theFIS Report bibliography.L Summary DischargesLookupInformation about the hydrologic dischargeinformation associated with nodes referenced inthe FIS Report Summary of Discharges table.L Summary ElevationsLookupInformation about Special Flood Hazard Areaswith static elevations that are referenced in theFIS Report Summary of Elevations table.L Survey PtLookupCollection of field survey points captured andused as part of this flood study, per the DataCapture Technical Reference.L MeetingsL MT2 LOMRL Profil Bkwtr ElL Profil LabelL Profil PanelGuidelines and Standards forFlood Risk Analysis and MappingPage 5FIRM Database Technical Reference
FIRM Database Technical ReferenceFIRM Table NameL XS ElevL XS StructTable TypeTable DescriptionLookupInformation about the hydraulic model at eachmapped cross section and those cross sectionsreferenced in the FIS Report Floodway DataTables. This table is used to generate theFloodway Data Tables and contains lettered crosssections.LookupInformation about the cross sections at structuresneeded for the profiles. This table is only requiredif RASPLOT v.3 or higher was used to generatethe FIS profiles.4. FIRM Database Table Deliverables by MIP DataCapture TaskTable 2 presents the FIRM Database tables that apply to specific components of a FloodRisk Project. The scope of a particular project could include several of these activities;therefore, all of the tables from each of the activities involved in the project will likely applyto that project.Note that the ‘FIS Database Component’ column shows FIRM Database tables that areused to populate components of the FIS Report. The ‘Data Capture Component’ columnindicates FIRM Database tables that are applicable to MIP Data Capture tasks prior toDraft FIRM Database Data Capture. The ‘LOMR Component’ column indicates FIRMDatabase tables that are likely to be applicable to a LOMR that is being stitched into theNFHL.The FIRM Database tables are classified as either R – Required or A – Required ifApplicable, depending on the MIP Data Capture submittal requirements. These tablesneed to be submitted to FEMA via the Mapping Information Platform (MIP) workflow at thecorresponding MIP Data Capture task upload.Guidelines and Standards forFlood Risk Analysis and MappingPage 6FIRM Database Technical Reference
FIRM Database Technical ReferenceTable 2: FIRM Database Submittal TableDCS L Mtg POCR DCS L Source CitR DCS S Discovery MapR DCS S HUCR DCS S Pol ArR DCS S Prp FIRMPanA DCS S Trnsport LnR S Alluvial FanS Base IndexRAS BFEAS Cst GageA AAAAAA AAAA AAAAAA AAAALOMR ComponentData Capture ComponentDevelop Final Mapping ProductsData CaptureFIS Database ComponentRelatedElementsProduce Preliminary Products DataCaptureDraft FIRM DatabaseFloodplain Mapping Data CaptureAlluvial Fan Data CaptureCoastal Data CaptureHydrology Data CaptureHydraulics Data CaptureSurvey Data CaptureNew and Existing TopographicData CaptureTerrain Data CaptureBase Map Data CaptureTable NameDiscovery Data CaptureMIP Data Capture Tasks*AAAAA S Datum Conv PtAAAAA S FIRM PanRRRRR RRRR R5RRRR R6AAAA AAAAA AAAAA AAAA AS Label LdRRRS Label PtRRRS Cst Tsct LnRS Fld Haz ArRARRS Fld Haz LnS GageS Gen StructAAS HWMS Hydro ReachAAAAAARS LeveeAS LiMWAS LOMRNF HLS NodesRAAAAAA ARAAAAA AAAAA AAAA AOnlyRAS PFD LnAA S PLSS ArAAAAS Pol ArRRRRR AAAAA AS Profil BaslnGuidelines and Standards forFlood Risk Analysis and MappingRPage 7RAFIRM Database Technical Reference
FIRM Database Technical ReferenceALOMR ComponentAData Capture ComponentADevelop Final Mapping ProductsData CaptureFIS Database ComponentARelatedElementsPro
"FIRM_Spatial_Layers" feature dataset, but inside the GDB. In the FIRM Database Submittal (SHP) deliverable, the FIRM DatabaseSubmittal non-spatial tables must be in DBF files. 3. Table Descriptions A summary of the FIRM Database tables is provided in Table , along with a description 1 of the feature class purpose.
