CSV bulk import can be used to add new roundabouts or propose updates to existing roundabouts. The CSV format matches the export format from this database, so you can run a search, export rows, edit them, and then re-import for review.
Uploaded changes are always vetted by a human curator before they are written to the main database.
If you omit ID, the importer first checks for an existing roundabout near the submitted coordinates. If a nearby record is found (within about ±0.002 degrees latitude/longitude), your changes are attached to that record. If no nearby record is found, the row is treated as a new roundabout submission and added to the review queue. If you provide ID, that specific roundabout is used.
Submitters with contributor access can upload CSV files in the Approve Changes page. For questions, email roundabouts@kittelson.com.
Example header row:
ID,Latitude,Longitude,Intersection,City,County,State,Country,Approaches,Driveways,Type,Status,Lane Type,Functional Class,Control Type,Other Control Type,Previous Control Type,Year Completed,ICD,ICDft,Comments
For diameter, provide ICD in meters. ICD means Inscribed Circle Diameter, commonly measured as the outside curb-to-outside curb diameter of the circulatory roadway (through the roundabout center). You can optionally provide ICDft in feet instead. If both are provided and conflict, ICD (meters) takes precedence.
Approaches and Driveways are also supported in the CSV.
For Intersection, use this preferred style:
This follows existing data conventions. Example: Main St NW / 1st Ave NE.
For State, use 2-letter abbreviations for US states and Canadian provinces (USPS/Canada Post style), such as CA, TX, BC, ON. For County, prefer county-equivalent abbreviations where applicable: Co. for County and Par. for Parish.
Use Comments for context such as construction phasing/status notes, recent changes, and external references (project pages, agency documents, news links, etc.).
For lookup fields (Type, Status, Lane Type, Functional Class, Control Type, Other Control Type, Previous Control Type), you can provide either the numeric ID or the lookup Description. If you do not know a lookup value, leave it blank. For new records, unknown lookup values are assumed during review; for updates to existing records, blank lookup fields are treated as no change.
Please submit what you can. Do not worry about filling every column if you do not have the information. The only fields you should always provide are Latitude and Longitude.
| CSV Column | Data Type | Optional/Required | Description |
|---|---|---|---|
| ID | Integer | Optional | Existing roundabout ID. If blank, importer attempts coordinate-based matching, otherwise treats as a new submission. |
| Latitude | Decimal | Required | Roundabout latitude in decimal degrees (required for import matching/new placement). |
| Longitude | Decimal | Required | Roundabout longitude in decimal degrees (required for import matching/new placement). |
| Intersection | Text | Recommended | Intersection name, preferably "Major Rd / Minor Rd" with abbreviated suffixes and directionals. |
| City | Text | Optional | City or locality. |
| County | Text | Optional | County-equivalent area. Prefer abbreviated forms such as Co. (County) and Par. (Parish) where applicable. |
| State | Text | Optional | For US states and Canadian provinces, use 2-letter abbreviations (for example CA, TX, BC, ON). For other countries, use local region/state text. |
| Country | Text | Optional | Country name. |
| Approaches | Integer | Optional | Number of entering approaches. |
| Driveways | Integer | Optional | Number of driveway connections. |
| Type | Lookup (ID or Text) | Optional | Roundabout type. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Status | Lookup (ID or Text) | Optional | Roundabout status. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Lane Type | Lookup (ID or Text) | Optional | Lane configuration category. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Functional Class | Lookup (ID or Text) | Optional | Roadway functional class. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Control Type | Lookup (ID or Text) | Optional | Primary control type. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Other Control Type | Lookup (ID or Text) | Optional | Secondary/supplemental control type. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Previous Control Type | Lookup (ID or Text) | Optional | Control type before conversion to roundabout. Accepts lookup ID or description. If blank, Unknown is assumed for new records. |
| Year Completed | Integer | Optional | Year roundabout was completed. |
| ICD | Decimal (meters) | Optional | Inscribed Circle Diameter in meters. If both ICD and ICDft are provided, ICD is used. |
| ICDft | Integer (feet) | Optional | Inscribed Circle Diameter in feet (converted to meters when ICD is blank). |
| Comments | Text | Optional | Construction details, source notes, or external links/references. |
For lookup fields, you may use either the ID or the Description values listed below.
| ID | Description |
|---|---|
| 5 | Unknown |
| 1 | Roundabout |
| 6 | Signalized Roundabout/Circle |
| 2 | Rotary |
| 3 | Traffic Calming Circle |
| 4 | Other |
| ID | Description |
|---|---|
| 3 | Unknown |
| 1 | Existing |
| 2 | Removed |
| ID | Description |
|---|---|
| 4 | Unknown |
| 1 | Single-Lane |
| 2 | Multilane (2 Lane, unspecified) |
| 8 | Multilane (2 Lane, 2x1 max) |
| 9 | Multilane (2 Lane, 2x2 max) |
| 3 | Multilane (3+ Lane) |
| 5 | Single-lane w/ Traversable Central Island |
| 7 | Multilane (2+ lanes) w/ Traversable Central Island |
| 6 | Ring junction (3+ mini-roundabouts in ring) |
| ID | Description |
|---|---|
| 3 | Unknown |
| 1 | Freeway Ramps (Grade-Separated) |
| 2 | Other (At-Grade) |
| ID | Description |
|---|---|
| 7 | Unknown |
| 1 | All-Way Yield |
| 2 | All-Way Stop |
| 3 | One-Way/Two-Way Stop |
| 4 | Signal |
| 5 | Uncontrolled |
| 6 | Other |
| ID | Description |
|---|---|
| 7 | Unknown |
| 1 | None |
| 5 | Metering Signal |
| 2 | Active Pedestrian Warning (flashing yellow) |
| 8 | Rectangular Rapid Flashing Beacon (RRFB) |
| 3 | Pedestrian Hybrid Beacon (PHB, HAWK) |
| 4 | Pedestrian Signal (red-yellow-green to drivers) |
| 9 | At-grade Rail Crossing Signal/Beacon |
| 11 | At-grade Rail Crossing Signals/Gates (controlling approach only) |
| 12 | At-grade Rail Crossing Signals/Gates (controlling circulatory roadway only) |
| 10 | At-grade Rail Crossing Signals/Gates (controlling all approaches) |
| 6 | Other |
| ID | Description |
|---|---|
| 8 | Unknown |
| 1 | None (new) |
| 2 | Uncontrolled |
| 9 | One/Two-Way Yield |
| 3 | One/Two-Way Stop |
| 4 | All-Way Stop |
| 5 | Signal |
| 10 | Rotary/traffic circle |
| 6 | Grade Separated |
| 7 | Other |