Name: Garbage and Recycling Carts

Display Field: RouteName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 11c7fd6782ce46db874b900f04989b5d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RouteName ( type: esriFieldTypeString, alias: RouteName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RouteName )
• CartType ( type: esriFieldTypeString, alias: CartType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CartType , Coded Values: [Trash: Trash] , [Recycle: Recycle] )
• CartSize ( type: esriFieldTypeDouble, alias: CartSize, editable: true, nullable: true, defaultValue: null, modelName: CartSize )
• AddressNumber ( type: esriFieldTypeDouble, alias: AddressNumber, editable: true, nullable: true, defaultValue: null, modelName: AddressNumber )
• StreetName ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetName )
• AddressUnit ( type: esriFieldTypeString, alias: AddressUnit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressUnit )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 255, defaultValue: null, modelName: State )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: City )
• Zip ( type: esriFieldTypeDouble, alias: Zip, editable: true, nullable: true, defaultValue: null, modelName: Zip )
• Delivered ( type: esriFieldTypeSmallInteger, alias: Delivered, editable: true, nullable: true, defaultValue: null, modelName: Delivered )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SerialNumber )
• RFIDTag ( type: esriFieldTypeString, alias: RFIDTag, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RFIDTag )
• ReasonCodeName ( type: esriFieldTypeString, alias: ReasonCodeName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReasonCodeName )
• DeliveryNotes ( type: esriFieldTypeString, alias: DeliveryNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DeliveryNotes )
• TimestampDelivered ( type: esriFieldTypeDate, alias: TimestampDelivered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TimestampDelivered )
• AddressId ( type: esriFieldTypeDouble, alias: AddressId, editable: true, nullable: true, defaultValue: null, modelName: AddressId )
• LongitudeDelivered ( type: esriFieldTypeDouble, alias: LongitudeDelivered, editable: true, nullable: true, defaultValue: null, modelName: LongitudeDelivered )
• LatitudeDelivered ( type: esriFieldTypeDouble, alias: LatitudeDelivered, editable: true, nullable: true, defaultValue: null, modelName: LatitudeDelivered )
• FULL_ADD ( type: esriFieldTypeString, alias: FULL_ADD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULL_ADD )
• GLOBAL_ID ( type: esriFieldTypeGUID, alias: GLOBAL_ID (OG), editable: true, nullable: true, length: 38, defaultValue: null, modelName: GLOBAL_ID )
• CreatBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatBy )
• CreateDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• EditBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID (actual), editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ReplaceCartDate ( type: esriFieldTypeDate, alias: Replace Cart Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReplaceCartDate )
• ReplaceLidDate ( type: esriFieldTypeDate, alias: Replace Lid Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReplaceLidDate )
• ReplaceNotes ( type: esriFieldTypeString, alias: Replace Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ReplaceNotes )

Templates:

• Name: Garbage and Recycling Carts
  Description:
  Prototype:
  ReplaceLidDate: null
  ReplaceCartDate: null
  RouteName: null
  CartType: null
  CartSize: null
  AddressNumber: null
  StreetName: null
  AddressUnit: null
  State: null
  City: null
  Zip: null
  Delivered: null
  SerialNumber: null
  RFIDTag: null
  ReasonCodeName: null
  DeliveryNotes: null
  TimestampDelivered: null
  AddressId: null
  LongitudeDelivered: null
  LatitudeDelivered: null
  FULL_ADD: null
  GLOBAL_ID: null
  ReplaceNotes: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• CustomerPoints (0) -- Related To: Customer Address Points (0)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreatBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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