Draft Panels
The S_FIRM_Pan table contains information about the FIRM panel area.

Fields:
FIRM_ID: Primary key for table lookup. Assigned by table creator.
ST_FIPS: State FIPS. This is the two-digit code that corresponds to the State Federal Information Processing Standard (FIPS) code. This is a standard numbering system used by the Federal government, defined in FIPS Pub 6-4. These two numbers correspond to the first two digits of the panel number. Acceptable values for this field are listed in the D_State_FIPS table.
PCOMM: Community or County Identification Number. This is the third through the sixth digits of the panel number. For community based maps this corresponds to the FEMA Community Identification number. For countywide maps this is the county (or county equivalent) FIPS code with a “C.”
PANEL: Panel Number. This is seventh through the 10th digits in the complete panel number. This is assigned by the scale of the map and the position within the community or county. The panel number scheme is described in detail in Appendix K of these Guidelines.
SUFFIX: Map Suffix. This is the final digit in the complete panel number. This is a letter suffix at the end of the panel number. The map suffix is incremented one letter every time the panel gets republished.
FIRM_PAN: FIRM Panel Number. This is the complete 11-digit FIRM panel number, which is made up of ST_FIPS, PCOMM, PANEL, and SUFFIX. This is the FIRM panel number that is shown in the title block of the map.
Work_Map:  Yes or No.  This field indicates if the panel has been revised with new data.
PANEL_TYP: Panel Type. The type of FIRM panel identifies whether the panel is printed or not, and whether it is community based or countywide. Acceptable values for this field are listed in the D_Panel_Typ table.
SCALE: Map Scale. This is the denominator of the FIRM scale as a ratio. For example, 24000 is the denominator for a 1? = 2000' map. Acceptable values for this field are listed in the D_Scale table.
PNP_REASON: Panel Not Printed Reason. This is the explanation for the FIRM panels that are not printed. Only completed if the hardcopy panel is not printed by FEMA. For example “No Special Flood Hazard Areas.” See Appendix K of these Guidelines for commonly used values.
NW_LAT: Latitude of North West corner of the panel.
NW_LONG: Longitude of North West corner of the panel.
SE_LAT: Latitude of South East corner of the panel.
SE_LONG: Longitude of South East corner of the panel.
COUNTY: Name of the County 
STATE: Name of the State
nan
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'FIRM_ID', 'type': 'esriFieldTypeString', 'alias': 'FIRM_ID', 'sqlType': 'sqlTypeOther', 'length': 11, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ST_FIPS', 'type': 'esriFieldTypeString', 'alias': 'ST_FIPS', 'sqlType': 'sqlTypeOther', 'length': 2, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PCOMM', 'type': 'esriFieldTypeString', 'alias': 'PCOMM', 'sqlType': 'sqlTypeOther', 'length': 4, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PANEL', 'type': 'esriFieldTypeString', 'alias': 'PANEL', 'sqlType': 'sqlTypeOther', 'length': 4, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SUFFIX', 'type': 'esriFieldTypeString', 'alias': 'SUFFIX', 'sqlType': 'sqlTypeOther', 'length': 1, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FIRM_PAN', 'type': 'esriFieldTypeString', 'alias': 'FIRM_PAN', 'sqlType': 'sqlTypeOther', 'length': 11, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PANEL_TYP', 'type': 'esriFieldTypeString', 'alias': 'PANEL_TYP', 'sqlType': 'sqlTypeOther', 'length': 35, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SCALE', 'type': 'esriFieldTypeString', 'alias': 'SCALE', 'sqlType': 'sqlTypeOther', 'length': 5, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PNP_REASON', 'type': 'esriFieldTypeString', 'alias': 'PNP_REASON', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'NW_LAT', 'type': 'esriFieldTypeString', 'alias': 'NW_LAT', 'sqlType': 'sqlTypeOther', 'length': 15, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'NW_LONG', 'type': 'esriFieldTypeString', 'alias': 'NW_LONG', 'sqlType': 'sqlTypeOther', 'length': 15, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SE_LAT', 'type': 'esriFieldTypeString', 'alias': 'SE_LAT', 'sqlType': 'sqlTypeOther', 'length': 15, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SE_LONG', 'type': 'esriFieldTypeString', 'alias': 'SE_LONG', 'sqlType': 'sqlTypeOther', 'length': 15, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'COUNTY', 'type': 'esriFieldTypeString', 'alias': 'COUNTY', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'STATE', 'type': 'esriFieldTypeString', 'alias': 'STATE', 'sqlType': 'sqlTypeOther', 'length': 10, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Work_Map', 'type': 'esriFieldTypeString', 'alias': 'Work_Map', 'sqlType': 'sqlTypeOther', 'length': 3, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'PDF_URL', 'type': 'esriFieldTypeString', 'alias': 'URL to Preliminary Workmap PDF', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Notes', 'type': 'esriFieldTypeString', 'alias': 'Notes', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'URL_DATA', 'type': 'esriFieldTypeString', 'alias': 'URL to Preliminary Workmap Data', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Rel_Date', 'type': 'esriFieldTypeString', 'alias': 'Release Date', 'sqlType': 'sqlTypeOther', 'length': 20, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'GlobalID', 'type': 'esriFieldTypeGlobalID', 'alias': '', 'sqlType': 'sqlTypeOther', 'length': 38, 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'Shape__Area', 'type': 'esriFieldTypeDouble', 'alias': 'Shape__Area', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'Shape__Length', 'type': 'esriFieldTypeDouble', 'alias': 'Shape__Length', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__PRELIMIN__F4B70D85D8C73A92', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_166.PRELIMINARY_WORKMAPS_GREATLAKES_PUBLIC_DRAFT_PANELS_Shape_sidx', 'fields': 'SHAPE', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}, {'name': 'Shape__Area_Index', 'fields': 'Shape__Area', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'Shape__Length_Index', 'fields': 'Shape__Length', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'GlobalID_idx', 'fields': 'GlobalID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'COUNTY_Index', 'fields': 'COUNTY', 'isAscending': True, 'isUnique': False, 'description': 'COUNTY_Index', 'indexType': 'Attribute'}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [0, 0, 0, 0], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [255, 170, 0, 255], 'width': 2}}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': [{'labelPlacement': 'esriServerPolygonPlacementAlwaysHorizontal', 'where': None, 'labelExpression': '[FIRM_PAN] CONCAT  NEWLINE  CONCAT [COUNTY]', 'useCodedValues': True, 'symbol': {'type': 'esriTS', 'color': [0, 200, 0, 255], 'verticalAlignment': 'bottom', 'horizontalAlignment': 'left', 'rightToLeft': False, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'kerning': True, 'haloColor': [255, 255, 255, 255], 'haloSize': 2, 'font': {'family': 'Arial', 'size': 10, 'style': 'normal', 'weight': 'bold', 'decoration': 'none'}}, 'minScale': 144447.638572, 'maxScale': 0}]}
[]
[{'name': 'Draft Panels (supersede ABFE)', 'description': '', 'drawingTool': 'esriFeatureEditToolPolygon', 'prototype': {'attributes': {'Rel_Date': None, 'FIRM_ID': ' ', 'ST_FIPS': ' ', 'PCOMM': ' ', 'PANEL': ' ', 'SUFFIX': ' ', 'FIRM_PAN': ' ', 'PANEL_TYP': ' ', 'SCALE': ' ', 'PNP_REASON': ' ', 'NW_LAT': ' ', 'NW_LONG': ' ', 'SE_LAT': ' ', 'SE_LONG': ' ', 'COUNTY': ' ', 'STATE': ' ', 'Work_Map': ' ', 'PDF_URL': None, 'Notes': None, 'URL_DATA': None}}}]