Layers:

Layer: Culverts (0)

Name: Culverts

Display Field: Location

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0da5070170fe45be8da60eb1a2e98f16

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 300000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ROADNUMBER ( type: esriFieldTypeInteger, alias: Road Number )
• Milepost ( type: esriFieldTypeSingle, alias: Milepost )
• Culvert_ID ( type: esriFieldTypeString, alias: Culvert ID, length: 50 )
• Picture ( type: esriFieldTypeString, alias: Picture, length: 50 )
• FullPath ( type: esriFieldTypeString, alias: FullPath, length: 255 )
• Inspected ( type: esriFieldTypeString, alias: Inspection Status, length: 255 , Coded Values: [C: Complete] , [CL: City Limits] , [DNE: Does Not Exist] , ...3 more... )
• LastInspected ( type: esriFieldTypeDate, alias: Date Last Inspected, length: 8, precision: 1 )
• Length ( type: esriFieldTypeDouble, alias: Length (ft) )
• Diameter ( type: esriFieldTypeInteger, alias: Diameter (in) )
• Depth ( type: esriFieldTypeDouble, alias: Depth (ft) )
• New ( type: esriFieldTypeString, alias: New Culvert?, length: 256 )
• Headwall ( type: esriFieldTypeString, alias: Concrete Headwall, length: 256 )
• CulvertType ( type: esriFieldTypeString, alias: Type of Pipe, length: 256 , Coded Values: [C: Concrete] , [CMP: Corrugated Metal Pipe] , [S: Steel] , ...1 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• edited_user ( type: esriFieldTypeString, alias: edited_user, length: 255 )
• edited_date ( type: esriFieldTypeDate, alias: edited_date, length: 8 )

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

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Culvert_ID ( type: esriFieldTypeString, alias: Culvert ID, length: 1073741822 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 1073741822 )
• Operator ( type: esriFieldTypeString, alias: Inspector, length: 1073741822 )
• Condition ( type: esriFieldTypeString, alias: Condition of Pipe, length: 1073741822 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...1 more... )
• Issues ( type: esriFieldTypeString, alias: Issues, length: 1073741822 , Coded Values: [Add Extension: Add Extension] , [Buried: Buried] , [Damaged: Damaged] , ...4 more... )
• DateTime ( type: esriFieldTypeDate, alias: Date/Time, length: 8, precision: 1 )
• Bool_Burn ( type: esriFieldTypeString, alias: Needs Burned Out, length: 256 )
• Bool_ReplacePipe ( type: esriFieldTypeString, alias: Pipe Needs Replace, length: 256 )
• Bool_Clean ( type: esriFieldTypeString, alias: Clean/Flush Out Pipe, length: 256 )
• Bool_Attn ( type: esriFieldTypeString, alias: Attention needed?, length: 256 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

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

Table: PublicWorks.DBO.Culverts__ATTACH (6)

Name: PublicWorks.DBO.Culverts__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• edited_user ( type: esriFieldTypeString, alias: edited_user, length: 255 )
• edited_date ( type: esriFieldTypeDate, alias: edited_date, length: 8 )