View In:   ArcGIS Online Map Viewer

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

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: created_date
• Creator Field: created_user
• Edit Date Field: edited_date
• Editor Field: edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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