Name: Asset

Display Field: collname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -12825646.0367
YMin: 6300850.28450001
XMax: -12700211.658
YMax: 6633095.6268
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[170,75,94,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• trailid (type: esriFieldTypeString, alias: Trail ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• assettype (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: Bench], [2: Boardwalk], [3: Bridge], ... 7 more ...)
• otherasset (type: esriFieldTypeString, alias: Other Asset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ttf (type: esriFieldTypeString, alias: TTF, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: A-Frame], [2: Berm], [3: Bridge], ... 13 more ...)
• otherttf (type: esriFieldTypeString, alias: Other Feature, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ttfdifficulty (type: esriFieldTypeString, alias: Difficulty, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Green], [2: Blue], [3: Black], ... 1 more ...)
• mandatory (type: esriFieldTypeString, alias: Mandatory Feature , SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• meetstds (type: esriFieldTypeString, alias: Conform to Whistler Stds?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• signtype1 (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: Closure], [2: Direction Arrow], [3: Distance Marker], ... 8 more ...)
• signtype2 (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: Closure], [2: Direction], [3: Distance Marker], ... 10 more ...)
• signtype3 (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: Closure], [2: Direction], [3: Distance Marker], ... 10 more ...)
• othersign (type: esriFieldTypeString, alias: Other Sign, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• signpost (type: esriFieldTypeString, alias: Sign Post Material, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Carsonite], [2: Cedar 4" x 4"], [3: Cedar 6" x 6"], ... 5 more ...)
• assetcond (type: esriFieldTypeString, alias: Asset Condition, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Good], [2: Fair], [3: Needs Repair], ... 1 more ...)
• comments (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• length (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• width (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lat (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• long (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latlong (type: esriFieldTypeString, alias: Lat/Long, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• collname (type: esriFieldTypeString, alias: Collector's Name, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Ben Martin], [2: Peter Eaton], [3: Wade Hawkins], ... 4 more ...)
• collrole (type: esriFieldTypeString, alias: Collector's Role, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Administrator], [2: Trail Manager], [3: Trail Crew], ... 1 more ...)
• gnss (type: esriFieldTypeString, alias: GNSS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: External Antenna], [2: Integrated Antenna])
• globalorig (type: esriFieldTypeGUID, alias: Original GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• creationdate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• editdate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• esrignss_positionsourcetype (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
• esrignss_direction (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_speed (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrisnsr_azimuth (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_h_rms (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_v_rms (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_positions (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_h_stddev (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• countstatus (type: esriFieldTypeString, alias: Trail Counter Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Active], [2: Not Active], [3: Uncertain])
• countlocat (type: esriFieldTypeString, alias: Trail Counter Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• countname (type: esriFieldTypeString, alias: Trail Counter Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• countserial (type: esriFieldTypeString, alias: Trail Counter Serial #, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• countinstall (type: esriFieldTypeString, alias: Trail Counter Installed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• countsced (type: esriFieldTypeString, alias: Trai Counter Schedule, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Permanent], [2: Seasonal], [3: Ad-hoc])
• countfrom (type: esriFieldTypeDate, alias: Trail Counter From Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• countto (type: esriFieldTypeDate, alias: Trail Counter To Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• countlastchk (type: esriFieldTypeDate, alias: Trail Counter Last Checked, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspected (type: esriFieldTypeDate, alias: Most Recent Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• culvertdia (type: esriFieldTypeInteger, alias: Culvert Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4"], [6: 6"], [8: 8'], ... 3 more ...)

Templates:

Name: Asset
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• (0) -- Related To: Asset_Inspections (7)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/2/2024 8:04:16 PM

Schema Last Edit Date: 4/2/2024 8:04:16 PM

Data Last Edit Date: 4/2/2024 8:04:14 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat