Name: WDLGIS.DBO.TrashLog

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• DATE ( type: esriFieldTypeDate, alias: DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• NAME ( type: esriFieldTypeString, alias: TECH NAME/ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• CONDITION ( type: esriFieldTypeString, alias: COND/MECH, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONDITION )
• ROUTE ( type: esriFieldTypeString, alias: ROUTE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE )
• BAGS_AM ( type: esriFieldTypeDouble, alias: BAGS AM, editable: true, nullable: true, defaultValue: null, modelName: BAGS_AM )
• BAGS_PM ( type: esriFieldTypeDouble, alias: BAGS PM, editable: true, nullable: true, defaultValue: null, modelName: BAGS_PM )
• BAGS_RECYCLING ( type: esriFieldTypeDouble, alias: BAGS RECYCLING, editable: true, nullable: true, defaultValue: null, modelName: BAGS_RECYCLING )
• BAGS_BULK ( type: esriFieldTypeDouble, alias: BAGS BULK, editable: true, nullable: true, defaultValue: null, modelName: BAGS_BULK )
• BAGS_TOTAL ( type: esriFieldTypeDouble, alias: BAGS TOTAL COUNT, editable: true, nullable: true, defaultValue: null, modelName: BAGS_TOTAL )
• CARDBOARD ( type: esriFieldTypeSmallInteger, alias: CARDBOARD, editable: true, nullable: true, defaultValue: null, modelName: CARDBOARD )
• METAL ( type: esriFieldTypeSmallInteger, alias: METAL, editable: true, nullable: true, defaultValue: null, modelName: METAL )
• WOOD ( type: esriFieldTypeSmallInteger, alias: WOOD, editable: true, nullable: true, defaultValue: null, modelName: WOOD )
• SIGN ( type: esriFieldTypeSmallInteger, alias: SIGN, editable: true, nullable: true, defaultValue: null, modelName: SIGN )
• CAR_PART ( type: esriFieldTypeSmallInteger, alias: CAR PART, editable: true, nullable: true, defaultValue: null, modelName: CAR_PART )
• TIRE ( type: esriFieldTypeSmallInteger, alias: TIRE, editable: true, nullable: true, defaultValue: null, modelName: TIRE )
• FURNITURE ( type: esriFieldTypeSmallInteger, alias: FURNITURE, editable: true, nullable: true, defaultValue: null, modelName: FURNITURE )
• OTHER ( type: esriFieldTypeSmallInteger, alias: OTHER, editable: true, nullable: true, defaultValue: null, modelName: OTHER )
• BULK_TOTAL ( type: esriFieldTypeSmallInteger, alias: BULK ITEM TOTAL, editable: true, nullable: true, defaultValue: null, modelName: BULK_TOTAL )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 250, defaultValue: null, modelName: NOTE )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_ID ( type: esriFieldTypeString, alias: STREET_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_ID )
• 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 )
• ParentGuid ( type: esriFieldTypeGUID, alias: Parent Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentGuid )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• COMPLETED ( type: esriFieldTypeString, alias: COMPLETED?, editable: true, nullable: true, length: 1, defaultValue: null, modelName: COMPLETED )

Templates:

• Name: WDLGIS.DBO.TrashLog
  Description:
  Prototype:
  ParentGuid: null
  DATE: null
  NAME: null
  CONDITION: null
  ROUTE: null
  BAGS_AM: null
  BAGS_PM: null
  BAGS_RECYCLING: null
  BAGS_BULK: null
  BAGS_TOTAL: null
  CARDBOARD: null
  METAL: null
  WOOD: null
  SIGN: null
  CAR_PART: null
  TIRE: null
  FURNITURE: null
  OTHER: null
  BULK_TOTAL: null
  NOTES: null
  STREET_NAME: null
  STREET_ID: null
  COMPLETED: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• StreetscapeTrashCollectionRoutes (1) -- Related To: Streetscape RoW Trash Collection Routes (0)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: false

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