Layers:

Layer: Valve Inspection (0)

Name: Valve Inspection

Display Field: sdedata.SDEDATA.WSystemValve.INSPTEMPLATENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: false

Supports Statistics: false

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 0.0
YMin: 0.0
XMax: 2727601.75189209
YMax: 746779.7692871094
Spatial Reference: 3361  (3361)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Cityworks_NMB.DBO.%INSPECTION.STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CLOSED
  Label: CLOSED
  Description: N/A
  Symbol:
  
• Value: COMPLETE
  Label: COMPLETE
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [255, 255, 115, 255]
  Size: 14.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [104, 104, 104, 255] Width: 0
• Value: OPEN
  Label: OPEN
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [sdedata.SDEDATA.WSystemValve.INSPECTIONID]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 801.0
Max. Scale: 0.0

Advanced Query Capabilities:
Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Sub_type

Fields:
• sdedata.SDEDATA.WSystemValve.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• sdedata.SDEDATA.WSystemValve.AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole )
• sdedata.SDEDATA.WSystemValve.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WSystemValve.FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• sdedata.SDEDATA.WSystemValve.Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• sdedata.SDEDATA.WSystemValve.InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• sdedata.SDEDATA.WSystemValve.LifeCycleStatus ( type: esriFieldTypeString, alias: LifeCycleStatus, length: 20 , Coded Values: [PRP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...2 more... )
• sdedata.SDEDATA.WSystemValve.WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• sdedata.SDEDATA.WSystemValve.InstallContractor ( type: esriFieldTypeString, alias: InstallContractor, length: 60 )
• sdedata.SDEDATA.WSystemValve.Condition ( type: esriFieldTypeString, alias: Condition, length: 10 )
• sdedata.SDEDATA.WSystemValve.ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• sdedata.SDEDATA.WSystemValve.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 20 , Coded Values: [A: American] , [C: Clow] , [K: Kennedy] , ...9 more... )
• sdedata.SDEDATA.WSystemValve.Diameter ( type: esriFieldTypeDouble, alias: Diameter )
• sdedata.SDEDATA.WSystemValve.GroundType ( type: esriFieldTypeString, alias: GroundType, length: 20 , Coded Values: [UNK: Unknown] , [OTH: Other] , [D: Dirt] , ...3 more... )
• sdedata.SDEDATA.WSystemValve.CurrentPosition ( type: esriFieldTypeString, alias: CurrentPosition, length: 20 , Coded Values: [UNK: Unknown] , [OPEN: Open] , [OPIO: Open Inoperable] , ...4 more... )
• sdedata.SDEDATA.WSystemValve.Sub_type ( type: esriFieldTypeInteger, alias: Sub_type )
• sdedata.SDEDATA.WSystemValve.BypassValve ( type: esriFieldTypeInteger, alias: BypassValve , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WSystemValve.TurnsToClose ( type: esriFieldTypeInteger, alias: TurnsToClose )
• sdedata.SDEDATA.WSystemValve.OpenDirection ( type: esriFieldTypeString, alias: OpenDirection, length: 255 , Coded Values: [L: Left] , [R: Right] , [UNK: Unknown] )
• sdedata.SDEDATA.WSystemValve.CurrentlyOpen ( type: esriFieldTypeInteger, alias: CurrentlyOpen , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WSystemValve.Housing ( type: esriFieldTypeString, alias: Housing, length: 255 , Coded Values: [MANHOLE: Manhole] , [MTRBOX: Meterbox] , [VLVBOX: ValveBox] , ...2 more... )
• sdedata.SDEDATA.WSystemValve.SizeofNut ( type: esriFieldTypeString, alias: SizeofNut, length: 255 , Coded Values: [2inchSQ: 2" Square] , [WHEEL: Wheel] )
• sdedata.SDEDATA.WSystemValve.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID ( type: esriFieldTypeDouble, alias: INSPECTIONID )
• Cityworks_NMB.DBO.%INSPECTION.WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, length: 60 )
• Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATEID ( type: esriFieldTypeDouble, alias: INSPTEMPLATEID )
• Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATENAME ( type: esriFieldTypeString, alias: INSPTEMPLATENAME, length: 30 )
• Cityworks_NMB.DBO.%INSPECTION.ENTITYUID ( type: esriFieldTypeString, alias: ENTITYUID, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE ( type: esriFieldTypeString, alias: ENTITYTYPE, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.INSPDATE ( type: esriFieldTypeDate, alias: INSPDATE, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBY ( type: esriFieldTypeString, alias: INSPECTEDBY, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 256 )
• Cityworks_NMB.DBO.%INSPECTION.OBSERVATIONSUM ( type: esriFieldTypeString, alias: OBSERVATIONSUM, length: 900 )
• Cityworks_NMB.DBO.%INSPECTION.REPAIRSMADE ( type: esriFieldTypeString, alias: REPAIRSMADE, length: 900 )
• Cityworks_NMB.DBO.%INSPECTION.FOREMANRECOMND ( type: esriFieldTypeString, alias: FOREMANRECOMND, length: 900 )
• Cityworks_NMB.DBO.%INSPECTION.REQUESTID ( type: esriFieldTypeInteger, alias: REQUESTID )
• Cityworks_NMB.DBO.%INSPECTION.PRJSTARTDATE ( type: esriFieldTypeDate, alias: PRJSTARTDATE, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.PRJFINISHDATE ( type: esriFieldTypeDate, alias: PRJFINISHDATE, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.ACTFINISHDATE ( type: esriFieldTypeDate, alias: ACTFINISHDATE, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.DATECLOSED ( type: esriFieldTypeDate, alias: DATECLOSED, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.CLOSEDBY ( type: esriFieldTypeString, alias: CLOSEDBY, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.CLOSESR ( type: esriFieldTypeSmallInteger, alias: CLOSESR )
• Cityworks_NMB.DBO.%INSPECTION.CANCEL ( type: esriFieldTypeSmallInteger, alias: CANCEL )
• Cityworks_NMB.DBO.%INSPECTION.DATECANCELLED ( type: esriFieldTypeDate, alias: DATECANCELLED, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBY ( type: esriFieldTypeString, alias: CANCELLEDBY, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.CANCELREASON ( type: esriFieldTypeString, alias: CANCELREASON, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.INSPX ( type: esriFieldTypeDouble, alias: INSPX )
• Cityworks_NMB.DBO.%INSPECTION.INSPY ( type: esriFieldTypeDouble, alias: INSPY )
• Cityworks_NMB.DBO.%INSPECTION.DOMAINID ( type: esriFieldTypeInteger, alias: DOMAINID )
• Cityworks_NMB.DBO.%INSPECTION.FEATURETYPE ( type: esriFieldTypeString, alias: FEATURETYPE, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.FEATUREID ( type: esriFieldTypeInteger, alias: FEATUREID )
• Cityworks_NMB.DBO.%INSPECTION.FEATUREUID ( type: esriFieldTypeString, alias: FEATUREUID, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.ENTITYSID ( type: esriFieldTypeInteger, alias: ENTITYSID )
• Cityworks_NMB.DBO.%INSPECTION.INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.INITIATEDATE ( type: esriFieldTypeDate, alias: INITIATEDATE, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.SHOP ( type: esriFieldTypeString, alias: SHOP, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.MAPPAGE ( type: esriFieldTypeString, alias: MAPPAGE, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TILENO ( type: esriFieldTypeString, alias: TILENO, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.RESOLUTION ( type: esriFieldTypeString, alias: RESOLUTION, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.CONDRATING ( type: esriFieldTypeDouble, alias: CONDRATING )
• Cityworks_NMB.DBO.%INSPECTION.TEXT1 ( type: esriFieldTypeString, alias: TEXT1, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT2 ( type: esriFieldTypeString, alias: TEXT2, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT3 ( type: esriFieldTypeString, alias: TEXT3, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT4 ( type: esriFieldTypeString, alias: TEXT4, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT5 ( type: esriFieldTypeString, alias: TEXT5, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT6 ( type: esriFieldTypeString, alias: TEXT6, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT7 ( type: esriFieldTypeString, alias: TEXT7, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT8 ( type: esriFieldTypeString, alias: TEXT8, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT9 ( type: esriFieldTypeString, alias: TEXT9, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.TEXT10 ( type: esriFieldTypeString, alias: TEXT10, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.NUM1 ( type: esriFieldTypeDouble, alias: NUM1 )
• Cityworks_NMB.DBO.%INSPECTION.NUM2 ( type: esriFieldTypeDouble, alias: NUM2 )
• Cityworks_NMB.DBO.%INSPECTION.NUM3 ( type: esriFieldTypeDouble, alias: NUM3 )
• Cityworks_NMB.DBO.%INSPECTION.NUM4 ( type: esriFieldTypeDouble, alias: NUM4 )
• Cityworks_NMB.DBO.%INSPECTION.NUM5 ( type: esriFieldTypeDouble, alias: NUM5 )
• Cityworks_NMB.DBO.%INSPECTION.DATE1 ( type: esriFieldTypeDate, alias: DATE1, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.DATE2 ( type: esriFieldTypeDate, alias: DATE2, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.DATE3 ( type: esriFieldTypeDate, alias: DATE3, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.DATE4 ( type: esriFieldTypeDate, alias: DATE4, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.DATE5 ( type: esriFieldTypeDate, alias: DATE5, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.CONDSCORE ( type: esriFieldTypeDouble, alias: CONDSCORE )
• Cityworks_NMB.DBO.%INSPECTION.UPDATEMAP ( type: esriFieldTypeString, alias: UPDATEMAP, length: 1 )
• Cityworks_NMB.DBO.%INSPECTION.SUBMITTOEMPLOYEESID ( type: esriFieldTypeDouble, alias: SUBMITTOEMPLOYEESID )
• Cityworks_NMB.DBO.%INSPECTION.SUBMITTONAME ( type: esriFieldTypeString, alias: SUBMITTONAME, length: 100 )
• Cityworks_NMB.DBO.%INSPECTION.DATESUBMITTO ( type: esriFieldTypeDate, alias: DATESUBMITTO, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.EFFORT ( type: esriFieldTypeDouble, alias: EFFORT )
• Cityworks_NMB.DBO.%INSPECTION.PARENTINSPID ( type: esriFieldTypeInteger, alias: PARENTINSPID )
• Cityworks_NMB.DBO.%INSPECTION.CYCLETYPE ( type: esriFieldTypeString, alias: CYCLETYPE, length: 20 )
• Cityworks_NMB.DBO.%INSPECTION.CYCLEFROM ( type: esriFieldTypeString, alias: CYCLEFROM, length: 30 )
• Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALNUM ( type: esriFieldTypeInteger, alias: CYCLEINTERVALNUM )
• Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALUNIT ( type: esriFieldTypeString, alias: CYCLEINTERVALUNIT, length: 1 )
• Cityworks_NMB.DBO.%INSPECTION.CREATEDBYCYCLE ( type: esriFieldTypeSmallInteger, alias: CREATEDBYCYCLE )
• Cityworks_NMB.DBO.%INSPECTION.FROMDATE ( type: esriFieldTypeDate, alias: FROMDATE, length: 8 )
• Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYAPP ( type: esriFieldTypeString, alias: INITIATEDBYAPP, length: 50 )
• Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBYSID ( type: esriFieldTypeInteger, alias: INSPECTEDBYSID )
• Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBYSID ( type: esriFieldTypeInteger, alias: CANCELLEDBYSID )
• Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYSID ( type: esriFieldTypeInteger, alias: INITIATEDBYSID )
• Cityworks_NMB.DBO.%INSPECTION.CLOSEDBYSID ( type: esriFieldTypeInteger, alias: CLOSEDBYSID )
• Cityworks_NMB.DBO.%INSPECTION.FACILITY_ID ( type: esriFieldTypeString, alias: FACILITY_ID, length: 256 )
• Cityworks_NMB.DBO.%INSPECTION.LEVEL_ID ( type: esriFieldTypeString, alias: LEVEL_ID, length: 256 )
• Cityworks_NMB.DBO.%INSPECTION.PROJECTSID ( type: esriFieldTypeDouble, alias: PROJECTSID )
• Cityworks_NMB.DBO.%INSPECTION.PROJECTPHASEID ( type: esriFieldTypeInteger, alias: PROJECTPHASEID )
• Cityworks_NMB.DBO.%INSPECTION.METADATA ( type: esriFieldTypeString, alias: METADATA, length: 1073741822 )
• Cityworks_NMB.DBO.%INSPECTION.INSPZ ( type: esriFieldTypeDouble, alias: INSPZ )
• Cityworks_NMB.DBO.%INSPECTION.ESRI_OID ( type: esriFieldTypeInteger, alias: ESRI_OID )
• sdedata.SDEDATA.WSystemValve.ModifiedDate ( type: esriFieldTypeDate, alias: ModifiedDate, length: 8 )
• sdedata.SDEDATA.WSystemValve.Owner ( type: esriFieldTypeSmallInteger, alias: Owner , Coded Values: [1: Public] , [2: Private] , [3: Unknown] )
Types:
ID: 3
Name: Gate
Domains:
• sdedata.SDEDATA.WSystemValve.Enabled:
  Inherited
• sdedata.SDEDATA.WSystemValve.LifeCycleStatus:
  Inherited
• sdedata.SDEDATA.WSystemValve.Manufacturer:
  Inherited
• sdedata.SDEDATA.WSystemValve.GroundType:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentPosition:
  Inherited
• sdedata.SDEDATA.WSystemValve.BypassValve:
  Inherited
• sdedata.SDEDATA.WSystemValve.OpenDirection:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentlyOpen:
  Inherited
• sdedata.SDEDATA.WSystemValve.Housing:
  Inherited
• sdedata.SDEDATA.WSystemValve.SizeofNut:
  Inherited

---

ID: 1
Name: Butterfly
Domains:
• sdedata.SDEDATA.WSystemValve.Enabled:
  Inherited
• sdedata.SDEDATA.WSystemValve.LifeCycleStatus:
  Inherited
• sdedata.SDEDATA.WSystemValve.Manufacturer:
  Inherited
• sdedata.SDEDATA.WSystemValve.GroundType:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentPosition:
  Inherited
• sdedata.SDEDATA.WSystemValve.BypassValve:
  Inherited
• sdedata.SDEDATA.WSystemValve.OpenDirection:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentlyOpen:
  Inherited
• sdedata.SDEDATA.WSystemValve.Housing:
  Inherited
• sdedata.SDEDATA.WSystemValve.SizeofNut:
  Inherited

---

ID: 4
Name: Check
Domains:
• sdedata.SDEDATA.WSystemValve.Enabled:
  Inherited
• sdedata.SDEDATA.WSystemValve.LifeCycleStatus:
  Inherited
• sdedata.SDEDATA.WSystemValve.Manufacturer:
  Inherited
• sdedata.SDEDATA.WSystemValve.GroundType:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentPosition:
  Inherited
• sdedata.SDEDATA.WSystemValve.BypassValve:
  Inherited
• sdedata.SDEDATA.WSystemValve.OpenDirection:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentlyOpen:
  Inherited
• sdedata.SDEDATA.WSystemValve.Housing:
  Inherited
• sdedata.SDEDATA.WSystemValve.SizeofNut:
  Inherited

---

ID: 2
Name: BO
Domains:
• sdedata.SDEDATA.WSystemValve.Enabled:
  Inherited
• sdedata.SDEDATA.WSystemValve.LifeCycleStatus:
  Inherited
• sdedata.SDEDATA.WSystemValve.Manufacturer:
  Inherited
• sdedata.SDEDATA.WSystemValve.GroundType:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentPosition:
  Inherited
• sdedata.SDEDATA.WSystemValve.BypassValve:
  Inherited
• sdedata.SDEDATA.WSystemValve.OpenDirection:
  Inherited
• sdedata.SDEDATA.WSystemValve.CurrentlyOpen:
  Inherited
• sdedata.SDEDATA.WSystemValve.Housing:
  Inherited
• sdedata.SDEDATA.WSystemValve.SizeofNut:
  Inherited

---

Tables:

Table: Cityworks_NMB.azteca.INSPECTION (1)

Name: Cityworks_NMB.azteca.INSPECTION

Display Field: INSPTEMPLATENAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• INSPECTIONID ( type: esriFieldTypeDouble, alias: INSPECTIONID )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, length: 60 )
• INSPTEMPLATEID ( type: esriFieldTypeDouble, alias: INSPTEMPLATEID )
• INSPTEMPLATENAME ( type: esriFieldTypeString, alias: INSPTEMPLATENAME, length: 30 )
• ENTITYUID ( type: esriFieldTypeString, alias: ENTITYUID, length: 50 )
• ENTITYTYPE ( type: esriFieldTypeString, alias: ENTITYTYPE, length: 50 )
• INSPDATE ( type: esriFieldTypeDate, alias: INSPDATE, length: 8 )
• INSPECTEDBY ( type: esriFieldTypeString, alias: INSPECTEDBY, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 256 )
• OBSERVATIONSUM ( type: esriFieldTypeString, alias: OBSERVATIONSUM, length: 900 )
• REPAIRSMADE ( type: esriFieldTypeString, alias: REPAIRSMADE, length: 900 )
• FOREMANRECOMND ( type: esriFieldTypeString, alias: FOREMANRECOMND, length: 900 )
• REQUESTID ( type: esriFieldTypeInteger, alias: REQUESTID )
• PRJSTARTDATE ( type: esriFieldTypeDate, alias: PRJSTARTDATE, length: 8 )
• PRJFINISHDATE ( type: esriFieldTypeDate, alias: PRJFINISHDATE, length: 8 )
• ACTFINISHDATE ( type: esriFieldTypeDate, alias: ACTFINISHDATE, length: 8 )
• DATECLOSED ( type: esriFieldTypeDate, alias: DATECLOSED, length: 8 )
• CLOSEDBY ( type: esriFieldTypeString, alias: CLOSEDBY, length: 100 )
• CLOSESR ( type: esriFieldTypeSmallInteger, alias: CLOSESR )
• CANCEL ( type: esriFieldTypeSmallInteger, alias: CANCEL )
• DATECANCELLED ( type: esriFieldTypeDate, alias: DATECANCELLED, length: 8 )
• CANCELLEDBY ( type: esriFieldTypeString, alias: CANCELLEDBY, length: 100 )
• CANCELREASON ( type: esriFieldTypeString, alias: CANCELREASON, length: 100 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 )
• INSPX ( type: esriFieldTypeDouble, alias: INSPX )
• INSPY ( type: esriFieldTypeDouble, alias: INSPY )
• DOMAINID ( type: esriFieldTypeInteger, alias: DOMAINID )
• FEATURETYPE ( type: esriFieldTypeString, alias: FEATURETYPE, length: 50 )
• FEATUREID ( type: esriFieldTypeInteger, alias: FEATUREID )
• FEATUREUID ( type: esriFieldTypeString, alias: FEATUREUID, length: 50 )
• ENTITYSID ( type: esriFieldTypeInteger, alias: ENTITYSID )
• INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, length: 100 )
• INITIATEDATE ( type: esriFieldTypeDate, alias: INITIATEDATE, length: 8 )
• SHOP ( type: esriFieldTypeString, alias: SHOP, length: 100 )
• MAPPAGE ( type: esriFieldTypeString, alias: MAPPAGE, length: 100 )
• TILENO ( type: esriFieldTypeString, alias: TILENO, length: 50 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• RESOLUTION ( type: esriFieldTypeString, alias: RESOLUTION, length: 100 )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, length: 50 )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, length: 50 )
• CONDRATING ( type: esriFieldTypeDouble, alias: CONDRATING )
• TEXT1 ( type: esriFieldTypeString, alias: TEXT1, length: 100 )
• TEXT2 ( type: esriFieldTypeString, alias: TEXT2, length: 100 )
• TEXT3 ( type: esriFieldTypeString, alias: TEXT3, length: 100 )
• TEXT4 ( type: esriFieldTypeString, alias: TEXT4, length: 100 )
• TEXT5 ( type: esriFieldTypeString, alias: TEXT5, length: 100 )
• TEXT6 ( type: esriFieldTypeString, alias: TEXT6, length: 100 )
• TEXT7 ( type: esriFieldTypeString, alias: TEXT7, length: 100 )
• TEXT8 ( type: esriFieldTypeString, alias: TEXT8, length: 100 )
• TEXT9 ( type: esriFieldTypeString, alias: TEXT9, length: 100 )
• TEXT10 ( type: esriFieldTypeString, alias: TEXT10, length: 100 )
• NUM1 ( type: esriFieldTypeDouble, alias: NUM1 )
• NUM2 ( type: esriFieldTypeDouble, alias: NUM2 )
• NUM3 ( type: esriFieldTypeDouble, alias: NUM3 )
• NUM4 ( type: esriFieldTypeDouble, alias: NUM4 )
• NUM5 ( type: esriFieldTypeDouble, alias: NUM5 )
• DATE1 ( type: esriFieldTypeDate, alias: DATE1, length: 8 )
• DATE2 ( type: esriFieldTypeDate, alias: DATE2, length: 8 )
• DATE3 ( type: esriFieldTypeDate, alias: DATE3, length: 8 )
• DATE4 ( type: esriFieldTypeDate, alias: DATE4, length: 8 )
• DATE5 ( type: esriFieldTypeDate, alias: DATE5, length: 8 )
• CONDSCORE ( type: esriFieldTypeDouble, alias: CONDSCORE )
• UPDATEMAP ( type: esriFieldTypeString, alias: UPDATEMAP, length: 1 )
• SUBMITTOEMPLOYEESID ( type: esriFieldTypeDouble, alias: SUBMITTOEMPLOYEESID )
• SUBMITTONAME ( type: esriFieldTypeString, alias: SUBMITTONAME, length: 100 )
• DATESUBMITTO ( type: esriFieldTypeDate, alias: DATESUBMITTO, length: 8 )
• EFFORT ( type: esriFieldTypeDouble, alias: EFFORT )
• PARENTINSPID ( type: esriFieldTypeInteger, alias: PARENTINSPID )
• CYCLETYPE ( type: esriFieldTypeString, alias: CYCLETYPE, length: 20 )
• CYCLEFROM ( type: esriFieldTypeString, alias: CYCLEFROM, length: 30 )
• CYCLEINTERVALNUM ( type: esriFieldTypeInteger, alias: CYCLEINTERVALNUM )
• CYCLEINTERVALUNIT ( type: esriFieldTypeString, alias: CYCLEINTERVALUNIT, length: 1 )
• CREATEDBYCYCLE ( type: esriFieldTypeSmallInteger, alias: CREATEDBYCYCLE )
• FROMDATE ( type: esriFieldTypeDate, alias: FROMDATE, length: 8 )
• INITIATEDBYAPP ( type: esriFieldTypeString, alias: INITIATEDBYAPP, length: 50 )
• INSPECTEDBYSID ( type: esriFieldTypeInteger, alias: INSPECTEDBYSID )
• CANCELLEDBYSID ( type: esriFieldTypeInteger, alias: CANCELLEDBYSID )
• INITIATEDBYSID ( type: esriFieldTypeInteger, alias: INITIATEDBYSID )
• CLOSEDBYSID ( type: esriFieldTypeInteger, alias: CLOSEDBYSID )
• FACILITY_ID ( type: esriFieldTypeString, alias: FACILITY_ID, length: 256 )
• LEVEL_ID ( type: esriFieldTypeString, alias: LEVEL_ID, length: 256 )
• PROJECTSID ( type: esriFieldTypeDouble, alias: PROJECTSID )
• PROJECTPHASEID ( type: esriFieldTypeInteger, alias: PROJECTPHASEID )
• METADATA ( type: esriFieldTypeString, alias: METADATA, length: 1073741822 )
• INSPZ ( type: esriFieldTypeDouble, alias: INSPZ )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: Cityworks_NMB.azteca.INSPQUESTION (2)

Name: Cityworks_NMB.azteca.INSPQUESTION

Display Field: QUESTION

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• INSPQUESTIONID ( type: esriFieldTypeDouble, alias: INSPQUESTIONID )
• INSPECTIONID ( type: esriFieldTypeDouble, alias: INSPECTIONID )
• QUESTIONID ( type: esriFieldTypeDouble, alias: QUESTIONID )
• QUESTIONSEQUENCE ( type: esriFieldTypeInteger, alias: QUESTIONSEQUENCE )
• QUESTION ( type: esriFieldTypeString, alias: QUESTION, length: 250 )
• ANSWER ( type: esriFieldTypeString, alias: ANSWER, length: 250 )
• INSTRUCTION ( type: esriFieldTypeString, alias: INSTRUCTION, length: 512 )
• EXPLANATION ( type: esriFieldTypeString, alias: EXPLANATION, length: 512 )
• SCORE ( type: esriFieldTypeDouble, alias: SCORE )
• WEIGHT ( type: esriFieldTypeDouble, alias: WEIGHT )
• NUMERICANSWER ( type: esriFieldTypeDouble, alias: NUMERICANSWER )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 256 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )