View In:   ArcGIS Online Map Viewer

Name: COLEGEODEV.DBO.SystemValve

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 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: 6211183.05126372
YMin: 2180984.7643259764
XMax: 6262345.152679473
YMax: 2204435.8696546406
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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 )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: true, defaultValue: null, modelName: assettype )
• globalid ( type: esriFieldTypeGUID, alias: Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: globalid )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: ownedby , Coded Values: [1: Our Agency] , [100: Other] , [2: Private] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Life Cycle Status, editable: true, nullable: true, defaultValue: null, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Proposed - Approved] , ...4 more... )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: null, modelName: BYPASSVALVE )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: null, modelName: CLOCKTOCLOSE )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: null, modelName: NORMALLYOPEN )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: null, modelName: OPERABLE )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: null, modelName: CURROPEN )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: ENABLED )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG )

Templates:

• Name: COLEGEODEV.DBO.SystemValve
  Description:
  Prototype:
  ENABLED: null
  ACTIVEFLAG: null
  assettype: null
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  BYPASSVALVE: null
  CLOCKTOCLOSE: null
  NORMALLYOPEN: null
  TURNSTOCLOSE: null
  OPERABLE: null
  CURROPEN: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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