Tables:

Table: Annual Citizen survey (0)

Name: Annual Citizen survey

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: The Police Department is responsible for updating this data regularly. They input updated results from the Annual Citizen Surveys.

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Year ( type: esriFieldTypeSmallInteger, alias: Year )
• AboveAvg_Excellent_Pct ( type: esriFieldTypeSmallInteger, alias: Percent of Responses above Avg and Excellent )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Table: Crime and Crash data (1)

Name: Crime and Crash data

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: The Police Department is responsible for updating this data regularly. They input updated Crime rates and Crash data based on data in the RMS system.

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Year ( type: esriFieldTypeSmallInteger, alias: Year )
• Property_Crime_Rate ( type: esriFieldTypeDouble, alias: Property Crime Rate )
• Violent_Crime_Rate ( type: esriFieldTypeDouble, alias: Violent Crime Rate )
• Major_Crime_Rate ( type: esriFieldTypeDouble, alias: Major Crime Rate )
• Priority1_Avg_Resp_Time ( type: esriFieldTypeDouble, alias: Priority 1 Avg Response Time )
• Oth_Priorities_Avg_Resp_Time ( type: esriFieldTypeDouble, alias: All Other Priorities Avg Response Time )
• Fatality_Crashes ( type: esriFieldTypeSmallInteger, alias: Fatality Crashes )
• Injury_Crashes ( type: esriFieldTypeSmallInteger, alias: Injury Crashes )
• Total_Crashes ( type: esriFieldTypeSmallInteger, alias: Total Crashes )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Table: Monthly Satisfaction with Police survey (2)

Name: Monthly Satisfaction with Police survey

Display Field: Month

Type: Table

Geometry Type: N/A

Description: The Police Department is responsible for updating this data regularly. They input updated survey results from a Monthly Satisfaction survey for Police Services.

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Month ( type: esriFieldTypeString, alias: Month, length: 9 )
• Year ( type: esriFieldTypeSmallInteger, alias: Year )
• Very_Satisfied ( type: esriFieldTypeSmallInteger, alias: Very Satisfied )
• Satisfied ( type: esriFieldTypeSmallInteger, alias: Satisfied )
• Neutral ( type: esriFieldTypeSmallInteger, alias: Neutral )
• Unsatisfied ( type: esriFieldTypeSmallInteger, alias: Unsatisfied )
• Very_Unsatisfied ( type: esriFieldTypeSmallInteger, alias: Very Unsatisfied )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )