headers
Stephen Woodbridge | 1 Mar 2010 01:16
Favicon
Gravatar

Re: Read file encoding from from shape file

Frank Warmerdam wrote:
> Paul Ramsey wrote:
>> I was never certain that ESRI software actually respected the DBF code
>> page flags, but your reference indicates they do, so this seems
>> reasonable. Some investigation of the current state of shapelib WRT
>> encoding would be wise, as I think we should update our shapelib to
>> the current version when we release 2.0.
> 
> Paul,
> 
> Encodings have not yet been addressed in shapelib or OGR but this is
> something for which pressure is growing.
> 
> Best regards,

Since I have had to deal with this for some clients, I have been working 
around this problem with the following:

I create a *.cpg file with the encoding string in it. Then when I 
manipulate the file like, loading it to postgis, I can read the .cpg 
file and set the encoding correctly. This works pretty well, except no 
other code knows about the .cpg files.

I would love it if shapelib appropriately handled code page info.

-Steve W
Permalink | Reply | 0 comments |
headers
Nicolas Ribot | 1 Mar 2010 10:34
Picon

Re: configure postgis for editing outside LAN

On 9 February 2010 10:59, maning sambale <emmanuel.sambale <at> gmail.com> wrote:
> Hi,
>
> First post, newbie.
>
> I was able to finally install PostGIS and can already access my dbase
> via LAN.  I want to be able access the data outside LAN.  I played
> around with the pg_hba.conf and now I cannot access postgis database
> via pgadmin3 directly in the server machine!
>
> Current setup is:
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>
> # "local" is for Unix domain socket connections only
> local    all     all     trust
> # IPv4 local connections:
> #host    all     all     127.168.199     trust
> # IPv6 local connections:
> host     all     all     ::1/128         trust
> host     all     all     192.168.1.0/24 trust
>
> Any ideas
>

Hi,
Did you check if any firewall is present and allow traffic on PG port ?
Also, did you change the "listen_addresses" parameter in postgresql.conf ?

Nicolas
(Continue reading)

Permalink | Reply | 0 comments |
headers
Richard Greenwood | 1 Mar 2010 14:52
Picon

Re: TIGER geocoder with Census 2009 shapefiles

On Fri, Feb 26, 2010 at 9:52 PM, Paragon Corporation <lr <at> pcorp.us> wrote:
> David,
>
> As a matter of fact we've been working on that for chapter 10 of our
> upcoming book and think we have it all working.  As a part of the example
> generation process for our chapter 10, we had to come up with a way to load
> the tables that works on both windows and Linux.  Unfortunately we haven't
> had a chance to test the Linux loading approach, but is pretty much a
> parallel of the windows approach.

I am following this steps in the ReadMe.txt in
   http://www.postgis.us/downloads/tiger_geocoder_2009.zip
The ReadMe does not mention running tiger_loader.sql or
create_geocode.sql which I assume needs to take place.

When running tiger_loader.sql I get error:
ERROR:  relation "state_lookup" does not exist
LINE 189: FROM state_lookup) As s CROSS JOIN loader_platform As platfo...

When running create_geocode.sql I get error:
ERROR:  syntax error at or near "\"
LINE 21: \i utility/utmzone.sql

Thanks,
--

-- 
Richard Greenwood
richard.greenwood <at> gmail.com
www.greenwoodmap.com
Permalink | Reply | 5 comments |
headers
Paragon Corporation | 1 Mar 2010 15:13
Picon

Re: TIGER geocoder with Census 2009 shapefiles

Richard,

To answer your question.  We kind of glossed over it in Step 4 when we say
run the create_geocoder.bat file.

As you can see we don't have a .sh equaivalent yet though writing one is
fairly trivial.

If you look at the file, you'll see the sequence of scripts you need to run
and the order you need to run them.

David,
Regarding your question about roads_local.sql, we don't believe that table
is used any more and got replaced with edges,addr and faces --
 if you look at the tables\lookup_tables_revised.sql  you'll see that we
remarked out sections of the original that we deemed to be obsolete and
added some new ones

Let us know if you have any other questions,
Leo and Regina

http://www.postgis.us

