View In:   ArcGIS Online Map Viewer

Name: Sanitary Sewer Services

Display Field: SVG_STRC_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 5cef4bede14b464887ff3a3f2fba9bf6

Copyright Text: City of Grand Junction GIS

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 701302.4045572439
YMin: 4322871.596726205
XMax: 718924.1221189257
YMax: 4334525.945797492
Spatial Reference: 32612  (32612)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [221, 158, 255, 255]
Width: 1
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
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SVG_STRC_ID ( type: esriFieldTypeString, alias: Service Structure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SVG_STRC_ID )
• ADG_ADR_BDG ( type: esriFieldTypeInteger, alias: Address, editable: true, nullable: true, defaultValue: null, modelName: ADG_ADR_BDG )
• ADG_ADR_DIR ( type: esriFieldTypeString, alias: Street Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ADG_ADR_DIR , Coded Values: [W: W] , [SW: SW] , [SE: SE] , ...5 more... )
• ADG_ADR_STR ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADG_ADR_STR , Coded Values: [KOLOB CANYON: KOLOB CANYON] , [ROYAL CANYON: ROYAL CANYON] , [KINGS CANYON: KINGS CANYON] , ...2511 more... )
• ADG_ADR_TY ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ADG_ADR_TY , Coded Values: [RUN: RUN] , [LNDG: LNDG] , [VIA: VIA] , ...76 more... )
• ADG_ADR_SFX ( type: esriFieldTypeString, alias: Street Suffix, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADG_ADR_SFX , Coded Values: [VIA: VIA] , [BRG: BRG] , [SB: SB] , ...9 more... )
• ADG_ADR_APT ( type: esriFieldTypeString, alias: Apartment No, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ADG_ADR_APT )
• SVG_CON_CD ( type: esriFieldTypeInteger, alias: Connection Type, editable: true, nullable: true, defaultValue: null, modelName: SVG_CON_CD , Coded Values: [4: TAP] , [3: STUB] , [2: WYE] , ...2 more... )
• SVG_CON_NO ( type: esriFieldTypeInteger, alias: Lateral No., editable: true, nullable: true, defaultValue: 1, modelName: SVG_CON_NO )
• SVG_STYPE_CD ( type: esriFieldTypeInteger, alias: GIS SubType, editable: true, nullable: true, defaultValue: 0, modelName: SVG_STYPE_CD )
• SVG_LENGTH ( type: esriFieldTypeDouble, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: SVG_LENGTH )
• SVG_MAT_CD ( type: esriFieldTypeInteger, alias: Pipe Material, editable: true, nullable: true, defaultValue: null, modelName: SVG_MAT_CD , Coded Values: [7: CMP] , [6: CIP] , [5: DIP] , ...5 more... )
• SVG_STRC_CD ( type: esriFieldTypeInteger, alias: Structure Type, editable: true, nullable: true, defaultValue: null, modelName: SVG_STRC_CD , Coded Values: [2: OBSERVATION HOLE] , [1: CLEANOUT] )
• ADG_NETID ( type: esriFieldTypeInteger, alias: Pipe Rec #, editable: true, nullable: true, defaultValue: null, modelName: ADG_NETID )
• SVG_ADDID ( type: esriFieldTypeInteger, alias: Address Rec #, editable: true, nullable: true, defaultValue: null, modelName: SVG_ADDID )
• SVG_SERVID ( type: esriFieldTypeInteger, alias: Link into Service Ma, editable: true, nullable: true, defaultValue: null, modelName: SVG_SERVID )
• SVG_DB ( type: esriFieldTypeSmallInteger, alias: In GBA Database?, editable: true, nullable: true, defaultValue: 0, modelName: SVG_DB , Coded Values: [0: False] , [1: True] )
• SVG_DS_DIST ( type: esriFieldTypeDouble, alias: Dist from DS Struct, editable: true, nullable: true, defaultValue: null, modelName: SVG_DS_DIST )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SVG_SVST_CD ( type: esriFieldTypeInteger, alias: Service Status, editable: true, nullable: true, defaultValue: null, modelName: SVG_SVST_CD , Coded Values: [951: Out of Service] , [3: ABANDONED] , [2: INACTIVE] , ...2 more... )
• SVG_ACTIVE ( type: esriFieldTypeSmallInteger, alias: Active, editable: true, nullable: true, defaultValue: null, modelName: SVG_ACTIVE )
• SVG_CTO_CD ( type: esriFieldTypeInteger, alias: Connected To, editable: true, nullable: true, defaultValue: null, modelName: SVG_CTO_CD , Coded Values: [2: Network Structure] , [1: Sewer Pipe] )
• SVG_LOCATIO ( type: esriFieldTypeString, alias: Gen Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SVG_LOCATIO )
• SVG_SLOPE ( type: esriFieldTypeDouble, alias: Slope / Fall %, editable: true, nullable: true, defaultValue: null, modelName: SVG_SLOPE )
• SVG_INSTALL ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SVG_INSTALL )
• SVG_STAT_CD ( type: esriFieldTypeInteger, alias: Source of Data, editable: true, nullable: true, defaultValue: null, modelName: SVG_STAT_CD , Coded Values: [4: TV INSPECTIONS] , [3: RECORD DRAWINGS] , [2: FIELD INSPECTIONS] , ...2 more... )
• SVG_LINR_CD ( type: esriFieldTypeInteger, alias: Line Type, editable: true, nullable: true, defaultValue: null, modelName: SVG_LINR_CD , Coded Values: )
• SVG_MANG_CD ( type: esriFieldTypeInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: SVG_MANG_CD , Coded Values: )
• SVG_OWN_CD ( type: esriFieldTypeInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: SVG_OWN_CD , Coded Values: )
• SVG_DIA ( type: esriFieldTypeDouble, alias: Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: SVG_DIA )
• ADG_CITY_CD ( type: esriFieldTypeInteger, alias: City, editable: true, nullable: true, defaultValue: null, modelName: ADG_CITY_CD , Coded Values: [2: MESA COUNTY] , [1: GRAND JUNCTION] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, required: true, nullable: true, defaultValue: null, modelName: Shape.STLength() )

Templates:

• Name: Sanitary Sewer Services
  Description:
  Prototype:
  SVG_DIA: null
  SVG_STRC_ID: null
  ADG_ADR_BDG: null
  ADG_ADR_DIR: null
  ADG_ADR_STR: null
  ADG_ADR_TY: null
  ADG_ADR_SFX: null
  ADG_ADR_APT: null
  SVG_CON_CD: null
  SVG_CON_NO: 1
  SVG_STYPE_CD: 0
  SVG_LENGTH: null
  SVG_MAT_CD: null
  SVG_STRC_CD: null
  ADG_NETID: null
  SVG_ADDID: null
  SVG_SERVID: null
  SVG_DB: 0
  SVG_DS_DIST: null
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  ADG_CITY_CD: null
  SVG_SVST_CD: null
  SVG_ACTIVE: null
  SVG_CTO_CD: null
  SVG_LOCATIO: null
  SVG_SLOPE: null
  SVG_INSTALL: null
  SVG_STAT_CD: null
  SVG_LINR_CD: null
  SVG_MANG_CD: null
  SVG_OWN_CD: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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: true

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