[mapserver-users] mapserver >= 5.6 and querys via php-mapscript

[Cristiano Sumariva]

If I remember well the loader script shp2pgsql create the unique attribute
called gid. And that gid I supose be the record id or record position from
the shape source file.
So if you need a map between file position and database record returned read
the attribute 'gid' from that shape record.

I do not know if still done on recent versions of loader.



2010/6/10 Lime, Steve D (DNR) <Steve.Lime at state.mn.us>

>  The concept changed in 5.6 to support improved query performance,
> especially for RDBMS data sources. It’s been a bit of
>
> a cluster though and interpretation of $result->shapeindex varies by 5.6.x
> version and driver. We’ll get this straightened
>
> out and simplified in 6.0. Addressing 5.6.3 only:
>
>
>
> -          shapeindex should hold the global record index for a shape
>
> -          tileindex should hold the result set record index for a shape
> (for RDBMS data sources, e.g. Oracle and PostGIS only)
>
>
>
> There still may be inconsistencies with OGR-fronted RDBMS sources.
>
>
>
> Steve
>
>
>
> *From:* mapserver-users-bounces at lists.osgeo.org [mailto:
> mapserver-users-bounces at lists.osgeo.org] *On Behalf Of *Sven Schroeter
> *Sent:* Thursday, June 10, 2010 10:27 AM
> *To:* mapserver-users at lists.osgeo.org
> *Subject:* Re: [mapserver-users] mapserver >= 5.6 and querys via
> php-mapscript
>
>
>
> Hi Daniel,
> >
> > I don't think there is any way to get the "real" shapeindex unless you
> > have an id field in the data itself. You could file a ticket about this,
> > but for some data sources, such as Postgis, Oracle Spatial, and many OGR
> > ones, there is no concept of absolute record id, so if something was
> > added, it would very likely work only for shapefiles
> >
>
> in the older ms versions I got with $result->shapeindex an absolute record
> id for all data sources (postgis, OGR, shapefiles).
> what ids were used before by default e.g. for postgis data?
> why this concept has changed in the new version 5.6?
> Thanx
> Sven
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100611/c8800476/attachment.html