New answers tagged import
You have a different projection in your psql; and having a projection is not necessary. Is there a schema you want to add the shape file to? This should work: shp2pgsql -s 4326 -I worldcountries.shp schema.worldcountries > dr_worldcountries.sql psql -f worldcountries.sql -h [host] -d [database] -U postgres
ERROR: **function addGeometrycolumn**(unknown, unknown, unknown, unknown,unknown, integer) does not exist It seems that PostGIS is not yet installed. PostGIS is an extension of Postgres which allows the use of geographic files. Install it and your import will work fine.
No, you cannot do that or those sort of tasks in Google Earth. Your best investment would be QGIS. Use the OSGEO Network Installer if you can. The process you will use depends on the format of the map that you propose to overlay. Is it another vector layer? If so, is it a complete polygon or just a line which encloses the area of interest. For a one off ...
I personally hate working with FieldMap/FieldMappings objects, as I find them very tedious to construct correctly. I would normally do this by calling: CreateFeatureclass_management(), AddField_management() for the fields you want (just "GEOID10" in this case, since the OID and geometry are initialized with the feature class), being careful to use the same ...
You can't import QStringList in QGIS 2.x because we are using SIP bindings v2 which auto converts the types to Python types. If you are buildling at a standalone app you should import qgis.core before import PyQt4 because PyQt4 will set the sip API to V1 before QGIS can set it to v2. Long story short: Do this: from qgis.core import * from PyQt4.QtCore ...
Since I wasn't doing much 'exoticism' with that QStringList I tried to subsitute with a simple python List With Success. try: from PyQt4.QtCore import QStringList except ImportError: QStringList = list then ql = QStringList() l = Global.getPG_connection().tableList for item in l: ql.append(item) #Pass the QStringList to the ...
I think you can compile the library against python27 by yourself. Here is a description about compilation and installation. If you are also comfortable with python25 or python26, there are downloadable installer available for python25/26 here. I've tested the python26 installer and it works fine for me.
You can use ogr2ogr with the -sql option to use a sql statement
Top 50 recent answers are included