blog documentation FAQ followers forum marketplace services youtube

jrCoreChainedSelect

The Jamroom Network » Forum » Jamroom Developers » Page » jrCoreChainedSelect
nate
@nate
11 years ago
917 posts
Are there any location libraries around to use with jrCoreChainedSelect?
updated by @nate: 05/15/14 03:32:16AM
nate
@nate
11 years ago
917 posts
I'm googling now.
paul
@paul
11 years ago
4,335 posts
I downloaded and used a free Country/State/City with LatLong library a couple of years ago. Still have it somewhere if you want me to dig it out. I converted it to three linked DB tables so could export those?
Not sure what the licensing situation was for it but I do recall it had a few errors and only a vague idea of what Australia was all about ;-)


--
Paul Asher - JR Developer and System Import Specialist
nate
@nate
11 years ago
917 posts
I found one I will try. If it doesn't work out, I'll hit you back.

http://www.kindle-maps.com/blog/csv-location-of-all-the-cities-in-the-world.html
nate
@nate
11 years ago
917 posts
That file was only cities. What do you have?
paul
@paul
11 years ago
4,335 posts
http://paulasher.com/Misc/CountryStateCity.zip
Three SQL files to create country, state and city tables, with indexes and city lat/long


--
Paul Asher - JR Developer and System Import Specialist
nate
@nate
11 years ago
917 posts
Not exactly what I was expecting. I was hoping for a csv I could import in to the jrCoreChainedSelect.

Thanks for your help all the same.
updated by @nate: 04/04/14 02:17:22PM
paul
@paul
11 years ago
4,335 posts
Actually, that might be doable from what we have in those files. Let me check it out.


--
Paul Asher - JR Developer and System Import Specialist
nate
@nate
11 years ago
917 posts
Maybe someone can export one.

Anyone?
paul
@paul
11 years ago
4,335 posts
I'm trying to build a country/state/city csv file from what we have that can be imported into the jrChainedSelect module.
Not sure if its possible yet, and it could end up pretty big. I have 148634 cities registered in the files!!


--
Paul Asher - JR Developer and System Import Specialist
nate
@nate
11 years ago
917 posts
They are all pretty big as far as I can tell.
michael
@michael
11 years ago
7,805 posts
not sure if its relevant, but GeoLite have a CSV file of cities and countries here.

http://dev.maxmind.com/geoip/geoip2/geolite2/
nate
@nate
11 years ago
917 posts
Yeah I found those last night. The tutorial you guys have kinda stops short.

I'll try to figure it out.
brian
@brian
11 years ago
10,149 posts
Natedogg265:
Yeah I found those last night. The tutorial you guys have kinda stops short.

I'll try to figure it out.

What tutorial is that?

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
nate
@nate
11 years ago
917 posts
I mean the docs. It shows the basics of how to use it. If you're making something manually the tutorial is complete. But when I am working with these external csv files it stops a little short.

I only say that because importing locations seems to be one of those things a lot of people will want (especially those paying out).

I was actually told I could come to the site and find a file ready to go, but I haven't.
brian
@brian
11 years ago
10,149 posts
What document? I was hoping for a link to it. You mention it is not complete, but I have no idea what document you are talking about :)


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
paul
@paul
11 years ago
4,335 posts
I'm actually just testing a Worldwide Country/State/City library I've just built for import to jrChainedSelect. If it works I'll make it available somewhere, but beware, there appears to be approximately 130,000 cities in the world so its a big file and takes a time to import.
Point me to the docs you refer to and I'll make sure they're up to date.
Thanks
Pa


--
Paul Asher - JR Developer and System Import Specialist
nate
@nate
11 years ago
917 posts
I'm quite surprised no one has a location library prepared for this module.

Thanks for trying, anyway.
brian
@brian
11 years ago
10,149 posts
Natedogg265:
I'm quite surprised no one has a location library prepared for this module.

Thanks for trying, anyway.

Paul has put something together, but has also identified some other issues he is working on. There will be an update that will add some CSV files you can import.

Patience ;)


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
paul
@paul
11 years ago
4,335 posts
Libraries done for EU countries, USA, South America, Australia and New Zealand.
Its time-consuming creating the libraries so will do others on demand.
These will be included with the next release of the module, hopefully in the next day or two.
Pa


--
Paul Asher - JR Developer and System Import Specialist
nate
@nate
11 years ago
917 posts
Thanks guys.

Tags