4,713
edits
Dataset Errata: Difference between revisions
Jump to navigation
Jump to search
m
→comma, space, period, apostrophe in verbatimCoordinates errors
| Line 60: | Line 60: | ||
Gold Parsed NY01075760_lg.csv replaces the comma with a space, and replaces an apostrophe (') with a double quote (") in verbatimCoordinates: 38°42'20"N, 83°08'25'W is rendered as 38°42'20""N 83°08'25""W. (Note also that the double quote is replaced with two double quotes. This may be necessary to preserve the quote-delimited, comma separated fields, but could cause some problems when uploading to a database. Not presented here as an error, but we should be aware of possible implications.) <br> ('''Bryan''': Agreed. Should be fixed to match the Label except, the double quoted double quote I think is needed for CSV readers to identify fileds. I am not sure) | Gold Parsed NY01075760_lg.csv replaces the comma with a space, and replaces an apostrophe (') with a double quote (") in verbatimCoordinates: 38°42'20"N, 83°08'25'W is rendered as 38°42'20""N 83°08'25""W. (Note also that the double quote is replaced with two double quotes. This may be necessary to preserve the quote-delimited, comma separated fields, but could cause some problems when uploading to a database. Not presented here as an error, but we should be aware of possible implications.) <br> ('''Bryan''': Agreed. Should be fixed to match the Label except, the double quoted double quote I think is needed for CSV readers to identify fileds. I am not sure) | ||
<br> | |||
:::Fixed --[[User:Dpaul|Dpaul]] 21:49, 13 June 2013 (EDT) See this for how csv looks now. | |||
<nowiki>NY01075760_lg.csv:Richard C. Harris,52766,"38°42'20""N 83°08'25""W",21 May 2006,2006-05-21,,Scioto,Ohio,U.S.A.,Polycoccum minutulum Kocourková & 'F. Berger,"Shawnee State Forest, along Pond Lick Run N of Forest Road 1, 0.35 mi SW of SR 125",sandstone boulders along stream and adjacent oak woods.,on Trapeliopsis placodioides Coppins & James,ca. 190 m,,,"38°42'20""N",83°08'25'W,1075760,New York Botanical Garden,,Polycoccum minutulum Kocourková & F. Berger,,,, | |||
</nowiki> | |||
Gold Parsed NY01075764_lg.csv has a similar problem where a single space is replaced with a double space in verbatimCoordinates. <br> ('''Bryan:''' Agreed. Should be fixed to match the label as best as possible. If it is not clear follow the OCR file.) | Gold Parsed NY01075764_lg.csv has a similar problem where a single space is replaced with a double space in verbatimCoordinates. <br> ('''Bryan:''' Agreed. Should be fixed to match the label as best as possible. If it is not clear follow the OCR file.) | ||