Actually, it's the other way around. Hibernate that has to support PostGIS.
For what I know, Hibernate supports spatial objects and PostgreSQL. PostGIS
is probably included.
On Sun, Oct 21, 2012 at 8:14 PM, lineh arineh wrote:
> hello,
>
> I would like to know if post GIS supports hibernate ?
True :D
On Sat, Sep 29, 2012 at 1:42 AM, Puneet Kishor wrote:
>
>
> On Sep 28, 2012, at 9:31 PM, George Silva wrote:
>
> OMG, I'm sorry,
>
> I've confused the whole thing. I'm awake for a long long time. Way too
> long.
>
>
>
>
I was truly thinking in
SELECT ST_MaxDistance(
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(1,1)),
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(-1,1)));
I had the extra -1 on y there...sorry for the noise.
On Sat, Sep 29, 2012 at 1:31 AM, George Silva wrote:
> OMG, I'm sorry,
>
> I
t; At least, that's what Pythagoras told me once :)
>
> Mathieu.
>
>
> Le 28/09/2012 23:58, George Silva a écrit :
>
>> Hey guys, weird results here...
>>
>> Check this:
>>
>> SELECT ST_MaxDistance(
>> ST_MakeLine(ST_MakePoi
Hey guys, weird results here...
Check this:
SELECT ST_MaxDistance(
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(1,1)),
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(-1,-1)));
-- 2.82842712474619 (this corresponds to 2x sqrt(2)?)
For me the max distance between these polylines is 2.
Or am I expectin
I'll test rc1 against W7 tonight and publish the results :D
Cheers!
On Thu, Mar 29, 2012 at 2:32 PM, Paragon Corporation wrote:
> **
> 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 th
I guess the best way to do this is to combine the actual line and a
"virtual" line, probably a view, with "measured" points.
This involves a bit of thinking but it might be possible.
George
On Wed, Mar 28, 2012 at 3:03 PM, Stephen Woodbridge wrote:
> On 3/28/2012 1:26 PM, Andrés Maneiro wrote:
I don' think anyone understood what you meant.
Can you write a more clear question?
On Wed, Mar 28, 2012 at 8:22 AM, mahavir trivedi
wrote:
> hi
>
> output image problem is that whole image isn't display(first some
> upper widthxheight of input image display)
>
> gdal 1.9
>
>
> with thanks and
ed, but coming into to it cold . . .
> another story. :c)
>
> bobb
>
>
>
>
> >>> George Silva wrote:
>
> Also you can confirm if PROJ4 is installed by:
>
>
> SELECT * FROM POSTGIS_FULL_VERSION();
>
>
> If PROJ4 is installed, it should appear in that
Bob, can you try something like this?
select
st_astext(st_setsrid(st_geomfromtext('POINT(-48 -19)'),4326)) as "wgs84",
st_astext(st_transform(st_setsrid(st_geomfromtext('POINT(-48
-19)'),4326),29192)) as "sad69-utm22"
Here are my results:
"POINT(-48 -19)" ; "POINT(815865.331177955 7896471.32478
Also you can confirm if PROJ4 is installed by:
SELECT * FROM POSTGIS_FULL_VERSION();
If PROJ4 is installed, it should appear in that string.
George
On Tue, Mar 6, 2012 at 3:48 PM, Mike Toews wrote:
> On 7 March 2012 06:10, Bob Basques wrote:
> > ...
> >ST_AsText(ST_Transform(ST_S
I dont think so Bob.
Check this out:
In this case the table still exists
create table srid_inexistent_test(
> id serial not null);
> select * from
> addgeometrycolumn('public','srid_inexistent_test','the_geom',99,'POINT',2);
> NOTA: CREATE TABLE criará sequência implícita
> "srid_inexistent
Aggregators, AFAIK, can filter posts based on specific tags.
George
On Thu, Feb 23, 2012 at 12:38 PM, Pierre Racine wrote:
> Can we avoid, with aggregators, to have plenty of post not related to
> PostGIS?
>
> > -Original Message-
> > From: postgis-users-boun...@postgis.refractions.net
Hi Pierre,
In Brazil we have this sort of blogs and these multi-author blogs are
becoming very common. It's a good thing :D
The PostGIS Blog is a good a idea. Let me know if you need help.
George
On Thu, Feb 23, 2012 at 12:14 PM, Pierre Racine wrote:
> Hi all,
>
> With the venue of PostGIS 2.
Hello Mike,
What kinda of software will be used to do this?
Most GIS softwares can depict line hatchings without needing it physically
exists on the database. Each line of the hatch has a special meaning for you
or no?
If so, you should consider using a proper style, that will do that without
gi
ooops, prior to max use st_length!
On 4/26/11, George Silva wrote:
> hello marcello. what is your data model? dependng on the data model
> (if you have a column, lets say, rivername) you can use a group by
> clause and st_collect on your geometry field. ex:
>
> select rivername,
hello marcello. what is your data model? dependng on the data model
(if you have a column, lets say, rivername) you can use a group by
clause and st_collect on your geometry field. ex:
select rivername, max(st_collect(the_geom)) from rivers group by rivername
the intersects clause its up to you ,
I don't know the inner functioning of QGIS, but perhaps it should scan
geometry_columns first and only then try to figure out the geometry?
George
- Original message -
>> > I noticed this really inefficient query when QGIS was importing a
>> Postgis
>> > layer:
>> > *select distinct case
This works for me:
SELECT
st_asText(ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50,4)),
st_astext(ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50,'quad_segs=4'));
---
"POLYGON((150 90,146.193976625564 70.8658283817455,135.355339059327
54.6446609406727,119.134171618255 43.8060233744357,100 40,80
To eliminate the problemas presented by Paul, create a regular grid of 1x1
degrees and populate it randomly with points. Then make your test. All
square polygons will have 4 vertexes and the test is "less biased".
George
On Thu, Nov 25, 2010 at 3:22 PM, Paul Ramsey wrote:
> Depends on who you t
se where PostGIS (with pgRouting or another tool) is used. As I said, I
> must show a successful project where this technology has been applied.
>
> Any idea?
>
> --
> Mauricio Miranda
> Chief Development Officer
> http://www.xoomcode.com
>
>
>
>
> On Nov 2
Hello Mauricio,
Check pgRouting:
http://pgrouting.postlbs.org/
PostGIS also has a built-in topology module, but I'm not sure how much
people use it.
George
On Tue, Nov 2, 2010 at 7:46 PM, Mauricio Miranda wrote:
> Does anyone know about a network analysis project built using PostGIS? It
> sho
I'm sorry, I don't know german. Can't help you with that.
For what I could understand is that the relation
> uberschwemmungsgebiete existiert nicht
doest not exist. Are you sure the table exists?
It should work, my current version works.
If you can translate the error would be nice :P
I'll
t;;"midlandgis_test";"base";"wtr_mainvalves";"status";1;1
>>
>> Furthermore, I tried enabling another table with no foreign keys - no
>> problem there.
>>
>> Looking into the function code, it appears to be looking for a primary key
&
Looking into the function code, it appears to be looking for a primary key
> to use in the history table, but I can't immediately see an easy way to
> differentiate between a pk and fk in the key_column table.
>
> Anyone have any ideas?
>
> Lee
>
>
> ---
all that led to files being absent?
> More important, where
> can I get the history-tables scripts?
> Thanks!
> Mark
>
> On Tue, Aug 3, 2010 at 10:33 AM, George Silva
> wrote:
> > Since PostGIS 1.5, there is a implementation shipped with the software.
> >
> &
Since PostGIS 1.5, there is a implementation shipped with the software.
Check out PostgreSQL folder under share\contrib\Postgis1.5\ and there might
be a folder history-tables, which contains all the scripts needed to track
changes in a table.
George
On Tue, Aug 3, 2010 at 11:22 AM, Dominik Wiedn
Hello Dominik,
What do you mean by versioned? Please explain - as PostGIS has a logging set
of functions, but not versioned databases.
Are you referring to PostGIS History Tables or something else?
George
On Tue, Aug 3, 2010 at 4:20 AM, Dominik Wiedner wrote:
> Hi there,
>
> Currently I try to
Hello guys,
I'm not sure, but I would like to know what are the meaning of the
parameters ipx and ipy on ST_MakeEmptyRaster. Is it pixel size?
Thanks!
--
George R. C. Silva
Desenvolvimento em GIS
http://blog.geoprocessamento.net
___
postgis-users mai
t.sql
> in the source tree.
>
>
>
> Pierre
>
>
>
> *From:* postgis-users-boun...@postgis.refractions.net [mailto:
> postgis-users-boun...@postgis.refractions.net] *On Behalf Of *George Silva
> *Sent:* 21 juillet 2010 09:59
> *To:* PostGIS Users Discussi
Hello guys,
I'm trying to write a function to calculate flow direction using SQL, in
moving windows of 9x9 pixel size.
How can I write a output raster? What is the way to create a specific
raster?
George
--
George R. C. Silva
Desenvolvimento em GIS
http://blog.geoprocessamento.net
___
Nevermind, I'm sorry to bother. Had to install the binaries. Somehow that
got through me.
George
On Wed, Jul 21, 2010 at 9:24 AM, George Silva wrote:
> Hello guys,
>
> I'm using: "POSTGIS="1.4.0" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21
Hello guys,
I'm using: "POSTGIS="1.4.0" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21
August 2008" USE_STATS" with PostgreSQL 8.3 and* *I'm having some problems
using gdal2wktraster.
I have successfully installed WKTRaster:
postgis_raster_lib_build_date()
"2010-06-21 17:52:45"
postgis_raster_lib_
Hello Dominik,
Although it's not a versioning system, PostGIS has a Historic Tables module.
You can find it in extras folder.
Att
George
On Tue, Jul 20, 2010 at 9:29 AM, Ralf Suhr wrote:
> http://gis.hsr.ch/wiki/images/4/44/Postgis_historisierung.pdf
>
> Am Dienstag 20 Juli 2010, 14:08:35 sch
It worked just fine. Thanks.
George
On Mon, Jul 19, 2010 at 1:50 PM, George Silva wrote:
> Yeap Pierre, this is 8.3.
>
> I'll do that and i'll get back to you. Thanks for the quick answer.
>
> George
>
>
> On Mon, Jul 19, 2010 at 1:27 PM, Pierre Racine <
intgeom”
>
>
>
> with
>
>
>
> “SELECT ST_Intersection((gv).geom, $1) AS intgeom”…
>
>
>
> I’ll fix the source.
>
>
>
> Pierre
>
>
>
> *From:* postgis-users-boun...@postgis.refractions.net [mailto:
> postgis-users-boun...@postgis.
While we are at it, I've tried installing and there it complains about an
error here:
My download link was:
http://www.postgis.org/download/windows/pg83/experimental/wktraster/wktraster_pg83.zip
I've already placed all my files at the correct place. What is the name of
the environment variable fo
YOu might check out the Linear Referencing Functions available.
http://postgis.refractions.net/docs/reference.html#Linear_Referencing
George
On Tue, Jul 13, 2010 at 8:58 PM, salas wrote:
> Hi,
>
> I need to know like to implement the dynamic segmentation in postgis
>
> ¿ What tool can i use f
The hardest thing is (as Steve said) it seems more of a higher level
application thing. PostGIS could leverage a datamodel to separate vertexes,
boundaries, areas, etc and even map what is common for each geometry, but I
think it would be really hard to enforce such dynamic events (editing
mostly).
Congratulations on the great job done!
George
On Tue, Jun 29, 2010 at 12:55 PM, Nicolas Ribot wrote:
> Waoo !
> Real nice.
>
> Thank you for this work.
>
> Nicolas
>
> On 29 June 2010 17:29, Pierre Racine wrote:
> > Hi everybody,
> >
> > I'm pleased to announce that you can now do intersections
Do you mean intersection?
Check out the manual and here:
http://blog.geoprocessamento.net/2010/05/funcoes-postgis-3/
The scond one is in portuguese, but there is a translator.
George
On Mon, May 31, 2010 at 6:00 AM, salas wrote:
> Hi, there are one function that possibility obtain one list of
Build a view with that query. Register the geometry in geometry_columns
table and you're set. But remov that AsText, otherwise you wont have a
geometry column.
George
On Tue, May 18, 2010 at 3:07 PM, sunpeng wrote:
> hi, now,i know how to use quartum gis to load a postgres table with gemetry
>
Yea, this is very cool indeed.
George
On Thu, May 6, 2010 at 3:33 PM, David Fawcett wrote:
> Doesn't OpenSource suck!!!
>
>
> On Mon, May 3, 2010 at 11:49 PM, John Abraham
> wrote:
> > One of the things I miss about using ESRI's GIS is the ability to do
> dot-density maps. Within a polygon, th
es anyone have any pointers to algorithms for producing this
> effect?
>
> George Silva wrote:
>
>> The really big problem with dot density is that dots can overlap
>> themselves,
>> masking the real number, so if anything will be developed in this area,
>> the
&g
The really big problem with dot density is that dots can overlap themselves,
masking the real number, so if anything will be developed in this area, the
points should be
A) evenly distributed
or
B) randomly distributed, but with some sort of "colision" tests, so there is
no or little overlap.
Thi
>From what i understood of your request, you need to collect all the polygons
and merge in a single one. Use the St_Collect function to do that.
The bounding box function will give you the extent of the whole, as you
described. This is default behavior.
Att
On Mon, May 3, 2010 at 9:28 AM, Oscar
That's great news!
George
On Fri, Apr 23, 2010 at 2:30 PM, Abram Gillespie <
abe.gillespie.li...@gmail.com> wrote:
> The next full version release of zigGIS (3.0) will return to an OSI
> approved open source license. We think this is the right move to
> return the power back to the GIS communit
As Daniel stated, data is crucial to the success of a routing project. The
problem is not to have the road names (usually that is standart) but to have
turn tables and correct information about street flow.
pgRouting will provide you what you need for it, but your dataset must be
good.
George
On
Great! I´ve been waiting for pl/r for a while. Very nice.
Thank you all for the great work.
George
On Mon, Feb 22, 2010 at 11:04 PM, Paragon Corporation wrote:
> The PostGIS 1.5.0 windows installer is now up on Stack Builder.
>
> New major change to it is that it is packaged with the shp2pgsql
This is very weird. Very weird. I have experience with Esri SDE and if you
are working with OGC standarts everything should work fine.
Did you registered all your tables trough ArcSDE? If not, you need to do it.
OLE Connections will only let you handle tabular information, so let that
go. It's no
You can select the interval between minimun and maximum timestamp outside
each polygon. Interpolate to get a value "when entering" the polygon
(intersection between line and polygon) and when leaving.
Then you can subtract both values to get an estimate of time.
You probably can write a simple fu
oral side of PostGIS.
>
> Thanks...
>
> Sinan
>
> ------
> *From:* George Silva
> *To:* PostGIS Users Discussion
> *Sent:* Monday, October 5, 2009 5:31:04 PM
> *Subject:* Re: [postgis-users] PostGIS temporal support
>
> Yes, but that w
Yes, but that will largely depend on your database model.
We are working to add "versioning" support to PostGIS.
George
On Mon, Oct 5, 2009 at 11:28 AM, sinan keskin wrote:
> Hi,
> I want to study on spatial & temporal databases.
> I read some document about PostGIS and it is written that *Pos
There are many analysis techniques that uses 3x3, 5x5, 7x7, 9x9
windows. In particular, in block statistics and focal statistics.
There are functions that are used to determine the flow of a raster
(higher cell flows to lower cell), euclidean distance, best path, and
many others!
Also, this may be
Just placing some shapefile into a geographic SRID will not convert it to
correct coordinates.
What you need to is:
UPDATE foo_table SET the_geometry_field =
ST_TRANSFORM(the_geometry_field,NEW_SRID);
Att
George
On Fri, Sep 11, 2009 at 4:34 PM, Mac Martine wrote:
> Hello-
> I'm a total newb
Hello Gianvito,
AddGeometryColumns does an additional operation, which is updating the table
public.geometry_columns, used by most of OS GIS software to find out what is
the column that contains the geometry, it's type and SRID. Also this
function creates all the constraints necessary to use these
Hello all!
I´ve been trying to help the postgis community by building this type of
feature. This was asked in trac, as shown here:
http://trac.osgeo.org/postgis/ticket/180
Well, i came up with a solution (check v03.sql) that will create some
functions to help create and manage these historic tabl
etry));
> st_astext -
> LINESTRING(0 0,1 1,1 0,0 0)
> (1 row)
>
> Can you isolate the geometry that is causing you grief?
> -- Kevin
>
>
> George Silva wrote:
>
>> Hello everyone.
>>
>> I'm trying to build a function that will
Hello everyone.
I'm trying to build a function that will transforma one polygon into many
lines. I have a lot table, and i would like to insert each line from each
lot in a table, containing the id of the lot.
I've tried: SELECT gid, St_boundary(the_geom) INTO lines from lots and
postgis gave me
, 2009 at 1:48 PM, Aurora Geomatics
wrote:
> Thank you George,
> On 3-Apr-09, at 9:22 AM, George Silva wrote:
>
> Hello Aurora,
>
> In ArcGIS it's all different. In PostGIS you can use simple/complex SQL
> queries to "calculate values" in a similar fashion of arcgis
Hello Aurora,
In ArcGIS it's all different. In PostGIS you can use simple/complex SQL
queries to "calculate values" in a similar fashion of arcgis.
The simplest of them all would be, in your case:
ALTER TABLE table1 ADD COLUMN area_column double precision;
UPDATE table1 SET area_column = ST_AREA
1) How you use PostGIS?
To manage urban streets network and traffic accidents data.
2) What you find useful about it over anything else?
THere are many things. I have a ESRI background, and the ability to wrap
multiple functions for analysis is a mega plus (without the need to build
dozens of
Hello Simon and PostGIS users.
I have received you conversor i still could not work with it.
Our project in sourceforge did not moved since we last talked. My new
job taking up a lot of time and now ill be sent to field.
I would like to invite anyone that wishes to continue the sourceforge
p
Sure thing! Just have patiente because im swamped with work and thesis.
Give me a few days ;)
George
Webb Sprague escreveu:
On Fri, Aug 22, 2008 at 8:59 AM, George Silva <[EMAIL PROTECTED]> wrote:
I just would like to thank you all who helped me in this search.
Thanks a lot ev
I just would like to thank you all who helped me in this search.
Thanks a lot everyone.
George
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hello lists,
As you can i see im mailing this message to some lists around the web
(im sorry if thats a problem).
At the moment i am writing my BSc thesis (Geography) focusing the
development of a open source software and database for logging and
analysing traffic accidents in Uberlândia, MG
Yes!
2 for points, lines and polygons that dont have a Z value.
George
Edward Bridges escreveu:
Hmmm.
Ok so when I added the column, the paramters I passed where:
SELECT AddGeometryColumn('', 'point', 'coordinate', 600613, 'POINT', 0);
where 0 was the result of st_dimension, so should it be:
Some time ago, in this list there was a discussion about data models.
Is anyone carrying out that idea? I remember that there was a buzz around a
pipeline data model, and im wondering if that ever happened.
Im willing to contribute too, im building a data model(for my thesis in
college) for traff
Hello all again,
I´m curious. I´ve said in qgis list and some other 'desktop' GIS software
lists that the biggest feature missing for OSGIS is something like the
'auto-complete' polygon in ArcGIS,, that would make life much easier.
I´ve been reading some things, and i´ve seem people mentioning tr
osure or distribution is
> prohibited. If you are not the intended recipient, please contact the sender
> by reply e-mail and destroy all copies of the original message.
>
> (My corporate masters made me say this.)
>
>
>
> -Original Message-
> From: [EMAIL PROTECT
Thanks Robert. Will try that.
What should i look for?
George
On Wed, May 14, 2008 at 3:45 PM, Burgholzer,Robert <
[EMAIL PROTECTED]> wrote:
> BTW - I always dump the output of shp2pgsql to a text file, so that I can
> look at the SQL insert statements if there is a problem.
>
> Robert W. Burghol
Its not something urgent. I was giving it a try, so dont worry. I needed
only for study actually.
Its not something urgent!
Thanks for all the responses.
George Silva
On 5/2/08, Mike Leahy <[EMAIL PROTECTED]> wrote:
>
> Just to make sure nobody's waiting on me for anything...
Regina
>
>
> --
> *From:* [EMAIL PROTECTED] [mailto:
> [EMAIL PROTECTED] *On Behalf Of *George Silva
> *Sent:* Wednesday, April 30, 2008 10:47 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Line To Path
>
> In the same t
In the same trailing of that question and the answer, that select statement
would run the function st_union in that table, without the need to create a
new table or geometry column?
Sorry to use this post for this, just tought its a quite novice question, so
more people could use the answer.
Thx
Hello everyone,
I have a converted dataset that has only polygons, but they were imported
from ArcGIS as Multipolygons. I need them to become simple polygons. (I dont
have any real multi-polygons in the table - they were just imported that
way.
How can i convert this dataset to regular tyep polyg
Hello everyone,
Im quite a novice in the Open GIS world, and i would like to know if
theres any client out there that connects to PostGIS and has a
Autocomplete polygon tool (like in arcGis).
Thanks for your time
Att.
George Silva
___
postgis
when i create a postgis database i use a clean template_postgis database
(create at time of instalation) as template. Is this a ok / correct
practice?
Att.
George
Nicolas Ribot escreveu:
I'm planning to use database schemas to organize my spatial tables. For
example, all spatial tables of GI
Amazing this skeletonizer. I will definetly give it a try, and will give a
try with JUMP.
On 1/18/08, Martin Davis <[EMAIL PROTECTED]> wrote:
>
> Have a look at this:
>
> http://www.jump-project.org/project.php?PID=SK&SID=OVER
>
> Eric Yu wrote:
> > Hi,
> >
> > Suppose I have a long shaped polygo
Well, firstof all we need to divide the work, and then put it together. if
everyone gets two tables (and their relationships) the work would be
completed pretty fast.
aditional relationships can be made after all its done.
george
On 1/14/08, Burgholzer,Robert <[EMAIL PROTECTED]> wrote:
>
> OK,
The great part of this data model is the use of linear referencig. does
postgis support linear referencig? or any software that works with it?
im happy to help with all data models you guys are interested in building.
just drop me a line
george
On 1/14/08, Abram Gillespie <[EMAIL PROTECTED]> wr
Gustavo Ces escreveu:
You can´t export a geodatabase ( i supose your model is just that) by
odbc, because the geometric logic is not transfered ( can you export a
geodatabase in arcgis to postgis?) I think you have to rewrite the
model, adapting it to postgis. Is a hard work, but the you can us
I can supply it to you in .xml, if thats of any help.
Im quite new to the postGIS and pg world, but afaik there are no CASE
tools for pg. There is any?
Let me know.
George
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http:/
Abram Gillespie escreveu:
Does anyone know if there are scripts available to create the PODS and
/ or APDM structure in PostGIS?
Thanks!
-Abe
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/li
83 matches
Mail list logo