I'm currently using this as my query:
SELECT g.*,
ST_X(geomout) As lon,
ST_Y(geomout) As lat, (addy).*
FROM geocode('') As g;
I'm wondering what other fields I can add to the SELECT. E.g., can I get
census block?
I know one route is to use the lon/lat together with the shapefile
Thanks Puneet for the link, it worked like a charm.
@Sandro: also, I forgot to thank you, the link is very useful, although it'd be
great if more examples could be added there.
Thanks guys, PostGis rocks.
> From: gameji...@hotmail.com
> To: postgis-us
On Oct 7, 2011, at 11:33 AM, Gery . wrote:
>
>
> Hi,
>
> I'm calculating some distances and getting too many decimals, I just want 4
> decimals, this is the code:
>
> UPDATE line SET length_km = st_length(st_transform(geom,32718))/1000 WHERE
> id::int between 1 and 75;
>
> and the result i
Hi,
I'm calculating some distances and getting too many decimals, I just want 4
decimals, this is the code:
UPDATE line SET length_km = st_length(st_transform(geom,32718))/1000 WHERE
id::int between 1 and 75;
and the result is for example:
75.1634098489817
Is it possible to set the number
Did you check if, even with this error happening, the raster was loaded
successfully? I remember having seen this a couple of time but the raster was
loaded properly. It might be more like a warning than an error...
Pierre
> -Original Message-
> From: postgis-users-boun...@postgis.refra
On 10/7/2011 4:32 AM, Andreas Forø Tollefsen wrote:
We will now try the python script again and terminate and open the
connection for each year in the for loop.
If this works, then it seems like there is a resource issue in
Postgresql or in one of the functions of postgis i think.
As i said. This
Hi,
I'm new to this list and also rather new to the work with PostGIS , I used to
work with it a couple of years ago and started with it again 2 weeks ago.
Right now I'm experimenting a little bit with the possibilities to store raster
in PostGIS. I have a PostGIS 2.0 installation on top of Pos
On Oct 7, 2011, at 6:39 AM, "Gery ." wrote:
>
>
> Thanks Puneet, it's enough what I have now in the table, the scheme you
> showed (a & b into table c) is actually what I did, but the order just in one
> table (4000 rows) changed I dont know why.
Because, as I said in my earlier email,
On 05/10/11 14:09, MarkW wrote:
John - SET CLIENT is the beginning of a larger SQL statement. The
error says the SQL statement failed, "...sql begins:"
and then later down the error dump indicates a connectivity issue -
which you later identified as the probable cause.
So it is not saying th
On Fri, Oct 07, 2011 at 12:05:30PM +, Gery . wrote:
> where I can find the notation you used to solve this problem?
http://www.postgresql.org/docs/
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
Thanks Nicolas, it worked perfectly, and yes, my IDs are INT, I just put the
quotes (' ') because I saw that in some examples, btw, where I can find the
notation you used to solve this
problem? I was looking for something like that I didnt find anything like that,
also, I'm not receiving the
> Hi,
>
> I'm trying to update several rows of my table just with one call, based e.g.,
> in the number of ID. For that I would like to do something like the following:
>
> UPDATE line SET survey = 'GT', type = 'MR', source = 'TY' WHERE id = '5' TO
> id = '15';
>
> I know this doesnt work, it's j
Hi,
I'm trying to update several rows of my table just with one call, based e.g.,
in the number of ID. For that I would like to do something like the following:
UPDATE line SET survey = 'GT', type = 'MR', source = 'TY' WHERE id = '5' TO id
= '15';
I know this doesnt work, it's just to ask if
Thanks Puneet, it's enough what I have now in the table, the scheme you showed
(a & b into table c) is actually what I did, but the order just in one table
(4000 rows) changed I dont know why. The other table (50 rows) remained the
same after being inserted in c. Both a and b had their correla
Hi Sandro,
Since I am newbie in open source GIS so I have no experience in writing
scripts. :)
Yes, it will be great if there are other geologist which use these open source
GIS software.
Ok, I will try gvSIG.
Thanks.
Regards,
Wendi A
Powered by Telkomsel BlackBerry®
-Original Message
Il 07/10/2011 12:18, Sandro Santilli ha scritto:
> On Fri, Oct 07, 2011 at 09:39:58AM +, wendiadrians...@yahoo.com wrote:
>
>> I prefer to use MapInfo because it supports more on my activities,
>> mainly on geological study.
>> I have tried Quantum GIS, but it does not meet my needs.
>
> Qua
On Fri, Oct 07, 2011 at 09:39:58AM +, wendiadrians...@yahoo.com wrote:
> I prefer to use MapInfo because it supports more on my activities,
> mainly on geological study.
> I have tried Quantum GIS, but it does not meet my needs.
Quantum GIS has a powerful plugin-based architecture, allowing
Hi Jorge,
I haven't try gvSIG, maybe I can do it.
Thanks for advice.
Regards,
Wendi
Powered by Telkomsel BlackBerry®
-Original Message-
From: Jorge Arévalo
Date: Fri, 7 Oct 2011 11:57:26
To: ; PostGIS Users
Discussion
Cc: Sandro Santilli; Sandro Santilli
Subject: Re: [postgis-users]
And what about gvSIG?
On Fri, Oct 7, 2011 at 11:39 AM, wrote:
> Hi Sandro,
>
> Thanks for your comments.
> Yes, I prefer to use MapInfo because it supports more on my activities,
> mainly on geological study.
> I have tried Quantum GIS, but it does not meet my needs. That is the reason.
>
> Reg
Hi Sandro,
Thanks for your comments.
Yes, I prefer to use MapInfo because it supports more on my activities, mainly
on geological study.
I have tried Quantum GIS, but it does not meet my needs. That is the reason.
Regards,
Wendi
Powered by Telkomsel BlackBerry®
-Original Message-
F
We will now try the python script again and terminate and open the
connection for each year in the for loop.
If this works, then it seems like there is a resource issue in Postgresql or
in one of the functions of postgis i think.
As i said. This worked without a problem before.
2011/10/7 Andreas F
On Fri, Oct 07, 2011 at 08:13:43AM +, wendiadrians...@yahoo.com wrote:
> For your information, I am going to use MapInfo as GIS Engine.
> Is PostGIS v2.0 compatible with MapInfo?
PostGIS is lower level, so the correct question is:
"Is MapInfo® compatible with PostGIS v2.0 ?"
Beside, why woul
Hi Jorge,
Thanks for your information. This is very useful.
I will try on my laptop.
For your information, I am going to use MapInfo as GIS Engine. Is PostGIS v2.0
compatible with MapInfo?
Regards,
Wendi A
Powered by Telkomsel BlackBerry®
-Original Message-
From: Jorge Arévalo
Date: F
Hi Wendi,
"mercator" is the name of one of my machines. In the PgAdmin GUI tree
you can see your defined connections. I have 3 connections defined.
When you define your own connections, you'll see them at same place.
Best regards,
Jorge
2011/10/7 :
> Hi Jorge,
>
> Can you let me know how to mak
Hi Wendi,
I've updated the post. Please install the GDAL Python bindings
separately. Download the installer from
http://vbkto.dyndns.org/sdk/Download.aspx?file=release-1310-gdal-1-8-mapserver-5-6%5CGDAL-1.8.0.win32-py2.7.msi
Or you can use any of the executables at
http://www.lfd.uci.edu/~gohlke/
Hi,
What i have done now is to try to run the query in PgAdmin SQL windows
instead of through the Python/Psycopg2 framework to see if that was the
problem.
This means one insert query for each year. I tried to run a limited set with
10 annual insert queries and this worked. Then i tried the rest o
26 matches
Mail list logo