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
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: 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:
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: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
ORDERYEAR
(
type: esriFieldTypeInteger, alias: ORDERYEAR
)
-
ORDERNUMBER
(
type: esriFieldTypeInteger, alias: ORDERNUMBER
)
-
ORDERTYPE
(
type: esriFieldTypeInteger, alias: ORDERTYPE
)
-
WODESCRIPTION
(
type: esriFieldTypeString, alias: WODESCRIPTION, length: 50
)
-
WOCREATIONDATE
(
type: esriFieldTypeDate, alias: WOCREATIONDATE, length: 8
)
-
WOSCHEDULEDDATE
(
type: esriFieldTypeDate, alias: WOSCHEDULEDDATE, length: 8
)
-
ENQWOCREATIONTIME
(
type: esriFieldTypeString, alias: ENQWOCREATIONTIME, length: 81
)
-
WOCREATIONTIME
(
type: esriFieldTypeString, alias: WOCREATIONTIME, length: 82
)
-
CUSTOMERNUMBER
(
type: esriFieldTypeString, alias: CUSTOMERNUMBER, length: 25
)
-
ISSUEDBY
(
type: esriFieldTypeString, alias: ISSUEDBY, length: 50
)
-
WOCOMMENT1
(
type: esriFieldTypeString, alias: WOCOMMENT1, length: 50
)
-
WOCOMMENT2
(
type: esriFieldTypeString, alias: WOCOMMENT2, length: 50
)
-
CUSTOMERNAME
(
type: esriFieldTypeString, alias: CUSTOMERNAME, length: 50
)
-
SERVICEPREMISEADDRESSNUMBER
(
type: esriFieldTypeInteger, alias: SERVICEPREMISEADDRESSNUMBER
)
-
SERVICEPREMISENAME
(
type: esriFieldTypeString, alias: SERVICEPREMISENAME, length: 50
)
-
TOWN
(
type: esriFieldTypeString, alias: TOWN, length: 23
)
-
ZIP
(
type: esriFieldTypeString, alias: ZIP, length: 15
)
-
MAP_REF
(
type: esriFieldTypeString, alias: MAP_REF, length: 50
)
-
PREMISENUMBER
(
type: esriFieldTypeString, alias: PREMISENUMBER, length: 15
)
-
CISNUMBER
(
type: esriFieldTypeString, alias: CISNUMBER, length: 15
)
-
ONSTREET
(
type: esriFieldTypeString, alias: ONSTREET, length: 50
)
-
CROSSSTREET
(
type: esriFieldTypeString, alias: CROSSSTREET, length: 50
)
-
METER
(
type: esriFieldTypeString, alias: METER, length: 50
)
-
METER_INSTALLED_DATE
(
type: esriFieldTypeString, alias: METER_INSTALLED_DATE, length: 10
)
-
CLASS_DESCRIPTION
(
type: esriFieldTypeString, alias: CLASS_DESCRIPTION, length: 50
)
-
LAST_ACTUAL_READ
(
type: esriFieldTypeString, alias: LAST_ACTUAL_READ, length: 10
)
-
LAST_ACTUAL_READ_DATE
(
type: esriFieldTypeString, alias: LAST_ACTUAL_READ_DATE, length: 10
)
-
METER_CYCLE
(
type: esriFieldTypeString, alias: METER_CYCLE, length: 10
)
-
METER_ROUTE
(
type: esriFieldTypeString, alias: METER_ROUTE, length: 10
)
-
METER_COMMENT1
(
type: esriFieldTypeString, alias: METER_COMMENT1, length: 20
)
-
METER_COMMENT2
(
type: esriFieldTypeString, alias: METER_COMMENT2, length: 20
)
-
METER_COMMENT3
(
type: esriFieldTypeString, alias: METER_COMMENT3, length: 20
)
-
METER_COMMENT4
(
type: esriFieldTypeString, alias: METER_COMMENT4, length: 20
)
-
METER_DIAL
(
type: esriFieldTypeString, alias: METER_DIAL, length: 10
)
-
METER_MIU_REGISTER
(
type: esriFieldTypeString, alias: METER_MIU_REGISTER, length: 25
)
-
METER_DEAD_ZERO
(
type: esriFieldTypeString, alias: METER_DEAD_ZERO, length: 10
)
-
METER_MAKE
(
type: esriFieldTypeString, alias: METER_MAKE, length: 50
)
-
METER_MODEL
(
type: esriFieldTypeString, alias: METER_MODEL, length: 50
)
-
METER_SIZE
(
type: esriFieldTypeString, alias: METER_SIZE, length: 50
)
-
METER_MATERIAL
(
type: esriFieldTypeString, alias: METER_MATERIAL, length: 50
)
-
NOTEPADID
(
type: esriFieldTypeString, alias: NOTEPADID, length: 12
)
-
LONGNOTE
(
type: esriFieldTypeString, alias: LONGNOTE, length: 1000
)
-
SCRIPTCODE
(
type: esriFieldTypeInteger, alias: SCRIPTCODE
)
-
CONTACT_PHONE
(
type: esriFieldTypeString, alias: CONTACT_PHONE, length: 15
)
-
BUS_PHONE
(
type: esriFieldTypeString, alias: BUS_PHONE, length: 15
)
-
CUST_EMAIL
(
type: esriFieldTypeString, alias: CUST_EMAIL, length: 256
)
-
EXTRACTTIME
(
type: esriFieldTypeString, alias: EXTRACTTIME, length: 50
)
-
EXTRACTFLAG
(
type: esriFieldTypeString, alias: EXTRACTFLAG, length: 10
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
FacilityID
(
type: esriFieldTypeString, alias: FacilityID, length: 255
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
SedaruComment
(
type: esriFieldTypeString, alias: Sedaru Comment, length: 500
)
Supported Operations:
Query
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata