new & interesting places for your GPS

Quotes in 3rd Field of State Rest Areas

 

I was looking at the Rest Area 'csv' files by State and noticed that some of the files have the text after the 2nd comma (longitude, latitude,) enclosed in quotes. Others, for example CT & VT, do not have this 3rd field (POI Name) in quotes. Which is correct and what effect, if any, will either method have?

Thanks

Re: Quotes

Putting quotes in allows the parsing software to ignore any commas used. Such as in an address. Some software will interpret that enclosed comma as an end of line and start the next line.

--
Metricman Nuvi 660, GTM-20 Traffic Receiver Nuvi 3597 GTM-60 Traffic Receiver Williamsburg, VA

Usually to include commas, end of lines

That depends on what you're using to read them. I'm not totally sure about POI Loader because I haven't experimented, but normally commas indicate to the software that everything between comma's is one field and everything up to a carriage return is one record. Usually if you want an actual comma or carriage return included in the field then you enclose it in quotes.

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.

It's part of the CSV format

The CSV format, which is actually a text file using commas to mark different sections of the record requires quotation marks for a single section that contains special characters. Sometimes they are needed, sometimes not. It depends on what is supposed to be in that part of the record.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

Uniformity

Since the answer to the OPS question is "sometimes" as others have already explained, I have just gotten in the habit of putting quotes around both the 3rd and 4th fields just for uniformity and consistancy within my own POI files.

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2015.30 CN NA NT maps | Magellan Meridian Gold

sponsored links



Navigation



User login

Leave this blank! This field helps block spambots.

poi factory



Who's online

There are currently 14 users and 63 guests online.

Online users

  • Michael1368
  • Wen-Hann Shiau
  • wmcke
  • daveooo
  • jackj180
  • blake7mstr
  • sleggio
  • dobs108
  • zadmi
  • phranc