Layers:

Layer: Hydrant Fire Flow Tests (0)

Name: Hydrant Fire Flow Tests

Display Field: sdedata.SDEDATA.WHydrant.FacilityID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 2674752.0001220703
YMin: 719785.0001220703
XMax: 2727591.6196899414
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:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [sdedata.SDEDATA.WHydrant.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: null

Fields:
• sdedata.SDEDATA.WHydrant.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• sdedata.SDEDATA.WHydrant.AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• sdedata.SDEDATA.WHydrant.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WHydrant.FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• sdedata.SDEDATA.WHydrant.Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• sdedata.SDEDATA.WHydrant.InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• sdedata.SDEDATA.WHydrant.LifeCycleStatus ( type: esriFieldTypeString, alias: LifeCycleStatus, length: 20 , Coded Values: [PRP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...2 more... )
• sdedata.SDEDATA.WHydrant.WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• sdedata.SDEDATA.WHydrant.InstallContractor ( type: esriFieldTypeString, alias: InstallContractor, length: 60 )
• sdedata.SDEDATA.WHydrant.Condition ( type: esriFieldTypeString, alias: Condition, length: 10 )
• sdedata.SDEDATA.WHydrant.ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• sdedata.SDEDATA.WHydrant.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 20 , Coded Values: [A: American] , [C: Clow] , [K: Kennedy] , ...9 more... )
• sdedata.SDEDATA.WHydrant.HydrantID ( type: esriFieldTypeString, alias: HydrantID, length: 255 )
• sdedata.SDEDATA.WHydrant.Valve ( type: esriFieldTypeInteger, alias: Valve , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WHydrant.Model ( type: esriFieldTypeString, alias: Model, length: 20 )
• sdedata.SDEDATA.WHydrant.MainSize ( type: esriFieldTypeDouble, alias: MainSize , Coded Values: [0: Unknown] , [-1: Other] , [0.75: 3/4"] , ...16 more... )
• sdedata.SDEDATA.WHydrant.BarrelDiameter ( type: esriFieldTypeDouble, alias: BarrelDiameter , Range: [4, 6.5] )
• sdedata.SDEDATA.WHydrant.NozzleDiameter1 ( type: esriFieldTypeDouble, alias: NozzleDiameter1 , Range: [2, 4.5] )
• sdedata.SDEDATA.WHydrant.NozzleDiameter2 ( type: esriFieldTypeDouble, alias: NozzleDiameter2 , Range: [2, 4.5] )
• sdedata.SDEDATA.WHydrant.NozzleDiameter3 ( type: esriFieldTypeDouble, alias: NozzleDiameter3 , Range: [2, 4.5] )
• sdedata.SDEDATA.WHydrant.RiserExtension ( type: esriFieldTypeDouble, alias: RiserExtension , Range: [4.5, 5.25] )
• sdedata.SDEDATA.WHydrant.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.WHydrant.ModifiedDate ( type: esriFieldTypeDate, alias: ModifiedDate, length: 8 )
• sdedata.SDEDATA.WHydrant.Owner ( type: esriFieldTypeSmallInteger, alias: Owner , Coded Values: [1: Public] , [2: Private] , [3: Unknown] )

Layer: Hydrant Maintenance (1)

Name: Hydrant Maintenance

Display Field: sdedata.SDEDATA.WHydrant.FacilityID

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: 2674752.0001220703
YMin: 719785.0001220703
XMax: 2727591.6196899414
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:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [sdedata.SDEDATA.WHydrant.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: null

Fields:
• sdedata.SDEDATA.WHydrant.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• sdedata.SDEDATA.WHydrant.AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• sdedata.SDEDATA.WHydrant.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WHydrant.FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• sdedata.SDEDATA.WHydrant.Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• sdedata.SDEDATA.WHydrant.InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• sdedata.SDEDATA.WHydrant.LifeCycleStatus ( type: esriFieldTypeString, alias: LifeCycleStatus, length: 20 , Coded Values: [PRP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...2 more... )
• sdedata.SDEDATA.WHydrant.WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• sdedata.SDEDATA.WHydrant.InstallContractor ( type: esriFieldTypeString, alias: InstallContractor, length: 60 )
• sdedata.SDEDATA.WHydrant.Condition ( type: esriFieldTypeString, alias: Condition, length: 10 )
• sdedata.SDEDATA.WHydrant.ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• sdedata.SDEDATA.WHydrant.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 20 , Coded Values: [A: American] , [C: Clow] , [K: Kennedy] , ...9 more... )
• sdedata.SDEDATA.WHydrant.HydrantID ( type: esriFieldTypeString, alias: HydrantID, length: 255 )
• sdedata.SDEDATA.WHydrant.Valve ( type: esriFieldTypeInteger, alias: Valve , Coded Values: [0: False] , [1: True] )
• sdedata.SDEDATA.WHydrant.Model ( type: esriFieldTypeString, alias: Model, length: 20 )
• sdedata.SDEDATA.WHydrant.MainSize ( type: esriFieldTypeDouble, alias: MainSize , Coded Values: [0: Unknown] , [-1: Other] , [0.75: 3/4"] , ...16 more... )
• sdedata.SDEDATA.WHydrant.BarrelDiameter ( type: esriFieldTypeDouble, alias: BarrelDiameter , Range: [4, 6.5] )
• sdedata.SDEDATA.WHydrant.NozzleDiameter1 ( type: esriFieldTypeDouble, alias: NozzleDiameter1 , Range: [2, 4.5] )
• sdedata.SDEDATA.WHydrant.NozzleDiameter2 ( type: esriFieldTypeDouble, alias: NozzleDiameter2 , Range: [2, 4.5] )
• sdedata.SDEDATA.WHydrant.NozzleDiameter3 ( type: esriFieldTypeDouble, alias: NozzleDiameter3 , Range: [2, 4.5] )
• sdedata.SDEDATA.WHydrant.RiserExtension ( type: esriFieldTypeDouble, alias: RiserExtension , Range: [4.5, 5.25] )
• sdedata.SDEDATA.WHydrant.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.WHydrant.ModifiedDate ( type: esriFieldTypeDate, alias: ModifiedDate, length: 8 )
• sdedata.SDEDATA.WHydrant.Owner ( type: esriFieldTypeSmallInteger, alias: Owner , Coded Values: [1: Public] , [2: Private] , [3: Unknown] )

Tables:

Table: Cityworks_NMB.azteca.INSPECTION (2)

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 (3)

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 )