View Full Version : World Locations Database
Leandro Figueiredo
October 22, 2012, 04:29 PM
Admin,
I have the complete list of regions and cities of Brazil in SQL
Can you include in the World Locations Database on the Flynax server?
Thanks
Vladimir
October 23, 2012, 03:33 AM
Hello,
Would you please submit a ticket to our technical support and we will be able to make it.
Leandro Figueiredo
October 23, 2012, 11:14 AM
Vladimir,
Ticket submitted.
John
October 29, 2012, 06:58 AM
Hello Leandro,
Your cities database saved wrong, saving the csv you should chose UTF-8 as the default encoding to save
the non-latin characters properly.
We are going to update the "Multi-field/Geo Filter" plugin and add two new features:
- import data from xls/csv on any level (using this option you will be able to import Brazilian cities you have)
- import data from Flynax Server, now we are collecting Geo Location data and you and all forum user can send
us your location databases which will be integrated to the list of the available geo resources.
Make sire that you saved your GEO data properly using UTF-8 characters encoding.
John
Leandro Figueiredo
October 30, 2012, 02:54 AM
Hello Jon,
This ok now.
I saved the dados using UTF-8 caracters econding and worked correctly.
Ionut Barabasa
November 5, 2012, 05:03 PM
Hello
I have the database of All location in world structured like this COuntry-state(county)-city or village Format 3 sql files Very accurate database up to date till 21 january 2012.
264 countries
7656 regions/counties
1 865 950 locations
If you find this useful for your sever i can put it at your disposal
All the best!
Petrache Nicolae
November 5, 2012, 09:54 PM
Hello
I have the database of All location in world structured like this COuntry-state(county)-city or village Format 3 sql files Very accurate database up to date till 21 january 2012.
264 countries
7656 regions/counties
1 865 950 locations
If you find this useful for your sever i can put it at your disposal
All the best!
sal. poti sa-mi dai baza de date? multumesc
Mike
November 6, 2012, 03:23 AM
We will highly appreciate if you can share it with us, it will be very useful for all!
You can pm me link to the database or create ticket.
Thank you for participation!
Petrache Nicolae
November 7, 2012, 06:06 AM
We will highly appreciate if you can share it with us, it will be very useful for all!
You can pm me link to the database or create ticket.
Thank you for participation!
hello Mike. Maybe this will help. http://earth-info.nga.mil/gns/html/namefiles.htm
have looked into Romania file and looks ok. See if the data for your country is ok
Ionut Barabasa
November 7, 2012, 02:41 PM
Hello
I have sent those 3 sql files by mail. Petrache's link seem good too but has more names for the same city For example Onesti also appears with former name of Gheorghiu Ghe Dej. And cities dont not have the regions/counties
Petrache PM me if you want the database
Mike
March 1, 2013, 10:35 AM
We have added Brasil database to our server
Pete Young
March 30, 2013, 12:08 PM
Is the xls / csv import option available and if so are there any example files i can use as a template please.
Steffen Buschkemper
April 15, 2013, 01:37 PM
I have the database for germany.
Country - Language - ID - ISO2 - Region1 - Region2 - Region3 - Region4 - ZIP - City - Area1 - Area2 - Lat - Lng - TZ - UTC - DST
For examble
("DE", "DE", 20615, "DE-SH", "Schleswig-Holstein", "", "Ostholstein", "Kellenhusen (Ostsee)", "23743", "Kellenhusen (Ostsee)", "", "", 54.19246, 11.05643, "Europe/Berlin", "UTC+1", "Y"),
("DE", "DE", 20616, "DE-SH", "Schleswig-Holstein", "", "Ostholstein", "Kellenhusen (Ostsee)", "23746", "Kellenhusen (Ostsee)", "", "", 54.19246, 11.05643, "Europe/Berlin", "UTC+1", "Y"),
("DE", "DE", 20617, "DE-SH", "Schleswig-Holstein", "", "Ostholstein", "Kellenhusen (Ostsee)", "23743", "Morest", "", "", 54.20708, 10.98854, "Europe/Berlin", "UTC+1", "Y"),
Best regards
Steffen
Mike
May 1, 2013, 10:00 AM
There is no import from csv files at the moment and also any other import from file facility in the plugin, we are thinking to update Data Entries import plugin to work with the multiField plugin so it will be possible for you to import csv files.
But better if you just provide me with database you want to import and most likely i will import it to our server, you then will be able to import this data using remote import feature of the plugin. Or we can do it for you
I have the database for germany.
I have the database for germany.
can you sent it p, or ticket, if you allow us to import database to server
Matthias Ficht
August 28, 2013, 03:46 PM
Good evening,
my project with flynax should cover the south of Germany, Austria and Switzerland and with flynax support I have now for the plugin IP Geo Location a ~680000 items database table (~30MB). The data shows like:
INSERT INTO `fl_ipgeo` (`From`, `To`, `Country_code`, `Country_name`) VALUES
(1101806592, 1101807615, 'US', 'United States'),
I am interested in this Germany database, (possibly also for Austria & Switzerland?) but first I would like to understand for which plugin do you speak here.
Thank you!
Carolina Vitorino
June 3, 2014, 05:12 PM
Hello
I have tried to fix the Brasil Locations database many times. I paid the Flynax developers to do it and it still seems wrong. Actually I was told that the OS doesnt read portuguese signs and everytime the database is imported it comes wrong. Once I already paid to fix this issue I would like to suggest to Flynax to find a solution for this issue once you want to sell scripts here in Brazil and over another latin countries as well.
Please I need this working properly ASAP.
Thank you
Milea Ionut
August 5, 2014, 12:54 PM
Hello to all,
Does anyone have the complete Germany database? If yes could I have it please?
Thank you very much!
Milea Ionut
September 3, 2014, 09:20 AM
Anyone please?
Thank you!
Viktor
September 4, 2014, 04:24 AM
Hello Milea Ionut,
If you want you can buy it and we will integrate in for you. http://www.geopostcodes.com/Germany
Powered by vBulletin® Version 4.1.9 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.