http://www.earthpoint.us/forum/recent.aspx Earth Point - Recent Posts en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Wed, 08 May 2013 14:12:54 GMT Wed, 08 May 2013 14:12:54 GMT http://www.earthpoint.us/forum/topic87-which-utm-datum.aspx
WGS84 is the correct datum!]]> Wed, 08 May 2013 14:12:54 GMT http://www.earthpoint.us/forum/topic87-which-utm-datum.aspx
Thanks!]]> Sat, 04 May 2013 10:23:28 GMT http://www.earthpoint.us/forum/topic86-batch-convert-not-finishing-converting-data.aspx Fri, 03 May 2013 19:50:13 GMT http://www.earthpoint.us/forum/topic64-batch-coordinates-convert.aspx Fri, 03 May 2013 19:46:45 GMT http://www.earthpoint.us/forum/topic85-convert-eastingsnorthings-to-latlong.aspx
Bill, this is truly more than I expected. THANK YOU. Your feedback is also a great learning tool, and will help me through future problems I may have.

Again - THANK YOU VERY MUCH!]]> Wed, 17 Apr 2013 06:25:43 GMT http://www.earthpoint.us/forum/topic85-convert-eastingsnorthings-to-latlong.aspx moose sightings-TimeWhen.xls
TimeWhen is an Excel formula that copies the value of the second column in the spreadsheet, which is labeled "Date".


Earth Point Excel To KML-TimeWhen.kmz
The resulting map in Google Earth, created by the Excel To Google Earth utility.

MooseMap-TimeWhen.mp4
Video demonstration in Google Earth.]]> Wed, 17 Apr 2013 02:32:32 GMT http://www.earthpoint.us/forum/topic85-convert-eastingsnorthings-to-latlong.aspx
moose sightings-IconColorFolder.xls

Count - an Excel formula that calculates the number of animals sighted. Used to select an icon.

Icon - An Excel formula that calculates a number, whose value corresponds to an icon at the bottom of the Excel To Google Earth page. The only available icons are numbered 0 to 10. Fortunately, our data is also in this range, so we can accurately display numbered icons in Google Earth. Icons from the "Black and White" table are used, so that color can be added using the "IconColor" column, described below.

The following columns are used to calculate the "Folder" column.
CowOnly - True or False depending if only Moose cows were sighted.
CowCalf - True if only Cows with Calves were sighted.
Other - True if Bulls are in the group.
NoSighting - True if only evidence, such as tracks, were found.
Folder - "CowCalf", "CowOnly", "NoSighting", or "Other" depending on the value of the above columns.

IconColor - An Excel formula that sets "CowCalf", "CowOnly", "NoSighting", and "Other" to the colors "Lime","Yellow","Cyan", and "HotPink".

Earth Point Excel To KML-IconColorFolder.kmz
The resulting map in Google Earth, created by the Excel To Google Earth utility.
edited by Bill Clark on 4/17/2013]]> Wed, 17 Apr 2013 01:11:28 GMT http://www.earthpoint.us/forum/topic85-convert-eastingsnorthings-to-latlong.aspx
moose sightings-Label.xls
The following columns are added
Name - An Excel formula that copies in the first column of the spreadsheet, labeled "RPT"
HideNameUntilMouseOver - reduces map clutter, especially useful as here, when many points are close together.
AppendDataColumnsToDescription - an easy way to show the spreadsheet data when each icon is clicked in Google Earth.
AppendLatLonToDescription - shows the UTM to Latitude/Longitude conversion when each icon is clicked in Google Earth.

Earth Point Excel To KML-Label.kmz
The resulting map in Google Earth, created by the Excel To Google Earth utility.]]> Tue, 16 Apr 2013 23:11:48 GMT http://www.earthpoint.us/forum/topic85-convert-eastingsnorthings-to-latlong.aspx
moose sightings-Position.xls
This is the original spreadsheet with an added column, "Position". In this example, the columns "Latitude" and "Longitude" are not used. The "Position" column contains an Excel formula that creates an UTM coordinate out of the X and Y values in the spreadsheet. The UTM zone, "18T", is hard-coded into the formula.

moose sightings-Position_converted.xls
This is the resulting conversion using the Batch Convert utility. Decimal degrees was selected for the converted values.

Earth Point Excel To KML-Position.kmz
This is the resulting map on Google Earth, created by the Excel To Google Earth utility. This is a very basic map. It has the default icons, no labels, and no description pop-up balloons. However, it does demonstrate that even with "Position" only, a map can be created.]]> Tue, 16 Apr 2013 23:00:09 GMT http://www.earthpoint.us/forum/topic85-convert-eastingsnorthings-to-latlong.aspx
I'm a bit of a novice with ArcGIS so that tool has been difficult to use.

Thanks]]> Wed, 10 Apr 2013 13:22:56 GMT http://www.earthpoint.us/forum/topic84-google-earth-does-not-open.aspx Mon, 08 Apr 2013 21:28:41 GMT http://www.earthpoint.us/forum/topic83-folder-column.aspx Mon, 08 Apr 2013 17:40:09 GMT http://www.earthpoint.us/forum/topic83-folder-column.aspx Mon, 08 Apr 2013 13:52:53 GMT http://www.earthpoint.us/forum/topic82-create-polyline.aspx Fri, 29 Mar 2013 13:32:23 GMT http://www.earthpoint.us/forum/topic81-custom-degree-grids.aspx
I want to see grids at 0.5 X 0.5 degree. What zoom level is appropriate for that? How can view these grids and lock my view at 0.5 x 0.5 degree.

