Saturday 15 August 2015

Running Spatial Queries in PostGIS 2.1.3 and Postgresql 9.3 in Windows 7 -



Running Spatial Queries in PostGIS 2.1.3 and Postgresql 9.3 in Windows 7 -

i installed postgresql 9.3 ( pgadmin 3 gui) , postgis 2.1.3 (http://www.enterprisedb.com/products-services-training/pgdownload#windows) windows 7 64 bit. after installing it, downloaded sql files country database (http://www.spatial.cs.umn.edu/book/labs/vania/spatialqueries.html) , tried execute commands in country.sql

in sql builder , stuck @ next error:

notice: srid value -1 converted officially unknown srid value 0 context: sql statement "select addgeometrycolumn('',$1,$2,$3,$4,$5,$6,$7)" pl/pgsql function addgeometrycolumn(character varying,character varying,character varying,integer,character varying,integer,boolean) line 5 @ sql statement error: function geometryfromtext(unknown, integer) not exist line 4: ...3000.0000','dollar','usd','n','5','united states',geometryfr... ^ hint: no function matches given name , argument types. might need add together explicit type casts. ********** error **********

error: function geometryfromtext(unknown, integer) not exist sql state: 42883 hint: no function matches given name , argument types. might need add together explicit type casts. character: 769

i can't error resolved. please help me out.

postgresql postgis windows-7-x64

No comments:

Post a Comment