-----Original Message-----
From: postgis-users-bounces <at> postgis.refractions.net
[mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Richard
Greenwood
Sent: Monday, March 01, 2010 8:52 AM
To: PostGIS Users Discussion
Cc: PostGIS Development Discussion
(Continue reading)

Permalink | Reply | 4 comments |
headers
Paragon Corporation | 1 Mar 2010 15:19
Picon

Re: postgis upgrade 1.4 to 1.5 sql file couldn't find $libdir/postgis-1.4

Bruno,

Hmm hadn't thought about this as a standard practice.  Now you point it out,
I guess I can see the thought process behind this.

The main issue is that since PostGIS no longer names the .so/.dlls the same
as the old name, as soon as you uninstall the old version, you have
temporarily broken your databases until you upgrade them.  This was not the
case in the past.

So really package managers should be treating these versions as being
different animals.  This will become more of an issue when PostGIS 2.0 comes
around.

The reason we changed towards this path is that it allows for two versions
of PostGIS to coexist on the same server thus allowing one to slowly migrate
to a newer version and also cross test behavior.  In the case of PostGIS
2.0, there will be many breaking changes, so you definitely would not want
to uninstall the old version when you install the new.

Paul, Kevin, Mark et. Al  -- any thoughts on the matter.  I suspect we'll be
seeing more of this issue crop up.

Thanks,
Regina 

-----Original Message-----
From: postgis-users-bounces <at> postgis.refractions.net
[mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Bruno
Friedmann
(Continue reading)

Permalink | Reply | 0 comments |
headers
Saeed Bhuta | 1 Mar 2010 16:35
Picon
Favicon

Libpq error

Hi All,

I am trying to install PostGIS in order to install PG Routing.

However when I run the configure script, at the end I am given the
following error even though I have libpq installed:

"configure: error: could not find libpq"

I am on Ubuntu 9.10 Karmic Koala and PostgreSQL 8.4.

I would greatly appreciate it if someone can point me in the right
direction.

Many Thanks,

Saeed.
Permalink | Reply | 2 comments |
headers
strk | 1 Mar 2010 16:52
Gravatar

Re: Libpq error

On Mon, Mar 01, 2010 at 03:35:21PM +0000, Saeed Bhuta wrote:
> Hi All,
> 
> I am trying to install PostGIS in order to install PG Routing.
> 
> However when I run the configure script, at the end I am given the
> following error even though I have libpq installed:
> 
> "configure: error: could not find libpq"
> 
> I am on Ubuntu 9.10 Karmic Koala and PostgreSQL 8.4.

Try:
sudo apt-cache search postgresql | grep dev | grep client

--strk;

  Share. It's fair.
  http://iwouldntsteal.net
Permalink | Reply | 1 comment |
headers
french30@inwind.it | 1 Mar 2010 16:54
Picon

import export file kml

Hi,
use PostGIS 1.5.0,
I would like to import KML files into batabase and export data in the database 
into a KML file.
use to export fwtools 2.4.7 and operation works, to import KML files with 
fwtool
write:
ogr2ogr-f "PostgreSQL" PG: dbname = PostGIS user = postgres password = 
postgres host = localhost port = 5432 "roads.kml
But it gives me an error: unable to find drivers 'Postgres'.
how can I fix this?
Can I import and export KML files directly without using fwtools but use 
PostGIS?
Thanks for your help.
Permalink | Reply | 1 comment |
headers
Olivier Courtin | 1 Mar 2010 17:05

Re: import export file kml


On Mar 1, 2010, at 4:54 PM, french30 <at> inwind.it wrote:

> Can I import and export KML files directly without using fwtools but  
> use
> PostGIS?

KML import and export are available since 1.5.0, but for geometries  
parts only
(i.e not for the whole KML file)

http://postgis.org/documentation/manual-1.5.0/ST_GeomFromKML.html
http://postgis.org/documentation/manual-svn/ST_AsKML.html

--
Olivier
Permalink | Reply | 0 comments |
headers
Saeed Bhuta | 1 Mar 2010 17:09
Picon
Favicon

Re: Libpq error

strk wrote:
On Mon, Mar 01, 2010 at 03:35:21PM +0000, Saeed Bhuta wrote:
Hi All, I am trying to install PostGIS in order to install PG Routing. However when I run the configure script, at the end I am given the following error even though I have libpq installed: "configure: error: could not find libpq" I am on Ubuntu 9.10 Karmic Koala and PostgreSQL 8.4.
Try: sudo apt-cache search postgresql | grep dev | grep client --strk; Share. It's fair. http://iwouldntsteal.net _______________________________________________ postgis-users mailing list postgis-users <at> postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Thanks Strk for your reply.

I ran the command and it gave the output: libpgtcl-dev - Tcl client library binding for PostgreSQL - development files.

So I did sudo apt-get install libpgtcl-dev and it installed successfully, I then ran the configure script but it still gives the same error;

configure: error: could not find libpq

Saeed.
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Permalink | Reply | 0 comments |

Gmane