Regards,]]> Sat, 16 Mar 2013 08:29:21 GMT http://www.earthpoint.us/forum/topic80-unusual-error-when-converting-to-kml.aspx
Many thanks
Jon]]> Mon, 04 Mar 2013 20:28:31 GMT http://www.earthpoint.us/forum/topic80-unusual-error-when-converting-to-kml.aspx Mon, 04 Mar 2013 14:15:05 GMT http://www.earthpoint.us/forum/topic80-unusual-error-when-converting-to-kml.aspx bill.clark@earthpoint.us Thanks.]]> Mon, 04 Mar 2013 12:41:52 GMT http://www.earthpoint.us/forum/topic80-unusual-error-when-converting-to-kml.aspx
An error has been detected.
Object reference not set to an instance of an object.

I do not get the error when I remove the LineStringColor column which contains the colour code but then of course I get no lines!

Does anybody have any suggestions as to what I may be doing wrong.

I have tried using old spredsheets that [reviously worked Ok and get the same error, I have also tried with varying lengths of file i.e just a few rows upto several thousand.

Rgds,
jon]]> Mon, 04 Mar 2013 06:18:25 GMT http://www.earthpoint.us/forum/topic79-row-1-error.aspx Fri, 01 Feb 2013 20:14:41 GMT http://www.earthpoint.us/forum/topic79-row-1-error.aspx We updated the driver used to read Excel spreadsheets. They are much better than the old driver, but unfortunately, a few differences excaped our attention. We have modified the web server code to accomodate these changes.
Thank you for reporting these problems.
edited by Bill Clark on 1/31/2013]]> Thu, 31 Jan 2013 18:25:52 GMT http://www.earthpoint.us/forum/topic79-row-1-error.aspx
"Errors:
Due to coordinate errors, 1 row is not displayed.
Optional cells have errors. Default values are substituted for display on Google Earth."

for xls files which had worked just fine in the past. I get it for all my xls files. When I do the "View File on Web Page, Check for Errors" thing, I don't get any errors.

Also the last character of the sheet name is truncated in the name of folder created by
"Excel to Googe Earth".

Any ideas? thanks - Craig.]]> Wed, 30 Jan 2013 20:29:20 GMT http://www.earthpoint.us/forum/topic78-create-polygon.aspx Wed, 23 Jan 2013 00:26:58 GMT http://www.earthpoint.us/forum/topic78-create-polygon.aspx Tue, 22 Jan 2013 09:47:13 GMT http://www.earthpoint.us/forum/topic78-create-polygon.aspx Sat, 19 Jan 2013 15:15:30 GMT http://www.earthpoint.us/forum/topic77-cannot-download-converted-file.aspx I would be happy to look at the file. Could you send me a copy to my email address bill.clark@earthpoint.us

Bill Clark]]> Wed, 16 Jan 2013 21:49:51 GMT http://www.earthpoint.us/forum/topic77-cannot-download-converted-file.aspx
Below are the first few lines of the file. When I convert a smaller file, it seems to work fine.


Position,rectype,recid,qno,pernum,tripnum,coord1Or2
4601 1303961.45USft 163744.3USft,3,1,2001,1,0,2
4601 1303961.45USft 163744.3USft,3,3,2001,1,2,1
4601 1270691.68USft 225989.55USft,3,3,2001,1,2,2
4601 1270691.68USft 225989.55USft,3,4,2001,1,3,1
4601 1303961.45USft 163744.3USft,3,4,2001,1,3,2

John]]> Wed, 16 Jan 2013 16:02:29 GMT http://www.earthpoint.us/forum/topic77-cannot-download-converted-file.aspx Wed, 16 Jan 2013 14:42:56 GMT http://www.earthpoint.us/forum/topic77-cannot-download-converted-file.aspx
Position rectype recid qno pernum tripnum coord1Or2
4601 1261599.16m 236525.5m 3 26551 15552 1 6 1
4601 1261599.16m 236525.5m 3 26551 15552 1 6 2
4601 1260018.33m 249258.54m 3 26553 15552 2 1 1

The "Position" column is hopefully formatted correctly for conversion. The remaining columns are so I can keep track of what to do with the converted coordinates after the conversion. The input file is called "tripxy_conversion_input.txt".

I'm attaching a shortened version of the input file.

The conversion seems to complete successfully. Internet Explorer gives me a notification at the bottom of the window asking me if I want to view or download "tripxy_conversion_input_converted.txt". When I try to download or view this file, I get an error saying the file could not be downloaded.

Any hints? Am I doing something wrong? Is it ok to have the extra columns in my input file?

John]]> Wed, 16 Jan 2013 13:30:24 GMT http://www.earthpoint.us/forum/topic76-township-and-range-for-my-ipad.aspx Tue, 14 Aug 2012 03:36:18 GMT