State / Province Info for CSV Files
Wed, 03/25/2009 - 1:23pm
17 years
|
I've installed a software update that analyzes POI files and shows the US states and Canadian provinces that have locations in the file.
The tool is accurate to within about 5 miles. Some locations near state / province borders may be uncertain.
Right now, the tool only works with CSV files.
JM
tool
sounds good , where is the tool located
Everyday is a GREAT day :)
file pages
on every file page you will see what states are included;)
Miss POI
New File
Sounds cool
And when the file maintainer uploads an updated file, will the new software re-analyze the file for additions and deletions or will the upload process be changing?
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold
I noticed
I noticed in the MedExpress file there was additional info like: "may be near a border". Cool!
sewisdom - Drive carefully. The life you save... may be someone who owes you money!
Updates
....when the file maintainer uploads an updated file, will the new software re-analyze the file for additions and deletions?
Yes. The location count and areas are automatically updated as the new file is submitted.
JM
Re: Updates
This is great!
And automation means less fat fingers.
Metricman DriveSmart 76 Williamsburg, VA
New Upgrade
Jon like the new upgrade. One question I was looking on my Wingers poi and it said one unsable file. Does that mean one of the lines is not working or is off?
johnm405 660 & MSS&T
Blank line
It was having troubles with an extra blank line at the bottom. I removed the extra line, uploaded, and it looks happy now
We'll have to see what other sorts of issues turn up, and then I may need to make a few adjustments to the tool.
JM
near a border
I noticed in the MedExpress file there was additional info like: "may be near a border" ...
This means one or more locations were too close to a border for the tool to determine the state/province with certainty.
It's not necessarily an international border. It might just be a border between states or provinces.
JM
Blank Line
Thanks Jon. I think it will be a great asset when people look at what poi's they want to download.
johnm405 660 & MSS&T
Checked my files
When I checked my files, I found my Batteries Plus file also showed "2 unusable lines" in it. So I opened the source file on my PC and sure enough I had fat-fingered an entry and didn't know it. It even loaded on my 660 with no error - double
I corrected the error, uploaded the new replacement file and your software instantly reported those errors as no longer there. Problem solved. Way cool
It also reported 2 locations outside the US/Canada which is true. There are 2 stores in Puerto Rico.
Nice upgrade to the website, Jon! Really, really super
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold
apostrophes
It looks like the tool can also have troubles handling lines that have apostrophes / single quotes (').
If the location count seems very low, it might be that the tool got stuck on a location name like Sammy's.
Single quotes are okay if double quotes are used to enclose the column data in the CSV file.
JM
Double Quotes
I have gotten in the habit of always putting the data in columns 3 & 4 in double quotes, whether or not there are any commas (or other punctuation) in the data.
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold