[postgis-users] QGIS SPIT import to POSTGIS -
I'm trying to use QGIS SPIT to load multiple shapefiles into PostGIS. But, for all users but my superuser, I can't see the non-public schemas. It sounds permission based but when I sign in as the user via PGAdmin or via psql I can access and view the schemas. The schemas were created within the postgis database so they should have the postgis extension - to confirm this I created a new schema from the public folder in the postgis database but this was not viewable either. I've included the schemas in the postgres.conf search_path also. And, geometry columns are in the public.geometry_column table. Line 478 of qgsspit.cpp is the only SQL reference to the namespace I can see (QString schemaSql = "select nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE')";) and this works from both PGAdmin and psql. I also copied the function to the specific database and schema to determine if it was simply not finding the function but this didn't work either. Yes I can revert back to shp2pgsql but I like the multiple files option of SPIT - otherwise, can someone assist with some vb script or batch file to run shp2pgsql on files within a folder. Am I missing something else in the POSTGIS environment that may be restricting this user's ability? Thanks. Abe. -- View this message in context: http://old.nabble.com/QGIS-SPIT-import-to-POSTGIS---tp29122870p29122870.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] [Postgis-User] Different between geometry and geography?
Hi Nguyen In PostGIS context, a GEOMETRY is in a 2d plane, a GEOGRAPHY is basically on a sphere/geoid/ellipsoid, see http://postgis.refractions.net/documentation/manual-1.5/ch04.html#PostGIS_Geography Peter -- Dott. Peter Hopfgartner R3 GIS Srl - GmbH Via Johann Kravogl-Str. 2 I-39012 Meran/Merano (BZ) Email: peter.hopfgart...@r3-gis.com Tel. : +39 0473 494949 Fax : +39 0473 069902 www : http://www.r3-gis.com XING : http://www.xing.com/go/invita/8917535 nguyen liem wrote Subject: [postgis-users] [Postgis-User] Different between geometry and geography? Date: 09.07.2010 08:44 >Hi everyone, >http://postgis.refractions.net/docs/ST_DWithin.html >I see the ST_DWithin function that we can we can determine the geometries >are within a specified distance of one another. >* >ST_DWithin*(*geometry* g1, *geometry *g2, double precision >distance_of_srid) >; >*ST_DWithin*(*geography* gg1, *geography *gg2, double precision >distance_meters); > >Could you explain me when we use *geometry *and when *geography*. >Geometry which is a geometry tupe: POINT, LINE, POLYGON ... ? >Geography: ...? >... > >Cheers. > >-- >Liem Nguyen >Developer >Axon Active Corp. > >Direct Line : +84 38 948 4645 >Fax : +84 38 811 3489 >Mobile Phone : +84 168 994 8897 >Skype ID : liemnguyendl2204 >Email : liem.ngu...@axonactive.net / liemnguye...@gmail.com >Web Site : http://axonactive.vn >Address : 87 Thang Long Street,Gate 2 Ward 4, > Tan Binh District, HCM city, Vietnam. > > >___ >postgis-users mailing list >postgis-users@postgis.refractions.net >http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] shp2pgsql date quirk
Brian Hamlin wrote: I am importing several large shape files, into pg 8.4 postgis 1.5+ most went in fine, but the last one failed with an error regarding date fields. At least one date field entry in the shape file apparently is "0" pg complains, the conversion fails.. "Maybe you need different date settings" is suggested.. the database I am importing into already has 60+ tables.. I dont want to change settings on that database to accommodate.. suggestions on an efficient work-around? thanks -Brian Hi Brian, Could you provide us with a shapefile/dbf file containing a few of the entries in question? ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] shp2pgsql date quirk
I am importing several large shape files, into pg 8.4 postgis 1.5+ most went in fine, but the last one failed with an error regarding date fields. At least one date field entry in the shape file apparently is "0" pg complains, the conversion fails.. "Maybe you need different date settings" is suggested.. the database I am importing into already has 60+ tables.. I dont want to change settings on that database to accommodate.. suggestions on an efficient work-around? thanks -Brian == Brian Hamlin planetwork.net OSGeo California Chapter (415) 717-4462 cell ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
