All Layers and Tables (PublicWorks/sewer_cctv

Layers:

Layer: Sewer Pipe (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

RockGIS.DPWUTIL.sewer_pipes.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
RockGIS.DPWUTIL.sewer_pipes.STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [Under construction: Under construction] , [Abandoned: Abandoned] , [Removed: Removed] , ...3 more... )
RockGIS.DPWUTIL.sewer_pipes.ID ( type: esriFieldTypeString, alias: ID, length: 20 )
RockGIS.DPWUTIL.sewer_pipes.PIPE_FLOW_TYPE ( type: esriFieldTypeString, alias: PIPE_FLOW_TYPE, length: 50 , Coded Values: [Gravity: Gravity] , [Force main: Force main] )
RockGIS.DPWUTIL.sewer_pipes.PIPE_SHAPE ( type: esriFieldTypeString, alias: PIPE_SHAPE, length: 100 , Coded Values: [A: Arched (with flat bottom)] , [B: Barrel (e.g. beer barrel shape)] , [C: Circular] , ...8 more... )
RockGIS.DPWUTIL.sewer_pipes.DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER , Coded Values: [1: 1"] , [2: 2"] , [3: 3"] , ...17 more... )
RockGIS.DPWUTIL.sewer_pipes.MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 25 , Coded Values: [AC: asbestos cement] , [BR: brick] , [CAS: cast iron] , ...26 more... )
RockGIS.DPWUTIL.sewer_pipes.UPSTREAM_ID ( type: esriFieldTypeString, alias: UPSTREAM_ID, length: 20 )
RockGIS.DPWUTIL.sewer_pipes.DOWNSTREAM_ID ( type: esriFieldTypeString, alias: DOWNSTREAM_ID, length: 20 )
RockGIS.DPWUTIL.sewer_pipes.NOTES ( type: esriFieldTypeString, alias: NOTES, length: 50 )
RockGIS.DPWUTIL.sewer_pipes.GREASE_HOT_SPOT ( type: esriFieldTypeString, alias: GREASE_HOT_SPOT, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
RockGIS.DPWUTIL.sewer_pipes.CITY ( type: esriFieldTypeString, alias: CITY, length: 50 )
RockGIS.DPWUTIL.sewer_pipes.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
RockGIS.DPWUTIL.sewer_pipes.Shape ( type: esriFieldTypeGeometry, alias: Shape )
RockGIS.DPWUTIL.sewer_pipes.GEN_EDITS_QC_USERNAME ( type: esriFieldTypeString, alias: GEN_EDITS_QC_USERNAME, length: 50 , Coded Values: [GK: GKosarek] , [JW: JWoods] , [JH: JHollida] , ...19 more... )
RockGIS.DPWUTIL.sewer_pipes.GEN_EDITS_QC_DATE ( type: esriFieldTypeDate, alias: GEN_EDITS_QC_DATE, length: 8 )
RockGIS.DPWUTIL.sewer_pipes.COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
RockGIS.DPWUTIL.sewer_pipes.DESIGN_GROUP ( type: esriFieldTypeString, alias: DESIGN_GROUP, length: 50 )
RockGIS.DPWUTIL.sewer_pipes.DESIGN_YEAR ( type: esriFieldTypeSmallInteger, alias: DESIGN_YEAR )
RockGIS.DPWUTIL.sewer_pipes.UPSTREAM_INVERT_ELEVATION ( type: esriFieldTypeDouble, alias: Upstream Invert Elevation )
RockGIS.DPWUTIL.sewer_pipes.UPSTREAM_INVERT_ELEV_SOURCE ( type: esriFieldTypeString, alias: Upstream Invert Elevation Value Source, length: 255 )
RockGIS.DPWUTIL.sewer_pipes.DOWNSTREAM_INVERT_ELEVATION ( type: esriFieldTypeDouble, alias: Downstream Invert Elevation )
RockGIS.DPWUTIL.sewer_pipes.DOWNSTREAM_INVERT_ELEV_SOURCE ( type: esriFieldTypeString, alias: Downstream Invert Elevation Value Source, length: 255 )
RockGIS.DPWUTIL.sewer_pipes.SLOPE ( type: esriFieldTypeDouble, alias: Slope )
RockGIS.DPWUTIL.sewer_pipes.PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, length: 1 , Coded Values: [Y: Yes] , [N: No] )
RockGIS.DPWUTIL.sewer_pipes.ID_NUM ( type: esriFieldTypeInteger, alias: ID_NUM )
RockGIS.DPWUTIL.sewer_pipes.created_user ( type: esriFieldTypeString, alias: Created User, length: 50 )
RockGIS.DPWUTIL.sewer_pipes.created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
RockGIS.DPWUTIL.sewer_pipes.last_edited_user ( type: esriFieldTypeString, alias: Last Edited User, length: 50 )
RockGIS.DPWUTIL.sewer_pipes.last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
RockGIS.DPWUTIL.sewer_pipes.AGE ( type: esriFieldTypeSmallInteger, alias: AGE )
RockGIS.DPWUTIL.sewer_pipes.GRADE ( type: esriFieldTypeSmallInteger, alias: GRADE )
RockGIS.DPWUTIL.sewer_pipes.TYPE ( type: esriFieldTypeString, alias: TYPE, length: 10 , Coded Values: [CLAY: Clay] , [CONCRETE: Concrete] , [METAL: Metal] , ...3 more... )
RockGIS.DPWUTIL.sewer_pipes.LAST_LINED_DATE ( type: esriFieldTypeDate, alias: LAST_LINED_DATE, length: 8 )
RockGIS.DPWUTIL.sewer_pipes.LAST_ROOT_CONTROL_DATE ( type: esriFieldTypeDate, alias: LAST_ROOT_CONTROL_DATE, length: 8 )
RockGIS.DPWUTIL.sewer_pipes.LAST_CCTV_DATE ( type: esriFieldTypeDate, alias: LAST_CCTV_DATE, length: 8 )
RockGIS.DPWUTIL.sewer_pipes.ASSET_LOCATION ( type: esriFieldTypeString, alias: ASSET_LOCATION, length: 100 )
RockGIS.DPWUTIL.sewer_pipes.ORANGEBURG ( type: esriFieldTypeString, alias: ORANGEBURG, length: 1 )
RockGIS.DPWUTIL.sewer_pipes.PIPE_LENGTH ( type: esriFieldTypeSmallInteger, alias: PIPE LENGTH )
RockGIS.DPWUTIL.sewer_pipes.DATA_RELIABILITY_LEVEL ( type: esriFieldTypeSmallInteger, alias: DATA_RELIABILITY_LEVEL , Coded Values: [1: Undetermined - Appears inaccurate, requires additional research] , [2: Low - Existing GIS information passing basic logic checks] , [3: High - Size, Shape & Material Fields populated by Design Sheet Review] , ...3 more... )
RockGIS.DPWUTIL.sewer_pipes.LOCATION_RELIABILITY_LEVEL ( type: esriFieldTypeSmallInteger, alias: LOCATION_RELIABILITY_LEVEL , Coded Values: [0: Unreviewed] , [1: Undetermined - Appears inaccurate & requires additional research] , [2: Low - Approximate location based on existing GIS data, structures not visible in aerial data and/or poorly georeferenced digitization] , ...3 more... )
RockGIS.DPWUTIL.sewer_pipes.OWNERSHIP_RELIABILITY_LEVEL ( type: esriFieldTypeSmallInteger, alias: OWNERSHIP_RELIABILITY_LEVEL , Coded Values: [0: Unreviewed] , [1: Undetermined] , [2: Low - Outside City ROW but conveying run-off from City ROW with no public easements OR located on private property OR located near a boundary where ownership is not clear] , ...2 more... )
RockGIS.DPWUTIL.sewer_pipes.FORCE_DIAMETER ( type: esriFieldTypeString, alias: FORCE PIPE DIAMETER, length: 5 , Coded Values: [1: 1 inch] , [1.5: 1 1/2 inch] , [2: 2 inch] , ...2 more... )
RockGIS.DPWUTIL.sewer_pipes.ASSET_ID ( type: esriFieldTypeString, alias: ASSET ID, length: 64 )
RockGIS.DPWUTIL.sewer_pipes.ownedby ( type: esriFieldTypeString, alias: ownedby, length: 255 , Coded Values: [Private: Private] , [Public City: Public - City] , [Public nonCity: Public - Non-City] )
RockGIS.DPWUTIL.sewer_pipes.maintainedby ( type: esriFieldTypeString, alias: maintainedby, length: 255 , Coded Values: [COR DPW: City of Rockville - DPW] , [COR Parks: City of Rockville - Parks] , [WSSC: WSSC] , ...4 more... )
RockGIS.DPWUTIL.sewer_pipes.GlobalID ( type: esriFieldTypeGlobalID, alias: RockGIS.DPWUTIL.sewer_pipes.GlobalID, length: 38 )
RockGIS.DPWUTIL.sewer_pipes.PipeFunction ( type: esriFieldTypeString, alias: OM Function, length: 50 , Coded Values: [Trunk: Trunk] , [Force Main: Force Main] , [Sewer Collector: Sewer Collector] , ...1 more... )
Shape.len ( type: esriFieldTypeDouble, alias: Shape.len )
POSM.dbo.POSM_SessionAll.SpecialFieldID ( type: esriFieldTypeInteger, alias: SpecialFieldID )
POSM.dbo.POSM_SessionAll.SessionID ( type: esriFieldTypeInteger, alias: Session ID )
POSM.dbo.POSM_SessionAll.Insp_Date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
POSM.dbo.POSM_SessionAll.ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 100 )
POSM.dbo.POSM_SessionAll.UseOfSewer ( type: esriFieldTypeString, alias: Use Of Sewer, length: 100 )
POSM.dbo.POSM_SessionAll.FlowDirection ( type: esriFieldTypeString, alias: Flow Direction, length: 100 )
POSM.dbo.POSM_SessionAll.AssetID ( type: esriFieldTypeString, alias: GIS Asset ID, length: 100 )
POSM.dbo.POSM_SessionAll.AssetSize ( type: esriFieldTypeString, alias: Asset Size, length: 100 )
POSM.dbo.POSM_SessionAll.AssetType ( type: esriFieldTypeString, alias: Asset Type, length: 100 )
POSM.dbo.POSM_SessionAll.AssetLocation ( type: esriFieldTypeString, alias: Asset Location, length: 100 )
POSM.dbo.POSM_SessionAll.AssetLength ( type: esriFieldTypeString, alias: Asset Length, length: 100 )
POSM.dbo.POSM_SessionAll.LengthSurveryed ( type: esriFieldTypeSingle, alias: Length Surveyed )
POSM.dbo.POSM_SessionAll.Struct_Rating ( type: esriFieldTypeString, alias: Structure Rating, length: 1 )
POSM.dbo.POSM_SessionAll.PacpQuickStructRating ( type: esriFieldTypeString, alias: PACP Quick Structutre Rating, length: 4 )
POSM.dbo.POSM_SessionAll.PacpQuickStructRatingNum ( type: esriFieldTypeInteger, alias: PACP Quick Structure Rating Number )
POSM.dbo.POSM_SessionAll.Maint_Rating ( type: esriFieldTypeString, alias: Maintenance Rating, length: 1 )
POSM.dbo.POSM_SessionAll.PacpQuickMaintRating ( type: esriFieldTypeString, alias: PACP Quick Maintenance Rating, length: 4 )
POSM.dbo.POSM_SessionAll.PacpQuickMaintRatingNum ( type: esriFieldTypeInteger, alias: PACP Quick Maintenance Rating Number )
POSM.dbo.POSM_SessionAll.WebPathtoReportIndex ( type: esriFieldTypeString, alias: POSM Report, length: 255 )
POSM.dbo.POSM_SessionAll.Num_Taps ( type: esriFieldTypeInteger, alias: Number of Taps )
POSM.dbo.POSM_SessionAll.Num_Roots ( type: esriFieldTypeInteger, alias: Number of Roots )
POSM.dbo.POSM_SessionAll.Num_CR_FR ( type: esriFieldTypeInteger, alias: Num_CR_FR )
POSM.dbo.POSM_SessionAll.Num_Broken_Holes ( type: esriFieldTypeInteger, alias: Number of Broken / Holes )
POSM.dbo.POSM_SessionAll.Num_Deposits ( type: esriFieldTypeInteger, alias: Number of Deposits )
POSM.dbo.POSM_SessionAll.Num_Obstruction ( type: esriFieldTypeInteger, alias: Number of Obstructions )
POSM.dbo.POSM_SessionAll.NumAbdSurv ( type: esriFieldTypeInteger, alias: NumAbdSurv )
POSM.dbo.POSM_SessionAll.IsLatestInspection ( type: esriFieldTypeSmallInteger, alias: Is this the Latest Inspection )
POSM.dbo.POSM_SessionAll.InspectionCount ( type: esriFieldTypeInteger, alias: Inspection Count )

Tables:

Table: POSM All Sessions (1)