Ahmet Temiz | 16 Nov 13:27 2014
Picon

postgis table from another postgis table in different projection?

How can I create  postgis table from another postgis table in different projection?


regards


--
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Planlama ve Zarar Azaltma Dairesi Başkanlığı


________________________

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Paragon Corporation | 16 Nov 05:41 2014
Picon

FOSS4G NA 2015 - Last day for submissions November 17th

Just a friendly reminder to folks who aren't aware.

The FOSS4G NA 2015 conference will be held in the San Francisco, California
area this year: March 9th-12th.
PostgreSQL Day will be co-hosted with it on March 10th 2015.

Talk submission deadline for FOSS4GNA 2015 ends this Monday November 17th.
Accepted speakers get free admission to the main conference.

Hint Hint: dustymugs

Thanks,
Regina Obe
FOSS4G NA 2015 Program Committee Member 
PostGIS PSC Member
http://www.postgis.us
http://postgis.net
Martin Landa | 13 Nov 18:49 2014
Picon

geocoding

Hi all,

I would like to geocode addresses in my DB which are located in Czech
Republic. I was thinking to use Nominatim, does anyone here have an
experience with such task?

Thanks in advance, Martin

--

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.eu/mentors/landa
Andy Anderson | 12 Nov 17:33 2014
Picon

Geographic Type Documentation Correction

Hi, I just noticed that on this page:


there are a number of references to “sphere” when they should instead say “spheroid”, and to “great circle arc” when they should instead say “geodesic”.

This is clear from the subsequent discussion, in particular in the FAQ section:


where it says 

4.2.3.1.

Do you calculate on the sphere or the spheroid?

By default, all distance and area calculations are done on the spheroid. You should find that the results of calculations in local areas match up will with local planar results in good local projections. Over larger areas, the spheroidal calculations will be more accurate than any calculation done on a projected plane.

All the geography functions have the option of using a sphere calculation, by setting a final boolean parameter to 'FALSE'. This will somewhat speed up calculations, particularly for cases where the geometries are very simple.


So in

4.2. PostGIS Geography Type

the corrected documentation would change:

The basis for the PostGIS geographic type is a sphere. The shortest path between two points on the sphere is a great circle arc. That means that calculations on geographies (areas, distances, lengths, intersections, etc) must be calculated on the sphere, using more complicated mathematics. For more accurate measurements, the calculations must take the actual spheroidal shape of the world into account, and the mathematics becomes very complicated indeed.

to:

The basis for the PostGIS geographic type is a spheroid, a “squashed” sphere whose polar diameter is smaller than its equatorial diameter. The shortest path between two points on the sphere is a great circle arc, and on a spheroid it’s a similar arc called a geodesic. That means that calculations on geographies (areas, distances, lengths, intersections, etc) will provide more accurate measurements, but the calculations must take the actual spheroidal shape of the world into account, and the mathematics becomes very complicated indeed.

and in

4.2.3.3. What is the longest arc you can process?

the corrected documentation would change:

We use great circle arcs as the "interpolation line" between two points. That means any two points are actually joined up two ways, depending on which direction you travel along the great circle. All our code assumes that the points are joined by the *shorter* of the two paths along the great circle. As a consequence, shapes that have arcs of more than 180 degrees will not be correctly modelled.

to:

We use geodesics as the "interpolation line" between two points (these are great circle arcs on spheres). That means any two points are actually joined up two ways, depending on which direction you travel between them. All our code assumes that the points are joined by the *shorter* of the two paths. As a consequence, shapes that have arcs of more than 180 degrees will not be correctly modeled.

Cheers,

— Andy

_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Rémi Cura | 12 Nov 17:41 2014
Picon

no .bat in windows zip installers

Hey everybody.
The 2 bat files
makepostgisdb_using_extensions.bat
and
makepostgisdb.bat

seems to have vanished from the zip release file for version newer than 2.1.1 (postgis-bundle-pg93x64-2.1.1)

I'm I missing something?
thanks,
cheers,
Rémi-C

_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Paul Ramsey | 12 Nov 17:09 2014
Picon

Re: FileGDB curves

Correct, the curves were likely ruined on the way through GDAL. In
some ways, fortunate they ever got through at all.

On Wed, Nov 12, 2014 at 7:48 AM, Bborie Park <dustymugs <at> gmail.com> wrote:
> If I remember correctly, curve geometries are not currently supported in
> GDAL/OGR. There is a GDAL RFC making the rounds for adding curve support...
>
> http://trac.osgeo.org/gdal/wiki/rfc49_curve_geometries
>
> -bborie
>
> On Wed, Nov 12, 2014 at 7:44 AM, Andy Colson <andy <at> squeakycode.net> wrote:
>>
>> Shoot.  I changed the command to:
>>
>> ogr2ogr
>>   -f PostgreSQL
>>   -t_srs EPSG:3857
>>   'PG:dbname=gis'
>>   WCWebDataCC.gdb
>>   -lco FID=gid
>>   -lco SPATIAL_INDEX=OFF
>>   -lco GEOMETRY_NAME=the_geom
>>   -lco SCHEMA=washingtonmn
>>   -lco PRECISION=NO
>>   streets
>>
>>
>> (removing the -nlt) and I still get a MULTILINESTRING, and it still looks
>> the same.
>>
>> The ogr2ogr is part of a perl script, and the first command I posted was
>> my guess at what it generated, which was a little off.  The command above is
>> correct.
>>
>> I'm not sure what else to try.
>>
>>
>> -Andy
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users <at> lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users <at> lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Andy Colson | 12 Nov 00:00 2014
Picon

FileGDB curves

Hi All,

Not sure where the best place to ask this, so I'll start here.

I have a FileGDB that contains some curved lines, I import it into 
PostGIS and they come out as chopped off Multiline.

Here are some screen shots to help explain:

Here is arc viewing the .gdb:
http://testmaps.camavision.com/arc.png

Here is qgis viewing PostGIS:
http://testmaps.camavision.com/qgis.png

I tried to get arcCatalog to export to shapefile, but something went bad 
and I cannot even look at the .shp files.

Any hints how I can get the curve back?

Thanks for your time,

-Andy
Jerry Locke | 10 Nov 22:09 2014

Trouble installing PostGIS using MacOSx

Background

-----------------------------

OS version: Mac OS X 10.9.5

Postgres: 9.2.5_1 via Homebrew

PostGis: 2.1.4_1 via Homebrew

-----------------------------


Competed installation and am stuck with the following error when running

extension creation -


-- Enable PostGIS (includes raster)

CREATE EXTENSION postgis;

-- Enable Topology

CREATE EXTENSION postgis_topology;

-- fuzzy matching needed for Tiger

CREATE EXTENSION fuzzystrmatch;

-- Enable US Tiger Geocoder

CREATE EXTENSION postgis_tiger_geocoder;


OUTPUT

----------------------------------------


ERROR:  could not access file "$libdir/postgis-2.1": No such file or

directory

********** Error **********


ERROR: could not access file "$libdir/postgis-2.1": No such file or

directory

SQL state: 58P01

----------------------------------------


Thanks- Jerry

_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Christopher Braune | 10 Nov 12:41 2014
Picon

simple polygon clip

Dear all,

I want to clip polygons like this:


<!-- /* Font Definitions */ <at> font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-536870145 1073786111 1 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;} <at> page WordSection1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 2.0cm 70.85pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> I tried the following SQL-sentences:

CREATE TABLE aoi_blocks AS
SELECT *,
    ST_Difference(aoi.geom, lines.buffer_geom)
    FROM aoi, lines;

I get polygons, but not only the difference polygons!

Thanks for all replies!
Christopher
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
dandrigo | 31 Oct 18:32 2014

Import gpx files into Postgis db (windows)?

Dear all,

I'm working with windows 8 & postgis 2.1.

I have several gps (gpx) files. I would like to import directly those gpx
files into my postgis database. 

What would be the easiest way?

In advance, thank you to throw light for me. 

Regards. 

--
View this message in context: http://postgis.17.x6.nabble.com/Import-gpx-files-into-Postgis-db-windows-tp5007255.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
Guillaume Drolet | 31 Oct 15:17 2014
Picon

Topology: cannot delete slivers (or gaps)

Hi!

I'm am turning to you all hoping you'll have some tricks to help with
this problem:

I created a topology for 2290 polygons and populated a topogeom column
using these commands:

SELECT topology.CreateTopology('de_20k_topo', find_srid('syshiera',
'de_20k', 'geom_32198'), 1e-4);
SELECT topology.AddTopoGeometryColumn('de_20k_topo', 'syshiera',
'de_20k', 'topogeom', 'MULTIPOLYGON');

DO $$DECLARE r record;
BEGIN
  FOR r IN SELECT * FROM syshiera.de_20k LOOP
    BEGIN
      UPDATE syshiera.de_20k SET topogeom = toTopoGeom(geom_32198,
'de_20k_topo', 1, 1e-4)
      WHERE gid = r.gid;
    EXCEPTION
      WHEN OTHERS THEN
        RAISE WARNING 'Loading of record % failed: %', r.gid, SQLERRM;
    END;
  END LOOP;
END$$;

-- For testing:
SELECT topology.CopyTopology('de_20k_topo', 'de_20k_topo_tests');

I need to fix 1) extra nodes along edges that are not at an
intersection and 2) sliver polygons.

For cases in 1, I was successful using 'ST_NewEdgeHeal' and a plPgsql script.

For cases in 2, I can remove some slivers with 'ST_RemEdgeModFace' but
some of them I just can't delete:

I get either:

ERROR: TopoGeom 1123 in layer 1 (de_20k_topo_tests.LAYER1.) cannot be
represented healing faces 1514 and 1502

Or, when trying with remove a node with 'topology.ST_NewEdgeHeal':

ERROR:  SQL/MM Spatial exception - other edges connected (3912)

In this particular example, two edges are connected two the same two
nodes, similar to what was discussed here:

http://postgis.17.x6.nabble.com/PostGIS-1955-Exception-when-2-edges-passed-to-ST-ModEdgeHeal-that-are-attached-to-the-same-2-nodes-td4999383.html

But according to that discussion thread, this was fixed in an earlier
version (I'm using topology version 2.1.3).

Maybe my problem is different but I'll need your help to get it
sorted. Here's an example showing the small face (1502) I want remove:

https://dl.dropboxusercontent.com/u/5196336/example1.bmp

Thanks for your help!

Gmane