View In:   ArcGIS Online Map Viewer

Name: Incidents/Cases

Display Field: FIRSTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: f6c63778fdd34547b12a6948e0c97ca2

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON

Min Scale: 20000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 2434569.409367427
YMin: 707515.0217296109
XMax: 2434569.409367427
YMax: 707515.0217296109
Spatial Reference: 102672  (3436)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: INTERTYPE
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Other
  Label: Other
  Description:
  Symbol:
  
• Value: Suspect
  Label: Suspect
  Description:
  Symbol:
  
• Value: Victim
  Label: Victim
  Description:
  Symbol:
  
• Value: Witness
  Label: Witness
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: INTERTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• INTERID ( type: esriFieldTypeString, alias: Interview ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: INTERID )
• INTERDATE ( type: esriFieldTypeDate, alias: Interview Date/Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INTERDATE )
• OFFICERNM ( type: esriFieldTypeString, alias: Officer Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OFFICERNM )
• BADGENO ( type: esriFieldTypeString, alias: Badge #, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BADGENO )
• AGENCY ( type: esriFieldTypeString, alias: Agency, editable: true, nullable: true, length: 50, defaultValue: Trenton Police Department, modelName: AGENCY )
• FULLADDR ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FULLADDR )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 100, defaultValue: City of Trenton, modelName: MUNICIPALITY )
• SUSACTIVITY ( type: esriFieldTypeString, alias: Suspected Activity, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SUSACTIVITY )
• INTERTYPE ( type: esriFieldTypeString, alias: Type of Subject, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INTERTYPE , Coded Values: [Suspect: Suspect] , [Victim: Victim] , [Witness: Witness] , ...1 more... )
• FIRSTNAME ( type: esriFieldTypeString, alias: First Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIRSTNAME )
• LASTNAME ( type: esriFieldTypeString, alias: Last Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTNAME )
• AKANAME ( type: esriFieldTypeString, alias: AKA, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AKANAME )
• RESADDR ( type: esriFieldTypeString, alias: Subject's Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RESADDR )
• RESCITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RESCITY )
• RESSTATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: IL, modelName: RESSTATE , Coded Values: [AL: Alabama] , [AK: Alaska] , [AS: American Samoa] , ...56 more... )
• RESZIP5 ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RESZIP5 )
• SSN ( type: esriFieldTypeString, alias: SSN #, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SSN )
• DATEBIRTH ( type: esriFieldTypeDate, alias: Date of Birth, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEBIRTH )
• RACE ( type: esriFieldTypeString, alias: Race, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RACE , Coded Values: [American Indian or Alaska Native: American Indian or Alaska Native] , [Asian: Asian] , [Black or African American: Black or African American] , ...4 more... )
• GENDER ( type: esriFieldTypeString, alias: Gender, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GENDER , Coded Values: [Male: Male] , [Female: Female] )
• HAIRCOLOR ( type: esriFieldTypeString, alias: Hair Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: HAIRCOLOR )
• EYECOLOR ( type: esriFieldTypeString, alias: Eye Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EYECOLOR )
• BODYHEIGHT ( type: esriFieldTypeString, alias: Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BODYHEIGHT )
• BODYWEIGHT ( type: esriFieldTypeInteger, alias: Weight, editable: true, nullable: true, defaultValue: null, modelName: BODYWEIGHT )
• PHYSDESC ( type: esriFieldTypeString, alias: Physical Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PHYSDESC )
• CLOTHDESC ( type: esriFieldTypeString, alias: Clothing Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CLOTHDESC )
• VEHLPNUM ( type: esriFieldTypeString, alias: License Plate #, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VEHLPNUM )
• VEHLPSTATE ( type: esriFieldTypeString, alias: License Plate (State), editable: true, nullable: true, length: 2, defaultValue: IL, modelName: VEHLPSTATE , Coded Values: [AL: Alabama] , [AK: Alaska] , [AS: American Samoa] , ...56 more... )
• VEHMAKE ( type: esriFieldTypeString, alias: Vehicle Make, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VEHMAKE )
• VEHMODEL ( type: esriFieldTypeString, alias: Vehicle Model, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VEHMODEL )
• VEHYEAR ( type: esriFieldTypeString, alias: Vehicle Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: VEHYEAR )
• VEHCOLOR ( type: esriFieldTypeString, alias: Vehicle Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VEHCOLOR )
• UCRCODE ( type: esriFieldTypeString, alias: UCR Code, editable: true, nullable: true, length: 250, defaultValue: null, modelName: UCRCODE , Coded Values: [0001: SECURITY CHECK -RESIDENCE : 0001: SECURITY CHECK -RESIDENCE ] , [0002: SECURITY CHECK -PARK : 0002: SECURITY CHECK -PARK ] , [0003: SECURITY CHECK -CEMETERY : 0003: SECURITY CHECK -CEMETERY ] , ...720 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ACTIVITYDATE ( type: esriFieldTypeDate, alias: ACTIVITYTIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTIVITYDATE )
• ACTIVITYTIME ( type: esriFieldTypeSmallInteger, alias: ACTIVITYTIME, editable: true, nullable: true, defaultValue: 1200, modelName: ACTIVITYTIME )
• ACTIVITYAMPM ( type: esriFieldTypeString, alias: ACTIVITYAMPM, editable: true, nullable: true, length: 2, defaultValue: AM, modelName: ACTIVITYAMPM , Coded Values: [AM: AM] , [PM: PM] )

Types:

ID: Other
Name: Other
Domains:
• INTERTYPE:
  Inherited
• RESSTATE:
  Inherited
• RACE:
  Inherited
• GENDER:
  Inherited
• VEHLPSTATE:
  Inherited
• UCRCODE:
  Inherited
• ACTIVITYAMPM:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  BADGENO: null
  FULLADDR: null
  SUSACTIVITY: null
  RESCITY: null
  VEHLPNUM: null
  ACTIVITYDATE: null
  ACTIVITYTIME: 1200
  ACTIVITYAMPM: AM
  INTERID: null
  INTERDATE: null
  OFFICERNM: null
  AGENCY: Trenton Police Department
  MUNICIPALITY: City of Trenton
  INTERTYPE: Other
  FIRSTNAME: null
  LASTNAME: null
  AKANAME: null
  RESADDR: null
  RESSTATE: IL
  RESZIP5: null
  SSN: null
  DATEBIRTH: null
  RACE: null
  GENDER: null
  HAIRCOLOR: null
  EYECOLOR: null
  BODYHEIGHT: null
  BODYWEIGHT: null
  PHYSDESC: null
  CLOTHDESC: null
  VEHLPSTATE: IL
  VEHMAKE: null
  VEHMODEL: null
  VEHYEAR: null
  VEHCOLOR: null
  UCRCODE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Suspect
Name: Suspect
Domains:
• INTERTYPE:
  Inherited
• RESSTATE:
  Inherited
• RACE:
  Inherited
• GENDER:
  Inherited
• VEHLPSTATE:
  Inherited
• UCRCODE:
  Inherited
• ACTIVITYAMPM:
  Inherited
Templates:
• Name: Suspect
  Description:
  Prototype:
  BADGENO: null
  FULLADDR: null
  SUSACTIVITY: null
  RESCITY: null
  VEHLPNUM: null
  ACTIVITYDATE: null
  ACTIVITYTIME: 1200
  ACTIVITYAMPM: AM
  INTERID: null
  INTERDATE: null
  OFFICERNM: null
  AGENCY: Trenton Police Department
  MUNICIPALITY: City of Trenton
  INTERTYPE: Suspect
  FIRSTNAME: null
  LASTNAME: null
  AKANAME: null
  RESADDR: null
  RESSTATE: IL
  RESZIP5: null
  SSN: null
  DATEBIRTH: null
  RACE: null
  GENDER: null
  HAIRCOLOR: null
  EYECOLOR: null
  BODYHEIGHT: null
  BODYWEIGHT: null
  PHYSDESC: null
  CLOTHDESC: null
  VEHLPSTATE: IL
  VEHMAKE: null
  VEHMODEL: null
  VEHYEAR: null
  VEHCOLOR: null
  UCRCODE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Victim
Name: Victim
Domains:
• INTERTYPE:
  Inherited
• RESSTATE:
  Inherited
• RACE:
  Inherited
• GENDER:
  Inherited
• VEHLPSTATE:
  Inherited
• UCRCODE:
  Inherited
• ACTIVITYAMPM:
  Inherited
Templates:
• Name: Victim
  Description:
  Prototype:
  BADGENO: null
  FULLADDR: null
  SUSACTIVITY: null
  RESCITY: null
  VEHLPNUM: null
  ACTIVITYDATE: null
  ACTIVITYTIME: 1200
  ACTIVITYAMPM: AM
  INTERID: null
  INTERDATE: null
  OFFICERNM: null
  AGENCY: Trenton Police Department
  MUNICIPALITY: City of Trenton
  INTERTYPE: Victim
  FIRSTNAME: null
  LASTNAME: null
  AKANAME: null
  RESADDR: null
  RESSTATE: IL
  RESZIP5: null
  SSN: null
  DATEBIRTH: null
  RACE: null
  GENDER: null
  HAIRCOLOR: null
  EYECOLOR: null
  BODYHEIGHT: null
  BODYWEIGHT: null
  PHYSDESC: null
  CLOTHDESC: null
  VEHLPSTATE: IL
  VEHMAKE: null
  VEHMODEL: null
  VEHYEAR: null
  VEHCOLOR: null
  UCRCODE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Witness
Name: Witness
Domains:
• INTERTYPE:
  Inherited
• RESSTATE:
  Inherited
• RACE:
  Inherited
• GENDER:
  Inherited
• VEHLPSTATE:
  Inherited
• UCRCODE:
  Inherited
• ACTIVITYAMPM:
  Inherited
Templates:
• Name: Witness
  Description:
  Prototype:
  BADGENO: null
  FULLADDR: null
  SUSACTIVITY: null
  RESCITY: null
  VEHLPNUM: null
  ACTIVITYDATE: null
  ACTIVITYTIME: 1200
  ACTIVITYAMPM: AM
  INTERID: null
  INTERDATE: null
  OFFICERNM: null
  AGENCY: Trenton Police Department
  MUNICIPALITY: City of Trenton
  INTERTYPE: Witness
  FIRSTNAME: null
  LASTNAME: null
  AKANAME: null
  RESADDR: null
  RESSTATE: IL
  RESZIP5: null
  SSN: null
  DATEBIRTH: null
  RACE: null
  GENDER: null
  HAIRCOLOR: null
  EYECOLOR: null
  BODYHEIGHT: null
  BODYWEIGHT: null
  PHYSDESC: null
  CLOTHDESC: null
  VEHLPSTATE: IL
  VEHMAKE: null
  VEHMODEL: null
  VEHYEAR: null
  VEHCOLOR: null
  UCRCODE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata