Name: sde.DBO.Harvey_Losses_Zip_Long

Display Field: ZCTA5CE10

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ZCTA5CE10 (type: esriFieldTypeString, alias: ZCTA5CE10, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ClaimType (type: esriFieldTypeString, alias: ClaimType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Damages (type: esriFieldTypeString, alias: Damages, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_OBJEC (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_ZCTA5 (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_AFFGE (type: esriFieldTypeString, alias: AFFGEOID10, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_TOT_P (type: esriFieldTypeInteger, alias: Total Payout, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_Dev_A (type: esriFieldTypeDouble, alias: Developed Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_Acres (type: esriFieldTypeDouble, alias: Total Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_Claim (type: esriFieldTypeInteger, alias: Number of Claims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_XZONE (type: esriFieldTypeDouble, alias: Percent outside floodplain, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_SBA_H (type: esriFieldTypeInteger, alias: Total SBA home loan amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_SBA_B (type: esriFieldTypeInteger, alias: Total SBA business loan amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_SBA_T (type: esriFieldTypeInteger, alias: Total SBA loan amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_IHP (type: esriFieldTypeInteger, alias: Total Individual Assistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_Total (type: esriFieldTypeInteger, alias: Total Losses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_HU_AC (type: esriFieldTypeInteger, alias: Housing Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_Proj_ (type: esriFieldTypeInteger, alias: Additional Development (2015), SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_NICB_ (type: esriFieldTypeInteger, alias: NICB Auto Claims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_NICB1 (type: esriFieldTypeInteger, alias: NICB Flood Claims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_NIC_1 (type: esriFieldTypeInteger, alias: NICB Wind Claims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_NIC_2 (type: esriFieldTypeInteger, alias: All other NICB Claims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_NIC_3 (type: esriFieldTypeInteger, alias: Total NICB claims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sde_DBO_Harvey_Losses_Zip_TWIA (type: esriFieldTypeInteger, alias: Wotal Wind Losses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHAPE_STArea__ (type: esriFieldTypeDouble, alias: SHAPE_STArea__, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHAPE_STLength__ (type: esriFieldTypeDouble, alias: SHAPE_STLength__, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: sde.DBO.Harvey_Losses_Zip_Long
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Harvey_Losses_Zip (0) -- Related To: Harvey Losses, by Zipcode (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/16/2021 5:45:39 PM

Schema Last Edit Date: 7/16/2021 5:45:39 PM

Data Last Edit Date: 7/16/2021 5:45:39 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat