View In:   ArcGIS Online Map Viewer

Name: SignsPostsInspectionsMostRecent

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4d33fc2a2aee47a38ca396071ab2f8ea

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: -1.0761096829889204E7
YMin: 4918220.858952607
XMax: -1.0027719540707309E7
YMax: 5394343.69754051
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 77, 168, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Type ID Field:

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 )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• REL_GlobalID ( type: esriFieldTypeGUID, alias: REL_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GlobalID )
• Post ( type: esriFieldTypeInteger, alias: Post, editable: true, nullable: true, defaultValue: null, modelName: Post , Coded Values: [0: 000-Unknown] , [2: 002-Structure] , [3: 003-Truss/Cantilever] , ...21 more... )
• NumberPosts ( type: esriFieldTypeInteger, alias: NumberPosts, editable: true, nullable: true, defaultValue: null, modelName: NumberPosts )
• PostLength1 ( type: esriFieldTypeInteger, alias: PostLength1, editable: true, nullable: true, defaultValue: null, modelName: PostLength1 )
• PostLength2 ( type: esriFieldTypeInteger, alias: PostLength2, editable: true, nullable: true, defaultValue: null, modelName: PostLength2 )
• PostLength3 ( type: esriFieldTypeInteger, alias: PostLength3, editable: true, nullable: true, defaultValue: null, modelName: PostLength3 )
• DOTDistrict ( type: esriFieldTypeInteger, alias: DOTDistrict, editable: true, nullable: true, defaultValue: null, modelName: DOTDistrict , Coded Values: [1: 1-District 1 (Central)] , [2: 2-District 2 (Northeast)] , [3: 3-District 3 (Northwest)] , ...3 more... )
• SideOfRoad ( type: esriFieldTypeInteger, alias: SideOfRoad, editable: true, nullable: true, defaultValue: null, modelName: SideOfRoad , Coded Values: [0: 0-Not indicated] , [1: 1-Left] , [2: 2-Median] , ...2 more... )
• PostPrimaryUse ( type: esriFieldTypeInteger, alias: PostPrimaryUse, editable: true, nullable: true, defaultValue: null, modelName: PostPrimaryUse , Coded Values: [1: 1-Sign] , [2: 2-Signal] , [3: 3-Streetlight] , ...3 more... )
• JointUsage ( type: esriFieldTypeInteger, alias: JointUsage, editable: true, nullable: true, defaultValue: null, modelName: JointUsage , Coded Values: [0: 0-No] , [1: 1-Yes] )
• OwnedBy ( type: esriFieldTypeInteger, alias: OwnedBy, editable: true, nullable: true, defaultValue: null, modelName: OwnedBy , Coded Values: [1: 1-Iowa DOT] , [2: 2-Other public agency] , [3: 3-Private] )
• ManagedBy ( type: esriFieldTypeInteger, alias: ManagedBy, editable: true, nullable: true, defaultValue: null, modelName: ManagedBy , Coded Values: [1: 1-Iowa DOT] , [2: 2-Other public agency] , [3: 3-Private] )
• OnOrNearRampSideroadLocation ( type: esriFieldTypeInteger, alias: OnOrNearRampSideroadLocation, editable: true, nullable: true, defaultValue: null, modelName: OnOrNearRampSideroadLocation , Coded Values: [0: 0-No] , [1: 1-Yes] )
• GarageCostCenter ( type: esriFieldTypeInteger, alias: GarageCostCenter, editable: true, nullable: true, defaultValue: null, modelName: GarageCostCenter , Coded Values: [554602: 554602-Adair Garage] , [553802: 553802-Akron Garage] , [555668: 555668-Albia Garage] , ...106 more... )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• PostBaseType ( type: esriFieldTypeInteger, alias: PostBaseType, editable: true, nullable: true, defaultValue: null, modelName: PostBaseType , Coded Values: [0: 0-None] , [1: 1-Slip base] , [2: 2-Soil anchor] , ...1 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RouteID ( type: esriFieldTypeString, alias: RouteID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RouteID , Coded Values: [S001910029N: I 29 N] , [S001910029S: I 29 S] , [S001910035N: I 35 N] , ...269 more... )
• Measure ( type: esriFieldTypeDouble, alias: Measure, editable: true, nullable: true, defaultValue: null, modelName: Measure )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• SignTypical ( type: esriFieldTypeInteger, alias: SignTypical, editable: true, nullable: true, defaultValue: null, modelName: SignTypical , Coded Values: [0: 000-None] , [1: 001-TAS-801 - Primary Highway Intersections] , [2: 002-TAS-802 - Intersection of Primary and Secondary Road with Destination Signs] , ...34 more... )
• Milepost ( type: esriFieldTypeString, alias: Milepost, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Milepost )
• MilepostOffset ( type: esriFieldTypeDouble, alias: MilepostOffset, editable: true, nullable: true, defaultValue: null, modelName: MilepostOffset )
• NumberSignsOnPost ( type: esriFieldTypeInteger, alias: NumberSignsOnPost, editable: true, nullable: true, defaultValue: null, modelName: NumberSignsOnPost )
• BridgeID ( type: esriFieldTypeString, alias: BridgeID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BridgeID )
• Zone ( type: esriFieldTypeSmallInteger, alias: Zone, editable: true, nullable: true, defaultValue: null, modelName: Zone , Range: [1, 36] )
• PostRating ( type: esriFieldTypeInteger, alias: PostRating, editable: true, nullable: true, defaultValue: null, modelName: PostRating , Coded Values: [0: 0-No rating] , [1: 1-Excellent] , [2: 2-Good] , ...1 more... )
• PostStatus ( type: esriFieldTypeInteger, alias: PostStatus, editable: true, nullable: true, defaultValue: null, modelName: PostStatus , Coded Values: [0: 0-INSPECT post] , [1: 1-NEW post] , [2: 2-RETIRE post] , ...4 more... )
• PostInspectionComments ( type: esriFieldTypeString, alias: PostInspectionComments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PostInspectionComments )
• PostInspectionDate ( type: esriFieldTypeDate, alias: PostInspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PostInspectionDate )
• Reason ( type: esriFieldTypeInteger, alias: Reason, editable: true, nullable: true, defaultValue: null, modelName: Reason , Coded Values: [0: 0-Routine inspection] , [1: 1-Crash related inspection] , [2: 2-Weather related inspection] , ...1 more... )
• IncidentID ( type: esriFieldTypeString, alias: IncidentID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: IncidentID )
• RespondingOfficer ( type: esriFieldTypeString, alias: RespondingOfficer, editable: true, nullable: true, length: 24, defaultValue: null, modelName: RespondingOfficer )
• AccidentDate ( type: esriFieldTypeDate, alias: AccidentDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AccidentDate )
• Agency ( type: esriFieldTypeInteger, alias: Agency, editable: true, nullable: true, defaultValue: null, modelName: Agency , Coded Values: [1: Ackley Police Department] , [2: Ackworth Police Department] , [3: Adair Police Department] , ...1187 more... )
• SIGN ( type: esriFieldTypeInteger, alias: SIGN, editable: true, nullable: true, defaultValue: null, modelName: SIGN , Coded Values: [1102: 1/2 MILE-PANEL - W26-4 - 812 702559 - (8.5x29.5)] , [1105: 1000 FT - W27-3A - 812 702586 - (8.5x29.5)] , [687: 11CROSSING DIAGONAL LEFT DOWN ARROW - W16-7PM - 812 702061 - (18x30)] , ...993 more... )
• GlobalID_REL ( type: esriFieldTypeGUID, alias: GlobalID_REL, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID_REL )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 48, defaultValue: null, modelName: ProjectNumber )
• SignNumber ( type: esriFieldTypeString, alias: SignNumber, editable: true, nullable: true, length: 48, defaultValue: null, modelName: SignNumber )
• StockNumber ( type: esriFieldTypeString, alias: StockNumber, editable: true, nullable: true, length: 16, defaultValue: null, modelName: StockNumber )
• SignStatus ( type: esriFieldTypeInteger, alias: SignStatus, editable: true, nullable: true, defaultValue: null, modelName: SignStatus , Coded Values: [1: 01-ADD sign (field verified)] , [2: 02-RETIRE sign (remove)] , [3: 03-REPLACE sign] , ...5 more... )
• SignFacesDirection ( type: esriFieldTypeInteger, alias: SignFacesDirection, editable: true, nullable: true, defaultValue: null, modelName: SignFacesDirection , Coded Values: [1: 1-East] , [2: 2-North] , [3: 3-Northeast] , ...5 more... )
• IowaMutcdCode ( type: esriFieldTypeString, alias: IowaMutcdCode, editable: true, nullable: true, length: 16, defaultValue: null, modelName: IowaMutcdCode )
• SignColor ( type: esriFieldTypeString, alias: SignColor, editable: true, nullable: true, length: 24, defaultValue: null, modelName: SignColor )
• SignSize ( type: esriFieldTypeString, alias: SignSize, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SignSize )
• DateSignInstalled ( type: esriFieldTypeDate, alias: DateSignInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateSignInstalled )
• SignMessage ( type: esriFieldTypeString, alias: SignMessage, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SignMessage )
• SignComments ( type: esriFieldTypeString, alias: SignComments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SignComments )
• SignRemarks ( type: esriFieldTypeString, alias: SignRemarks, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SignRemarks )
• SignID_ ( type: esriFieldTypeString, alias: SignID_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignID_ )
• SignID ( type: esriFieldTypeInteger, alias: SignID, editable: true, nullable: true, defaultValue: null, modelName: SignID )
• SignWidth ( type: esriFieldTypeDouble, alias: SignWidth, editable: true, nullable: true, defaultValue: null, modelName: SignWidth )
• SignHeight ( type: esriFieldTypeDouble, alias: SignHeight, editable: true, nullable: true, defaultValue: null, modelName: SignHeight )
• SignBracingPresent ( type: esriFieldTypeInteger, alias: SignBracingPresent, editable: true, nullable: true, defaultValue: null, modelName: SignBracingPresent , Coded Values: [0: 0-No] , [1: 1-Yes] )
• SignType ( type: esriFieldTypeInteger, alias: SignType, editable: true, nullable: true, defaultValue: null, modelName: SignType , Coded Values: [1: 1-Construction] , [2: 2-Guide] , [3: 3-Regulatory] , ...3 more... )
• SignSubcategory ( type: esriFieldTypeInteger, alias: SignSubcategory, editable: true, nullable: true, defaultValue: null, modelName: SignSubcategory , Coded Values: [0: 00-No subcategory] , [1: 01-Construction Signs] , [3: 03-Regulatory Signs (general)] , ...96 more... )
• SignSheeting ( type: esriFieldTypeInteger, alias: SignSheeting, editable: true, nullable: true, defaultValue: null, modelName: SignSheeting , Coded Values: [1: 1-Diamond Grade] , [2: 2-Engineering Grade] , [3: 3-Prismatic High Intensity] )
• SignBlankMaterial ( type: esriFieldTypeInteger, alias: SignBlankMaterial, editable: true, nullable: true, defaultValue: null, modelName: SignBlankMaterial , Coded Values: [1: 1-Extruded Aluminum] , [2: 2-Metal] , [3: 3-Wood] )
• FieldVerificationStatus ( type: esriFieldTypeInteger, alias: FieldVerificationStatus, editable: true, nullable: true, defaultValue: null, modelName: FieldVerificationStatus , Coded Values: [0: 0-None] , [1: 1-Field verified] , [2: 2-Not field verified] , ...2 more... )
• NumberOfBraces ( type: esriFieldTypeInteger, alias: NumberOfBraces, editable: true, nullable: true, defaultValue: null, modelName: NumberOfBraces )
• FlagBeaconStatus ( type: esriFieldTypeInteger, alias: FlagBeaconStatus, editable: true, nullable: true, defaultValue: null, modelName: FlagBeaconStatus , Coded Values: [0: 0-No] , [1: 1-Yes] , [2: 2-Both] )
• StockNumberIndex ( type: esriFieldTypeInteger, alias: StockNumberIndex, editable: true, nullable: true, defaultValue: null, modelName: StockNumberIndex )
• SignMountingHeight ( type: esriFieldTypeInteger, alias: SignMountingHeight, editable: true, nullable: true, defaultValue: null, modelName: SignMountingHeight , Coded Values: [0: 0-NA] , [1: 1-4'] , [2: 2-5'] , ...1 more... )
• TypeAEligible ( type: esriFieldTypeInteger, alias: TypeAEligible, editable: true, nullable: true, defaultValue: null, modelName: TypeAEligible , Coded Values: [0: 0-No] , [1: 1-Yes] )
• SignInspectionTimeCollected ( type: esriFieldTypeInteger, alias: SignInspectionTimeCollected, editable: true, nullable: true, defaultValue: null, modelName: SignInspectionTimeCollected , Coded Values: [0: 0-Day] , [1: 1-Night] )
• SignInspectionRating ( type: esriFieldTypeInteger, alias: SignInspectionRating, editable: true, nullable: true, defaultValue: null, modelName: SignInspectionRating , Coded Values: [0: 0-Excellent] , [1: 1-Good] , [2: 2-Poor] )
• InspectionConditionDate ( type: esriFieldTypeDate, alias: InspectionConditionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionConditionDate )
• InspectionSignRetroreflectivit ( type: esriFieldTypeInteger, alias: InspectionSignRetroreflectivit, editable: true, nullable: true, defaultValue: null, modelName: InspectionSignRetroreflectivit )
• SignInspectionComments ( type: esriFieldTypeString, alias: SignInspectionComments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SignInspectionComments )

Templates:

• Name: SignsPostsInspectionsMostRecent
  Description:
  Prototype:
  InspectionSignRetroreflectivit: null
  InspectionConditionDate: null
  SignInspectionComments: null
  ID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  REL_GlobalID: null
  Post: null
  NumberPosts: null
  PostLength1: null
  PostLength2: null
  PostLength3: null
  DOTDistrict: null
  SideOfRoad: null
  PostPrimaryUse: null
  JointUsage: null
  OwnedBy: null
  ManagedBy: null
  OnOrNearRampSideroadLocation: null
  GarageCostCenter: null
  InstallationDate: null
  PostBaseType: null
  Comments: null
  RouteID: null
  Measure: null
  Latitude: null
  Longitude: null
  SignTypical: null
  Milepost: null
  MilepostOffset: null
  NumberSignsOnPost: null
  BridgeID: null
  Zone: null
  PostRating: null
  PostStatus: null
  PostInspectionComments: null
  PostInspectionDate: null
  Reason: null
  IncidentID: null
  RespondingOfficer: null
  AccidentDate: null
  Agency: null
  SIGN: null
  GlobalID_REL: null
  ProjectNumber: null
  SignNumber: null
  StockNumber: null
  SignStatus: null
  SignFacesDirection: null
  IowaMutcdCode: null
  SignColor: null
  SignSize: null
  DateSignInstalled: null
  SignMessage: null
  SignComments: null
  SignRemarks: null
  SignID_: null
  SignID: null
  SignWidth: null
  SignHeight: null
  SignBracingPresent: null
  SignType: null
  SignSubcategory: null
  SignSheeting: null
  SignBlankMaterial: null
  FieldVerificationStatus: null
  NumberOfBraces: null
  FlagBeaconStatus: null
  StockNumberIndex: null
  SignMountingHeight: null
  TypeAEligible: null
  SignInspectionTimeCollected: null
  SignInspectionRating: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata