View In:   ArcGIS Online Map Viewer

Parent Layer: StormwaterNetwork

Name: Stormwater End Structure

Display Field: site_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer file represents all current recorded Stormwater End Structures across the Sunshine Coast Council Region. End Structures include Headwall and Endwall structures.

Service Item Id: 1d5ff8d70f8542bd8c4497096b467100

Copyright Text: Sunshine Coast Council

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9027.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 466962.31039999984
YMin: 7016026.9791
XMax: 514956.38570000045
YMax: 7076157.3497
Spatial Reference: 7856  (7856)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "End Wall"
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1128.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "Head Wall"
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1128.0
Max. Scale: 0.0

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• EWType ( type: esriFieldTypeString, alias: EWType, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: EWType , Coded Values: [Box Endwall: Box Endwall] , [Multi Cell Box Endwall: Multi Cell Box Endwall] , [Multi Cell Pipe & Box Endwall: Multi Cell Pipe & Box Endwall] , ...4 more... )
• GrateType ( type: esriFieldTypeString, alias: GrateType, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: GrateType , Coded Values: [Unknown: Unknown] , [Grated: Grated] , [Baffled: Baffled] , ...2 more... )
• TideGateType ( type: esriFieldTypeString, alias: TideGateType, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: TideGateType , Coded Values: [Fibreglass Proprietary: Fibreglass Proprietary] , [Fabricated: Fabricated] , [Controlled: Controlled] , ...3 more... )
• Culvert ( type: esriFieldTypeString, alias: Culvert, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: Culvert , Coded Values: [No: No] , [Yes: Yes] , [Not Applicable: Not Applicable] , ...1 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: Council, modelName: Owner , Coded Values: [Council: Council] , [Private: Private] , [State: State] , ...6 more... )
• MediaLink ( type: esriFieldTypeString, alias: MediaLink, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MediaLink )
• GeomMthd ( type: esriFieldTypeString, alias: GeomMthd, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeomMthd , Coded Values: [Supplied Digital XML (ADAC): Supplied Digital XML (ADAC)] , [Supplied Digital CAD (ADAC): Supplied Digital CAD (ADAC)] , [Supplied Digital CAD/ GIS (Other): Supplied Digital CAD/ GIS (Other)] , ...8 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Status1 , Coded Values: [Active: Active] , [Closed: Closed] , [Disposed: Disposed] , ...3 more... )
• central_asset_id ( type: esriFieldTypeString, alias: central_asset_id, editable: true, nullable: true, length: 20, defaultValue: null, modelName: central_asset_id )
• Below_10mAHD ( type: esriFieldTypeString, alias: Below_10mAHD, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: Below_10mAHD , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...1 more... )
• InstalledDate ( type: esriFieldTypeDate, alias: InstalledDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConstructionDate )
• PipeDescription ( type: esriFieldTypeString, alias: PipeDesc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PipeDesc )
• FeatureTypeCode ( type: esriFieldTypeString, alias: FeatureTypeCode, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FeatureTypeCode , Coded Values: [SS01: Endwall] , [SS02: Headwall] )
• SWMinorCatchment ( type: esriFieldTypeString, alias: SWMinorCatchment, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: SWMinorCatchment , Coded Values: [Bells Creek: Bells Creek] , [Elimbah Creek: Elimbah Creek] , [Eudlo Creek: Eudlo Creek] , ...18 more... )
• ApronConstruction ( type: esriFieldTypeString, alias: ApronConstruction, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: ApronConstruction , Coded Values: [Precast: Precast] , [Insitu: Insitu] , [Unknown: Unknown] , ...1 more... )
• Quantity ( type: esriFieldTypeInteger, alias: Quantity, editable: true, nullable: true, defaultValue: null, modelName: Quantity )
• EWConstruction ( type: esriFieldTypeString, alias: EWConstruction, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: EWConst , Coded Values: [Insitu: Insitu] , [Precast: Precast] , [Unknown: Unknown] )
• StructureLevel_m ( type: esriFieldTypeDouble, alias: StructureLevel_m, editable: true, nullable: true, defaultValue: null, modelName: SL )
• site_name ( type: esriFieldTypeString, alias: site_name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: site_name )
• EWMaterial ( type: esriFieldTypeString, alias: EWMaterial, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: EWMaterial , Coded Values: [Concrete: Concrete] , [Concrete Reinforced: Concrete Reinforced] , [Grouted Rock: Grouted Rock] , ...5 more... )
• ApronMaterial ( type: esriFieldTypeString, alias: ApronMaterial, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: ApronMaterial , Coded Values: [Grassed: Grassed] , [Concrete: Concrete] , [Stone Pitched: Stone Pitched] , ...8 more... )
• LWWConstruction ( type: esriFieldTypeString, alias: LWWConstruction, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: LWWConstruction , Coded Values: [Insitu: Insitu] , [Precast: Precast] , [Unknown: Unknown] , ...1 more... )
• RWWConstruction ( type: esriFieldTypeString, alias: RWWConstruction, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: RWWConstruction , Coded Values: [Insitu: Insitu] , [Precast: Precast] , [Unknown: Unknown] , ...1 more... )
• LWWMaterial ( type: esriFieldTypeString, alias: LWWMaterial, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: LWWMaterial , Coded Values: [Concrete: Concrete] , [Concrete Reinforced: Concrete Reinforced] , [Grouted Rock: Grouted Rock] , ...6 more... )
• RWWMaterial ( type: esriFieldTypeString, alias: RWWMaterial, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: RWWMaterial , Coded Values: [Concrete: Concrete] , [Concrete Reinforced: Concrete Reinforced] , [Grouted Rock: Grouted Rock] , ...6 more... )
• EWLength_m ( type: esriFieldTypeDouble, alias: EWLength_m, editable: true, nullable: true, defaultValue: null, modelName: EWLength_m )
• EWHeight_m ( type: esriFieldTypeDouble, alias: EWHeight_m, editable: true, nullable: true, defaultValue: null, modelName: EWHeight_m )
• LWW_Length_m ( type: esriFieldTypeDouble, alias: LWW_Length_m, editable: true, nullable: true, defaultValue: null, modelName: LWW_Length_m )
• LWW_Height_m ( type: esriFieldTypeDouble, alias: LWW_Height_m, editable: true, nullable: true, defaultValue: null, modelName: LWW_Height_m )
• RWW_Length_m ( type: esriFieldTypeDouble, alias: RWW_Length_m, editable: true, nullable: true, defaultValue: null, modelName: RWW_Length_m )
• RWW_Height_m ( type: esriFieldTypeDouble, alias: RWW_Height_m, editable: true, nullable: true, defaultValue: null, modelName: RWW_Height_m )
• ApronArea_m2 ( type: esriFieldTypeDouble, alias: ApronArea_m2, editable: true, nullable: true, defaultValue: null, modelName: ApronArea_m2 )
• ApronWidth_m ( type: esriFieldTypeDouble, alias: ApronWidth_m, editable: true, nullable: true, defaultValue: null, modelName: ApronWidth_m )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Location )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Stormwater End Structure (Council)
  Description:
  Prototype:
  ROWSTAMP: 0
  MXSITEID: OPS
  Location: null
  EWType: Unknown
  GrateType: Unknown
  TideGateType: Unknown
  Culvert: Unknown
  Owner: Council
  MediaLink: null
  GeomMthd: null
  Status: null
  central_asset_id: null
  Below_10mAHD: Unknown
  InstalledDate: null
  PipeDescription: null
  FeatureTypeCode: null
  SWMinorCatchment: Unknown
  ApronConstruction: Unknown
  Quantity: null
  EWConstruction: Unknown
  StructureLevel_m: null
  site_name: null
  EWMaterial: Unknown
  ApronMaterial: Unknown
  LWWConstruction: Unknown
  RWWConstruction: Unknown
  LWWMaterial: Unknown
  RWWMaterial: Unknown
  EWLength_m: null
  EWHeight_m: null
  LWW_Length_m: null
  LWW_Height_m: null
  RWW_Length_m: null
  RWW_Height_m: null
  ApronArea_m2: null
  ApronWidth_m: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata