Hi Ahmad
You won't connect to the database directly. Depending on what the data is you
can use a variety of methods. Simple REST style calls to a web server which
runs code to query the database and return the data could be sufficient, but
for anything more complex I suggest using a WMS server
It's just a series of points which you can position in a curve. The more
points, the smoother the curve.
charles
On Mar 14, 2012, at 5:24 AM, Ed Linde wrote:
Is a LINESTRING always a straight line in postgis? Or can there be a
curvature? I didn't get that from the documentation.
The distance should be in the projection units, which for 4326 is decimal
degrees, and if you want meters you'll need to convert the results to meters.
But first, I suspect your data is not in 4326 then if you get 1179. Make sure
you are using the SRID when inserting them
update address set
I'm not sure about the support for geography but I see you need a comma between
id and locGeog
-- charles
On Feb 2, 2012, at 5:58 PM, Jay Moss jaymo...@gmail.com wrote:
Is there any support for the Geography data type in the PostGIS JDBC driver?
I received a classCastException if I try to
Stephen, do you mind sharing what the source of the traffic disruption feed is?
Mainly curious if it's one of the ones we use (email direct if needed). I had
tried to do something similar a while ago but honestly did not make good
progress (this was before I found st_HausdorffDistance and need
Yes, my mistake :)
On Jan 26, 2012, at 3:51 PM, Nicolas Ribot wrote:
As far as I understand, shouldn't the self join in the query be
table1 t1, table1 t2, in your example ?
___
postgis-users mailing list
postgis-users@postgis.refractions.net
And your description has put an image in my head for the cover art - an
elephant in a tutu dancing on a globe!
charles
On Dec 14, 2011, at 11:40 PM, Chris English wrote:
Santos -
I just put up my layers on qgis
and it is wonderful. I can see why Regina
exuberantly tap dances in her
On Oct 6, 2011, at 5:11 AM, Robert Buckley wrote:
If I have multiple charts which use mulitple queries, am I able to put them
in one php script or do I need a seperate script for each query?
Please excuse me if this should not be posted here...but I consider this more
of a
Hi Regina
I am revisiting this again. How much of a performance difference should one
expect to see between the 32 bit version and the 64 bit version of postgres
when using PostGIS for typical gis queries like filtering by bounding box,
locating nearest points etc? Depending on how I break up
On Aug 29, 2011, at 2:29 PM, Mr. Puneet Kishor wrote:
the data themselves are routine points, lines and polygons (MySQL allows
defining POINT, LINE, POLYGON, or the all-encompassing GEOMETRY). Other than
that, there are the usual MySQL-Pg mismatches such as `mediumint` and
`enum`. I
On Aug 30, 2011, at 10:10 AM, Mr. Puneet Kishor wrote:
Since this is a one-time job, I think I will open two db handles in Perl and
query one and insert in the other. That will work. Yet, surprising that
either a need for this is not as common as I thought it might be, or it is
On Aug 28, 2011, at 5:47 PM, Mr. Puneet Kishor wrote:
I have inherited a bunch of spatial data in MySQL, and I need to move it to
PostGIS for testing and comparison. Suggestions on how this could be done
without corrupting the data?
Can you give us an example of what the data looks like in
On Aug 28, 2011, at 1:22 PM, Marcelo Pereira wrote:
I would like to know the distance between one fixed point (42.331002
-71.112678) and all points in this table.
This is untested but you'd do a self join for this
select p1.longitude, p1.latitude, p2.longitude, p2.latitude, ST_Distance(
On Aug 26, 2011, at 3:50 PM, Paragon Corporation wrote:
You know we do have pretty much latest builds of PostGIS (even trunk on
PostGIS website for windows).
http://www.postgis.org/download/windows/experimental.php
and as far as PostgreSQL -- they have released windows binaries for even
If this is too off topic, please let me know and I'll sign up on a postgres
list to get help. But this is related to my use of postgis and If anyone knows
this stuff, it's you guys.
I have an example query that I expect to be much faster, but my main concern is
we are about to do some
and not null where clause)?
cheers
Ben
On 25/08/2011, at 9:41 PM, Charles Galpin wrote:
If this is too off topic, please let me know and I'll sign up on a
postgres list to get help. But this is related to my use of postgis
and If anyone knows this stuff, it's you guys.
I have
On Aug 25, 2011, at 4:00 PM, fork wrote:
One thing -- while we hope that you ask lots of questions on this list, would
you not top posting, and trimming out non-germane text? Threading and
trimming make a conversation MUCH easier to follow.
My apologies
Also -- if you are developing an
Rob you can do this with geoserver and it's sql view feature. The docs cover
it pretty well.
hth
charles
On Aug 23, 2011, at 12:26 PM, Robert Buckley wrote:
Hi,
I have to use postgis to create a puffer layer. I could do this within
postgis, but the problem is that I have to display the
I assume you mean it takes a long time? The key is to create a buffer around
the point that is as big as you feel necessary to make a match, and then in
your where clause only match lines that intersect this. That way the index is
used to limit the number of candidates to get the distance for.
Chris, just use the postgres copy command to copy out the data you need, and
then copy into your new DB then. It can take an arbitrary sql expression so if
needed do a query that grabs the columns you care about and ignores the
location ones.
hth
charles
On Aug 16, 2011, at 6:28 PM, Chris Gat
Santilli wrote:
On Wed, Aug 10, 2011 at 05:26:06PM -0400, Charles Galpin wrote:
Does anyone know of a way to say this geometry looks [a lot] like this one?
ST_HausdorffDistance
--strk;
___
postgis-users mailing list
postgis-users
I use single forward slashes just fine, but just in case, this has to be run on
the same machine as the server afaik.
charles
On Aug 10, 2011, at 3:28 PM, John Callahan wrote:
Sorry if this is more of a postgres question than postgis...
I'm trying to bring in a CSV table into my postgis
Some background - I have a set of line geometries (happens to be Navteq
streets/links) which we have used the ids of certain links for various reasons
(like we have stored routes based on start/end link, or other edits to enhance
the data). We are looking at upgrading the data and have found
Assuming you can export them in a tab delimited or CSV format, you can use the
copy command to import the data into postgresql.
http://www.postgresql.org/docs/9.0/static/sql-copy.html
hth
charles
On Aug 8, 2011, at 6:11 AM, Robert Buckley wrote:
Hi,
What is the easiest way to load a
Sorry for the somewhat off topic question, but I figured someone here has
probably dealt with this. I am using postgis and am very happy with it, but
for various reasons I need to export some of our data to sql server
periodically and want to automate it, preferably to fit into our existing
I think he's asking for
select st_x(pointcol) as x, st_y(pointcol) as y from his_table;
hth
charles
On May 26, 2011, at 2:40 PM, Paul Ramsey wrote:
If you have byte-level chops then the most efficient call would be to
ask for ST_AsBinary(geom) and then handle the well-known-binary byte
Does anyone have any bright ideas on how to sort linestrings (with postgis or
anything else for that matter).
The idea is I have some set of linestrings which mostly if not all will be part
of an interconnected route or roadway, but not sorted from start to finish in
say a particular
Thanks for responding Steve (and fork)
On Mar 30, 2011, at 7:47 PM, Stephen Woodbridge wrote:
Charles Galpincgalpinat lhsw.com writes:
Does anyone have any bright ideas on how to sort linestrings (with postgis
or anything else for that matter).
ok, need some more criteria here.
But his lat/lon are character varying so I think it would be more like
update mytable set the_geom=ST_GeometryFromText('POINT(' || long || ' ' || lat
|| ')',4326)
On Mar 25, 2011, at 11:26 AM, Stephen Woodbridge wrote:
update mytable set the_geom=st_setsrid(st_makepoint(lon,lat),4326);
On
Why put the images in the database at all? If you leave them on disk and put a
relative path into postgres, you can host them anywhere using apache and the
client can fetch them via url.
charles
On Mar 8, 2011, at 6:32 AM, Paragon Corporation wrote:
300 is nothing. For simplicity especially
David, I believe the (…) as giddy is what is returning the rec. If so you just
need to change it to SET huc = giddy.huc
hth
charles
On Jan 27, 2011, at 5:37 PM, Poynter, David wrote:
Greetings PostGIS list,
I am trying to populate a relate field (huc) in a point table
(permit_sites) from
Just FYI, I have tries upgis_lineshift and in general it does a great job - at
a minimum for visualizing the different paths. However I have found that
sometimes the shifted line doesn't go in the direction you'd expect so you'll
get situations where the shifting switches sides and this can be
Hi All
I have a need to identify roads (in say streets_ny) neighboring the state of
new jersey which I have in streets_nj. I used to do this with a function that
looked for the new york streets near/touching the new jersey roads, then looped
over these roads finding roads near them. I have
the geography format.
To make this work fast the key is to get the indexes working. Do you have
spatial indexes on your geometries? Are the indexes used?
If you need that construction with gid in( it is also important to have an
index on gid,
HTH
Nicklas
2010-12-22 skrev Charles Galpin
Unless it's a typo in your email, you probably need a space between '400' and
'else'. Also make sure the selling price is not a string so the following query
should work
select count(*) from selling1 where price 200 and price 300
Otherwise if they are strings you will need to cast them to
Sebastian, you might want to try something like
EXECUTE 'UPDATE ' || quote_ident(table_name) || ' SET FIELD=' || CAST(''' ||
CAST(geometry as text) || ''' as geometry)
hth
charles
On Dec 3, 2010, at 6:59 AM, Sebastian E. Ovide wrote:
Hi All,
I'm creating a PLPGSQL which has 2 parameters:
Hi John
I ran into this recently. You have to use the 32 bit postgres to use postgis.
Once installed you can use the stack builder to install postgis.
hth
charles
On Nov 5, 2010, at 2:11 AM, John Zhang wrote:
Hi all,
After the successful installation of PostgreSQL 9.0
This may be a stupid question, so excuse me if it is :)
Do I have to install the 32 bit version of postgresql 9.0 to use the 32 bit
PostGIS 1.5.2? I would think yes, but just want to make sure.
I want to install the latest and greatest on a 64 bit windows machine, and just
installed the 64 bit
On May 25, 2010, at 5:43 AM, nguyen liem wrote:
One more question, if i would like to use ST_DWithin in projection WGS84 and
the radius is in 1 meter, how to do that?
As someone else said it depends on the latitude you are dealing with, but you
take the circumference of the earth at your
I'm no expert but the third dimension appears to be supported by most types and
the docs are pretty good about showing this. Take a point for example:
http://postgis.refractions.net/docs/ST_MakePoint.html
You can add a third argument to add the z coordinate. Use ST_Y(point) to
access the
Steve, I get the same results on 1.4 and 1.5 (but they differ from yours)
On 1.4
PostgreSQL 8.4.2, compiled by Visual C++ build 1400, 32-bit
POSTGIS=1.4.1 GEOS=3.2.0-CAPI-1.6.0 PROJ=Rel. 4.6.1, 21 August 2008
USE_STATS
LINESTRING(0 0,4030 0,4030 4030,0 4030);
LINESTRING(0
Even better, thanks!
On May 11, 2010, at 3:15 AM, strk wrote:
On Mon, May 10, 2010 at 11:32:32AM -0400, Charles Galpin wrote:
ST_PointN doesn't work for multipoints,
ST_GeometryN does.
--strk;
() Free GIS Flash consultant/developer
/\ http://strk.keybit.net/services.html
Thanks Maxime!
On May 10, 2010, at 11:47 AM, Maxime van Noppen wrote:
On 05/10/2010 05:32 PM, Charles Galpin wrote:
I searched the archives and saw this asked in 2005 but it didn't appear to
have a resolution then. I have two points in a multipoint geometry which
represent the start
Check out the upgis_lineshift function on
http://trac.osgeo.org/postgis/wiki/UsersWikiplpgsqlfunctions
The resulting line will have endpoints that you want.
hth
charles
On Apr 29, 2010, at 7:10 PM, ots wrote:
Hello,
I have oriented line. The line is given as two points (WGS84). I need to
, it is ok. But I do not
understand, why the distance is too much different.
Thanks, Ota
Charles Galpin-2 wrote:
Check out the upgis_lineshift function on
http://trac.osgeo.org/postgis/wiki/UsersWikiplpgsqlfunctions
The resulting line will have endpoints that you want.
hth
charles
I am not sure I understand the requirement, but I recently used upgis_lineshift
to create lines parallel to other lines (to show bidirectional links as 2 lines)
http://trac.osgeo.org/postgis/wiki/UsersWikiplpgsqlfunctions
hth
charles
-Original Message-
From:
This came up the other day. It's a display limitation of spql or pgadmin. Try
this
select st_length(the_geom), st_asText(st_startpoint(the_geom)),
st_asText(st_endpoint(the_geom)) from MY_GEOMETRY_TABLE limit 1;
You should see all is well.
hth
charles
On Mar 2, 2010, at 9:26 AM, Sebastian
47 matches
Mail list logo