Name: EOC_ASSESSMENT_TABLE

Display Field: ASSESSORNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, editable: true, nullable: true, length: 3, defaultValue: 999, modelName: GEODBID )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FEATUREID )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCE )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: SOURCETYPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PRODUCTIONNOTES )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, editable: true, nullable: true, length: 255, defaultValue: UNSET, modelName: REPLICAFILTER )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: CREATEDBY )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: MODIFIEDBY )
• ASSESSMENTSTARTDATE ( type: esriFieldTypeDate, alias: ASSESSMENTSTARTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSESSMENTSTARTDATE )
• ASSESSMENTENDDATE ( type: esriFieldTypeDate, alias: ASSESSMENTENDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSESSMENTENDDATE )
• ASSESSORNAME ( type: esriFieldTypeString, alias: ASSESSORNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSESSORNAME )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPARTMENT )
• CONTACTNUMBER ( type: esriFieldTypeString, alias: CONTACTNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTACTNUMBER )
• LOCATIONOFDAMAGE ( type: esriFieldTypeString, alias: LOCATIONOFDAMAGE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONOFDAMAGE )
• EVENTTYPE ( type: esriFieldTypeString, alias: EVENTTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVENTTYPE )
• DWELLINGTYPE ( type: esriFieldTypeString, alias: DWELLINGTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DWELLINGTYPE , Coded Values: [SINGLE FAMILY: Single Family] , [MULTI FAMILY: Multi Family] , [MOBILE: Mobile] , ...1 more... )
• OCCUPANTSTATUS ( type: esriFieldTypeString, alias: OCCUPANTSTATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OCCUPANTSTATUS , Coded Values: [OWNER: Owner] , [RENTER: Renter] )
• INSURANCETYPE ( type: esriFieldTypeString, alias: INSURANCETYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSURANCETYPE , Coded Values: [HOMEOWNERS: Homeowners] , [RENTERS: Renters] , [FLOOD: Flood] , ...3 more... )
• BASEMENTDEPTHOFWATER ( type: esriFieldTypeInteger, alias: BASEMENTDEPTHOFWATER, editable: true, nullable: true, defaultValue: null, modelName: BASEMENTDEPTHOFWATER )
• FIRSTFLOORDEPTHOFWATER ( type: esriFieldTypeInteger, alias: FIRSTFLOORDEPTHOFWATER, editable: true, nullable: true, defaultValue: null, modelName: FIRSTFLOORDEPTHOFWATER )
• STRUCTURALDAMAGE ( type: esriFieldTypeString, alias: STRUCTURALDAMAGE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STRUCTURALDAMAGE , Coded Values: [PARTIAL: Partial Damage] , [MINOR: Minor Damage] , [MAJOR: Major Damage] )
• PROJECTEDCOSTESTIMATE ( type: esriFieldTypeInteger, alias: PROJECTEDCOSTESTIMATE, editable: true, nullable: true, defaultValue: null, modelName: PROJECTEDCOSTESTIMATE )
• INSPECTEDCOSTESTIMATE ( type: esriFieldTypeInteger, alias: INSPECTEDCOSTESTIMATE, editable: true, nullable: true, defaultValue: null, modelName: INSPECTEDCOSTESTIMATE )
• KEYCOMMENTLETTERS ( type: esriFieldTypeString, alias: KEYCOMMENTLETTERS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KEYCOMMENTLETTERS , 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, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPTION )
• GID_ADDRESSPIN_POINT ( type: esriFieldTypeGUID, alias: GID_ADDRESSPIN_POINT, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GID_ADDRESSPIN_POINT )
• HABITABILITYWITHREPAIRS ( type: esriFieldTypeSmallInteger, alias: HABITABILITYWITHREPAIRS, editable: true, nullable: true, defaultValue: null, modelName: HABITABILITYWITHREPAIRS , Coded Values: [0: No] , [1: Yes] )
• HABITABILITYWITHOUTREPAIRS ( type: esriFieldTypeSmallInteger, alias: HABITABILITYWITHOUTREPAIRS, editable: true, nullable: true, defaultValue: null, modelName: HABITABILITYWITHOUTREPAIRS , Coded Values: [0: No] , [1: Yes] )
• UNINHABITABLE ( type: esriFieldTypeSmallInteger, alias: UNINHABITABLE, editable: true, nullable: true, defaultValue: null, modelName: UNINHABITABLE , Coded Values: [0: No] , [1: Yes] )
• REPEAIRSNOTFEASIBLE ( type: esriFieldTypeSmallInteger, alias: REPEAIRSNOTFEASIBLE, editable: true, nullable: true, defaultValue: null, modelName: REPEAIRSNOTFEASIBLE , Coded Values: [0: No] , [1: Yes] )
• BASEMENTLIVINGAREA ( type: esriFieldTypeSmallInteger, alias: BASEMENTLIVINGAREA, editable: true, nullable: true, defaultValue: null, modelName: BASEMENTLIVINGAREA , Coded Values: [0: No] , [1: Yes] )
• BASEMENTNONLIVINGAREA ( type: esriFieldTypeSmallInteger, alias: BASEMENTNONLIVINGAREA, editable: true, nullable: true, defaultValue: null, modelName: BASEMENTNONLIVINGAREA , Coded Values: [0: No] , [1: Yes] )
• HAZARDOUSMATERIALS ( type: esriFieldTypeSmallInteger, alias: HAZARDOUSMATERIAL, editable: true, nullable: true, defaultValue: null, modelName: HAZARDOUSMATERIALS , Coded Values: [0: No] , [1: Yes] )
• DEBRISREMOVAL ( type: esriFieldTypeSmallInteger, alias: DEBRISREMOVAL, editable: true, nullable: true, defaultValue: null, modelName: DEBRISREMOVAL , Coded Values: [0: No] , [1: Yes] )
• PROTECTIVEMEASURES ( type: esriFieldTypeSmallInteger, alias: PROTECTIVEMEASURES, editable: true, nullable: true, defaultValue: null, modelName: PROTECTIVEMEASURES , Coded Values: [0: No] , [1: Yes] )
• ROADSBRIDGES ( type: esriFieldTypeSmallInteger, alias: ROADSBRIDGES, editable: true, nullable: true, defaultValue: null, modelName: ROADSBRIDGES , Coded Values: [0: No] , [1: Yes] )
• WATERCONTROLFACILITIES ( type: esriFieldTypeSmallInteger, alias: WATERCONTROLFACILITIES, editable: true, nullable: true, defaultValue: null, modelName: WATERCONTROLFACILITIES , Coded Values: [0: No] , [1: Yes] )
• PUBLICBUILDING ( type: esriFieldTypeSmallInteger, alias: PUBLICBUILDING, editable: true, nullable: true, defaultValue: null, modelName: PUBLICBUILDING , Coded Values: [0: No] , [1: Yes] )
• PUBLICFACILITY ( type: esriFieldTypeSmallInteger, alias: PUBLICFACILITY, editable: true, nullable: true, defaultValue: null, modelName: PUBLICFACILITY , Coded Values: [0: No] , [1: Yes] )
• FACILITYUNDERCONSTRUCTION ( type: esriFieldTypeSmallInteger, alias: FACILITYUNDERCONSTRUCTION, editable: true, nullable: true, defaultValue: null, modelName: FACILITYUNDERCONSTRUCTION , Coded Values: [0: No] , [1: Yes] )
• PRIVATENONPROFIT ( type: esriFieldTypeSmallInteger, alias: PRIVATENONPROFIT, editable: true, nullable: true, defaultValue: null, modelName: PRIVATENONPROFIT , Coded Values: [0: No] , [1: Yes] )
• PUBLICRECREATION ( type: esriFieldTypeSmallInteger, alias: PUBLICRECREATION, editable: true, nullable: true, defaultValue: null, modelName: PUBLICRECREATION , Coded Values: [0: No] , [1: Yes] )
• HABITABLESTATUS ( type: esriFieldTypeString, alias: HABITABLESTATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HABITABLESTATUS , Coded Values: [HABITABLENOREPAIRS: Habitable without Repairs] , [HABITABLEFEWREPAIRS: Habitable with Few Repairs] , [UNINHABITABLE: Uninhabitable/Needs Extensive Repair] , ...1 more... )
• ADDITIONALCOMMENTS ( type: esriFieldTypeString, alias: ADDITIONALCOMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDITIONALCOMMENTS )
• FEMALEVELOFDAMAGE ( type: esriFieldTypeString, alias: FEMALEVELOFDAMAGE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: FEMALEVELOFDAMAGE , Coded Values: [AFFECTED: Affected] , [MINOR: Minor] , [MAJOR: Major] , ...3 more... )

Templates:

• Name: EOC_ASSESSMENT_TABLE
  Description:
  Prototype:
  ADDITIONALCOMMENTS: null
  HABITABLESTATUS: null
  GEODBID: 999
  FEATUREID: null
  PUBLICRECREATION: null
  PRIVATENONPROFIT: null
  SOURCE: null
  SOURCETYPE: UNKNOWN
  FEMALEVELOFDAMAGE: UNKNOWN
  PRODUCTIONNOTES: null
  REPLICAFILTER: UNSET
  FACILITYUNDERCONSTRUCTION: null
  PUBLICFACILITY: null
  ASSESSMENTSTARTDATE: null
  ASSESSMENTENDDATE: null
  ASSESSORNAME: null
  DEPARTMENT: null
  CONTACTNUMBER: null
  LOCATIONOFDAMAGE: null
  EVENTTYPE: null
  DWELLINGTYPE: null
  OCCUPANTSTATUS: null
  INSURANCETYPE: null
  BASEMENTDEPTHOFWATER: null
  FIRSTFLOORDEPTHOFWATER: null
  STRUCTURALDAMAGE: null
  PROJECTEDCOSTESTIMATE: null
  INSPECTEDCOSTESTIMATE: null
  KEYCOMMENTLETTERS: null
  DESCRIPTION: null
  GID_ADDRESSPIN_POINT: null
  HABITABILITYWITHREPAIRS: null
  HABITABILITYWITHOUTREPAIRS: null
  UNINHABITABLE: null
  REPEAIRSNOTFEASIBLE: null
  BASEMENTLIVINGAREA: null
  BASEMENTNONLIVINGAREA: null
  HAZARDOUSMATERIALS: null
  DEBRISREMOVAL: null
  PROTECTIVEMEASURES: null
  ROADSBRIDGES: null
  WATERCONTROLFACILITIES: null
  PUBLICBUILDING: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATEDBY
• Edit Date Field: DATEMODIFIED
• Editor Field: MODIFIEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata