[postgis-users] cannot retrieve any geometric data

[david techer]

Hi Orkun

Did U try ogr2ogr to import the data?

So U have to use the schema public for your data

Regards

David

orkun wrote:

> hello
>
> I cannot retrieve any geometric data with any select command :
>
> select distinct(cat),astext(wkb_geometry) as geometry from jeopgis  
> gives nothing.
>
> here is my postgis structure:
>
> bzk=# \d jeopgis
>                                     Table "public.jeopgis"
>    Column    |       Type        |                          Modifiers
> --------------+-------------------+-------------------------------------------------------------- 
>
> ogc_fid      | integer           | not null default 
> nextval('public.jeopgis_ogc_fid_seq'::text)
> wkb_geometry | geometry          |
> cat          | integer           |
> label        | character varying |
> Indexes:
>    "jeo_gidx" gist (wkb_geometry)
> Check constraints:
>    "enforce_srid_wkb_geometry" CHECK (srid(wkb_geometry) = 1)
>    "enforce_dims_wkb_geometry" CHECK (ndims(wkb_geometry) = 2)
>    "enforce_geotype_wkb_geometry" CHECK (geometrytype(wkb_geometry) = 
> 'POLYGON'::text OR wkb_geometry IS NULL)
>
>
> what might be the problem ?
>
> regards
>
> Ahmet Temiz
>
>
> ______________________________________
> XamimeLT - installed on mailserver for domain @deprem.gov.tr
> Queries to: postmaster at deprem.gov.tr
> ______________________________________
> The views and opinions expressed in this e-mail message are the 
> sender's own
> and do not necessarily represent the views and the opinions of 
> Earthquake Research Dept.
> of General Directorate of Disaster Affairs.
>
> Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal 
> olarak T.C.
> B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici 
> nitelikte degildir.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com