Could be a password issue, though that usually gets written to the log
files.
Does your password have any ' or in it. I think we might still have issue
with that.
It sounds like it might have got passed copying over the files, so you can
probably just enable PostGIS anyway in the database of
We've started a new campaign and hoping it will be as successful as our last
windows 64-bit campaign.
This campaign is to package pgRouting as part of the Windows PostGIS
stackbuilder package. First we have to work out some kinks with compiling
which will take some time to work out.
If you want
in the regex compare.
Regards,
James
On Thu, Sep 27, 2012 at 04:20:41PM -0400, Paragon Corporation wrote:
James,
Which version are you using? I assume the 2.1.0SVN one?
That we can probably change the structure of a bit since it hasn't
been released yet and can probalby get away with change
] On Behalf Of Paragon
Corporation
Sent: Thursday, September 06, 2012 8:14 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Geocode function fails
whencallingnormalize_address
Rob,
Regarding your normalize issue, it's probably one record causing it. I
thought we fixed some of these issues
James,
Sadly this is a known issue and one we haven't settled on the best way to
fix without resorting to major surgery.
Here is the ticket for it:
http://trac.osgeo.org/postgis/ticket/1118
If you can add your examples to the ticket and add yourself to cc for the
ticket that would be great.
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of James
Marca
Sent: Thursday, September 27, 2012 4:06 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Tiger geocoder,Spanish street types are pushed
to the end
On Thu, Sep 27, 2012 at 03:56:53PM -0400, Paragon
If you are looking for disk space, just delete the addrfeat tables. They
are a denormalized join of addr / edges and feat and we aren't using them.
I had planned to use that instead of edges but after much thinking, decided
it really didn't provide any benefit and just took up a lot of disk
_
Date: Sat, 15 Sep 2012 18:46:06 -0500
From: ericas...@gmail.com
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] Odd question
That's fantastic! Exactly what I was looking for. Thank you very much.
On Sat, Sep 15, 2012 at 6:44 PM, Paragon Corporation l...@pcorp.us wrote
Eric,
Did y ou want to change the default or set it to 0 or something?
We were meaning to expose that but wasn't sure if anyone would be interested
in changing it.
The setting is on the function:
interpolate_from_address
Just change the hardcoded default of 10 to what you want.
CREATE OR
As some people may have noticed we've been beefing up our build and regress
infrastructure currently with the creation of 2 build bots
Debbie: a Debian jenkins bot that builds the PostGIS 2.0 (I just put in a
job to do that so 2.0.2 branch tar balls are now being built again, PostGIS
2.0/2.1 docs
You can't use PostGIS compiled for one version of PostgreSQL on a different
version of PostgreSQL. They are not compatible binaries across versions.
We'll have 2.0.1 for PostgreSQL 9.2 available for Windows probably sometime
next week.
However -- we do have PostGIS 2.1.0SVN available for 9.2
Rob,
Regarding your normalize issue, it's probably one record causing it. I
thought we fixed some of these issues in 2.0.1 and 2.1.0SVN so you might
want to upgrade your script to the 2.0.1 -- there is an upgrade script you
can use packaged in the tar ball.
If that still doesn't fix your issue,
Brent,
Is your data 2D or 3D? You might want to try out the new
ST_DelaunayTriangles in 2.1
http://www.postgis.org/documentation/manual-svn/ST_DelaunayTriangles.html
Right now I beleive it's just 2D, but work is going on in GEOS land to make
it 3D.: http://trac.osgeo.org/geos/ticket/570
Check to make sure that topology schema is in your database search path.
CREATE EXTENSION postgis_topology;
adds it automatically, but if you built from a template database it won't be
there.
I forget if the regular topology install script automatically adds it.
So something like
ALTER
I've put together a preliminary listings of PostGIS distributions I know
about. I would appreciate it if package maintainers can update it and
provide links to any helpful instructions relevant to your distribution.
http://trac.osgeo.org/postgis/wiki/UsersWikiPackages
Thanks,
Regina
You don't need to do array unless you have a reason for that LIMIT.
ST_Union is an overloaded function: One version is an aggregate and one
takes an array of geometries.
So below is a bit shorter to write:
SELECT ST_Union(poly)
FROM portal.catalog
WHERE cat.type = 'CADRG';
-Original
Correct it will dissolve overlapping regions, though you still may end up
with multipolygons if you have islands of polygons.
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of DrYSG
Sent: Thursday,
Olivier,
You can use FWTools or Tamas nightly builds.
http://www.postgis.org/documentation/manual-2.0/RT_FAQ.html#id2979398
Both have gdalinfo.exe. Tamas always has the latest and greatest.
Hope that helps,
Regina
h http://www.postgis.us ttp://www.postgis.us
_
From:
Correct. It's just with loading tabblock data which isn't used in Geocoder.
I don't have it used in any function at the moment actually though its a
table a couple of people asked for for stats
which is why we included it.
anyrate just fixed the issue for tiger_2011 (distributed with PostGIS
It's not just you. I'll see what I can do about this next week. I think it
happened when we switched our jdbc build to use Maven instead of Ant and our
buildbots have not been updaed yet to use the new Maven bindings.
http://trac.osgeo.org/postgis/ticket/1835
Sorry about that,
Regina
Chandler,
1) As Muhammad mentioned, you want to check to make sure your geometries are
in the same planar projection. First verify you brought them in with a
specific projection
By doing a
SELECT ST_SRID(geom), ST_AsText(geom) As wkt
FROM factory limit 1;
SELECT ST_SRID(geom)
FROM
Not included at the moment. Would require putting an entry in the
loader_generate_tables and also companion structures for each table in tiger
schema and mostly a lot of testing
mostly because census seems to like to change field names etc. every year.
It's something we've thought about just
be the best way to
clean up my current database?
Best regards,
Tom
On 11-7-2012 2:53, Paragon Corporation wrote:
The only issue I see with CREATE EXTENSION at this point is that if
you want to use the subversion releases because they don't have
extension version points (which
The only issue I see with CREATE EXTENSION at this point is that if you want
to use the subversion releases
because they don't have extension version points (which CREATE EXTENSION
requires freeze points)
, it's not upgradeable. I have a work around for that issue which I'm
experimenting with.
We've setup a PostGIS planet and are looking for bloggers. The planet is
currently housed here
http://planet.postgis.net
If you are interested in being aggregated, you can reply to this message or
send me a note offline
at:
lr at pcorp.us
We'll need your
blog name
feed url -- this
Kevin,
Can you ticket this one:
http://trac.osgeo.org/postgis/
and I'll take a look next I have the chance. I suspect it has something to
do with the fact that Westford only appears in cousub table and the reverse
geocoder uses that as a check, but I suspect the geocoder doesn't or at
least
Which version of GEOS are you using? Might be your path setting for geos is
wrong. I don't ahve issue compiling trunk under mingw 32 or 64-bit and am
using geos 3.4.0 dev
Thanks,
Regina
http://www.postgis.us
_
From: postgis-users-boun...@postgis.refractions.net
Take a look at these instructions if you haven't already:
http://trac.osgeo.org/postgis/wiki/UsersWikiWinCompile
We are working on building a self-contained ming environment for both 64-bit
and 32-bit. We have the 64-bit one dones. We are moving the 32-bit to use
the mingw64-win32
It worked fine for me upgrading from 2.0.0 to 2.0.1.
I used:
ALTER EXTENSION postgis UPDATE TO 2.0.1;
Which version of PostGIS are you using.
do a
SELECT postgis_full_version()l
When all fails, to fix your database.
1) Backup your database
2) Restore it.
It should automatically upgrade
It's not a win64 issue. My Windows 2008 64-bit 9.1 shows this as closed as
well.
George,
Are you sure this is the actual geometry you were testing with and not the
ST_AsText of it? I suspect you have some long digits making this not
closed. Can you please verify this does register as not
Does your password have apostrophes in it? I think there is an issue with '
and possibly spaces as well in passwords that is on our todo to fix.
One work around is change your pg_hba.conf temporarily to trust for
localhost, reload or restart the service
and then change it back to md5 when you
Donald,
This is extremely odd. Seems like its breaking when its trying to compile
the topology addtosearchpath function
as you are getting compiled function gibberish it seems.
That function is in postgis_topology, so what you could do is just use the
binaries (you might not even need to as the
That is annoying, I would expect something like geometry(point)
or geometry(pointZ) instead. Do types of other spatial
tables look fine in pgadminIII or is it a general issue with
any geometry column ?
Check the version of pgAdmin you are running . I complained about this
when we had
My mistake that is the right name. It the 5 digit zcta. so looks like it
imported fine for you and that's not the issue.
Will if you can give me an example point, I can check it out.
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
Can you put in a ticket for this. I suspect its a bug. The census blocks
piece was the last piece to go in and when I was testing I was loading
mostly separately.
http://trac.osgeo.org/postgis/
Set to tiger_geocoder for component and it will be assigned to me.
Also are you using tiger_2010
Forgot to add in the o\loader_table if you disable those tables it shouldn't
generate a script for them. You only need them for census block lookups
functions not for the core geocoder.
_
From: Paragon Corporation [mailto:l...@pcorp.us]
Sent: Tuesday, May 22, 2012 3:25 PM
To: 'PostGIS
Jeff,
Which point for example are you trying to reverse geocode? Mine seems to be
working fine but I just have MA data loaded.
Also are you using the tiger_2010 or tiger_2011. In the 2.1 trunk I have
tiger_2011 and even if you are on 2.0 probably the best to use since its
designed for the newer
Smaran,
This error usually happens for one of 2 reasons
1) You are trying to import into a database that is not PostGIS enabled
2) You installed PostGIS in a schema other than public and did not add that
schema to your search_path.
(this you can fix by adding the schema to your database search
Mary,
Unfortuantely I don't have a 8.3 handy around to test with at the moment
though I will soon. The libiconv-2.dll is sometimes present and sometimes
not and the installer should skip it if its already present. I'll double
check to make sure we didn't mess that up when packaging last.
David,
box3d_extent wasn't included in legacy because its an internal type not
meant for direct use.
Regarding your issue with restore, strk can look into that one. I would
suggest putting in a ticket for it.
http://trac.osgeo.org/postgis/newticket
as it sound like it might be a bug in the
Ryan,
We tested them on 64-bit (windows 2008, 2008 R2, 2003, and 7) so we know it
works on all those. Admittedly we were mostly focussed on 9.1 so we can't
be absolutely sure we tested the 9.0 on windows 2008 R2 (but we did on
windows 7 64-bit). We were testing against the EnterpriseDb
Brian,
I guess I should ask first what were you expecting to happen?
The concave hull always returns a single polygon. It should never return a
multipolygon. So given that constraint, I don't see how it could avoid
splitting the edge of your example.
Note the union of your polygon is a
It might have to do with search_paths. the CREATE EXTENSION
postgis_topology
adds topology to the search path for you, but this is lost if you create
from template.
_
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
http://www.postgis.org/documentation/manual-svn/ST_DWithin.html
_
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
superman0920
Sent: Friday, May 04, 2012 10:11 PM
To: postgis-users
Subject: [postgis-users] about
Wouter,
It should work fine with XP. I tested earlier on a windows xp box. I think
we had issues with earlier installers.
That said, I haven't tried installing the one from Stack builder on my
windows xp box. I'll give that a try tomorrow to verify that works fine.
Where did you get the
Yap definitely works on windows xp. I just tried uninstalling my 9.1.3 on
windows xp , reinstalling and then using application stack builder to
install PostGIS 2.0.0 and it worked fine.
Regarding dependency walker -- if you still have problems -- there is a
setting in dependency walker that lets
Giannis,
Sorry about that. What version os PostgreSQL are you running.
Do a
SELECT version();
You may be running an early 64-bit install. If you are not running the
latest micro (9.1.3) you may want to upgrade to a newer version of
PostgreSQL 9.1 64-bit or wait till our next packaging
It should be all in share folder. Note extensions is not in contrib its in
root of share so in the zip you should see a share that has
share/
contrib
extension
I think the older zip may have had it not in share, which was incorrect.
The batch script provided should copy the relevant
Hmm strange works all fine on my window box and my postgres doesn't have
it's own search_paths.
You did set the search path of the database right?
Mine is like this:
ALTER DATABASE mygisdb SET search_path=$user, postgis, public, contrib;
and it works fine for all users. I do have user
One other thought. It's possible you have the search_path set for postgres
in your database. I think that features was introduced in postgresql 9.0 or
9.1. Can't recall.
So for example in my database, I have a setting like this:
ALTER ROLE postgres IN DATABASE mygisdb SET search_path=$user,
Scott,
It's greyed out if you don't have a database selected. As long as your
database
has postgis installed, it should work fine.
Regarding world files as I recall, I think the 394 one has one record per
TZ, and the other has further broken out.
I usually use the 28,000 one for spatial
It sounds like you might have a mix of postgis installs. Did you upgrade
from a prior version and how did you do it?
What does
SELECT postgis_full_verion();
return.
I just moved my postgis extension from public to postgis schema. Added
postgis to my search path and then imported a shape
He has that it seems in fact he has it in the first slot since all his test
tables are being created in postgis. It should be at the end.
The AddGeometryColumn error and non-unique would happen if you have some
obsolete functions in your install. All these would be in public if they
are from an
I put in a ticket explaining what I think the issue is here:
http://trac.osgeo.org/postgis/ticket/1746
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of Paragon Corporation
Sent: Tuesday
It's a bug. Can you ticket this.
I noticed the same thing myslef when I tried to move postgis to a separate
schema but hadn't confirmed if it was my system, an issue with the extension
install or our postgis upgrade script. Long before I couldn't move it at
all because it complained about casts
Actually I'm not absolutely sure its the same thing. I'll put in a ticket
myself, but it might be related.
When I move rc1 (which I had upgraded from beta2) to another schema I am
left with two functions in public.
st_dump, st_ivaliddetail
I think this is similar to what is happening to you.
All we have windows binaries rc1 up.
John,
You were right about the xml. We neglected to package this dll in the
postgis 2.0.0 experimental builds thinking that EDB builds already had them.
Theirs has a different name though.
So I think all people who were installing with on an instance
Pachól [mailto:piotrpac...@gmail.com]
Sent: Wednesday, March 28, 2012 3:57 PM
To: PostGIS Users Discussion
Cc: Paragon Corporation
Subject: Re: [postgis-users] POSTGIS 2.0 on WIn
Hello,
I tried all hints from this thread and that:
http://postgis.refractions.net/pipermail/postgis-users/2012
PROJSO settings shouldn't be necessary anymore because libproj.dll is not
used.
I upgraded the install to use proj 4.8.0 so the dll is now libproj-0.dll
which is what gdal assumes by default.
It's possible I missed a dll and my tests systems already had them -- make
sure you have libproj-0.dll
Just a reminder that if you are interested in a 64-bit windows PostGIS
build, you should sign our pledge to speed up the process.
We have 16 signers so far and need another 4 to make this pledge
successful.
http://www.pledgebank.com/postgis64windows
Thanks,
Regina and Leo
the
problem in the first place.
Best
Sebastian
2012/2/27 Paragon Corporation l...@pcorp.us:
Sebastian,
That shouldn't matter. That just affects what you see in pgAdmin.
As far as dependency walker goes those errors are fine
since the lib
becomes part of path when postgresql
to install a new postgresql/postgis (maybe 9.0 or 8.4 with
postgis 1.5.3 or 1.4.2) I get the same error with the
template_postgis table missing.
Best
Sebastian
2012/2/26 Paragon Corporation l...@pcorp.us:
Sebastian,
Is your old database working again or not?
Yah they do get
checked the registry and
under HKEY_CURRENT_USER\Software\pgAdmin III\Servers I find
three identical server 1, 2 and 3 with the exact same
databases. Is that correct? But maybe that has nothing to do
with the error message I get ...
2012/2/26 Paragon Corporation l...@pcorp.us:
You
Sebastian,
I presume you installed the 32-bit PostgreSQL the second time around you
installed right?
If not that is probably your problem since PostGIS is not yet supported on
the 64-bit EDB windows builds
(just the 32-bit installers). If you are interested in supporting our
efforts to build a
as a template.
Btw the files that the postgis-1.5.dll depends are not there
- I checked with the depencywalker - but I thought they get
installed when I use the stackbuilder or not?
Thanks for your answer in advance.
Best
Sebastian
2012/2/26 Paragon Corporation l...@pcorp.us:
Sebastian
For those interested, heard thru the grapevine that psql native binary
output is slated for 9.3. Sadly it missed the 9.2 cut and the 9.2 is now at
feature freeze.
http://archives.postgresql.org/pgsql-hackers/2012-02/msg00671.php
I also did some experimenting with LibreOffice 3.5 and it is
put to a file but the file is
corrupted.
I appreciate the help.
Joan
On 14 February 2012 21:27, Paragon Corporation l...@pcorp.us wrote:
We have this documented in the docs.
http://www.postgis.org/documentation/manual-svn/using_raster.xml.html#RT_Ras
ter_Applications
There is an example
appreciate the help.
Joan
On 14 February 2012 21:27, Paragon Corporation l...@pcorp.us wrote:
We have this documented in the docs.
http://www.postgis.org/documentation/manual-svn/using_raster.xml.html#RT_Ras
ter_Applications
There is an example for doing it with PHP, .NET, Java, and PLPython
compiling geojson on mingw is tricky.
Did you try configure as the
http://trac.osgeo.org/postgis/wiki/DevWikiWinMingWSys_20 instructions
suggested with CFLAGS=-w
./configure --prefix=/c/projects/json-c/rel-0.9 CFLAGS=-w
I think I ran into similar issues without using the -w flag.
Hope that
Puneet,
You might want to try using --jobs as well. I do that for databases above
8.4.
You should also be able to see the tables restoring if you do a
SELECT * FROM pg_stat_activity
We suspect you have some stupid wrong like pg_restore is waiting for a
password.
Leo and Regina
It's included in stack builder. So you should be fine.
SELECT postgis_full_version();
Will tell you which version of each you are running.
Leo
http://www.postgis.us
_
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net]
Darrell,
I'm having similar issues using our alpha3 build and latest comiled from
http://vbkto.dyndns.org/sdk/ . There is an example in the FAQ with a text
field and that used to work when I tried it when I wrote that FAQ item a
while ago on windows.
I think it might be because of some changes
Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of Paragon Corporation
Sent: 04 February 2012 02:19
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Rv: Postgis for Postgres 64 bits
What people
Darrel,
I have a table of 11 rasters (3601x3134, originally tifs)
each tiled into 1000x1000 blocks and I have a simple geometry
shape file. My first ever SQL query looks like this:
SELECT rid, gid, ST_Value(rast, 1, geom), filename,
ST_X(geom) As X_coord, ST_Y(geom) As Y_coord FROM
Your polygon is untyped so could cast to raster or geometry thus ambiguous
which function to use.
Try casting it first by changing your code to:
SELECT
ST_SummaryStats(r.rast) as stats
FROM
new_york_r as r
WHERE
ST_Intersects(r.rast, 'SRID=900913;POLYGON((-8239995.68240392
What people are interested in seeing a 64-bit windows build of PostGIS and
willing to pay for it? We've heard a lot of people mention it,
but unfortunately as Bborie said, we've run into some build issues with
getting GEOS and GDAL to compile so its not trivial. A lot of the pieces we
do have
*
On Wed, Jan 25, 2012 at 5:40 PM, Paragon Corporation l...@pcorp.us wrote:
I unfortunately have to move my Postgres/PostGIS database to a new
Windows server. My current (source) db is Postgres 9.0.2 with PostGIS
2.0.0SVN (I believe from Jan 2011.)
January 2011 is a bit old
I unfortunately have to move my Postgres/PostGIS database to a new
Windows server. My current (source) db is Postgres 9.0.2 with PostGIS
2.0.0SVN (I believe from Jan 2011.)
January 2011 is a bit old or do you mean 2012?
The new (destination) db will likely be Postgres 9.1.2. It
Thanks for suggestion, I have checked the date and it is 2011-10-06
08:02:01. What could be other problem can you please..
_
From: Paragon Corporation l...@pcorp.us
To: 'PostGIS Users Discussion' postgis-users@postgis.refractions.net
Sent: Monday, 23 January 2012, 4:57
Subject: Re
Just tried it on my latest build which is about a week old (a little newer
than the windows build currently on site but much older than when this doc
section was written). Works fine for me.
Which version of PostGIS are you using?
Run this command:
select postgis_scripts_build_date(),
Hmm I meant 2012-01-01
_
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Sunday, January 22, 2012 10:48 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] ST_MapAlgebraExpr
guess only real use will tell).
Best wishes and many thanks again for your help.
Darrel
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: 08 January 2012 01:25
To: 'PostGIS Users
Darrel,
This should work fine. I haven't tried it, but can't see why it would be
any different from shp2pgsql. It should be pretty much the same story as
shp2pgsql except you'll need to copy the libgdal-1.dll as well to the
folder.
I'm not sure if you have tried it before --- but here is a
What version of GDAL are you using? You'll want to be using
what will be 1.9 (currently beta 2).
But there is an additional question about whether or not GDAL's PostGIS
Raster driver has been updated to the PostGIS Raster's
current (and probably final) format for the raster_columns
Steve,
Depends how your data is setup -- I'm assuming you are looking for a moving
average?
If for example you have a raster record for each date in the same table,
with a field denoting the date, then the best bet is probably use ST_Union
with the optional MEAN expression.
I haven't stress
...@postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: Thursday, December 22, 2011 2:44 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] raster map algebra question(s)
Steve,
Depends how your data is setup -- I'm assuming you are looking for a moving
average?
If for example you
for one
date in one table? In my my test db I have them by date,
by variable,
so the query I want to try first is the one I mention above.
Thanks,
Steve
On 12/22/2011 2:44 PM, Paragon Corporation wrote:
Steve,
Depends how your data is setup -- I'm assuming you are
looking
Just realized I sent this to the wrong list.
-Original Message-
From: Paragon Corporation [mailto:l...@pcorp.us]
Sent: Wednesday, December 21, 2011 6:27 AM
To: 'PostGIS Development Discussion'
Subject: RE: [postgis-devel] PostGIS 2.0.0SVN: TIGER Geocoder and TIGER'sown
Primary Keys
Steve,
I don't see where the topology issue is relevant here.
Everything should be able to be done within SQL without
reliance upon topology, when TIGER's primary keys are used.
The only reason on my radar for wanting a normalized tiger dataset is for
breaking
edges at the local
,
0, 255 etc.
Thanks,
Steve
On 12/20/2011 6:13 PM, Paragon Corporation wrote:
3) You can use gdal_translate (compiled with PostgreSQL support) to
output a postgis raster query.
--
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
/documentation/manual-svn/RT_ST_Union.html
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On
Behalf Of Paragon Corporation
Sent: Wednesday, December 21, 2011 4:03 PM
To: 'PostGIS Users Discussion'
Subject: Re
Stephen,
There are couple of ways to view raster data.
1) QGIS has a plug-in for viewing raster which as I recall is on 1.7. QGIS
users can probably fill you in on the details of that.
2) UMN Mapserver can also load PostGIS raster detailed here:
parameter. By adding
additional normalize_address function when doing the
geocode_address
akes
it run any faster?
Thanks
Ravi Ada
On Wed, 14 Dec 2011 04:18:27 -0500, Paragon Corporation wrote
I just don't understand why the geocode function takes
so long to
return
I just don't understand why the geocode function takes so
long to return the coordinates. I am sure some of you on this
list might have done the batch geocoding millions of
addresses. I may be missing just a simple configuration which
might make a whole lot of difference in the speed. I
Yes, you are correct about the significant performance issues
with calling ST_SetValue for each pixel of a raster. This
unfortunately has to do with the deserialization and
serialization that occurs every time ST_SetValue is called.
Hopefully, I can get to it before the 2.0 code freeze
Andreas ,
You don't need to install postgis.sql, rtpostgis.sql
Just _upgrade_20_minor.sql ones.
That is unless we change the on disk format or change non-droppable things
like casts which we might before release.
_
From: postgis-users-boun...@postgis.refractions.net
Ravi,
If you have pgAdmin, you might want to try something like pgScript. Unlike
plpgsql it commits on each update so doesn't suffer from the same issue as a
stored proc.
http://www.postgresonline.com/journal/archives/181-pgscript_intro.html
Hope that helps,
Regina
http://www.postgis.us
It doesn't geocode cross streets or if it is its share accident. I think
what it's doing is just picking the first one most likely so you are getting
at the beginning of a street with that name and it's ignoring the second
street at best.
The cross streets feature takes a different algorithm.
work for the
developer to split into cross streets rather than having postgis
figure that out upon every geocode.
Aren
On Mon, Nov 28, 2011 at 4:08 PM, Paragon Corporation l...@pcorp.us
mailto:l...@pcorp.us wrote:
It doesn't geocode cross streets or if it is its share
Andrew,
Did you read the README.txt file? The makepostgisdb.bat packaged you just
need to edit with the location to your PostgreSQL install and then you
should be able to just click on it and be set since it copies all the
necessary files
to the PostgreSQL directory.
For the extension piece,
1 - 100 of 791 matches
Mail list logo