↓ Archives ↓

Archive → July, 2012

Loading a shape file into MYSQL with ogr2ogr

Whit ogr you can load a shape file directly onto an existing database. The syntax is quite simple:

ogr2ogr -f "MySQL" MySQL:"ogr,user=root,host=localhost,password=root" -lco engine=MYISAM Comuni_01.shp

Patstat import scripts for MySQL (201204 version)

I finally released the import scripts for mysql. You can find it on github along with a small documentation on the (beautiful) github page here.

Please note this is for April 2012 version. If you’re importing another release of Patstat you have to change the thing accordingly.