Script SQLserver con Departamentos,Ciudades, y Barrios de Colombia.

Question

Señores,

Alguien sabe de casualidad en donde encuentro un script que contenga, no solo los deparamentos y sus ciudades si no tanbienlos barrios de cada ciudad de colombia?

 

De antemano Mil Gracias.

---

Jhohan Alexander Vasquez Sierra

Answer 1

Translation: Anyone know where I find by chance on a script that contains not only the cities deparamentos and tanbienlos if every city neighborhoods of Colombia?

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

Hi Jhohan,

Do you want to obtain the data about departments, cities or other organizations neighborhoods of Colombia? There may be some companies who can provide such databases or codes over world. Please take a look at the links below about this issue:
http://www.freelancer.com/job-search/cities-states-database
http://forums.devarticles.com/general-sql-development-47/world-country-region-city-database-script-4825.html

Hope this helps.

---

Best Regards,
Stephanie Lv

Forum Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact [e-mail].

Answer 3

Hola a todos,

Haciendo un e-commerce site, me vi en la situación de agregar todos los departamentos de Colombia pues la instalación por defecto de Prestashop no los contiene.

A continuación les dejo el link en caso de que alguno también necesite hacerlo:

Script SQL para agregar los Departamentos de Colombia a la base de datos de Prestashop en la tabla ps_state

http://trickortip.co...ates-table.html

Espero que les sirva =)

Hello,

Recently I was developing an e-commerce site in Colombia and had the need to add all the states (in Colombia it is called departamentos) into the database.

To quickly do this, I used a SQL script to add all the Colombian departamentos and I thought it would be useful to share them with you.

SQL script to add the list of Colombian departamentos into the ps_state table in Prestashop database

http://trickortip.co...ates-table.html

I hope this helps since prestashop does not have the Colombian departamentos in the ps_state by default.