Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Geocoding Script

ctmacquet's profile image ctmacquet posted 2 weeks ago in Running SQL scripts Permalink

I am a BA type (no programming expertise) helping a NFP NGO create a Food website.

I have recently converted from MySQL to Maria (10.7, X64) and use Heidi (11.3.0.6295) as the interface.

In MySQL, I used the following script to geo-code 107K Providores (farmers, grower, producers, etc):

Geo-code

ALTER TABLE prov_au ADD Location Point:

ALTER TABLE prov_au MODIFY Location POINT NOT NULL; and it took a few seconds to create the Geometry field in the Location field.

This is used for mapping, calculating food miles, etc.

I did manage to geo-code a smaller Maria DB (11K records) with a script similar to this:

ALTER TABLE vic_rural ADD Location Point;

INSERT INTO vic_rural VALUES (GeomFromText ('POINT(longitude, latitude)'));

Not sure how, but it (or some script similar worked - and without a 'where' clause - see below.

But have not been able to replicate this, as Heidi now requires me to add a 'where' clause somewhere in the Query script, which is beyond my knowledge.

Any ideas?

ansgar's profile image ansgar posted 2 weeks ago Permalink

Can you add a screenshot of how HeidiSQL requires you to add a WHERE clause?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.