{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 128, "name": "CRM CodeInspection_Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "DATECREATED", "creatorField": "CREATEDBY", "editDateField": "DATEMODIFIED", "editorField": "MODIFIEDBY" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "EnerGov_Inspection_POINT", "relatedTableId": 28, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GID_INSPECTION_POINT", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "OwnerName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "CRM_Types", "description": "Dwelling Inspection Type", "codedValues": [ { "name": "Accumulations of trash and junk", "code": "Accumulations of trash and junk" }, { "name": "Dead or diseased tree hazards", "code": "Dead or diseased tree hazards" }, { "name": "Gutters rusted or hanging loose", "code": "Gutters rusted or hanging loose" }, { "name": "Illegal dumping", "code": "Illegal dumping" }, { "name": "Inoperative vehicles on private property", "code": "Inoperative vehicles on private property" }, { "name": "Loose and missing roof shingles", "code": "Loose and missing roof shingles" }, { "name": "Missing or deteriorated siding", "code": "Missing or deteriorated siding" }, { "name": "Overgrowth of weeds or grass on vacant or developed lots (including easements)", "code": "Overgrowth of weeds or grass on vacant or developed lots (including easements)" }, { "name": "Paint peeling from surfaces needing protection", "code": "Holiday Decorations" }, { "name": "Roof leaks", "code": "Roof leaks" }, { "name": "Sheds or fences in disrepair", "code": "Sheds or fences in disrepair" }, { "name": "Street number not displayed", "code": "Street number not displayed" }, { "name": "Vacant, open buildings", "code": "Vacant, open buildings" }, { "name": "Violations involving storage or disposal of refuse", "code": "Violations involving storage or disposal of refuse" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Type" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "CRM_Status", "description": "Status of inspection", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "Owner Name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "OwnerName" }, { "name": "BusinessName", "type": "esriFieldTypeString", "alias": "Business Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "BusinessName" }, { "name": "OwnerContact", "type": "esriFieldTypeString", "alias": "Owner Contact Information", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OwnerContact" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspector" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Notes" }, { "name": "ReportedDate", "type": "esriFieldTypeDate", "alias": "ReportedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReportedDate" }, { "name": "ComplyBy", "type": "esriFieldTypeDate", "alias": "ComplyBy", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComplyBy" }, { "name": "DateComplied", "type": "esriFieldTypeDate", "alias": "Date Complied", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateComplied" }, { "name": "SOURCETYPE", "type": "esriFieldTypeString", "alias": "SOURCETYPE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SOURCETYPE" }, { "name": "FEATUREID", "type": "esriFieldTypeString", "alias": "FEATUREID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "FEATUREID" }, { "name": "REPLICAFILTER", "type": "esriFieldTypeString", "alias": "REPLICAFILTER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "REPLICAFILTER" }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DATECREATED", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECREATED" }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SOURCE" }, { "name": "GEODBID", "type": "esriFieldTypeString", "alias": "GEODBID", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": "000", "modelName": "GEODBID" }, { "name": "PRODUCTIONNOTES", "type": "esriFieldTypeString", "alias": "PRODUCTIONNOTES", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PRODUCTIONNOTES" }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEMODIFIED" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "MODIFIEDBY", "type": "esriFieldTypeString", "alias": "MODIFIEDBY", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODIFIEDBY" }, { "name": "GID_INSPECTION_POINT", "type": "esriFieldTypeGUID", "alias": "GID_INSPECTION_POINT", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GID_INSPECTION_POINT" } ], "indexes": [ { "name": "R688_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_39428_GID_IN", "fields": "GID_INSPECTION_POINT", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CRM CodeInspection_Table", "description": "", "prototype": { "attributes": { "GEODBID": "000", "GID_INSPECTION_POINT": null, "Type": null, "Status": null, "OwnerName": null, "BusinessName": null, "OwnerContact": null, "Inspector": null, "Notes": null, "ReportedDate": null, "ComplyBy": null, "DateComplied": null, "SOURCETYPE": null, "FEATUREID": null, "REPLICAFILTER": null, "PRODUCTIONNOTES": null, "SOURCE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }