rjpawley at shaw.ca
Tue May 27 14:37:43 PDT 2008
I want to explore your thought of using 'boxes' as targets.
Is there some method of placing one box beside another without knowing the
I've seen the operators (>>) but I can't find how to do anything with them
other than querying their position.
----- Original Message -----
From: "Chris Hermansen" <chris.hermansen at timberline.ca>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, May 26, 2008 6:05 PM
Subject: Re: [postgis-users] srid
> Or, in another direction... Bob, if your "geometrical data" is meant to
> be something like a "data flow diagram" or a "process diagram", you can
> surely do that with PostGIS.
> Doubtless you must be aware of tools like Visio (in Windoze) or Dia (in
> Linux or Windoze) that are made for drawing diagrams like "data flow",
> but nevertheless you've decided to put your data into PostGIS instead.
> Then you probably want to make some "boxes" in your process diagram
> appear above, below, to the right of, or to the left of, other boxes.
> To do that, you would need to define some kind of partial order on the
> boxes (this box is to the right of that box, etc). This sounds like a
> topological sort to me.
> Presumably you could turn that topological ordering into some set of
> offsets that could be applied to compute coordinates of each box.
> is that where you're trying to end up?
> Andy Anderson wrote:
>> On May 26, 2008, at 3:06 PM, Bob Pawley wrote:
>>> However, I attempting to interpret functions made for geographic data
>>> to use with geometric data.
>>> I have PostgreSQL tables which represent engineering processes.
>>> I want to display that data in a graphical form - hopefully using
>>> Postgis - - - if I can translate the functions (or the Postgis
>>> concept) into a form that I can use.
>> Hmmm... if all you want to do is display X-Y data, I would suggest
>> using geographic coordinates, e.g. SRID = 4326 (WGS84 datum), which
>> most programs will display by default with X and Y rectilinear.
>> However, you earlier said you wanted to use ST_Transform(geometry,
>> integer), which implies you want to switch between different geographies.
>> So it sounds like you need to pick a particular projection for your work.
>> Is your geography spherical or spheroidal? If so, you might want to
>> define your own datum. If not, you'll need to use a projection to a
>> flat surface. What's more important, that it be conformal
>> (equiangular) or equal area or that it preserve distance in one
>> -- Andy
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
> Chris Hermansen mailto:chris.hermansen at timberline.ca
> tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644
> Timberline Natural Resource Group · http://www.timberline.ca
> 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users