Name: EOC_ASSESSMENT_TABLE

Display Field: ASSESSORNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 10000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, length: 15 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 20 )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 100 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 100 )
• ASSESSMENTSTARTDATE ( type: esriFieldTypeDate, alias: ASSESSMENTSTARTDATE, length: 8 )
• ASSESSMENTENDDATE ( type: esriFieldTypeDate, alias: ASSESSMENTENDDATE, length: 8 )
• ASSESSORNAME ( type: esriFieldTypeString, alias: ASSESSORNAME, length: 50 )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, length: 50 )
• CONTACTNUMBER ( type: esriFieldTypeString, alias: CONTACTNUMBER, length: 50 )
• LOCATIONOFDAMAGE ( type: esriFieldTypeString, alias: LOCATIONOFDAMAGE, length: 255 )
• EVENTTYPE ( type: esriFieldTypeString, alias: EVENTTYPE, length: 50 )
• DWELLINGTYPE ( type: esriFieldTypeString, alias: DWELLINGTYPE, length: 50 , Coded Values: [SINGLE FAMILY: Single Family] , [MULTI FAMILY: Multi Family] , [MOBILE: Mobile] , ...1 more... )
• OCCUPANTSTATUS ( type: esriFieldTypeString, alias: OCCUPANTSTATUS, length: 50 , Coded Values: [OWNER: Owner] , [RENTER: Renter] )
• INSURANCETYPE ( type: esriFieldTypeString, alias: INSURANCETYPE, length: 50 , Coded Values: [HOMEOWNERS: Homeowners] , [RENTERS: Renters] , [FLOOD: Flood] , ...3 more... )
• BASEMENTDEPTHOFWATER ( type: esriFieldTypeInteger, alias: BASEMENTDEPTHOFWATER )
• FIRSTFLOORDEPTHOFWATER ( type: esriFieldTypeInteger, alias: FIRSTFLOORDEPTHOFWATER )
• STRUCTURALDAMAGE ( type: esriFieldTypeString, alias: STRUCTURALDAMAGE, length: 50 , Coded Values: [PARTIAL: Partial Damage] , [MINOR: Minor Damage] , [MAJOR: Major Damage] )
• PROJECTEDCOSTESTIMATE ( type: esriFieldTypeInteger, alias: PROJECTEDCOSTESTIMATE )
• INSPECTEDCOSTESTIMATE ( type: esriFieldTypeInteger, alias: INSPECTEDCOSTESTIMATE )
• KEYCOMMENTLETTERS ( type: esriFieldTypeString, alias: KEYCOMMENTLETTERS, length: 50 , Coded Values: [A: A - No one living in dwelling at time of event] , [B: B - Dwelling was not a primary residence] , [CFLOOD: C - Damage caused by sewer backup only] , ...5 more... )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 255 )
• GID_ADDRESSPIN_POINT ( type: esriFieldTypeGUID, alias: GID_ADDRESSPIN_POINT, length: 38 )
• HABITABILITYWITHREPAIRS ( type: esriFieldTypeSmallInteger, alias: HABITABILITYWITHREPAIRS , Coded Values: [0: No] , [1: Yes] )
• HABITABILITYWITHOUTREPAIRS ( type: esriFieldTypeSmallInteger, alias: HABITABILITYWITHOUTREPAIRS , Coded Values: [0: No] , [1: Yes] )
• UNINHABITABLE ( type: esriFieldTypeSmallInteger, alias: UNINHABITABLE , Coded Values: [0: No] , [1: Yes] )
• REPEAIRSNOTFEASIBLE ( type: esriFieldTypeSmallInteger, alias: REPEAIRSNOTFEASIBLE , Coded Values: [0: No] , [1: Yes] )
• BASEMENTLIVINGAREA ( type: esriFieldTypeSmallInteger, alias: BASEMENTLIVINGAREA , Coded Values: [0: No] , [1: Yes] )
• BASEMENTNONLIVINGAREA ( type: esriFieldTypeSmallInteger, alias: BASEMENTNONLIVINGAREA , Coded Values: [0: No] , [1: Yes] )
• HAZARDOUSMATERIALS ( type: esriFieldTypeSmallInteger, alias: HAZARDOUSMATERIAL , Coded Values: [0: No] , [1: Yes] )
• DEBRISREMOVAL ( type: esriFieldTypeSmallInteger, alias: DEBRISREMOVAL , Coded Values: [0: No] , [1: Yes] )
• PROTECTIVEMEASURES ( type: esriFieldTypeSmallInteger, alias: PROTECTIVEMEASURES , Coded Values: [0: No] , [1: Yes] )
• ROADSBRIDGES ( type: esriFieldTypeSmallInteger, alias: ROADSBRIDGES , Coded Values: [0: No] , [1: Yes] )
• WATERCONTROLFACILITIES ( type: esriFieldTypeSmallInteger, alias: WATERCONTROLFACILITIES , Coded Values: [0: No] , [1: Yes] )
• PUBLICBUILDING ( type: esriFieldTypeSmallInteger, alias: PUBLICBUILDING , Coded Values: [0: No] , [1: Yes] )
• PUBLICFACILITY ( type: esriFieldTypeSmallInteger, alias: PUBLICFACILITY , Coded Values: [0: No] , [1: Yes] )
• FACILITYUNDERCONSTRUCTION ( type: esriFieldTypeSmallInteger, alias: FACILITYUNDERCONSTRUCTION , Coded Values: [0: No] , [1: Yes] )
• PRIVATENONPROFIT ( type: esriFieldTypeSmallInteger, alias: PRIVATENONPROFIT , Coded Values: [0: No] , [1: Yes] )
• PUBLICRECREATION ( type: esriFieldTypeSmallInteger, alias: PUBLICRECREATION , Coded Values: [0: No] , [1: Yes] )
• HABITABLESTATUS ( type: esriFieldTypeString, alias: HABITABLESTATUS, length: 50 , Coded Values: [HABITABLENOREPAIRS: Habitable without Repairs] , [HABITABLEFEWREPAIRS: Habitable with Few Repairs] , [UNINHABITABLE: Uninhabitable/Needs Extensive Repair] , ...1 more... )
• ADDITIONALCOMMENTS ( type: esriFieldTypeString, alias: ADDITIONALCOMMENTS, length: 255 )
• FEMALEVELOFDAMAGE ( type: esriFieldTypeString, alias: FEMALEVELOFDAMAGE, length: 20 , Coded Values: [AFFECTED: Affected] , [MINOR: Minor] , [MAJOR: Major] , ...3 more... )

Relationships:

• AddressPIN_POINT (0) -- Related To: AddressPIN_POINT (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata