{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "EOC_ASSESSMENT_TABLE", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSESSORNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GEODBID", "type": "esriFieldTypeString", "alias": "GEODBID", "length": 3, "domain": null }, { "name": "FEATUREID", "type": "esriFieldTypeString", "alias": "FEATUREID", "length": 15, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DATECREATED", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "length": 8, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "length": 20, "domain": null }, { "name": "SOURCETYPE", "type": "esriFieldTypeString", "alias": "SOURCETYPE", "length": 20, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PRODUCTIONNOTES", "type": "esriFieldTypeString", "alias": "PRODUCTIONNOTES", "length": 100, "domain": null }, { "name": "REPLICAFILTER", "type": "esriFieldTypeString", "alias": "REPLICAFILTER", "length": 255, "domain": null }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "length": 100, "domain": null }, { "name": "MODIFIEDBY", "type": "esriFieldTypeString", "alias": "MODIFIEDBY", "length": 100, "domain": null }, { "name": "ASSESSMENTSTARTDATE", "type": "esriFieldTypeDate", "alias": "ASSESSMENTSTARTDATE", "length": 8, "domain": null }, { "name": "ASSESSMENTENDDATE", "type": "esriFieldTypeDate", "alias": "ASSESSMENTENDDATE", "length": 8, "domain": null }, { "name": "ASSESSORNAME", "type": "esriFieldTypeString", "alias": "ASSESSORNAME", "length": 50, "domain": null }, { "name": "DEPARTMENT", "type": "esriFieldTypeString", "alias": "DEPARTMENT", "length": 50, "domain": null }, { "name": "CONTACTNUMBER", "type": "esriFieldTypeString", "alias": "CONTACTNUMBER", "length": 50, "domain": null }, { "name": "LOCATIONOFDAMAGE", "type": "esriFieldTypeString", "alias": "LOCATIONOFDAMAGE", "length": 255, "domain": null }, { "name": "EVENTTYPE", "type": "esriFieldTypeString", "alias": "EVENTTYPE", "length": 50, "domain": null }, { "name": "DWELLINGTYPE", "type": "esriFieldTypeString", "alias": "DWELLINGTYPE", "length": 50, "domain": { "type": "codedValue", "name": "EOC_DWELLINGTYPE", "description": "Codes used to identify dwelling type for EOC", "codedValues": [ { "name": "Single Family", "code": "SINGLE FAMILY" }, { "name": "Multi Family", "code": "MULTI FAMILY" }, { "name": "Mobile", "code": "MOBILE" }, { "name": "Business", "code": "BUSINESS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OCCUPANTSTATUS", "type": "esriFieldTypeString", "alias": "OCCUPANTSTATUS", "length": 50, "domain": { "type": "codedValue", "name": "EOC_OCCUPANTSTATUS", "description": "Codes used to identify Occupant Status in EOC", "codedValues": [ { "name": "Owner", "code": "OWNER" }, { "name": "Renter", "code": "RENTER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSURANCETYPE", "type": "esriFieldTypeString", "alias": "INSURANCETYPE", "length": 50, "domain": { "type": "codedValue", "name": "EOC_INSURANCETYPE", "description": "Codes used to identify insurance type for EOC", "codedValues": [ { "name": "Homeowners", "code": "HOMEOWNERS" }, { "name": "Renters", "code": "RENTERS" }, { "name": "Flood", "code": "FLOOD" }, { "name": "None", "code": "NONE" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Sewer", "code": "SEWER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BASEMENTDEPTHOFWATER", "type": "esriFieldTypeInteger", "alias": "BASEMENTDEPTHOFWATER", "domain": null }, { "name": "FIRSTFLOORDEPTHOFWATER", "type": "esriFieldTypeInteger", "alias": "FIRSTFLOORDEPTHOFWATER", "domain": null }, { "name": "STRUCTURALDAMAGE", "type": "esriFieldTypeString", "alias": "STRUCTURALDAMAGE", "length": 50, "domain": { "type": "codedValue", "name": "EOC_STRUCTURALDAMAGE", "description": "Codes used to identify ", "codedValues": [ { "name": "Partial Damage", "code": "PARTIAL" }, { "name": "Minor Damage", "code": "MINOR" }, { "name": "Major Damage", "code": "MAJOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECTEDCOSTESTIMATE", "type": "esriFieldTypeInteger", "alias": "PROJECTEDCOSTESTIMATE", "domain": null }, { "name": "INSPECTEDCOSTESTIMATE", "type": "esriFieldTypeInteger", "alias": "INSPECTEDCOSTESTIMATE", "domain": null }, { "name": "KEYCOMMENTLETTERS", "type": "esriFieldTypeString", "alias": "KEYCOMMENTLETTERS", "length": 50, "domain": { "type": "codedValue", "name": "EOCKEYCOMMENTS Codes", "description": "Codes to describe key items of a dwelling during an emergency event", "codedValues": [ { "name": "A - No one living in dwelling at time of event", "code": "A" }, { "name": "B - Dwelling was not a primary residence", "code": "B" }, { "name": "C - Damage caused by sewer backup only", "code": "CFLOOD" }, { "name": "D - No one home during assessment. Cannot determine damage", "code": "D" }, { "name": "E - No one home during assessment. Information obtained by observation or another source", "code": "E" }, { "name": "F - Water heater, furnace, and or duct work not operable due to flood", "code": "F" }, { "name": "NA - No applicable option", "code": "NA" }, { "name": "C - Roof or wall covered in tarp or plywood", "code": "CNONFLOOD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 255, "domain": null }, { "name": "GID_ADDRESSPIN_POINT", "type": "esriFieldTypeGUID", "alias": "GID_ADDRESSPIN_POINT", "length": 38, "domain": null }, { "name": "HABITABILITYWITHREPAIRS", "type": "esriFieldTypeSmallInteger", "alias": "HABITABILITYWITHREPAIRS", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HABITABILITYWITHOUTREPAIRS", "type": "esriFieldTypeSmallInteger", "alias": "HABITABILITYWITHOUTREPAIRS", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "UNINHABITABLE", "type": "esriFieldTypeSmallInteger", "alias": "UNINHABITABLE", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REPEAIRSNOTFEASIBLE", "type": "esriFieldTypeSmallInteger", "alias": "REPEAIRSNOTFEASIBLE", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BASEMENTLIVINGAREA", "type": "esriFieldTypeSmallInteger", "alias": "BASEMENTLIVINGAREA", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BASEMENTNONLIVINGAREA", "type": "esriFieldTypeSmallInteger", "alias": "BASEMENTNONLIVINGAREA", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HAZARDOUSMATERIALS", "type": "esriFieldTypeSmallInteger", "alias": "HAZARDOUSMATERIAL", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DEBRISREMOVAL", "type": "esriFieldTypeSmallInteger", "alias": "DEBRISREMOVAL", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PROTECTIVEMEASURES", "type": "esriFieldTypeSmallInteger", "alias": "PROTECTIVEMEASURES", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ROADSBRIDGES", "type": "esriFieldTypeSmallInteger", "alias": "ROADSBRIDGES", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WATERCONTROLFACILITIES", "type": "esriFieldTypeSmallInteger", "alias": "WATERCONTROLFACILITIES", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PUBLICBUILDING", "type": "esriFieldTypeSmallInteger", "alias": "PUBLICBUILDING", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PUBLICFACILITY", "type": "esriFieldTypeSmallInteger", "alias": "PUBLICFACILITY", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FACILITYUNDERCONSTRUCTION", "type": "esriFieldTypeSmallInteger", "alias": "FACILITYUNDERCONSTRUCTION", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRIVATENONPROFIT", "type": "esriFieldTypeSmallInteger", "alias": "PRIVATENONPROFIT", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PUBLICRECREATION", "type": "esriFieldTypeSmallInteger", "alias": "PUBLICRECREATION", "domain": { "type": "codedValue", "name": "BOOLEAN", "description": "Yes/No codes used in boolean fields for certain feature classes", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HABITABLESTATUS", "type": "esriFieldTypeString", "alias": "HABITABLESTATUS", "length": 50, "domain": { "type": "codedValue", "name": "EOCHABITABLESTATUS Codes", "description": "Codes used to describe the habitable status of a dwelling", "codedValues": [ { "name": "Habitable without Repairs", "code": "HABITABLENOREPAIRS" }, { "name": "Habitable with Few Repairs", "code": "HABITABLEFEWREPAIRS" }, { "name": "Uninhabitable/Needs Extensive Repair", "code": "UNINHABITABLE" }, { "name": "Total Loss/Not Feasible to Repair", "code": "TOTALLOSS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDITIONALCOMMENTS", "type": "esriFieldTypeString", "alias": "ADDITIONALCOMMENTS", "length": 255, "domain": null }, { "name": "FEMALEVELOFDAMAGE", "type": "esriFieldTypeString", "alias": "FEMALEVELOFDAMAGE", "length": 20, "domain": { "type": "codedValue", "name": "EOC_FEMADamageLevel", "description": "Level of damage by FEMA standards", "codedValues": [ { "name": "Affected", "code": "AFFECTED" }, { "name": "Minor", "code": "MINOR" }, { "name": "Major", "code": "MAJOR" }, { "name": "Destroyed", "code": "DESTROYED" }, { "name": "Inaccessible", "code": "INACCESSIBLE" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R427_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_427", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3105_GID_ADD", "fields": "GID_ADDRESSPIN_POINT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_427", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "AddressPIN_POINT", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GID_ADDRESSPIN_POINT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }