View In:   ArcGIS Online Map Viewer

Name: SignsInspectionMostRecent

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 84be5c2f401d4c108f0f2f0b516d4d62

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 48593.78379999846
YMin: 45103.46849999949
XMax: 581313.4534000009
YMax: 392956.92440000176
Spatial Reference: PROJCS["LRS_Lambert_Iowa_DOT",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["Geodetic_Reference_System_of_1980",6378137.0,298.2572221008916]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["false_easting",304800.0],PARAMETER["false_northing",0.0],PARAMETER["central_meridian",-93.5],PARAMETER["standard_parallel_1",40.375],PARAMETER["standard_parallel_2",43.625],PARAMETER["latitude_of_origin",40.0],UNIT["Meter",1.0]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 74, 71, 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

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 )
• 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... )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: ID )
• 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 )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 254, 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: 254, 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 )
• 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... )
• 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] )
• 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] )
• 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 )
• StockNumberIndex ( type: esriFieldTypeInteger, alias: StockNumberIndex, editable: true, nullable: true, defaultValue: null, modelName: StockNumberIndex )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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: InspectionSignRetroreflectivity, 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: SignsInspectionMostRecent
  Description:
  Prototype:
  InspectionSignRetroreflectivit: null
  InspectionConditionDate: null
  SIGN: null
  ID: 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
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  SignWidth: null
  SignHeight: null
  SignBracingPresent: null
  SignType: null
  SignSubcategory: null
  OwnedBy: null
  ManagedBy: null
  SignSheeting: null
  SignBlankMaterial: null
  FieldVerificationStatus: null
  NumberOfBraces: null
  FlagBeaconStatus: null
  RouteID: null
  Measure: null
  StockNumberIndex: null
  SignInspectionComments: 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

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata