Name: combined_inmates

Display Field: lastName

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)
• inmateNum (type: esriFieldTypeString, alias: inmateNum, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• jailId (type: esriFieldTypeString, alias: jailId, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• lastName (type: esriFieldTypeString, alias: lastName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• firstName (type: esriFieldTypeString, alias: firstName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• sex (type: esriFieldTypeString, alias: sex, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DOB (type: esriFieldTypeDateOnly, alias: DOB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• arrestDate (type: esriFieldTypeDateOnly, alias: arrestDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• arrestTime (type: esriFieldTypeTimeOnly, alias: arrestTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bookingDate (type: esriFieldTypeDateOnly, alias: bookingDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bookingTime (type: esriFieldTypeTimeOnly, alias: bookingTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• releaseDate (type: esriFieldTypeDateOnly, alias: releaseDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• releaseTime (type: esriFieldTypeTimeOnly, alias: releaseTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• scheduledReleaseDate (type: esriFieldTypeDateOnly, alias: scheduledReleaseDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• scheduledReleaseTime (type: esriFieldTypeTimeOnly, alias: scheduledReleaseTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• scheduledReleaseType (type: esriFieldTypeString, alias: scheduledReleaseType, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• releaseReason (type: esriFieldTypeString, alias: releaseReason, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• firstArrestingAgency (type: esriFieldTypeString, alias: firstArrestingAgency, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• held_for_agency (type: esriFieldTypeString, alias: held_for_agency, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• arresting_agency (type: esriFieldTypeString, alias: arresting_agency, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• in_custody (type: esriFieldTypeSmallInteger, alias: in_custody, SQL Type: sqlTypeOther, nullable: true, editable: true)
• current_inmates (type: esriFieldTypeSmallInteger, alias: current_inmates, SQL Type: sqlTypeOther, nullable: true, editable: true)
• arrests (type: esriFieldTypeSmallInteger, alias: arrests, SQL Type: sqlTypeOther, nullable: true, editable: true)
• releases (type: esriFieldTypeSmallInteger, alias: releases, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: combined_inmates
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/6/2026 4:02:02 PM

Schema Last Edit Date: 8/6/2026 4:02:02 PM

Data Last Edit Date: 8/6/2026 4:02:02 PM

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