The National Motor Freight Traffic Association publishes a database of Standard Point Location Codes (SPLC). They say:

The SPLC is designed to provide each point originating freight and each point receiving freight in North America with a unique code number so constructed as to identify the point with its geographic location, using two digits to identify State, County and City and three digits to identify Sub-Code.

Sub-codes can be used to identify things I'm interested in, such as Plant sites, Warehouses, Docks, and Piers, as well as things I'm not so interested in such as Resorts, Parks, Race Tracks, Amusement Centers, and Zoos. (Well, I might be interested in some of those, just not while I'm at work.)

Product's described here: http://www.nmfta.org/Pages/Splc.aspx

I'm wondering if any of you in transportation and logistics have used this database, and have found there to be substantive data at the sub-code level. Essentially, I'm looking for a Point of Interest database that's highly relevant for motor freight: production facilities, distribution centers, warehouses, etc.

I'd be happy to learn of your experiences with the SPLC, or hear about any similar products or efforts to compile such data.

Thanks, Eric

asked 20 Sep '11, 15:51

eric%20theise's gravatar image

eric theise
2112
accept rate: 0%

1

Thank you both for your responses. I also heard back from someone at NMFTA, and it sounds as if the SPLC database isn't going to be very helpful in my work. Their schema is reasonable, but data is added primarily at the request of SPLC users.

The project I'm working on needs more detail than zipcodes; we're not working to offer or develop rates, but rather, to offer up likely origins/destinations to our customers as they enter shipment data. My goal is to do offer a "search near here" map interface, similar to Yelp's, but to limit the POIs to business-to-business entities that would be highly likely to be engaged in motor freight.

It would be one of several interfaces, but it would be the most fun to develop.

--Eric

(26 Sep '11, 15:41) eric theise

It's been a long time since I have used SPLCs for geocoding! When I worked at ALK Technologies in the 1990s, we providing a geocoding option that would map a SPLC to a location (point along an arc) in the highway network that we used for providing truck driving distances and times to users. Similar geocoding mapping was provided for the rail freight network. At one point in time, the US freight rail and trucking industries used them extensively to generate standard rate quotes and the like, but I'm not sure whether it is still heavily used.

I do not have enough experience with the database to have a good idea on how frequently it is updated, and whether it would be useful for your purposes. My gut feeling is that street addresses (or even more simply, zip codes) are the basis for most rates these days so it is not clear that newer facilities (plants, DCs, warehouses, etc) would certainly in all cases be included.

link

answered 21 Sep '11, 10:16

Alan%20Erera's gravatar image

Alan Erera
1.0k37
accept rate: 12%

I had used two leading truck highway routers for years until 2010 for various trucking companies. Although both routers support SPLC, I did not see any route request using SPLC.

link

answered 25 Sep '11, 09:13

Xiaodong%20Zhang's gravatar image

Xiaodong Zhang
611
accept rate: 0%

Thanks for sharing useful information on Freight forwarding in Germany database published by NMFT. The detail of what the code represent is:- 1st digit:- identifies a region, 2nd digit:-identify a State, Province or Territory, 3rd and 4th digit:-identify county, 5th and 6th digit:- identify a point as part of the area covered by the first four digits of the code and if the 7th, 8th and 9th digits are 000, the point is not defined beyond the City level. If the 7th, 8th and 9th digits digits are other than 000, the point is defined at the Sub-Code level (see Sub-Code Structure below).

link

answered 03 Apr '14, 02:41

KaylnTailor's gravatar image

KaylnTailor
112
accept rate: 0%

edited 03 Apr '14, 02:42

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×9
×5
×4

Asked: 20 Sep '11, 15:51

Seen: 4,675 times

Last updated: 03 Apr '14, 04:29

OR-Exchange! Your site for questions, answers, and announcements about operations research.