Name: Review

Display Field:

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:

• service_request_num (type: esriFieldTypeString, alias: service_request_num, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• sr_status (type: esriFieldTypeString, alias: sr_status, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• status_date (type: esriFieldTypeDate, alias: status_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• last_activity (type: esriFieldTypeString, alias: last_activity, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• outcome (type: esriFieldTypeString, alias: outcome, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: neighborhood, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• longitude (type: esriFieldTypeString, alias: longitude, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• latitude (type: esriFieldTypeString, alias: latitude, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• year_created (type: esriFieldTypeInteger, alias: year_created, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• month_created (type: esriFieldTypeInteger, alias: month_created, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• year_qrt_created (type: esriFieldTypeDouble, alias: year_qrt_created, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• wday_created (type: esriFieldTypeInteger, alias: wday_created, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• days_to_closed (type: esriFieldTypeDouble, alias: days_to_closed, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• address_geo (type: esriFieldTypeString, alias: address_geo, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• block (type: esriFieldTypeInteger, alias: block, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• coordinates (type: esriFieldTypeString, alias: coordinates, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• county_fips (type: esriFieldTypeInteger, alias: county_fips, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• geocoded_address (type: esriFieldTypeString, alias: geocoded_address, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• id (type: esriFieldTypeInteger, alias: id, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• is_exact (type: esriFieldTypeString, alias: is_exact, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• is_match (type: esriFieldTypeString, alias: is_match, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• latitude_geo (type: esriFieldTypeDouble, alias: latitude_geo, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• longitude_geo (type: esriFieldTypeDouble, alias: longitude_geo, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• returned_address (type: esriFieldTypeString, alias: returned_address, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• side (type: esriFieldTypeString, alias: side, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: state, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• state_fips (type: esriFieldTypeInteger, alias: state_fips, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• tiger_line (type: esriFieldTypeInteger, alias: tiger_line, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• tract (type: esriFieldTypeInteger, alias: tract, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• zipcode (type: esriFieldTypeString, alias: zipcode, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/11/2020 8:10:36 PM

Schema Last Edit Date: 6/11/2020 8:10:36 PM

Data Last Edit Date: 6/11/2020 8:10:36 PM

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