View In:   ArcGIS Online Map Viewer

Parent Layer: Streets

Name: Intersections

Display Field: INT_TYPE

Type: Feature Layer

Geometry Type: esriGeometryMultipoint

Description: Centerline file with potential address ranges. There is a cooperative agreement among local agencies within Franklin County to maintain one road centerline file. The file contains a 7 mile buffer outside of Franklin in order to provide complete coverage to cities that extend outside of the county boundary. The Franklin County portion of the file is part of the ODOT/OGRIP statewide LBRS program and will eventually be incorporated into their system. The file is a constant work in progress and to be used for reference only. Some attribute fields are still being worked on and new data is being added or edited daily.

Service Item Id: 890c4710e5e249c39483ebb9866ae522

Copyright Text: Current editors of the file include: Columbus, Dublin, Worthington, Westerville, Gahanna, Grove City, Hilliard, Franklin County Engineer, Franklin County Auditor and MORPC

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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: 1855636.4231930673
YMin: 724417.3405107856
XMax: 1881329.6100420356
YMax: 749233.751969114
Spatial Reference: 102723  (3735)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: INT_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Signalized
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Roundabout
  Description: N/A
  Symbol:
  
• Value: 3
  Label: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
  Description: N/A
  Symbol:
  
• Value: 4
  Label: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
  Description: N/A
  Symbol:
  
• Value: 5
  Label: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
  Description: N/A
  Symbol:
  
• Value: 7
  Label: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
  Description: N/A
  Symbol:
  
• Value: 6
  Label: None
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Yield
  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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: INT_TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INT_TYPE ( type: esriFieldTypeString, alias: INT_TYPE, editable: true, nullable: true, length: 75, defaultValue: null, modelName: INT_TYPE , Coded Values: [1: Signalized] , [2: Roundabout] , [3: 4 way Stop-Controlled] , ...5 more... )
• INTERSECTION ( type: esriFieldTypeString, alias: INTERSECTION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INTERSECTION )
• Private ( type: esriFieldTypeString, alias: Private, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Private , Coded Values: [Y: Yes] , [N: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• cFacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cFacilityID )
• cLegacyID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cLegacyID )
• Address ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• Location ( type: esriFieldTypeString, alias: Location Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• cInstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cInstallDate )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• cWarranty ( type: esriFieldTypeString, alias: Warranty Information, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cWarranty )
• cWarrantyResponsible ( type: esriFieldTypeString, alias: Warranty Responsible, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cWarrantyResponsible )
• cStatus ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cStatus , Coded Values: [OOSERV: Out of Service] , [DISPOSE: Disposed/Removed] , [PLANNED: Planned/On Order] , ...3 more... )
• cAssetCost ( type: esriFieldTypeDouble, alias: Asset Cost, editable: true, nullable: true, defaultValue: null, modelName: cAssetCost )
• cCondition ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: cCondition , Coded Values: [1: Excellent] , [2: Good] , [3: Fair] , ...1 more... )
• cConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cConditionDate )
• cLifeExpectancy ( type: esriFieldTypeSmallInteger, alias: Life Expectancy in Yrs, editable: true, nullable: true, defaultValue: null, modelName: cLifeExpectancy )
• cCOF ( type: esriFieldTypeSmallInteger, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: cCOF )
• cPOF ( type: esriFieldTypeSmallInteger, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: cPOF )
• cBRE ( type: esriFieldTypeSmallInteger, alias: Business Risk Exposure, editable: true, nullable: true, defaultValue: null, modelName: cBRE )
• cHazard ( type: esriFieldTypeString, alias: Hazard?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cHazard )
• cComments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cComments )

Types:

ID: 1
Name: Signalized
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 1
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Roundabout
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 2
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 3
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 4
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 4
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 5
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 5
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: 4 way Stop-Controlled; 2 way Stop-Controlled; Single Stop Sign; 3 way Stop-Controlled
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 7
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 7
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: None
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 6
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 6
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Yield
Domains:
• INT_TYPE:
  Inherited
• Private:
  Inherited
• cStatus:
  Inherited
• cCondition:
  Inherited
Templates:
• Name: 8
  Description:
  Prototype:
  cHazard: null
  cBRE: null
  INT_TYPE: 8
  INTERSECTION: null
  Private: null
  cComments: null
  cPOF: null
  cCOF: null
  cLifeExpectancy: null
  cConditionDate: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  cInstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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