Hi Regina and Bob,
Wow, IDEF in PostGIS.
Awhile back I struggled with rendering IDEF node layouts for simple
IDEF web navigation and ended up using the xml DB eXist
(http://exist.sourceforge.net/ ) for my store and then exporting to SVG for
rendering. I could then use something like jung
Hi Antonio,
The scripts are a replacement for the spatial_ref_sys table. In my
scripts instead, spatial_ref_sys is a view (meaning that it is a
description of what data is requested, it is constructed on-the-fly, the
data is automatically collected from the original EPSG tables) which is
compliant
I've been working around one minor issue and it occurred to me that
someone here might be able to explain the rationale for its design.
I start with a shapefile of US states, which to me appears to be a set
of multipolygons, one for each state. So, for example, Hawaii is a
single multipolyg
Sorry, that subject line should have been "shp2pgsql". That question
will come later, I'm sure! :-)
On May 27, 2008, at 4:20 PM, Andy Anderson wrote:
I've been working around one minor issue and it occurred to me that
someone here might be able to explain the rationale for its design.
I st
Hi!
I have created random point over a territory and I want to calculate the density
for each random point. I do it by calculating the number of point of interest
(POI) I found in a buffer of 250 meters for each random point on my territory.
My problem is that my query take too much time for no
You have a misconception. If it's a multipolygon in the shape file, it
will be a multipolygon in postgis. When you open up the table view of
your file in ArcView, how many rows are devoted to Hawaii? One, or 27?
P
On Tue, May 27, 2008 at 1:23 PM, Andy Anderson <[EMAIL PROTECTED]> wrote:
> Sorry,
(a) The ST_Transform() function is making your spatial index
un-usable, because your spatial index is against the raw coordinates
of your data.
(b) You are using ST_Buffer() instead of just calculating a distance.
So, first transform your data to your working projection.
Then, use ST_DWithin() to
I have a basic tool built using xmlstartlet that can convert any of the ESRI
GeoDatabase data models (as XML Schema of the GeoDatabase) to Oracle SQL.
Modifying to convert to PostGIS is pretty trivial. The converter already
converts the SewerStorm data model. It creates the domain tables, main t
Re: "You have a misconception. If it's a multipolygon in the shape
file, it will be a multipolygon in postgis. "
No misconception in that regard. The issue was that I expected there
to be a one-to-one feature correspondence, and it appeared that there
wasn't.
But digging further back in
Hi Chris
I want to explore your thought of using 'boxes' as targets.
Is there some method of placing one box beside another without knowing the
actual coordinates.
I've seen the operators (>>) but I can't find how to do anything with them
other than querying their position.
Bob
- Ori
I am having issues with splitting a polygon with a line. I do the
intersection, then extract the lines of the polygon. Then I attempt to
geomunion the LINESTRINGS together and get something like this
('MULTILINESTRING((597002.205895278 324851.044018193,597118.930687031
324409.678399375,596848.
I guess if you had, say, a two level structure to your data:
1. process A
1.1 sub-process A-i)
1.2 sub-process A-ii)
2. process B
2.1 sub-process B-i)
2.2 sub-process B-ii)
2.3 sub-process B-iii)
for example, then this "conceptually" places one box beside another
without knowing the actual coordi
Hello everyone!
Once again i come to your expertise.
I have a MULTILINESTRING layer (logradouros) and a test point layer.
What i want to do is to locate the midpoint of a specific road and place
a point into it.
Well, the roads layer have these informations nomelog(name of the road),
prefix
Nevermind, got it to work fine.
This is the final code, so if anyone has a similar problem:
*
create or replace function interpola_centro(text,text,text) returns
geometry as
$$
declare
geo_ponto geometry;
geometria geometry;
begin
geometria:= (select the_geom from logradouros where nomelog=$1
14 matches
Mail list logo