View In:   ArcGIS Online Map Viewer

Name: Water Main Break

Display Field: GEODBID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: OBJECTID: System-generated unique identifier for each record within the feature classGEODBID: Three-digit code that assigns editing responsibility to a community in the GIS ConsortiumFEATUREID: GIS-Consortium-generated unique identifier for each record within the feature class. All FEATUREIDs start with the GEODBID of the community that owns the record.DATECREATED: Date/time stamp from the moment the GIS record was created DATEMODIFIED: Date/time stamp from the last moment the GIS record was changed SOURCE: Organization that provided the data. The GIS Consortium standard is to preface the source with the three-letter municipal code of the community providing the data, followed by a dash. Example: VGV-Public WorksSOURCETYPE: Accuracy context for the recordBREAKDATE: Date the water main break occurredDATEREPAIRED: Date the water main was repairedFAILURETYPE: The type of failure or break to the pipeAccident- When a contractor or individual impacts the water main to cause it to breakBlowout- Aka, a hole; a large portion of the main is missingJoint- A failure occurring where pipes are joined together, as in the mechanical or flange jointsShear- A crack that completely circles the circumference of a pipe; aka, 360Split- A crack that runs horizontally along the length of pipe; aka, lateralService: direct tap- A failure occurring where a service line is directly threaded into the mainService: saddle- A failure occurring at the saddle used to connect service to mainService: sleeve- A failure occurring at the sleeve used to connect service to mainService: corporation stop- A failure occurring at the corporation stop ("corp")Service: roundway- A failure occurring at the roundway (aka "Bbox")Unknown- Unable to identify the failureJULIENUMBER: Identifier for reporting and interacting with JULIELOCATIONDESCRIPTION: Description of the location of the breakCOMMENTS: For issues related to the break and reportingNEEDSRESTORATION: Boolean field indicating if site restoration is neededDATERESTORED: Date the site was restoredPIPECONDITIONNOTES: Additional notes regarding the condition or assesment of the pipeCOMPLETEDBY: The person or contrator completing the workPRODUCTIONNOTES: Technical notes from GIS personnelREPLICAFILTER: Code used to filter data for the creation of custom geodatabasesGlobalID: System-generated unique identifier for each record that is required in replicated geodatabasesSHAPE: System-generated geometry type of the featureGID_PRESSURIZEDMAIN_LINE: Unique identifier that can be joined to the GlobalID field of the StreetLight_Control_POINT feature class to provide a link between the two feature classes

Copyright Text: Created by the GIS Consortium's members with ongoing updates.

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

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: -17463800
YMin: -46132600
XMax: 1344444.0797500014
YMax: 2093402.2575000003
Spatial Reference: 102671  (3435)

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, editable: true, nullable: true, length: 3, defaultValue: 999, modelName: GEODBID , Coded Values: [001: CHP] , [002: VGC] , [003: CPR] , ...82 more... )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FEATUREID )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCE )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: SOURCETYPE , Coded Values: [ASBUILT: As-built] , [DATABASE: Database] , [ESTIMATED: Estimated] , ...12 more... )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PRODUCTIONNOTES )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, editable: true, nullable: true, length: 255, defaultValue: UNSET, modelName: REPLICAFILTER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: CREATEDBY )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: MODIFIEDBY )
• BREAKDATE ( type: esriFieldTypeDate, alias: BREAKDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BREAKDATE )
• DATEREPAIRED ( type: esriFieldTypeDate, alias: DATEREPAIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEREPAIRED )
• JULIENUMBER ( type: esriFieldTypeString, alias: JULIENUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JULIENUMBER )
• FAILURETYPE ( type: esriFieldTypeString, alias: FAILURETYPE, editable: true, nullable: true, length: 50, defaultValue: UNKNOWN, modelName: FAILURETYPE , Coded Values: [BLOWOUT: Blowout] , [JOINT: Joint] , [SERVICEDIRECTTAP: Service: Direct Tap] , ...7 more... )
• NEEDSRESTORATION ( type: esriFieldTypeSmallInteger, alias: NEEDSRESTORATION, editable: true, nullable: true, defaultValue: null, modelName: NEEDSRESTORATION , Coded Values: [0: No] , [1: Yes] )
• DATERESTORED ( type: esriFieldTypeDate, alias: DATERESTORED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATERESTORED )
• COMPLETEDBY ( type: esriFieldTypeString, alias: COMPLETEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMPLETEDBY )
• PIPECONDITIONNOTES ( type: esriFieldTypeString, alias: PIPECONDITIONNOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PIPECONDITIONNOTES )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: COMMENTS )
• GID_PRESSURIZEDMAIN_LINE ( type: esriFieldTypeGUID, alias: GID_PRESSURIZEDMAIN_LINE, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GID_PRESSURIZEDMAIN_LINE )
• SUSPECTEDCAUSE ( type: esriFieldTypeString, alias: SUSPECTEDCAUSE, editable: true, nullable: true, length: 50, defaultValue: UNKNOWN, modelName: SUSPECTEDCAUSE , Coded Values: [ACCIDENT: Accident] , [UNKNOWN: Unknown] , [TEMP: Temperature Change] , ...1 more... )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WEBLINK )
• COMMUNITYID ( type: esriFieldTypeString, alias: COMMUNITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COMMUNITYID )
• MAINDEPTHATBREAK ( type: esriFieldTypeDouble, alias: MAINDEPTHATBREAK, editable: true, nullable: true, defaultValue: null, modelName: MAINDEPTHATBREAK )
• DATETIMEWATEROFF ( type: esriFieldTypeDate, alias: DATETIMEWATEROFF, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEWATEROFF )
• DATETIMEWATERON ( type: esriFieldTypeDate, alias: DATETIMEWATERON, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEWATERON )
• REPAIRMATERIALS ( type: esriFieldTypeString, alias: REPAIRMATERIALS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPAIRMATERIALS )
• INHOUSEWORK ( type: esriFieldTypeString, alias: INHOUSEWORK, editable: true, nullable: true, length: 10, defaultValue: YES, modelName: INHOUSEWORK , Coded Values: [NO: No] , [YES: Yes] )

Templates:

• Name: Water Main Break
  Description:
  Prototype:
  JULIENUMBER: null
  REPAIRMATERIALS: null
  GID_PRESSURIZEDMAIN_LINE: null
  PRODUCTIONNOTES: null
  SOURCE: null
  GEODBID: 999
  FEATUREID: null
  DATETIMEWATERON: null
  DATETIMEWATEROFF: null
  SOURCETYPE: UNKNOWN
  REPLICAFILTER: UNSET
  INHOUSEWORK: YES
  MAINDEPTHATBREAK: null
  COMMUNITYID: null
  BREAKDATE: null
  DATEREPAIRED: null
  FAILURETYPE: UNKNOWN
  NEEDSRESTORATION: null
  DATERESTORED: null
  COMPLETEDBY: null
  PIPECONDITIONNOTES: null
  LOCATIONDESCRIPTION: null
  COMMENTS: null
  SUSPECTEDCAUSE: UNKNOWN
  WEBLINK: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• is refined by wsPressMain_LINE (1) -- Related To: Water Mains (13)
• is refined by wsPressMain_LINE (2) -- Related To: Water Mains - Private (14)
• is refined by wsPressMain_LINE (3) -- Related To: Water Main Labels (16)

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 ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATEDBY
• Edit Date Field: DATEMODIFIED
• Editor Field: MODIFIEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata