[Gfoss] QGis e vista PostGIS

Marco Li Volsi marco.livolsi a gmail.com
Mar 4 Feb 2014 21:20:46 CET


Ciao Paolo.
Di seguito l'output di ogrinfo:
INFO: Open of `PG:dbname='miodb' host='192.168.1.4' user='postgres' 
password='xxxx''
       using driver `PostgreSQL' successful.

Layer name: v_poi_airport
Geometry: Point
Feature Count: 849
Extent: (-27.075851, 27.814005) - (135.171327, 78.246444)
Layer SRS WKT:
GEOGCS["WGS 84",
     DATUM["WGS_1984",
         SPHEROID["WGS 84",6378137,298.257223563,
             AUTHORITY["EPSG","7030"]],
         AUTHORITY["EPSG","6326"]],
     PRIMEM["Greenwich",0,
         AUTHORITY["EPSG","8901"]],
     UNIT["degree",0.0174532925199433,
         AUTHORITY["EPSG","9122"]],
     AUTHORITY["EPSG","4326"]]
Geometry Column = geom
id: Integer (0.0)
poi_name: String (0.0)
service_group: String (0.0)
sub_category: String (0.0)
importance: String (0.0)
name: String (0.0)
stname: String (0.0)
hsnum: String (0.0)
postcode: String (0.0)
locname: String (0.0)
lancd: String (0.0)
telnum: String (0.0)
tel_num_type: String (0.0)
faxnum: String (0.0)
email: String (0.0)
http: String (0.0)
brandname: String (0.0)
compname: String (0.0)
cltrpelid: Integer (0.0)
relpos: Real (0.0)
extpoiid: String (0.0)
addrpid: Integer (0.0)
posaccur: Integer (0.0)
gal: Integer (0.0)
content_source: String (0.0)
content_modification: String (0.0)
Saluti.

Il 04/02/2014 09:22, Paolo Corti ha scritto:
> 2014-02-03 Marco Li Volsi <marco.livolsi a gmail.com>:
>> Il log non è molto parlante
>> dbname='miodb' host=192.168.1.4 port=5432 user='postgres' password='xxxx'
>> sslmode=disable key='addrpid' srid=4326 type=POINT
>> table="public"."v_poi_airport" (geom) sql= è un layer non valido; non
>> caricato
>>
> ciao Marco
> cosa ti restituisce ogrinfo?
>
> $ ogrinfo PG:"dbname='miodb' host='192.168.1.4' user='postgres'
> password='xxxx'" v_poi_airport -so
>
> p
>

-------------- parte successiva --------------
Un allegato HTML ? stato rimosso...
URL: <http://lists.gfoss.it/pipermail/gfoss/attachments/20140204/2f388416/attachment-0001.html>


Maggiori informazioni sulla lista Gfoss