{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "EE Notice of Violation Reports", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "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": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "CONTACT_NAME_FIRST", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DIVISION", "type": "esriFieldTypeString", "alias": "Division", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "DIVISION" }, { "name": "DEPARTMENT", "type": "esriFieldTypeString", "alias": "Department", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "DEPARTMENT" }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "Category", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CATEGORY" }, { "name": "INCIDENT_ID", "type": "esriFieldTypeInteger", "alias": "Oracle ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INCIDENT_ID" }, { "name": "INCIDENT_NUMBER", "type": "esriFieldTypeString", "alias": "Service Request Number", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "INCIDENT_NUMBER" }, { "name": "INCIDENT_TYPE_ID", "type": "esriFieldTypeInteger", "alias": "Service Request Type ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INCIDENT_TYPE_ID" }, { "name": "REQUEST_TYPE", "type": "esriFieldTypeString", "alias": "Service Request Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "REQUEST_TYPE" }, { "name": "REPORTED_DATE", "type": "esriFieldTypeDate", "alias": "Reported Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTED_DATE" }, { "name": "REQUEST_SUMMARY", "type": "esriFieldTypeString", "alias": "Service Request Summary", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "REQUEST_SUMMARY" }, { "name": "CREATED_BY_USER", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATED_BY_USER" }, { "name": "LAST_UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "Last Updated Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_UPDATE_DATE" }, { "name": "UPDATED_BY_USER", "type": "esriFieldTypeString", "alias": "Updated By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UPDATED_BY_USER" }, { "name": "FOLLOWUP_DATE", "type": "esriFieldTypeDate", "alias": "Follow Up Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FOLLOWUP_DATE" }, { "name": "NOV_DATE", "type": "esriFieldTypeDate", "alias": "Notice Given Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "NOV_DATE" }, { "name": "Court_Date", "type": "esriFieldTypeDate", "alias": "Court Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Court_Date" }, { "name": "JOB_NOTES", "type": "esriFieldTypeString", "alias": "Job Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "JOB_NOTES" }, { "name": "CLOSE_DATE", "type": "esriFieldTypeDate", "alias": "Closed Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CLOSE_DATE" }, { "name": "SUPERVISOR", "type": "esriFieldTypeString", "alias": "Supervisor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUPERVISOR" }, { "name": "ADDRESS1", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ADDRESS1" }, { "name": "ADDRESS2", "type": "esriFieldTypeString", "alias": "Apt/ Unit No", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ADDRESS2" }, { "name": "ADDRESS3", "type": "esriFieldTypeString", "alias": "P.O. Box", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ADDRESS3" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CITY" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATE" }, { "name": "POSTAL_CODE", "type": "esriFieldTypeString", "alias": "Postal Code", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "POSTAL_CODE" }, { "name": "PARCEL_ID", "type": "esriFieldTypeString", "alias": "Parcel ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PARCEL_ID" }, { "name": "CONTACT_NAME_FIRST", "type": "esriFieldTypeString", "alias": "Owner Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONTACT_NAME_FIRST" }, { "name": "CONTACT_NAME_LAST", "type": "esriFieldTypeString", "alias": "Owner Name 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONTACT_NAME_LAST" }, { "name": "PERSON_ADDRESS1", "type": "esriFieldTypeString", "alias": "Owner Address1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERSON_ADDRESS1" }, { "name": "PERSON_ADDRESS2", "type": "esriFieldTypeString", "alias": "Owner Address2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERSON_ADDRESS2" }, { "name": "PERSON_ADDRESS3", "type": "esriFieldTypeString", "alias": "Owner Address3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERSON_ADDRESS3" }, { "name": "PERSON_STATE", "type": "esriFieldTypeString", "alias": "Owner State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PERSON_STATE" }, { "name": "PERSON_CITY", "type": "esriFieldTypeString", "alias": "Owner City", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PERSON_CITY" }, { "name": "PERSON_ZIP_CODE", "type": "esriFieldTypeString", "alias": "Owner Zip Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PERSON_ZIP_CODE" }, { "name": "MAP_PG", "type": "esriFieldTypeString", "alias": "Map Page", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAP_PG" }, { "name": "MAP_BLK", "type": "esriFieldTypeString", "alias": "Map Block", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAP_BLK" }, { "name": "CODE_DISTRICT", "type": "esriFieldTypeString", "alias": "Code District", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CODE_DISTRICT" }, { "name": "CODE_SUBDISTRICT", "type": "esriFieldTypeString", "alias": "Code Sub-District", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CODE_SUBDISTRICT" }, { "name": "TARGET_BLOCK", "type": "esriFieldTypeString", "alias": "Target Block", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TARGET_BLOCK" }, { "name": "MLGW_CUSTOMER", "type": "esriFieldTypeString", "alias": "MLGW Customer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MLGW_CUSTOMER" }, { "name": "MLGW_CONTACT1", "type": "esriFieldTypeString", "alias": "MLGW Contact 1", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MLGW_CONTACT1" }, { "name": "MLGW_CONTACT2", "type": "esriFieldTypeString", "alias": "MLGW Contact 2", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MLGW_CONTACT2" }, { "name": "MLGW_EMAIL", "type": "esriFieldTypeString", "alias": "MLGW Contact Email", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "MLGW_EMAIL" }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "X_COORD" }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Y_COORD" }, { "name": "VOYC", "type": "esriFieldTypeString", "alias": "VOYC", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "VOYC" }, { "name": "VOB", "type": "esriFieldTypeString", "alias": "VOB", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "VOB" }, { "name": "VOM", "type": "esriFieldTypeString", "alias": "VOM", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "VOM" }, { "name": "NOV_Owner", "type": "esriFieldTypeString", "alias": "NOV Owner", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NOV_Owner" }, { "name": "NOV_Agent", "type": "esriFieldTypeString", "alias": "NOV Agent", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NOV_Agent" }, { "name": "NOV_Occupant", "type": "esriFieldTypeString", "alias": "NOV Occupant", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NOV_Occupant" }, { "name": "Abate_Date", "type": "esriFieldTypeDate", "alias": "Abatement Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Abate_Date" }, { "name": "Ord15_48", "type": "esriFieldTypeString", "alias": "Ord. 15-48", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord15_48" }, { "name": "Ord15_54", "type": "esriFieldTypeString", "alias": "Ord. 15-54", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord15_54" }, { "name": "Ord15_49", "type": "esriFieldTypeString", "alias": "Ord. 15-49", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord15_49" }, { "name": "Ord15_52", "type": "esriFieldTypeString", "alias": "Ord. 15-52", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord15_52" }, { "name": "Ord20_26", "type": "esriFieldTypeString", "alias": "Ord. 20-26", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord20_26" }, { "name": "Ord15_34", "type": "esriFieldTypeString", "alias": "Ord. 15-34", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord15_34" }, { "name": "Ord15_24", "type": "esriFieldTypeString", "alias": "Ord. 15-24", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord15_24" }, { "name": "Ord5708_Sect3021", "type": "esriFieldTypeString", "alias": "Ord. 5708 Sect. 302.1", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord5708_Sect3021" }, { "name": "Ord5708_Sect3081", "type": "esriFieldTypeString", "alias": "Ord. 5708 Sect. 308.1", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord5708_Sect3081" }, { "name": "Ord5708_Sect3082", "type": "esriFieldTypeString", "alias": "Ord. 5708 Sect. 308.2", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ord5708_Sect3082" }, { "name": "Other_Offense", "type": "esriFieldTypeString", "alias": "Other Offenses", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Other_Offense" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G101_INDICENTID", "fields": "INCIDENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G101_GLOBALID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "EE Notice of Violation Reports", "description": "", "prototype": { "attributes": { "Ord5708_Sect3082": null, "Other_Offense": null, "DIVISION": null, "DEPARTMENT": null, "CATEGORY": null, "INCIDENT_ID": null, "INCIDENT_NUMBER": null, "INCIDENT_TYPE_ID": null, "REQUEST_TYPE": null, "REPORTED_DATE": null, "REQUEST_SUMMARY": null, "CREATED_BY_USER": null, "LAST_UPDATE_DATE": null, "UPDATED_BY_USER": null, "FOLLOWUP_DATE": null, "NOV_DATE": null, "Court_Date": null, "JOB_NOTES": null, "CLOSE_DATE": null, "SUPERVISOR": null, "ADDRESS1": null, "ADDRESS2": null, "ADDRESS3": null, "CITY": null, "STATE": null, "POSTAL_CODE": null, "PARCEL_ID": null, "CONTACT_NAME_FIRST": null, "CONTACT_NAME_LAST": null, "PERSON_ADDRESS1": null, "PERSON_ADDRESS2": null, "PERSON_ADDRESS3": null, "PERSON_STATE": null, "PERSON_CITY": null, "PERSON_ZIP_CODE": null, "MAP_PG": null, "MAP_BLK": null, "CODE_DISTRICT": null, "CODE_SUBDISTRICT": null, "TARGET_BLOCK": null, "MLGW_CUSTOMER": null, "MLGW_CONTACT1": null, "MLGW_CONTACT2": null, "MLGW_EMAIL": null, "X_COORD": null, "Y_COORD": null, "VOYC": null, "VOB": null, "VOM": null, "NOV_Owner": null, "NOV_Agent": null, "NOV_Occupant": null, "Abate_Date": null, "Ord15_48": null, "Ord15_54": null, "Ord15_49": null, "Ord15_52": null, "Ord20_26": null, "Ord15_34": null, "Ord15_24": null, "Ord5708_Sect3021": null, "Ord5708_Sect3081": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "3eac37e56a214741ad3b0f078d37aaf3" }