Name: CrimeStatistics

Display Field: rptperioddates

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• rptperioddates (type: esriFieldTypeString, alias: Reporting Period Dates, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• curcnt_7days (type: esriFieldTypeDouble, alias: Current Count 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prevcnt_7days (type: esriFieldTypeDouble, alias: Previous Count 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• perc_7days (type: esriFieldTypeDouble, alias: Percent Change 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pz_7days (type: esriFieldTypeDouble, alias: Poisson Z-Score 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzave_7days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period Average 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper1_7days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 1 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper2_7days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 2 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper3_7days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 3 7 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• curcnt_28days (type: esriFieldTypeDouble, alias: Current Count 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prevcnt_28days (type: esriFieldTypeDouble, alias: Previous Count 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• perc_28days (type: esriFieldTypeDouble, alias: Percent Change 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pz_28days (type: esriFieldTypeDouble, alias: Poisson Z-Score 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzave_28days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period Average 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper1_28days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 1 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper2_28days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 2 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper3_28days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 3 28 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• curcnt_365days (type: esriFieldTypeDouble, alias: Current Count 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prevcnt_365days (type: esriFieldTypeDouble, alias: Previous Count 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• perc_365days (type: esriFieldTypeDouble, alias: Percent Change 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pz_365days (type: esriFieldTypeDouble, alias: Poisson Z-Score 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzave_365days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period Average 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper1_365days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 1 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper2_365days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 2 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper3_365days (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 3 365 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• curcnt_ytd (type: esriFieldTypeDouble, alias: Current Count YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prevcnt_ytd (type: esriFieldTypeDouble, alias: Previous Count YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• perc_ytd (type: esriFieldTypeDouble, alias: Percent Change YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pz_ytd (type: esriFieldTypeDouble, alias: Poisson Z-Score YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzave_ytd (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period Average YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper1_ytd (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 1 YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper2_ytd (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 2 YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pzper3_ytd (type: esriFieldTypeDouble, alias: Poisson Z Comparison Period 3 YTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• adminarea1 (type: esriFieldTypeString, alias: Beat, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• adminarea2 (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• adminarea3 (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• adminarea4 (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• category1 (type: esriFieldTypeString, alias: NIBRS Offense Code, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• category2 (type: esriFieldTypeString, alias: NIBRS Offense Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• category3 (type: esriFieldTypeString, alias: NIBRS Offense Category, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• category4 (type: esriFieldTypeString, alias: NIBRS Crimes Against Category, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• category5 (type: esriFieldTypeString, alias: NIBRS Group, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• statarea (type: esriFieldTypeString, alias: Statistical Area, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• statid (type: esriFieldTypeString, alias: Statistical ID, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Templates:

Name: CrimeStats
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/31/2025 5:29:48 PM

Schema Last Edit Date: 3/31/2025 5:29:48 PM

Data Last Edit Date: 3/31/2025 5:29:48 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat