{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Code Enforcement", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SBL" }, { "name": "USE_CODE", "type": "esriFieldTypeString", "alias": "Use Code", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "USE_CODE" }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OWNER" }, { "name": "OPEN_CASE", "type": "esriFieldTypeString", "alias": "Open Case", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "OPEN_CASE" }, { "name": "OPEN_CASES", "type": "esriFieldTypeSmallInteger", "alias": "Open Cases", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPEN_CASES" }, { "name": "CASE_TYPE", "type": "esriFieldTypeString", "alias": "Case Type", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CASE_TYPE" }, { "name": "CASE_SOURCE", "type": "esriFieldTypeString", "alias": "Case Source", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "CASE_SOURCE" }, { "name": "VACANT", "type": "esriFieldTypeString", "alias": "Vacant", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "VACANT" }, { "name": "OUTSTANDING_VIOLATIONS", "type": "esriFieldTypeSmallInteger", "alias": "Outstanding Violations", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTSTANDING_VIOLATIONS" }, { "name": "CODE_ENFORCEMENT", "type": "esriFieldTypeString", "alias": "Code Enforcement", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CODE_ENFORCEMENT" }, { "name": "TOTAL_TICKETS", "type": "esriFieldTypeSmallInteger", "alias": "Total Tickets", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_TICKETS" }, { "name": "PENDING_FINES", "type": "esriFieldTypeString", "alias": "Pending Fines", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PENDING_FINES" }, { "name": "FINE_BALANCE", "type": "esriFieldTypeSmallInteger", "alias": "Fine Balance", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FINE_BALANCE" }, { "name": "TAX_FORECLOSURE", "type": "esriFieldTypeString", "alias": "Tax Foreclosure", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "TAX_FORECLOSURE" }, { "name": "INSPECTOR_ID", "type": "esriFieldTypeString", "alias": "Inpsector ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INSPECTOR_ID" }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "Case Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CASE_NUMBER" }, { "name": "DEMO_CASE", "type": "esriFieldTypeString", "alias": "Demo Case", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "DEMO_CASE" }, { "name": "PERMIT_CASE", "type": "esriFieldTypeString", "alias": "PERMIT_CASE", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PERMIT_CASE" }, { "name": "CASE_OPEN_DATE", "type": "esriFieldTypeString", "alias": "Case Open Date", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CASE_OPEN_DATE" }, { "name": "LAST_TICKET_DATE", "type": "esriFieldTypeString", "alias": "Last Ticket Date", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LAST_TICKET_DATE" }, { "name": "VACANT_DATE", "type": "esriFieldTypeString", "alias": "Vacant Date", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "VACANT_DATE" }, { "name": "RUNDATE", "type": "esriFieldTypeString", "alias": "RUNDATE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "RUNDATE" }, { "name": "RUNTIME", "type": "esriFieldTypeString", "alias": "RUNTIME", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "RUNTIME" }, { "name": "INSPECTORAREA", "type": "esriFieldTypeString", "alias": "Inpsector Area", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSPECTORAREA" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Inspector", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "PHONE", "type": "esriFieldTypeString", "alias": "Phone Number", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PHONE" }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EMAIL" }, { "name": "NSC", "type": "esriFieldTypeString", "alias": "NSC", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NSC" }, { "name": "OFFICEADDR", "type": "esriFieldTypeString", "alias": "Office Address", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "OFFICEADDR" }, { "name": "CONTSITUA", "type": "esriFieldTypeString", "alias": "CONTSITUA", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONTSITUA" }, { "name": "NEWCOMPL", "type": "esriFieldTypeString", "alias": "NEWCOMPL", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "NEWCOMPL" } ], "indexes": [ { "name": "R91_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G523SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Code Enforcement", "description": "", "prototype": { "attributes": { "CONTSITUA": null, "NEWCOMPL": null, "ADDRESS": null, "SBL": null, "USE_CODE": null, "OWNER": null, "OPEN_CASE": null, "OPEN_CASES": null, "CASE_TYPE": null, "CASE_SOURCE": null, "VACANT": null, "OUTSTANDING_VIOLATIONS": null, "CODE_ENFORCEMENT": null, "TOTAL_TICKETS": null, "PENDING_FINES": null, "FINE_BALANCE": null, "TAX_FORECLOSURE": null, "INSPECTOR_ID": null, "CASE_NUMBER": null, "DEMO_CASE": null, "PERMIT_CASE": null, "CASE_OPEN_DATE": null, "LAST_TICKET_DATE": null, "VACANT_DATE": null, "RUNDATE": null, "RUNTIME": null, "INSPECTORAREA": null, "NAME": null, "PHONE": null, "EMAIL": null, "NSC": null, "OFFICEADDR": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 200000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 200000, "maxRecordCountFactor": 1, "serviceItemId": "0ee3b3255c0c423a87c5dfaf302f6c22" }