Hi,

Obviously you are playing with vector data, not rasters, and you are trying to 
make a ogrtileindex instead of gdaltindex. I know, technically there is no 
difference.

I have used ogrtileindex with great success with shapefiles. I have never tried 
to do the same with PostGIS data and I can only wish you luck with your 
experiments. One thing that came into my mind it that perhaps OGR connection to 
PostGIS would work better than the native one with tileindex.

-Jukka Rahkonen-

Lähettäjä: mapserver-users 
<mapserver-users-boun...@lists.osgeo.org<mailto:mapserver-users-boun...@lists.osgeo.org>>
 Puolesta Zmitser Kozhukh via mapserver-users
Lähetetty: keskiviikko 24. maaliskuuta 2021 9.03
Vastaanottaja: Carlos Ruiz 
<boolean10...@yahoo.com<mailto:boolean10...@yahoo.com>>
Kopio: mapserver-users@lists.osgeo.org<mailto:mapserver-users@lists.osgeo.org>
Aihe: Re: [mapserver-users] data parameter in tileindex

Dear Carlos, it is not about mapfile, it is in location cell of tileindex. It 
is one cell in table (database table, dbf file etc.), and I need to put there 
both connection and data details. The question is how to make it so that 
mapserver parses it correctly.
Sincerely, Zmitser

Среда, 24 марта 2021, 6:53 +03:00 от Carlos Ruiz 
<boolean10...@yahoo.com<mailto:boolean10...@yahoo.com>>:

Zmitser,

You have to have the following on a MAP file:

LAYER

...

CONNECTION "host=<HOST> ... password=<PASSWORD>"
CONNECTIONTYPE <CONNECTION_TYPE>
DATA "<GEOM_COLUMN> FROM <TABLE NAME> USING UNIQUE <ID> USING SRID=<SRID>"

...

END

On DATA you must specify the name of the geometry column and the table, if 
you're using a database. If you are using a shape file you just have to include 
the DATA keyword with the path and the name of the SHP file.


On Tuesday, March 23, 2021, 2:34:48 AM CST, Zmitser Kozhukh via mapserver-users 
<mapserver-users@lists.osgeo.org</compose?To=mapserver%2dus...@lists.osgeo.org>>
 wrote:


Dear mapserver users, I need to specify data parameter at the location item of 
tileindex.
So far, I have tried many possibilities but none works:
‘host=127.0.0.1 dbname=database user=admin password=admin DATA "geom from table 
using unique id using srid=4326"’
or
host=127.0.0.1 dbname=database user=admin password=admin data="geom from table 
using unique id using srid=4326"
etc.
Still I get an error :
msDrawMap(): Image handling error. Failed to draw layer named 'layer'. 
msPostGISLayerOpen(): Query error. Nothing specified in DATA statement.
Could someone please tell in which format data statement should be?
In documentation it is written vaguely:
Normally the location should contain the path to the tile file relative to the 
shapepath, not relative to the tileindex itself. If the DATA parameter contains 
a value then it is added to the end of the location.

--
Zmitser Kozhukh
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org<file://e.mail.ru/compose/%3fmailto=mailto%253amapserver%252dus...@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapserver-users


--
Zmitser Kozhukh

_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to