{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "NIBRS_Inc_DBonly", "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": "CaseNum", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "CaseNum", "type": "esriFieldTypeString", "alias": "CaseNum", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "CaseNum" }, { "name": "sOccDate", "type": "esriFieldTypeString", "alias": "sOccDate", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "sOccDate" }, { "name": "sOccTime", "type": "esriFieldTypeString", "alias": "sOccTime", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "sOccTime" }, { "name": "CR_Desc", "type": "esriFieldTypeString", "alias": "CR_Desc", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "CR_Desc" }, { "name": "Disposition", "type": "esriFieldTypeString", "alias": "Disposition", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "Disposition" }, { "name": "sCity", "type": "esriFieldTypeString", "alias": "sCity", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "sCity" }, { "name": "sZip", "type": "esriFieldTypeString", "alias": "sZip", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "sZip" }, { "name": "PremiseType", "type": "esriFieldTypeString", "alias": "PremiseType", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "PremiseType" }, { "name": "Weapon", "type": "esriFieldTypeString", "alias": "Weapon", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Weapon" }, { "name": "NIBRSClassID", "type": "esriFieldTypeString", "alias": "NIBRSClassID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NIBRSClassID" }, { "name": "NIBRSClassCode", "type": "esriFieldTypeString", "alias": "NIBRSClassCode", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NIBRSClassCode" }, { "name": "NIBRSClassDesc", "type": "esriFieldTypeString", "alias": "NIBRSClassDesc", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "NIBRSClassDesc" }, { "name": "NIBRSClassAtt", "type": "esriFieldTypeString", "alias": "NIBRSClassAtt", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "NIBRSClassAtt" }, { "name": "NIBRSPrimSubCat", "type": "esriFieldTypeString", "alias": "NIBRSPrimSubCat", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NIBRSPrimSubCat" }, { "name": "NIBRSClassCodeDesc", "type": "esriFieldTypeString", "alias": "NIBRSClassCodeDesc", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "NIBRSClassCodeDesc" }, { "name": "NIBRSClassIBRcode", "type": "esriFieldTypeString", "alias": "NIBRSClassIBRcode", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "NIBRSClassIBRcode" }, { "name": "NIBRSSubmitted", "type": "esriFieldTypeString", "alias": "NIBRSSubmitted", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NIBRSSubmitted" }, { "name": "NIBRSSubDate", "type": "esriFieldTypeString", "alias": "NIBRSSubDate", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NIBRSSubDate" }, { "name": "CAIU_CrimeAgainst", "type": "esriFieldTypeString", "alias": "CAIU_CrimeAgainst", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CAIU_CrimeAgainst" }, { "name": "CAIU_ClassType", "type": "esriFieldTypeString", "alias": "CAIU_ClassType", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "CAIU_ClassType" }, { "name": "CAIU_Rank", "type": "esriFieldTypeString", "alias": "CAIU_Rank", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CAIU_Rank" }, { "name": "CAIU_ClassLabel", "type": "esriFieldTypeString", "alias": "CAIU_ClassLabel", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "CAIU_ClassLabel" }, { "name": "CADIncidentType", "type": "esriFieldTypeString", "alias": "CADIncidentType", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "CADIncidentType" }, { "name": "OccurredFrom", "type": "esriFieldTypeDate", "alias": "OccurredFrom", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "OccurredFrom" }, { "name": "OccurredTo", "type": "esriFieldTypeDate", "alias": "OccurredTo", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "OccurredTo" }, { "name": "iOccYr", "type": "esriFieldTypeInteger", "alias": "iOccYr", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "iOccYr" }, { "name": "sOccMn", "type": "esriFieldTypeString", "alias": "sOccMn", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "sOccMn" }, { "name": "sOccYrMth", "type": "esriFieldTypeString", "alias": "sOccYrMth", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "sOccYrMth" }, { "name": "sOccDOW", "type": "esriFieldTypeString", "alias": "sOccDOW", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "sOccDOW" }, { "name": "sOccHr", "type": "esriFieldTypeString", "alias": "sOccHr", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "sOccHr" }, { "name": "iOccMth", "type": "esriFieldTypeInteger", "alias": "iOccMth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "iOccMth" }, { "name": "iOccDOW", "type": "esriFieldTypeInteger", "alias": "iOccDOW", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "iOccDOW" }, { "name": "Org_area", "type": "esriFieldTypeString", "alias": "Org_area", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Org_area" }, { "name": "Org_sector", "type": "esriFieldTypeString", "alias": "Org_sector", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Org_sector" }, { "name": "Geo_Zones", "type": "esriFieldTypeString", "alias": "Geo_Zones", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Geo_Zones" }, { "name": "Geo_Districts", "type": "esriFieldTypeString", "alias": "Geo_Districts", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Geo_Districts" }, { "name": "Geo_Beats", "type": "esriFieldTypeString", "alias": "Geo_Beats", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Geo_Beats" }, { "name": "Geo_Zip", "type": "esriFieldTypeString", "alias": "Geo_Zip", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Geo_Zip" }, { "name": "Geo_Council", "type": "esriFieldTypeString", "alias": "Geo_Council", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Geo_Council" }, { "name": "Geo_Congress", "type": "esriFieldTypeString", "alias": "Geo_Congress", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Geo_Congress" }, { "name": "Geo_Precintcts", "type": "esriFieldTypeString", "alias": "Geo_Precintcts", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Geo_Precintcts" }, { "name": "Geo_Townships", "type": "esriFieldTypeString", "alias": "Geo_Townships", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Geo_Townships" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "Inx_obj_nibrs_inc_dbonly", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "inx_nibrs_time", "fields": "CaseNum,iOccYr,sOccMn,sOccYrMth,sOccDOW,sOccHr,iOccMth,iOccDOW,OccurredFrom", "isAscending": true, "isUnique": false, "description": "" }, { "name": "inx_nibrs_loc", "fields": "CaseNum,NIBRSClassIBRcode,Geo_Zones,Geo_Districts,Geo_Beats,Geo_Council,Geo_Congress,Geo_Precintcts", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "NIBRS_Inc_DBonly", "description": "", "prototype": { "attributes": { "Geo_Townships": null, "CaseNum": null, "sOccDate": null, "sOccTime": null, "CR_Desc": null, "Disposition": null, "sCity": null, "sZip": null, "PremiseType": null, "Weapon": null, "NIBRSClassID": null, "NIBRSClassCode": null, "NIBRSClassDesc": null, "NIBRSClassAtt": null, "NIBRSPrimSubCat": null, "NIBRSClassCodeDesc": null, "NIBRSClassIBRcode": null, "NIBRSSubmitted": null, "NIBRSSubDate": null, "CAIU_CrimeAgainst": null, "CAIU_ClassType": null, "CAIU_Rank": null, "CAIU_ClassLabel": null, "CADIncidentType": null, "OccurredFrom": null, "OccurredTo": null, "iOccYr": null, "sOccMn": null, "sOccYrMth": null, "sOccDOW": null, "sOccHr": null, "iOccMth": null, "iOccDOW": null, "Org_area": null, "Org_sector": null, "Geo_Zones": null, "Geo_Districts": null, "Geo_Beats": null, "Geo_Zip": null, "Geo_Council": null, "Geo_Congress": null, "Geo_Precintcts": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "e481d945e7174e9e94e764fef6dff47d" }