Databases
StackOverflow2013
Postsdbo
POcsv to kml file New Zealand
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcsv to kml file New Zealand
    primarykey
    data
    text
    <p>I am trying to generate a kml file from a csv file so it can be plotted in Google earth. I am using this code I found in another help section and it seems to work fine for the generation of a kml but the points that are plotted are wrong. </p> <pre><code>library("sp") library("rgdal") data(meuse) coordinates(meuse) &lt;- c("x", "y") proj4string(meuse) &lt;- CRS("+init=epsg:28992") meuse_ll &lt;- spTransform(meuse, CRS("+proj=longlat +datum=WGS84")) writeOGR(meuse_ll["zinc"], "meuse.kml", layer="zinc", driver="KML") </code></pre> <p>First fix was to get rid of the decimal places, that took me from France to NZ but the points are still out by a wide margin. Instead of being North of Auckland New Zealand they are south of the Chatham Islands. I suspect that I am dealing with a projection miss match or fudge factor issue. I have also tried copying the zip file from here: <a href="http://trac.osgeo.org/proj/" rel="nofollow">http://trac.osgeo.org/proj/</a> To use NZGD49 in the hopes that that would work but it throws up this error:</p> <pre><code>meuse_ll2 &lt;- spTransform(test, CRS("+proj=longlat +datum=NZGD49")) #Error in spTransform(test, CRS("+proj=longlat +datum=NZGD49")) : # error in evaluating the argument 'CRSobj' in selecting a method for function 'spTransform': Error in CRS("+proj=longlat +datum=NZGD49") : #unknown elliptical parameter name </code></pre> <p>So any ideas how I can work out?</p> <h1>Example data:</h1> <pre><code>Date Time Latitude1 Longitude1 27/09/2013 12:18:02 -36.67593 174.429688 27/09/2013 12:18:03 -36.675892 174.42981 </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJosh Guilbert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COAre you saying that you're having problems with the first example that you posted? As in the meuse dataset plots in NZ when you open GoogleEarth? It works fine for me. I would check that you're up to date on R ([1] rgdal_0.8-11 sp_1.0-13) and then check your GE preferences.
      singulars
      1. POcsv to kml file New Zealand
      1. USvitale232
    2. COUsing R studio, version.string R version 2.15.2 (2012-10-26), all packages upto date. I am not certain what GE Preferences are. Meuse is an inbuilt set (from Germany I think) and the code works fine, the problem is with my data. If I use it raw data straight off the GPS unit I am tracking pigeons in France instead of Auckland, New Zealand. The meuse data did not have any decimal places and was representing the lat long as one integer. So I removed them from my data set by multiplying it by 10000. After that I ended up on the correct side of the planet and hemisphere but still off by a 1400km
      singulars
      1. POcsv to kml file New Zealand
      1. USJosh Guilbert
    3. COCan you get me access to some of your data? I enjoy working with the spatial packages, so I can try to help you out. Also, the packages will play better with R 3.0.2, as they are updated very frequently (sp in particular).
      singulars
      1. POcsv to kml file New Zealand
      1. USvitale232
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload