[postgis-users] Re: Table Spatial Extent

[Per-Olof Norén]

Brian,

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 
(<geometry_column_namn);
analyze <tablename>

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.

/Per-Olof


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
> http://postgis.refractions.net/mailman/listinfo/postgis-users