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) <[email protected]> > 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:* [email protected] [mailto: > [email protected]] *On Behalf Of *Sven Schroeter > *Sent:* Thursday, June 10, 2010 10:27 AM > *To:* [email protected] > *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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
