View In:   ArcGIS Online Map Viewer

Name: PIN

Display Field: COUNTY1_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: PINs used for Cost Estimating within the Exevision Application.

Service Item Id: 4029312c87224224a8ec6887e31d3cad

Copyright Text: Iowa Department of Transportation

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: -1.0757088203645E7
YMin: 4922564.8811475
XMax: -1.003632229914E7
YMax: 5388546.46572
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [133, 0, 11, 255]
Width: 2
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: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ID ( type: esriFieldTypeDouble, alias: ID, editable: true, nullable: true, defaultValue: null, modelName: ID )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATION_DATE )
• RECORD_LAST_UPDATED ( type: esriFieldTypeDate, alias: Record Last Updated (UTC), editable: true, nullable: false, length: 8, defaultValue: null, modelName: RECORD_LAST_UPDATED )
• DISTRICT ( type: esriFieldTypeSmallInteger, alias: District, editable: true, nullable: true, defaultValue: null, modelName: DISTRICT )
• PROJECT_MANAGER ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PROJECT_MANAGER )
• SEGMENT_MANAGER ( type: esriFieldTypeString, alias: Segment Manager, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SEGMENT_MANAGER )
• MATERIALS_ENGINEER ( type: esriFieldTypeString, alias: Materials Manager, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MATERIALS_ENGINEER )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PIN )
• RURAL_URBAN ( type: esriFieldTypeString, alias: Rural Urban, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RURAL_URBAN )
• MILES ( type: esriFieldTypeString, alias: Miles, editable: true, nullable: true, length: 6, defaultValue: null, modelName: MILES )
• RAILROAD_INVOLVED ( type: esriFieldTypeString, alias: Railroad Involved, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RAILROAD_INVOLVED )
• ACCESS_CONTROL ( type: esriFieldTypeString, alias: Access Control, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACCESS_CONTROL )
• LIGHTING ( type: esriFieldTypeString, alias: Lighting, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LIGHTING )
• TRAFFIC_SIGNALS ( type: esriFieldTypeString, alias: Traffic Signals, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TRAFFIC_SIGNALS )
• TRAFFIC_SIGNS ( type: esriFieldTypeString, alias: Traffic Signs, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TRAFFIC_SIGNS )
• UTILITIES ( type: esriFieldTypeString, alias: Utilities, editable: true, nullable: true, length: 1, defaultValue: null, modelName: UTILITIES )
• UTILITY_STATUS ( type: esriFieldTypeString, alias: Utility Status, editable: true, nullable: true, length: 35, defaultValue: null, modelName: UTILITY_STATUS )
• UTILITIES_IMPACTED ( type: esriFieldTypeString, alias: Utilities Impacted, editable: true, nullable: true, length: 1, defaultValue: null, modelName: UTILITIES_IMPACTED )
• BEGIN_MILEPOST ( type: esriFieldTypeString, alias: Begin Milepost, editable: true, nullable: true, length: 6, defaultValue: null, modelName: BEGIN_MILEPOST )
• END_MILEPOST ( type: esriFieldTypeString, alias: End Milepost, editable: true, nullable: true, length: 6, defaultValue: null, modelName: END_MILEPOST )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATUS )
• CORRIDOR ( type: esriFieldTypeString, alias: Corridor, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CORRIDOR )
• HIGHWAY_CLASS ( type: esriFieldTypeString, alias: Highway Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGHWAY_CLASS )
• PARK_INSTITUTION ( type: esriFieldTypeString, alias: Park Institution, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PARK_INSTITUTION )
• COUNTY1_NO ( type: esriFieldTypeString, alias: County1 Number, editable: true, nullable: true, length: 2, defaultValue: null, modelName: COUNTY1_NO )
• COUNTY1_NAME ( type: esriFieldTypeString, alias: County1 Name, editable: true, nullable: true, length: 13, defaultValue: null, modelName: COUNTY1_NAME )
• COUNTY2_NO ( type: esriFieldTypeString, alias: County2 Number, editable: true, nullable: true, length: 2, defaultValue: null, modelName: COUNTY2_NO )
• COUNTY2_NAME ( type: esriFieldTypeString, alias: County2 Name, editable: true, nullable: true, length: 13, defaultValue: null, modelName: COUNTY2_NAME )
• COUNTY3_NO ( type: esriFieldTypeString, alias: County3 Number, editable: true, nullable: true, length: 2, defaultValue: null, modelName: COUNTY3_NO )
• COUNTY3_NAME ( type: esriFieldTypeString, alias: County3 Name, editable: true, nullable: true, length: 13, defaultValue: null, modelName: COUNTY3_NAME )
• COUNTY4_NO ( type: esriFieldTypeString, alias: County4 Number, editable: true, nullable: true, length: 2, defaultValue: null, modelName: COUNTY4_NO )
• COUNTY4_NAME ( type: esriFieldTypeString, alias: County4 Name, editable: true, nullable: true, length: 13, defaultValue: null, modelName: COUNTY4_NAME )
• ROUTE1_SYSTEM ( type: esriFieldTypeString, alias: Route1 System, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ROUTE1_SYSTEM )
• ROUTE1_NO ( type: esriFieldTypeString, alias: Route1 Number, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ROUTE1_NO )
• ROUTE2_SYSTEM ( type: esriFieldTypeString, alias: Route2 System, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE2_SYSTEM )
• ROUTE2_NO ( type: esriFieldTypeString, alias: Route2 Number, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ROUTE2_NO )
• ROUTE3_SYSTEM ( type: esriFieldTypeString, alias: Route3 System, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE3_SYSTEM )
• ROUTE3_NO ( type: esriFieldTypeString, alias: Route3 Number, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ROUTE3_NO )
• ROUTE4_SYSTEM ( type: esriFieldTypeString, alias: Route4 System, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE4_SYSTEM )
• ROUTE4_NO ( type: esriFieldTypeString, alias: Route4 Number, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ROUTE4_NO )
• SEG_SEC_MNGR_ID ( type: esriFieldTypeString, alias: Segment Section Managery ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SEG_SEC_MNGR_ID )
• SEG_SEC_MNGR_NAME ( type: esriFieldTypeString, alias: Segment Section Manager Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SEG_SEC_MNGR_NAME )
• PIN_LOCATION ( type: esriFieldTypeString, alias: PIN Location, editable: true, nullable: true, length: 121, defaultValue: null, modelName: PIN_LOCATION )
• PROJ_TYPE_ID ( type: esriFieldTypeSmallInteger, alias: Project Type ID, editable: true, nullable: true, defaultValue: null, modelName: PROJ_TYPE_ID )
• PROJ_TYPE_NAME ( type: esriFieldTypeString, alias: Project Type Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJ_TYPE_NAME )
• FUNDS1_ID ( type: esriFieldTypeSmallInteger, alias: Funds1 ID, editable: true, nullable: false, defaultValue: null, modelName: FUNDS1_ID )
• FUNDS1_ABRV ( type: esriFieldTypeString, alias: Funds1 Abreviation, editable: true, nullable: false, length: 10, defaultValue: null, modelName: FUNDS1_ABRV )
• FUNDS1_DESC ( type: esriFieldTypeString, alias: Funds1 Description, editable: true, nullable: false, length: 100, defaultValue: null, modelName: FUNDS1_DESC )
• FUNDS2_ID ( type: esriFieldTypeSmallInteger, alias: Funds2 ID, editable: true, nullable: false, defaultValue: null, modelName: FUNDS2_ID )
• FUNDS2_ABRV ( type: esriFieldTypeString, alias: Funds2 Abreviation, editable: true, nullable: false, length: 10, defaultValue: null, modelName: FUNDS2_ABRV )
• FUNDS2_DESC ( type: esriFieldTypeString, alias: Funds2 Description, editable: true, nullable: false, length: 100, defaultValue: null, modelName: FUNDS2_DESC )
• FUNDS3_ID ( type: esriFieldTypeSmallInteger, alias: Funds3 ID, editable: true, nullable: false, defaultValue: null, modelName: FUNDS3_ID )
• FUNDS3_ABRV ( type: esriFieldTypeString, alias: Funds3 Abreviation, editable: true, nullable: false, length: 10, defaultValue: null, modelName: FUNDS3_ABRV )
• FUNDS3_DESC ( type: esriFieldTypeString, alias: Funds3 Description, editable: true, nullable: false, length: 100, defaultValue: null, modelName: FUNDS3_DESC )
• PK ( type: esriFieldTypeInteger, alias: PK, editable: true, nullable: false, defaultValue: null, modelName: PK )
• REST_UPDATED ( type: esriFieldTypeDate, alias: Rest Service Last Updated (UTC), editable: false, nullable: true, length: 8, defaultValue: null, modelName: REST_UPDATED )
• UTC_OFFSET ( type: esriFieldTypeString, alias: UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UTC_OFFSET )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• Shape__Length ( type: esriFieldTypeDouble, alias: Length (Meter), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.LEN )

