Layers:

Layer: Culverts (0)

Name: Culverts

Display Field: Location

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: fe291e2d1017476bb60fb45a3043a508

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 300000.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: 1940754.306124881
YMin: 332620.7357959002
XMax: 2204353.3137027174
YMax: 518338.8318786472
Spatial Reference: 2927  (2927)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Inspected
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: C
  Label: Complete
  Description: N/A
  Symbol:
  
• Value: CL
  Label: City Limits
  Description: N/A
  Symbol:
  
• Value: DNE
  Label: Does Not Exist
  Description: N/A
  Symbol:
  
• Value: FU
  Label: Follow Up
  Description: N/A
  Symbol:
  
• Value: I
  Label: Inaccessible
  Description: N/A
  Symbol:
  
• Value: TI
  Label: To Inspect
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Inspected

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ROADNUMBER ( type: esriFieldTypeInteger, alias: Road Number, editable: true, nullable: true, defaultValue: null, modelName: ROADNUMBER )
• Milepost ( type: esriFieldTypeSingle, alias: Milepost, editable: true, nullable: true, defaultValue: null, modelName: Milepost )
• Culvert_ID ( type: esriFieldTypeString, alias: Culvert ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Culvert_ID )
• Picture ( type: esriFieldTypeString, alias: Picture, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Picture )
• FullPath ( type: esriFieldTypeString, alias: FullPath, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FullPath )
• Inspected ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspected , Coded Values: [C: Complete] , [CL: City Limits] , [DNE: Does Not Exist] , ...3 more... )
• LastInspected ( type: esriFieldTypeDate, alias: Date Last Inspected, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LastInspected )
• Length ( type: esriFieldTypeDouble, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: Length )
• Diameter ( type: esriFieldTypeInteger, alias: Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: Diameter )
• Depth ( type: esriFieldTypeDouble, alias: Depth (ft), editable: true, nullable: true, defaultValue: null, modelName: Depth )
• New ( type: esriFieldTypeString, alias: New Culvert?, editable: true, nullable: true, length: 256, defaultValue: No, modelName: New )
• Headwall ( type: esriFieldTypeString, alias: Concrete Headwall, editable: true, nullable: true, length: 256, defaultValue: No, modelName: Headwall )
• CulvertType ( type: esriFieldTypeString, alias: Type of Pipe, editable: true, nullable: true, length: 256, defaultValue: null, modelName: CulvertType , Coded Values: [C: Concrete] , [CMP: Corrugated Metal Pipe] , [S: Steel] , ...1 more... )
• 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 )
• edited_user ( type: esriFieldTypeString, alias: edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: edited_user )
• edited_date ( type: esriFieldTypeDate, alias: edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: edited_date )
Types:
ID: C
Name: Complete
Domains:
• Inspected:
  Inherited
• CulvertType:
  Inherited
Templates:
• Name: Complete
  Description:
  Prototype:
  FullPath: null
  CulvertType: null
  Headwall: No
  Location: null
  ROADNUMBER: null
  Milepost: null
  Culvert_ID: null
  Picture: null
  Inspected: C
  LastInspected: null
  Length: null
  Diameter: null
  Depth: null
  New: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: CL
Name: City Limits
Domains:
• Inspected:
  Inherited
• CulvertType:
  Inherited
Templates:
• Name: City Limits
  Description:
  Prototype:
  FullPath: null
  CulvertType: null
  Headwall: No
  Location: null
  ROADNUMBER: null
  Milepost: null
  Culvert_ID: null
  Picture: null
  Inspected: CL
  LastInspected: null
  Length: null
  Diameter: null
  Depth: null
  New: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: DNE
Name: Does Not Exist
Domains:
• Inspected:
  Inherited
• CulvertType:
  Inherited
Templates:
• Name: Does Not Exist
  Description:
  Prototype:
  FullPath: null
  CulvertType: null
  Headwall: No
  Location: null
  ROADNUMBER: null
  Milepost: null
  Culvert_ID: null
  Picture: null
  Inspected: DNE
  LastInspected: null
  Length: null
  Diameter: null
  Depth: null
  New: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: FU
Name: Follow Up
Domains:
• Inspected:
  Inherited
• CulvertType:
  Inherited
Templates:
• Name: Follow Up
  Description:
  Prototype:
  FullPath: null
  CulvertType: null
  Headwall: No
  Location: null
  ROADNUMBER: null
  Milepost: null
  Culvert_ID: null
  Picture: null
  Inspected: FU
  LastInspected: null
  Length: null
  Diameter: null
  Depth: null
  New: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: I
Name: Inaccessible
Domains:
• Inspected:
  Inherited
• CulvertType:
  Inherited
Templates:
• Name: Inaccessible
  Description:
  Prototype:
  FullPath: null
  CulvertType: null
  Headwall: No
  Location: null
  ROADNUMBER: null
  Milepost: null
  Culvert_ID: null
  Picture: null
  Inspected: I
  LastInspected: null
  Length: null
  Diameter: null
  Depth: null
  New: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: TI
Name: To Inspect
Domains:
• Inspected:
  Inherited
• CulvertType:
  Inherited
Templates:
• Name: To Inspect
  Description:
  Prototype:
  FullPath: null
  CulvertType: null
  Headwall: No
  Location: null
  ROADNUMBER: null
  Milepost: null
  Culvert_ID: null
  Picture: null
  Inspected: TI
  LastInspected: null
  Length: null
  Diameter: null
  Depth: null
  New: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• PublicWorks.DBO.Inspection_Records (0) -- Related To: Inspection Records (5)

Tables:

Table: Inspection Records (5)

Name: Inspection Records

Display Field: Comments

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Culvert_ID ( type: esriFieldTypeString, alias: Culvert ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Culvert_ID )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Comments )
• Operator ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Operator )
• Condition ( type: esriFieldTypeString, alias: Condition of Pipe, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...1 more... )
• Issues ( type: esriFieldTypeString, alias: Issues, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Issues , Coded Values: [Add Extension: Add Extension] , [Buried: Buried] , [Damaged: Damaged] , ...4 more... )
• DateTime ( type: esriFieldTypeDate, alias: Date/Time, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: DateTime )
• Bool_Burn ( type: esriFieldTypeString, alias: Needs Burned Out, editable: true, nullable: true, length: 256, defaultValue: No, modelName: Bool_Burn )
• Bool_ReplacePipe ( type: esriFieldTypeString, alias: Pipe Needs Replace, editable: true, nullable: true, length: 256, defaultValue: No, modelName: Bool_ReplacePipe )
• Bool_Clean ( type: esriFieldTypeString, alias: Clean/Flush Out Pipe, editable: true, nullable: true, length: 256, defaultValue: No, modelName: Bool_Clean )
• Bool_Attn ( type: esriFieldTypeString, alias: Attention needed?, editable: true, nullable: true, length: 256, defaultValue: No, modelName: Bool_Attn )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: Inspection Records
  Description:
  Prototype:
  Bool_Attn: No
  Culvert_ID: null
  Comments: null
  Operator: null
  Condition: null
  Issues: null
  DateTime: null
  Bool_Burn: No
  Bool_ReplacePipe: No
  Bool_Clean: No
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PublicWorks.DBO.Culverts (0) -- Related To: Culverts (0)