similar to: AR, find(:all), loops and memory usage

Adding a column to a table just places the column at the end, but I like to keep related columns together. Is there a way to specify where the column is added in a table with migrations? For example, in MySQL you can do: ALTER TABLE my_table ADD COLUMN new_column INT AFTER other_column I was hoping migrations would support something like this: add_column :my_table, :new_column, :integer,

I''m currently planning a social app in Rails that relies on being able to see how far you are from everyone else. It''s my intention to store rough geo-coordinates as part of the sign up process. My intention is to capture their zipcode or postal code, and then be able to query a webservice once for that data. It''s also possible that there might be a database or even

Does anyone know how to geocode addresses using the YM4R Google Map plug-in? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe

Hey, Does anybody know of a good Geocode library for Ruby, similar to Perl''s Geocode::Postal, that i could use in my rail app? I need to do some "within 5 miles" calculations of zipcodes and i dont have a nice ruby (or gem) utility to do it. any help would be appreciated. thanks adam _______________________________________________ Rails mailing list

Hi all, I''m building a ror app and have a model with geo-coordinates would like to use the info in the model to generate a google map view, does anyone know what''s the best way to go round this? is is Google API?, I''ve also seen a gmaps4rails, any comments? Thank you in advance, Jax -- You received this message because you are subscribed to the Google Groups

Hello, A very simple question but I am stuck. I have an excel file each row is an address. However, I cannot make geocode read each line and come up with the latitude longitude. Could you please correct my code? library(ggmap) X<-c (2 Afxentiou Ampelokipi Thessaloniki Greece, 2 Afxentiou Ampelokipi Thessaloniki Greece, 4 Afxentiou Ampelokipi Thessaloniki Greece, 55 Agathonos

Hi, I would like to know if there is a library that provides an API to support map scrolling, like the one available in google maps. This is, I would like to create a user interface where the user is able to see a small part of a large map. It can then move the view, thus observing another part of the map. Additionally, I would also like to provide a zoom mechanism. Thanks in advance. --

I''m just curious about this, since my solution involved stubbing a call to GeoIp. Is there a good rule of thumb for when you make exceptions to the ''no stubbing'' philosophy of Cucumber? My step was: "Given I am accessing the site from Japan," but I can think of other situations - mostly when interacting with web services, that I''d probably

Hi guys (and gals), The code formatting is so nice on SO.com, so I thought I''d just share my post in hopes that someone from the group can help. http://stackoverflow.com/questions/9643786/cartographer-shows-correct-info-box-but-over-wrong-marker Feel free to answer back via email if you don''t have an SO account. Thanks! Abram -- You received this message because you are

This is a stupid question I know, but it is driving me crazy - I am missing something simple and basic here. I am trying to update missing zip codes on a data table. I am doing something incorrectly as the data in the Source table is not being updated, only the value in the array is changed. How do I get this to update the actual DB record instead? def add_missing_zips #find all records in

Hey all, I''m wondering about your thoughts on upgrading the Geocoder to use Mapstraction V2. Currently it uses the old syntax (i.e., for LatLonPoint, etc.): http://mapstraction.appspot.com/#geocoding Moving from V1 to V2 is fairly simple changes to the code. However, I wonder whether we want to update the way the geocoder is structured, as well? Some options: 1) Roll geocoding

I am using a smallint database column to store several boolean flags. The flags are accessible thru facade column accessors. I''d like to hide the database column so all access is thru the facade accessors. How do I do it? TIA, Jeffrey

Hi all, I started to see fun of gmaps4rails gem from https://github.com/apneadiving/Google-Maps-for-Rails. After everything done. When visited the locahost, i got the following error. undefined local variable or method `acts_as_gmappable'' for #<Class: 0x31a9da8> the error is due to i have line "acts_as_gmappable" in my model. Anybody knows how this is

Does anyone have any experience retrieving latitutde and longitude for an address from the Google Maps API? I'd like to have an R script that submits a street address, city, state, and zip code and returns the coordinates. So far, I've been submitting the coordinates from another program, then loading the coordinates in R and merging them back into the data frame I want to use.

Hello Railslist, (I''m using RadRails 0.6.3 on Windows XP with Ruby 1.8.4, Rails 1.1 and SQLite3) I have two tables in the database: "locations" and "customers": customers.sql --- id INT PRIMARY KEY name VARCHAR 255 address VARCHAR 255 postal_code VARCHAR 255 city VARCHAR 255 --- locations.sql --- id INT PRIMARY KEY postal_code TEXT longitude FLOAT latitude FLOAT

Hi- I am trying to find a way to diffuse GIS data on a European map. I have a dataset consisting of particular locations scattered across Europe, along with magnitude and value information. I can plot these as discrete points with something like the following: "geocode" is a dataframe with four columns: LAT; LONG; MAGNITUDE;VALUE. library(maps) library(mapdata)

Howdy folks, I know a lot of people (Google, Yahoo, others) offer geocoding, I am looking for a Web service for reverse geocoding. For instance, I have a latitude and longitude and I would like to get an approximate street address for them. I haven''t found anything that''s working all that well for me so I thought I would ask here. Any ideas? Thanks, H

Hola. Tengo algún tipo de problema con las tildes, a la hora de trabajar en R o en RStudio, que no sé resolver. Intentando reproducir en dos PCs distintos, ambos con Windows 7, uno de los últimos ejercicios que ha publicado Carlos Gil Bellosta en su blog ( https://www.datanalytics.com/2016/06/20/6602-767-km-alrededor-de-espana-para-visitar-todas-sus-capitales-de-provincia/), me ocurre que al

Hola, Carlos. Pues, efectivamente, me ha ayudado. Sobre la utilización de la función geocode con ciudades con tilde, me dio Carlos Gil Bellosta anteriormente la idea de utilizar iconv para transformar la cadena de búsqueda a UTF-8, y yo lo utilicé para intentar transformar el output de html_table sin resultado: capitales <- read_html("

Hola, Carlos. A mí también me resulta raro, porque no me pasa siempre. Es un poco aleatorio. Imagino que habrá alguna razón, y que el código de la página estará relacionado, claro, pero no consigo averiguar a qué se debe. Además las pruebas que hago me dejan todavía más perplejo. Esto Encoding(capitales) me dice que el encoding es "unknow", pero luego esto validUTF8(capitales) me