View In:   ArcGIS Online map viewer

Name: sde_Pub10.SDE.EnQuestaWorkOrders

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 6788080.838414714
YMin: 1827590.2499517202
XMax: 6843460.443206474
YMax: 1877572.7011677325
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 153]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ORDERYEAR ( type: esriFieldTypeInteger, alias: ORDERYEAR, editable: true, nullable: false, defaultValue: null, modelName: ORDERYEAR )
• ORDERNUMBER ( type: esriFieldTypeInteger, alias: ORDERNUMBER, editable: true, nullable: false, defaultValue: null, modelName: ORDERNUMBER )
• ORDERTYPE ( type: esriFieldTypeInteger, alias: ORDERTYPE, editable: true, nullable: false, defaultValue: null, modelName: ORDERTYPE )
• WODESCRIPTION ( type: esriFieldTypeString, alias: WODESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WODESCRIPTION )
• WOCREATIONDATE ( type: esriFieldTypeDate, alias: WOCREATIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WOCREATIONDATE )
• WOSCHEDULEDDATE ( type: esriFieldTypeDate, alias: WOSCHEDULEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WOSCHEDULEDDATE )
• ENQWOCREATIONTIME ( type: esriFieldTypeString, alias: ENQWOCREATIONTIME, editable: true, nullable: true, length: 81, defaultValue: null, modelName: ENQWOCREATIONTIME )
• WOCREATIONTIME ( type: esriFieldTypeString, alias: WOCREATIONTIME, editable: true, nullable: true, length: 82, defaultValue: null, modelName: WOCREATIONTIME )
• CUSTOMERNUMBER ( type: esriFieldTypeString, alias: CUSTOMERNUMBER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CUSTOMERNUMBER )
• ISSUEDBY ( type: esriFieldTypeString, alias: ISSUEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ISSUEDBY )
• WOCOMMENT1 ( type: esriFieldTypeString, alias: WOCOMMENT1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WOCOMMENT1 )
• WOCOMMENT2 ( type: esriFieldTypeString, alias: WOCOMMENT2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WOCOMMENT2 )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CUSTOMERNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CUSTOMERNAME )
• SERVICEPREMISEADDRESSNUMBER ( type: esriFieldTypeInteger, alias: SERVICEPREMISEADDRESSNUMBER, editable: true, nullable: true, defaultValue: null, modelName: SERVICEPREMISEADDRESSNUMBER )
• SERVICEPREMISENAME ( type: esriFieldTypeString, alias: SERVICEPREMISENAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICEPREMISENAME )
• TOWN ( type: esriFieldTypeString, alias: TOWN, editable: true, nullable: true, length: 23, defaultValue: null, modelName: TOWN )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ZIP )
• MAP_REF ( type: esriFieldTypeString, alias: MAP_REF, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_REF )
• PREMISENUMBER ( type: esriFieldTypeString, alias: PREMISENUMBER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PREMISENUMBER )
• CISNUMBER ( type: esriFieldTypeString, alias: CISNUMBER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CISNUMBER )
• ONSTREET ( type: esriFieldTypeString, alias: ONSTREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ONSTREET )
• CROSSSTREET ( type: esriFieldTypeString, alias: CROSSSTREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CROSSSTREET )
• METER ( type: esriFieldTypeString, alias: METER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER )
• METER_INSTALLED_DATE ( type: esriFieldTypeString, alias: METER_INSTALLED_DATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: METER_INSTALLED_DATE )
• CLASS_DESCRIPTION ( type: esriFieldTypeString, alias: CLASS_DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLASS_DESCRIPTION )
• LAST_ACTUAL_READ ( type: esriFieldTypeString, alias: LAST_ACTUAL_READ, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LAST_ACTUAL_READ )
• LAST_ACTUAL_READ_DATE ( type: esriFieldTypeString, alias: LAST_ACTUAL_READ_DATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LAST_ACTUAL_READ_DATE )
• METER_CYCLE ( type: esriFieldTypeString, alias: METER_CYCLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: METER_CYCLE )
• METER_ROUTE ( type: esriFieldTypeString, alias: METER_ROUTE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: METER_ROUTE )
• METER_COMMENT1 ( type: esriFieldTypeString, alias: METER_COMMENT1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: METER_COMMENT1 )
• METER_COMMENT2 ( type: esriFieldTypeString, alias: METER_COMMENT2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: METER_COMMENT2 )
• METER_COMMENT3 ( type: esriFieldTypeString, alias: METER_COMMENT3, editable: true, nullable: true, length: 20, defaultValue: null, modelName: METER_COMMENT3 )
• METER_COMMENT4 ( type: esriFieldTypeString, alias: METER_COMMENT4, editable: true, nullable: true, length: 20, defaultValue: null, modelName: METER_COMMENT4 )
• METER_DIAL ( type: esriFieldTypeString, alias: METER_DIAL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: METER_DIAL )
• METER_MIU_REGISTER ( type: esriFieldTypeString, alias: METER_MIU_REGISTER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: METER_MIU_REGISTER )
• METER_DEAD_ZERO ( type: esriFieldTypeString, alias: METER_DEAD_ZERO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: METER_DEAD_ZERO )
• METER_MAKE ( type: esriFieldTypeString, alias: METER_MAKE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER_MAKE )
• METER_MODEL ( type: esriFieldTypeString, alias: METER_MODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER_MODEL )
• METER_SIZE ( type: esriFieldTypeString, alias: METER_SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER_SIZE )
• METER_MATERIAL ( type: esriFieldTypeString, alias: METER_MATERIAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER_MATERIAL )
• NOTEPADID ( type: esriFieldTypeString, alias: NOTEPADID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: NOTEPADID )
• LONGNOTE ( type: esriFieldTypeString, alias: LONGNOTE, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LONGNOTE )
• SCRIPTCODE ( type: esriFieldTypeInteger, alias: SCRIPTCODE, editable: true, nullable: true, defaultValue: null, modelName: SCRIPTCODE )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: CONTACT_PHONE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONTACT_PHONE )
• BUS_PHONE ( type: esriFieldTypeString, alias: BUS_PHONE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BUS_PHONE )
• CUST_EMAIL ( type: esriFieldTypeString, alias: CUST_EMAIL, editable: true, nullable: true, length: 256, defaultValue: null, modelName: CUST_EMAIL )
• EXTRACTTIME ( type: esriFieldTypeString, alias: EXTRACTTIME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXTRACTTIME )
• EXTRACTFLAG ( type: esriFieldTypeString, alias: EXTRACTFLAG, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EXTRACTFLAG )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SedaruComment ( type: esriFieldTypeString, alias: Sedaru Comment, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SedaruComment )

