Name: ACPP Law Enforcement Misconduct Complaint Database 2024.csv

Display Field: NAME

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• UNIQUE_ID (type: esriFieldTypeInteger, alias: UNIQUE ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LABEL (type: esriFieldTypeString, alias: LABEL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MUNI_ID (type: esriFieldTypeInteger, alias: MUNI ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZIP_CODE (type: esriFieldTypeInteger, alias: ZIP CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EMAIL_RESPONSE (type: esriFieldTypeString, alias: EMAIL RESPONSE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RIGHT_TO_KNOW_FORM (type: esriFieldTypeInteger, alias: RIGHT TO KNOW FORM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OTHER_INFO (type: esriFieldTypeString, alias: OTHER INFO, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TRANSPARENCY_SCORE (type: esriFieldTypeString, alias: TRANSPARENCY SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GETTING_STARTED_COMPLETENESS_SC (type: esriFieldTypeString, alias: GETTING STARTED COMPLETENESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HOW_TO_FILE_COMPLETENESS_SCORE (type: esriFieldTypeString, alias: HOW TO FILE COMPLETENESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WHO_CAN_FILE_COMPLETENESS_SCORE (type: esriFieldTypeString, alias: WHO CAN FILE COMPLETENESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DELIVERY_COMPLETENESS_SCORE (type: esriFieldTypeString, alias: DELIVERY COMPLETENESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• POST_COMPLAINT_STEPS_COMPLETENE (type: esriFieldTypeString, alias: POST-COMPLAINT STEPS COMPLETENESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• COMPLETENESS_OF_PROCESS_SCORE (type: esriFieldTypeString, alias: COMPLETENESS OF PROCESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LETTER_GRADE_BASED_ON_COMPLETEN (type: esriFieldTypeString, alias: LETTER GRADE BASED ON COMPLETENESS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GETTING_STARTED_EASE_SCORE (type: esriFieldTypeString, alias: GETTING STARTED EASE SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FILING_COMPLAINT_EASE_SCORE (type: esriFieldTypeString, alias: FILING COMPLAINT EASE SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WHO_CAN_FILE_EASE_SCORE (type: esriFieldTypeString, alias: WHO CAN FILE EASE SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DELIVERY_EASE_SCORE (type: esriFieldTypeString, alias: DELIVERY EASE SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UNDERSTANDING_NEXT_STEPS_EASE (type: esriFieldTypeString, alias: UNDERSTANDING NEXT STEPS EASE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EASE_OF_PROCESS_SCORE (type: esriFieldTypeString, alias: EASE OF PROCESS SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EASE_OF_PROCESS_LETTER (type: esriFieldTypeString, alias: EASE OF PROCESS LETTER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TOTAL_SCORE_OF_PROCESS__COMP__E (type: esriFieldTypeString, alias: TOTAL SCORE OF PROCESS (COMP+ EASE), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TOTAL_SCORE_LETTER_GRADE (type: esriFieldTypeString, alias: TOTAL SCORE LETTER GRADE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeInteger, alias: POPULATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POLICE_SERVICE_TYPE (type: esriFieldTypeString, alias: POLICE SERVICE TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FULL_TIME_OFFICERS (type: esriFieldTypeInteger, alias: FULL TIME OFFICERS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PART_TIME_OFFICERS (type: esriFieldTypeInteger, alias: PART TIME OFFICERS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_OFFICERS (type: esriFieldTypeInteger, alias: TOTAL OFFICERS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTRACTED_TO_OTHERS_ (type: esriFieldTypeString, alias: CONTRACTED TO OTHERS?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CONTRACTED_TO_MUNIS (type: esriFieldTypeString, alias: CONTRACTED TO MUNIS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CONTRACTED_FROM_MUNIS (type: esriFieldTypeString, alias: CONTRACTED FROM MUNIS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REGIONAL_NAME (type: esriFieldTypeString, alias: REGIONAL NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REGIONAL_MUNIS (type: esriFieldTypeString, alias: REGIONAL MUNIS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2019_Police_Expenditures (type: esriFieldTypeString, alias: 2019 Police Expenditures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2019_Total_Expenditures (type: esriFieldTypeString, alias: 2019 Total Expenditures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2020_Police_Expenditures (type: esriFieldTypeString, alias: 2020 Police Expenditures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2020_Total_Expenditures (type: esriFieldTypeString, alias: 2020 Total Expenditures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2021_Police_Expenditures (type: esriFieldTypeString, alias: 2021 Police Expenditures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2021_Total_Expenditures (type: esriFieldTypeString, alias: 2021 Total Expenditures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Expected_Officers_Based_on_Popu (type: esriFieldTypeInteger, alias: Expected Officers Based on Population, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: ACPP Law Enforcement Misconduct Complaint Database 2024.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/9/2024 9:16:48 PM

Schema Last Edit Date: 4/9/2024 9:16:48 PM

Data Last Edit Date: 4/9/2024 9:16:48 PM

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