Re: [postgis-users] problems with mapinfo file export to postgis

2009-09-25 Thread Paragon Corporation
Karina, Richard is right ogr2ogr defaults the geometry name to wkb_geometry unless you override that behavior. shp2pgpsql happens to default to the_geom unless you override that with -g option. The names are just convention and you can name the geometry field anything you want. You can use the -

Re: [postgis-users] problems with mapinfo file export to postgis

2009-09-25 Thread Richard Greenwood
On Fri, Sep 25, 2009 at 4:19 PM, Karina Guardado wrote: > Hi all, > > I have exported a Mapinfo file into postgres using the following statement: > > ogr2ogr  -f  "PostgreSQL" -a_srs "EPSG:8913" PG:"host=localhost > user=mysusername dbname=mydatabase password=mypass"  mytabfile.TAB > > but when I

[postgis-users] problems with mapinfo file export to postgis

2009-09-25 Thread Karina Guardado
Hi all, I have exported a Mapinfo file into postgres using the following statement: ogr2ogr -f "PostgreSQL" -a_srs "EPSG:8913" PG:"host=localhost user=mysusername dbname=mydatabase password=mypass" mytabfile.TAB but when I want to access by mapserver layer I just don't know how to make que qu

Re: [postgis-users] Postgis-CommercialLicence

2009-09-25 Thread Paul Ramsey
That's very very old. Everyone has contributed under the understanding the product is GPL, a license change is very unlikely. The only change that occurred was the Java client code under ./java got moved to an LGPL license, so people could use it in their software directly and not have a GPL issue.

Re: [postgis-users] SQL moving window averages/statistics

2009-09-25 Thread George Silva
There are many analysis techniques that uses 3x3, 5x5, 7x7, 9x9 windows. In particular, in block statistics and focal statistics. There are functions that are used to determine the flow of a raster (higher cell flows to lower cell), euclidean distance, best path, and many others! Also, this may be