All,
Does anyone know if it's possible to specify the number of vertices in
ST_Buffer(geog)? If not, is there a way around this? It seems pretty limiting
to this geography function...
thanks,
Anthony
Anthony Lopez | GIS Analyst
Strategic Energy Analysis Center
National Renewable Energy Labo
All,
I am wondering if it is possible to return the lat, long coordinates of the
point that the ST_Distance(a.geog, b.geog) function basis its distance
calculation on. Essentially, I'm after ST_ClosestPoint(), but using geography
instead of geometry.
thanks,
Anthony
Anthony Lopez | GIS Ana
On Thu, Apr 14, 2011 at 12:56:33PM -0500, Jeff Dege wrote:
> ERROR: date/time field value out of range: "0"
> HINT: Perhaps you need a different "datestyle" setting.
>
> What I need is for these features to be inserted with NULL date fields,
> instead of '0'.
You may try to:
1) prepare the ta
I'm trying to load a shapefile into a PostGIS database, using shp2pgsql and
psql.
It's failing because a couple of the sql insert statements have date fields
containing '0'.
ERROR: date/time field value out of range: "0"
HINT: Perhaps you need a different "datestyle" setting.
What I need is
Hi Paul,
I'm not expert on Postgres so, maybe I should remain in silence?
Anyway, I know Oracle well and I know that the physical organization of
your data may be highly relevant to performance.
Maybe you could prepare all the data you need on a temporary table and
in the end create another t
On 12/04/11 17:38, Paul & Caroline Lewis wrote:
Hi,
Thank you Mark and Richard for your replies. Having looked at this it
seems a Full Vacuum is the answer, however I'm not sure why. Processing
the SQL scripts as originall reported I do get a large table from
TestSet1 and a small table from Test
I was running out of hard disk space on my root partition. I have,
for now, the geocoder database on a separate partition and hard drive.
I was debugging and capturing the output of every query and command. So
it generated a huge file in the gigabyte range especially when each
query was ab
