Name: dbo.vw_ActivityReportsHCSO

Display Field: CallType

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: uid

Unique ID Field:

Name : uid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• RecordID (type: esriFieldTypeInteger, alias: RecordID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CallType (type: esriFieldTypeString, alias: CallType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UnitsLastDispo (type: esriFieldTypeString, alias: UnitsLastDispo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FinalCallDispo (type: esriFieldTypeString, alias: FinalCallDispo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BackupUnit (type: esriFieldTypeString, alias: BackupUnit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CallNumber (type: esriFieldTypeString, alias: CallNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReportNumber (type: esriFieldTypeString, alias: ReportNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CallLocation (type: esriFieldTypeString, alias: CallLocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DispatchedTime (type: esriFieldTypeDate, alias: DispatchedTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ClearTime (type: esriFieldTypeDate, alias: ClearTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MinutesOnCall (type: esriFieldTypeDouble, alias: MinutesOnCall, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AsUnit (type: esriFieldTypeString, alias: AsUnit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• file_ (type: esriFieldTypeString, alias: file, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sheet (type: esriFieldTypeString, alias: sheet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DateUpdated (type: esriFieldTypeDate, alias: DateUpdated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• geoid_precinct_2020 (type: esriFieldTypeString, alias: geoid_precinct_2020, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• geoid_tract_2020 (type: esriFieldTypeString, alias: geoid_tract_2020, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• geoid_blockgroup_2020 (type: esriFieldTypeString, alias: geoid_blockgroup_2020, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• street_address (type: esriFieldTypeString, alias: street_address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• uid (type: esriFieldTypeOID, alias: uid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Excluded (type: esriFieldTypeInteger, alias: Excluded, SQL Type: sqlTypeOther, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Beat (type: esriFieldTypeString, alias: Beat, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• firstdate (type: esriFieldTypeString, alias: firstdate, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ProgramWeek (type: esriFieldTypeInteger, alias: ProgramWeek, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cYear (type: esriFieldTypeString, alias: cYear, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)

Templates:

Name: dbo.vw_ActivityReportsHCSO
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/21/2023 1:57:40 AM

Schema Last Edit Date: 6/21/2023 1:57:40 AM

Data Last Edit Date: 6/21/2023 1:57:40 AM

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