Templates:

• Name: sde_Pub10.SDE.EnQuestaWorkOrders
  Description:
  Prototype:
  SedaruComment: null
  FacilityID: null
  ORDERYEAR: 0
  ORDERNUMBER: 0
  ORDERTYPE: 0
  WODESCRIPTION: null
  WOCREATIONDATE: null
  WOSCHEDULEDDATE: null
  ENQWOCREATIONTIME: null
  WOCREATIONTIME: null
  CUSTOMERNUMBER: null
  ISSUEDBY: null
  WOCOMMENT1: null
  WOCOMMENT2: null
  CUSTOMERNAME: null
  SERVICEPREMISEADDRESSNUMBER: null
  SERVICEPREMISENAME: null
  TOWN: null
  ZIP: null
  MAP_REF: null
  PREMISENUMBER: null
  CISNUMBER: null
  ONSTREET: null
  CROSSSTREET: null
  METER: null
  METER_INSTALLED_DATE: null
  CLASS_DESCRIPTION: null
  LAST_ACTUAL_READ: null
  LAST_ACTUAL_READ_DATE: null
  METER_CYCLE: null
  METER_ROUTE: null
  METER_COMMENT1: null
  METER_COMMENT2: null
  METER_COMMENT3: null
  METER_COMMENT4: null
  METER_DIAL: null
  METER_MIU_REGISTER: null
  METER_DEAD_ZERO: null
  METER_MAKE: null
  METER_MODEL: null
  METER_SIZE: null
  METER_MATERIAL: null
  NOTEPADID: null
  LONGNOTE: null
  SCRIPTCODE: null
  CONTACT_PHONE: null
  BUS_PHONE: null
  CUST_EMAIL: null
  EXTRACTTIME: null
  EXTRACTFLAG: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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