Templates:

• Name: PIN
  Description:
  Prototype:
  PK: 0
  UTC_OFFSET: null
  ID: null
  CREATION_DATE: null
  RECORD_LAST_UPDATED: -2209161600000
  DISTRICT: null
  PROJECT_MANAGER: null
  SEGMENT_MANAGER: null
  MATERIALS_ENGINEER: null
  PIN: null
  RURAL_URBAN: null
  MILES: null
  RAILROAD_INVOLVED: null
  ACCESS_CONTROL: null
  LIGHTING: null
  TRAFFIC_SIGNALS: null
  TRAFFIC_SIGNS: null
  UTILITIES: null
  UTILITY_STATUS: null
  UTILITIES_IMPACTED: null
  BEGIN_MILEPOST: null
  END_MILEPOST: null
  STATUS: null
  CORRIDOR: null
  HIGHWAY_CLASS: null
  PARK_INSTITUTION: null
  COUNTY1_NO: null
  COUNTY1_NAME: null
  COUNTY2_NO: null
  COUNTY2_NAME: null
  COUNTY3_NO: null
  COUNTY3_NAME: null
  COUNTY4_NO: null
  COUNTY4_NAME: null
  ROUTE1_SYSTEM: null
  ROUTE1_NO: null
  ROUTE2_SYSTEM: null
  ROUTE2_NO: null
  ROUTE3_SYSTEM: null
  ROUTE3_NO: null
  ROUTE4_SYSTEM: null
  ROUTE4_NO: null
  SEG_SEC_MNGR_ID: null
  SEG_SEC_MNGR_NAME: null
  PIN_LOCATION: null
  PROJ_TYPE_ID: null
  PROJ_TYPE_NAME: null
  FUNDS1_ID: 0
  FUNDS1_ABRV:
  FUNDS1_DESC:
  FUNDS2_ID: 0
  FUNDS2_ABRV:
  FUNDS2_DESC:
  FUNDS3_ID: 0
  FUNDS3_ABRV:
  FUNDS3_DESC:
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: REST_UPDATED
• Editor Field:

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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