View In:   ArcGIS Online Map Viewer

Name: NBGIS.DBO.sRegulators

Display Field: FileName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 810519.4399141371
YMin: 2680503.6851828992
XMax: 819547.914639309
YMax: 2710986.6402929723
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [65, 33, 135, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AccessDiameter ( type: esriFieldTypeInteger, alias: AccessDiameter, editable: true, nullable: true, defaultValue: 36, modelName: AccessDiameter , Range: [0, 700] )
• AccessType ( type: esriFieldTypeString, alias: AccessType, editable: true, nullable: true, length: 20, defaultValue: Cover, modelName: AccessType , Coded Values: [Door: Door] , [Grate: Grate] , [Hand: Hand] , ...4 more... )
• GroundType ( type: esriFieldTypeString, alias: GroundType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: GroundType )
• HighPipeElevation ( type: esriFieldTypeDouble, alias: HighPipeElevation, editable: true, nullable: true, defaultValue: null, modelName: HighPipeElevation )
• InteriorDrop ( type: esriFieldTypeSmallInteger, alias: InteriorDrop, editable: true, nullable: true, defaultValue: null, modelName: InteriorDrop )
• InvertElevation ( type: esriFieldTypeDouble, alias: InvertElevation, editable: true, nullable: true, defaultValue: null, modelName: InvertElevation )
• WallMaterial ( type: esriFieldTypeString, alias: WallMaterial, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WallMaterial )
• AdministrativeArea ( type: esriFieldTypeString, alias: AdministrativeArea, editable: true, nullable: true, length: 60, defaultValue: null, modelName: AdministrativeArea , Coded Values: [N: North] , [S: South] , [E: East] , ...3 more... )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription )
• OperationalArea ( type: esriFieldTypeString, alias: OperationalArea, editable: true, nullable: true, length: 60, defaultValue: null, modelName: OperationalArea , Coded Values: [D1: District 1] , [D2: District 2] , [D3: District 3] , ...3 more... )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: 0, modelName: Rotation )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Abandoned: Abandoned] , [Removed: Removed] , [Proposed: Proposed] , ...2 more... )
• Subtype ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: null, modelName: Subtype )
• WorkorderID ( type: esriFieldTypeString, alias: WorkorderID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkorderID )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• WaterType ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 255, defaultValue: Sewage, modelName: WaterType , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• AncillaryRole ( type: esriFieldTypeInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• Matched_Regulator ( type: esriFieldTypeString, alias: Matched_Regulator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Matched_Regulator )
• FileName ( type: esriFieldTypeString, alias: File Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FileName )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• StructureNumber ( type: esriFieldTypeString, alias: StructureNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StructureNumber )
• Path ( type: esriFieldTypeString, alias: Path, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Path )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Address )
• LucityLink ( type: esriFieldTypeInteger, alias: InL, editable: true, nullable: true, defaultValue: null, modelName: LucityLink )
• InLucity ( type: esriFieldTypeSmallInteger, alias: InLucity, editable: true, nullable: true, defaultValue: null, modelName: InLucity )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Street )
• Municipality ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 25, defaultValue: New Bedford, modelName: Municipality )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 50, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 50, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: NBGIS.DBO.sRegulators
  Description:
  Prototype:
  last_edited_date: null
  last_edited_user: null
  AccessDiameter: 36
  AccessType: Cover
  GroundType: null
  HighPipeElevation: null
  InteriorDrop: null
  InvertElevation: null
  WallMaterial: null
  AdministrativeArea: null
  FacilityID: null
  InstallDate: null
  LocationDescription: null
  OperationalArea: null
  Rotation: 0
  LifecycleStatus: Active
  Subtype: null
  WorkorderID: null
  Elevation: null
  WaterType: Sewage
  AncillaryRole: 0
  Enabled: 1
  Matched_Regulator: null
  FileName: null
  Hyperlink: null
  StructureNumber: null
  Path: null
  Comments: null
  Address: null
  LucityLink: null
  InLucity: null
  Street: null
  Municipality: New Bedford
  created_user: null
  created_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

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   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata