Flood Risk Data Fields
| Field Name | Field Type | Description |
|---|---|---|
| pbkey | Char (17) | Unique key |
| flood_id | Integer | Unique identifier |
| flood_mapname | Char (11) | Map panel identifier |
| flood_type | Char (3) | Flood Zone Map Type Note: Refer Type Table Definitions Note: For more
information refer Type Definitions, table below.
|
| flood_statecode | Char (2) | State FIPS code |
| flood_fipscode | Char (5) | Deprecated [Should be changed to Federal Information Processing Standard (FIPS) numerical code: 2-digit state FIPS +3-digit county FIPS] |
| flood_floodzone | Char (12) | Flood Zone with Base Flood Elevation (Bfe_Elev) or Additional |
| flood_prim_zone | Char (4) | Flood zone |
| flood_addl_info | Char (5) | Additional Information Note: For more information refer to the Additional
Information Definition, table below
|
| flood_bfe_elev | Char (4) | Base flood elevation (BFE) in feet |
| flood_commnum | Char (6) | Community number |
| flood_commstatus | Char (3) | Community status in the National Flood Insurance Program (NFIP) as follows:
|
| flood_map_eff_date | Date / Time | Map effective date |
| flood_lomr_date | Date / Time | Letter of Map Revision date |
| flood_casenumber | Char (20) | Letter of Map Revision case number |
| flood_elevation | Float | Point elevation |
| flood_dist100yr | Float | Distance to 100 year flood zone, within 1 mile |
| flood_distshx | Float | Distance to SHX or B flood zone, within 1 mile |
| flood_elv_prof | Char (512) | Elevation profile describing elevation changes (in feet) at specific intervals between the location and the nearest body of water. |
| flood_elev_prof_dist | Double | Distance in feet to the nearest water body listed in the elevation profile. |
| flood_waterbody | Char (100) | Name of the closest body of water. |
| Type | Remarks |
|---|---|
| Q3P | Printed PaneL in Q3 Data |
| Q3I | Panel Not Printed in Q3 Data |
| DLC | Printed/ Not Printed Panel in DLG Data |
| DLP | Printed Panel in DLG Data |
| DLI | Panel Not Printed in DLG Data |
| PFP | Printed Panel (with Enhanced Details Like Flood ways as per Old Specifications) |
| PFI | Panel Not Printed (with Enhanced Details Like Flood ways as per Old Specifications) |
| PF1 | Not Sure, May Be Typo Error, should be PFI |
| PFC | Printed/ Not Printed Panel (as per Old Specifications) |
| P2P | Printed Panel (Without Flood ways as per current specifications) |
| P2I | Panel Not Printed (as per Current Specifications) |
| P2C | Printed/ Not Printed Panel (as per Current Specifications) |
| NMP | Represents Never Mapped Areas |
| NMA | If a valid zone not available, Flood Zone given as NMA for Never Mapped Areas |
| Q3C | Printed/ Not Printed Panel in Q3 Data |
| Addl_Info | Remarks |
|---|---|
| UB | Flood Polygon with Cobra Zones where the identifcation Date is not clear on Firm |
| UB1 | Flood Polygon with Cobra Zones Dated 10-01-1983 |
| UB10 | Flood Polygon with Cobra Zones Dated 12-06-1999 |
| UB11 | Flood Polygon with Cobra Zones Dated 10-18-2004 |
| UB12 | Flood Polygon with Cobra Zones Dated 11-29-1999 |
| UB13 | Flood Polygon with Cobra Zones Dated 10-01-1983 |
| UB2 | Flood Polygon with Cobra Zones Dated 10-01-1983 |
| UB21 | Flood Polygon with Cobra Zones Dated 10-01-1983 |
| UB3 | Flood Polygon with Cobra Zones Dated 10-01-1983 |
| UB31 | Flood Polygon with Cobra Zones Dated 11-16-1991 |
| F-UB3 | Flood Polygon with Cobra Zones |
| UB4 | Flood Polygon with Cobra Zones Dated 10-23-1992 |
| UB41 | Flood Polygon with Cobra Zones Dated 10-23-1992 |
| UB5 | Flood Polygon with Cobra Zones Dated 11-15-1993 |
| UB51 | Flood Polygon with Cobra Zones Dated 11-16-1993 |
| UB6 | Flood Polygon with Cobra Zones Dated 2-24-1997 |
| UB61 | Flood Polygon with Cobra Zones Dated 2-24-1997 |
| UB8 | Flood Polygon with Cobra Zones Dated 2-23-1995 |
| UB9 | Flood Polygon with Cobra Zones Dated 10-19-2000 |
| UB91 | Flood Polygon with Cobra Zones Dated 10-27-2000 |
| (NULL) | Flood Polygon Not Covered with Cobra Zones and LOMR Updations |
| FE | Flood Polygon Falling within Flood Easement Boundary as Printed on Firms |
| LOMR | Flood Polygon with LOMR updates |
| F | Flood Polygon for which the the Base Flood Elevations are available |
| L | Flood Polygon Covered by Levees as Printed on Firms |