[postgis-users] Re: Table Spatial Extent
pelle at alma.nu
Sun Oct 14 04:21:08 PDT 2007
Im no gdal or ogr guro, but my guess is that your reported extent
relates to a missing index on the spatial column of your data table.
Does your table have this index?
If not, issue somthing like this:
create index <an_index_name> on <tablename> using gist
If data has been loaded into postgis with shp2pgsql then you could have
supplied the -I flag to have the script create this index for you.
Brian Hamlin skrev:
>> using http://spatialreference.org I found the INSERT line ready-made
>> for epsg 4326
>> I inserted into my DB spatial_ref_sys.. however, ogrinfo still does
>> not pick it up...
>> pointers welcome...
> hmm, a little more research... following the general instructions for
> data import, I had been left with geometry_columns with an entry per
> table, but a spatial_ref_sys that was empty. After using the INSERT
> found on spatialreference.org, I could see better how this setup
> relates, how the SRID is arbitrary, and serves to link the two
> tables... however, my results are still not consistent.. It does seem
> difficult to get this right starting cold...
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users