Displaying 1 result from an estimated 1 matches for "pos_to_zip".
2009 May 25
3
Interpolating variables within (RODBC library) SQL statements for MySQL
...lot of rows out of a database (in my example POSITION_to_ZIPCODE
Database with holds records for German ZIP Code <--> Gauss-Krueger
Coordinate System ) and want this to be selected and computed individually
row by row as follows:
library(RODBC)
channel <- odbcConnect("database")
pos_to_zip <- sqlQuery(channel, "select YPOS, XPOS FROM
POSITION_to_ZIPCODE;")
my_row <- pos_to_zip[1,] # get the first element (change with next
ones afterwards)
ypos <-my_row[1] # get the first y-position xpos <-my_row[2] #
get the first X-Position
So far, so good:...