Hi Luigi:
yes, I also see the problem, there are at least two steps, step1: zip all
shapefile and upload. step 2: extract zip file, and import to certain
database. Maybe there is one way or some people are already working on it. I
am think whether possible translate OGR2OGR or Shp2pgsql into
Luigi et al,
If you use a Java environment, you would want to look at Geotools (can
parse shapefiles to Postgis)
and a servlet or JSP set-up for multi-part request processing on the
server. If you are familiar with
Groovy and Grails, I can recommend that to make the coding a lot easier.
GL
Hi,
I have polygon features in PostgreSQL database. How can i make
a query to find all polygons that are within a distance of say 1m from
polygon id = 100. Query should not select polygons that are within polygon
id = 100.
I used ST_WIthindistance, but it selcted all insidepolygons too. Please
Have you tried
SELECT a.gid, a.the_geom
FROM a INNER JOIN b ON (b.gid = 100 AND ST_DWithin(a.the_geom, b.the_geom,1)
)
WHERE NOT ST_Within(a.the_geom, b.the_geom)
Hope that helps,
Regina
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian
Sanjeewa Rupasinghe
Sent:
Or use the OS gis-viewer QuantumGIS (www.qgis.org) it has a plugin called
SPIT which allows you to load the file in QGIS and then upload to PostGIS...
--
Barend Köbben
International Institute for Geo-Information
Sciences and Earth Observation (ITC)
PO Box 6
7500AA Enschede, The Netherlands
+31
Hi Xian,
there is some bindings to ogr (phpogr, pyrhon etc). Maybe you should see
something.
Why you want to upload shp files direct to PostGIS via web? Is there really
need? Are you trying to make some type of WFS with this data?
Maybe is there some other solution for your problem.
[]'s
hi every body:
I'm in the same problem, I need upload a shape file to postgis via web, but
in the existing table, for example I have a table called mosaico, and
contains 2182 rows and need insert to final.
well I'm working with PHP, somebody helpme please
--
Sergio Ortuño Lopez
Hi Xiaoyu,
Geolabs is at the origin of the opensource Web-GIS Mapjax
(http://mapjax.org/mapjax/) project :
The main pieces of software where Mapjax is based on are :
- Postgresql/PostGIS
- GDAL/OGR libraries
- UMN Mapserver : PHP Mapscript
Mapjax has his own web-based backoffice to build up
Hi,
Is it possible to do 3d buffer for point or polygon.
thanks
_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vistamkt=en-USform=QBRE___
postgis-users
Can you define what a 3D buffer is?
eehab hamzeh wrote:
Hi,
Is it possible to do 3d buffer for point or polygon.
thanks
Discover the new Windows Vista Learn more!
Paul Ramsey wrote:
PS : The whole song-and-dance with the ST_Transform is so I can create
a proper circular buffer using a metric distance (meters = 1609 *
miles) around a geographic point (degrees).
Paul, yes. Thats fine, except I see you are using NAD datums/projections.
If these types of
I recall asking this question before (with tongue in cheek).
Point -- Sphere
Line -- Sausage
Polygon -- Extrusion
I imagine if you were to look at this practically, each point would be
buffered to a sphere for a given geometry and then tangent planes would
be added. The inner facing surfaces
I am using the following function that works quite well.
However, the center of the geometry (arrowhead) is moved to the center of
the geometry.
Is there someway of applying an offset so that the point of the arrow can be
moved so it is touching the boundary of the geometry??
Bob
Insert
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Welp, I think I have given up on trying to do the union inside PostGIS
because I can't make it fast and reliable. Instead I have decided to use
Java2D to perform the union. I ended up doing the same thing with
Oracle. Both Oracle and PostGIS have
It's your bad luck to have geometries that make PostGIS fail... 8^)
If there's geometries which cause problems with certain operations, the
most helpful thing to do is to post them along with a description of the
problem. That gives a fighting chance to fix them when further
development is
Mike,
FWIW: The unioning operations currently in PostGIS are very inefficient.
We are working on improving the union operation in PostGIS and hopefully
will have at least a first draft to show in the next release. Most notably
porting the JTS logic for doing Cascaded Unions to PostGIS.
This
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
It's your bad luck to have geometries that make PostGIS fail... 8^)
If there's geometries which cause problems with certain operations,
the
most helpful thing to do is to post them along with a description of
the
problem. That gives a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
FWIW: The unioning operations currently in PostGIS are very
inefficient.
Do I guess right that PostGIS iterates over each geometry and unions it
with the result of all previous geometries, something like this:
java.awt.geom.Area area
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
The original code for ST_SimplifyPreserveTopology comes from JTS. You
can either use the library directly, or try JEQL for a command-line
interface to it. You can find both at http://tsusiatsoftware.net/
Ah ha, I see that now. Do you think the
Quite possibly... at the moment Java's memory mngmt is beating out the
memory handling in GEOS.
Bresnahan, Mike wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
The original code for ST_SimplifyPreserveTopology comes from JTS. You
can either use the library directly, or try JEQL
I am having a really hard time getting going with PostGIS on Windows. I read
the documentation but it is mostly written for *nix users, and I have
trouble translating the instructions into something I can do on WIndows (XP
SP2).
One particular issue I am up against now is figuring out how to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
I type
pgsql2shp -f ..\dump -h localhost -p 5432 postgis postgres WIN1252
- -P
somepassword
and I get back
FATAL: password authentication failed for user Tara
But I don't have a pg user called Tara, just postgres...
Try adding -u
22 matches
Mail list logo