Re: [postgis-users] Allocating house numbers to a parcel table
Dear Simon, Each of the street segments have no attributes related to house numbers. The only relationship is whether the parcels are to the left or right of a particular street segment - furthermore house numbers were never allocated to any of the parcels. On 21 March 2012 00:47, Simon Greener wrote: > ** > Sindile, > > Questions: What is the source of the house numbers? Does a "particular > street segment " contain house numbering > in attributes - From_Left/To_Left/From_Right/To_Right (or equivalent > naming)? > > S > On Tue, 20 Mar 2012 23:39:46 +1100, Sindile Bidla > wrote: > > I have two tables (street and parcel) in my Postgis database and I would > like to perform the following: > 1. Select a particular street segment > 2. Select all parcels to the left or right of 1 > 3. Update a field in parcels selected in 2 with numbers (odd numbers if to > the left of 1 or even numbers if to the right of 1. > > This is to allow me to allocate house numbers to my parcel table. > > > > > -- > Holder of "2011 Oracle Spatial Excellence Award for Education and > Research." > SpatialDB Advice and Design, Solutions Architecture and Programming, > Oracle Database 10g Administrator Certified Associate; Oracle Database 10g > SQL Certified Professional > Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, > Radius Topology and Studio Specialist. > 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia. > Website: www.spatialdbadvisor.com > Email: si...@spatialdbadvisor.com > Voice: +61 362 396397 > Mobile: +61 418 396391 > Skype: sggreener > Longitude: 147.20515 (147° 12' 18" E) > Latitude: -43.01530 (43° 00' 55" S) > GeoHash: r22em9r98wg > NAC:W80CK 7SWP3 > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Allocating house numbers to a parcel table
I have two tables (street and parcel) in my Postgis database and I would like to perform the following: 1. Select a particular street segment 2. Select all parcels to the left or right of 1 3. Update a field in parcels selected in 2 with numbers (odd numbers if to the left of 1 or even numbers if to the right of 1. This is to allow me to allocate house numbers to my parcel table. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Query to select features that are parallel and perpendicular
Anyone who can offer advice on on building a query to accomplish the following within the same line feature - roads: 1. create a new table or view of all line features that are parallel to a selected line feature within the same line feature 2. create a new table or view of all line features that are perpendicular to a selected line feature within the same line feature ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Topology Pledge: completed !
Thanks strk,
I was trying to use the topology functions.
UPDATE public.sa_provinces
SET topogeom = toTopoGeom(the_geom, 'sa_provinces_topo');
I get the following message:
ERROR: function totopogeom(geometry, unknown) does not exist
LINE 2: SET topogeom = toTopoGeom(the_geom, 'sa_provinces_topo');
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Before running this function i used SET serch_path TO topology, public;
Any pointer what might i be doing wrong.
On 30 January 2012 14:47, Ben Madin wrote:
> Thanks strk,
>
> this is great news - thank you for your efforts,
>
> cheers
>
> Ben
>
>
> On 30/01/2012, at 7:49 PM, Sandro Santilli wrote:
>
> > As of revision 8963 (included in upcoming 2.0.0alpha3 [1]), the function
> > to convert simple layers to topologically defined layers [2] is
> completed.
> >
> > [1] 2.0.0alpha3 http://www.postgis.org/download/
> > [2] toTopoGeom http://trac.osgeo.org/postgis/ticket/1017
> >
> > This means that building a persistent topology for your
> public.states.geom
> > layer would be as simple as this:
> >
> > SELECT CreateTopology('states_topo');
> > SELECT AddTopoGeometryColumn('states_topo',
> > 'public', 'states', 'topogeom',
> > 'POLYGON');
> > UPDATE public.states
> > SET topogeom = toTopoGeom(geom, 'states_topo');
> >
> > You can then check correctness of the conversion:
> >
> > SELECT gid FROM public.states WHERE NOT ST_Equals(geom, topogeom);
> >
> > Look for area overlaps:
> >
> > SELECT r1.element_id FROM states_topo.relation r1, states_topo.relation
> r2
> > WHERE r1.topogeo_id != r2.topogeo_id AND r1.element_id = r2.element_id;
> >
> > Or underlaps:
> >
> > SELECT face_id FROM istat_topo.face WHERE face_id > 0
> > AND face_id NOT IN ( SELECT element_id FROM istat_topo.relation );
> >
> > Perform any editing required to clean things up [3], or to simplify the
> edges.
> > You can take a look at the primitives with QGIS db_manager plugin [4],
> or even
> > at the actual TopoGeometries with QGIS master [5] (although it will be
> slow in
> > selecting features within the viewport, see ticket #1290 [6]).
> >
> > [3]
> http://strk.keybit.net/blog/2011/11/21/topology-cleaning-with-postgis/
> > [4] qgis db_manager http://www.qgis.org/wiki/DB_Manager_plugin_GSoC_2011
> > [5] QuantumGIS http://www.qgis.org
> > [6] overlap TopoGeometry http://trac.osgeo.org/postgis/ticket/1290
> >
> > And of course you can convert TopoGeometries back to simple geometries
> when needed
> > for performance or compatibility reasons:
> >
> > ALTER TABLE public.states ADD newgeom geometry;
> > UPDATE public.states SET newgeom = topogeom::geometry;
> >
> > Happy edge walking!
> > http://strk.keybit.net/blog/2012/01/28/a-walk-on-the-wild-side/
> >
> >
> > C L O S I N GC R E D I T S
> >
> >
> > I was able to dedicate my time to the implementation of the toTopoGeom
> > function thanks to the contribution of a disparate group of people and
> > companies putting a part of the money each to reach the bigger target:
> >
> > Andrea PeriAnne Ghisla R3 GIS
> > Silvio Grosso GFOSS (gfoss.it) Cooperativa Alveo
> > AusVet Ingvild Nystuen Luca S. Percich
> > Richard Greenwod Andreas Neumann Oslandia
> >
> > A special thank goes to Andrea Peri for his initial kick-starter
> contribution
> > which allowed me to set an affordable target for the pledge.
> >
> > Also thanks to the Geographical Free and Open Source Software association
> > (GFOSS) for the help with reducing paperwork involved in handling all the
> > contributions.
> >
> > --strk;
> >
> > ,--o-.
> > | __/ |Thank you for PostGIS-2.0 Topology !
> > | / 2.0 |http://www.pledgebank.com/postgistopology
> > `-o--'
> >
> > ___
> > postgis-users mailing list
> > postgis-users@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> --
>
> Ben Madin
>
> t : +61 8 6102 5535
> m : +61 448 887 220
> e : b...@ausvet.com.au
>
> AusVet Animal Health Services
> P.O. Box 5467
> Broome WA 6725
> Australia
>
> AusVet's website: http://www.ausvet.com.au/
>
> This transmission is for the intended addressee only and anyone else
> subscribed to this mailing list. Clearly then it is not confidential
> information. If you have received this transmission in error, sorry. The
> contents of this email are the opinion of the writer only and are not
> endorsed by AusVet Animal Health Services unless expressly stated
> otherwise. Although AusVet uses virus scanning software we do not accept
> liability for viruses or similar in any attachments. Congratulations on
> reading this boring and probably completely unnecessary bit - you may be
> the only person
Re: [postgis-users] How to configure Postgis/Postgresql to use with QGIS
Hello, Can you please provide what steps you have carried out and what platform are you using. On 29 December 2011 03:37, Daniel Montenegro wrote: > Hi there! > > I've installed Postgis but I'm not being able to create a "spatial" table > with a geometry column in Postgresql. Actually, I think I still didn't get > all the steps to configure postgis in postgresql. > > I really need some help! > > Thanks a lot, > > > Daniel > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How do you install multiple versions of Postgis on a single database cluster
Thank you On 27 October 2011 17:48, Sandro Santilli wrote: > On Thu, Oct 27, 2011 at 12:01:14AM +0200, Sindile Bidla wrote: > > I am running ubuntu 11.10 with PostgreSQL 9.1 with Postgis 1.5.3 > installed > > via apt. I would also like to test Postgis 2.0 on the same database > cluster > > any advise on how to proceed. > > > > I have already downloaded Postgis 2.0 from > > http://postgis.refractions.net/download/postgis-2.0.0SVN.tar.gz > > ./configure --with-topology --with-raster && make && make check && > sudo make install > > createdb pgis20_tests > createlang pgis20_tests plpgsql > psql -f postgis/postgis.sql pgis20_tests > > Then you have your old databases using 1.5.3 and the new database > using 2.0.0SVN. > > Don't miss to also install GEOS-3.3.1 for getting most out of topology > (install it _before_ building the new postgis). > > --strk; > > () Free GIS & Flash consultant/developer > /\ http://strk.keybit.net/services.html > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] How do you install multiple versions of Postgis on a single database cluster
I am running ubuntu 11.10 with PostgreSQL 9.1 with Postgis 1.5.3 installed via apt. I would also like to test Postgis 2.0 on the same database cluster any advise on how to proceed. I have already downloaded Postgis 2.0 from http://postgis.refractions.net/download/postgis-2.0.0SVN.tar.gz ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Creating street centrelines from cadastre
I wonder if it would be possible to be able to create street centrelines as in this illustration http://www.ian-ko.com/ET_GeoWizards/UserGuide/createCenterlines.htm with Posting ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Error in accessing a Postgis database - function box3d(box3d_extent) is not unique
I am using ArcGIS with the Data Interoperabilty Extension to access a
Postgis database and I get the following error: Error executing SQL query
('SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_proposed"'): 'ERROR: function box3d(box3d_extent) is not
unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_propos...
^
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.
Below is the complete log:
2011-05-31 16:55:26| 0.1| 0.0|INFORM|Data Interoperability (20101013 -
Build 6233 - WIN32)
2011-05-31 16:55:26| 0.1| 0.0|INFORM|Feature Manipulation Engine 2010 SP3
(ESRI DESKTOP) (Build 6233)
2011-05-31 16:56:38| 10.7| 10.6|INFORM|Loaded module 'POSTGIS' from file
'C:\Program Files (x86)\ESRI\Data Interoperability
Extension\plugins/postgis/POSTGIS.dll'
2011-05-31 16:56:38| 10.7| 0.0|INFORM|FME API version of module 'POSTGIS'
matches current internal version (3.6 20090807)
2011-05-31 16:56:38| 10.7| 0.0|INFORM|Opening POSTGIS reader for dataset
'geodb'
2011-05-31 16:56:43| 12.0| 1.3|INFORM|PostgreSQL 8.4.8 on
x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro
4.5.2-8ubuntu4) 4.5.2, 64-bit
2011-05-31 16:56:43| 12.0| 0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:45| 12.0| 0.0|INFORM|PostGIS client encoding: 'LATIN1'
2011-05-31 16:56:45| 12.0| 0.0|INFORM|Using Dynamic Reader $Revision:
62876 $ ( $Date: 2009-08-27 11:28:55 -0700 (Thu, 27 Aug 2009) $ ) with
module POSTGIS to read data from dataset `geodb'
2011-05-31 16:56:48| 12.0| 0.0|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:56:51| 13.3| 1.3|INFORM|FME Configuration: Source coordinate
system for reader R_1[POSTGIS] set to `EPSG:4326' as read from input data
2011-05-31 16:56:54| 15.5| 2.2|INFORM|Coordinate System `EPSG:4326'
parameters: CS_NAME=`LL84' DESC_NM=`WGS84 datum, Latitude-Longitude;
Degrees' DT_NAME=`WGS84' EPSG=`4326' GROUP=`LL' MAP_SCL=`1' PROJ=`LL'
QUAD=`1' SCL_RED=`1' SOURCE=`Mentor Software' UNIT=`DEGREE'
2011-05-31 16:56:54| 15.5| 0.0|INFORM|Coordinate System `EPSG:4326' as OGC
Well Known Text: GEOGCS["WGS84 datum, Latitude-Longitude;
Degrees",DATUM["WGS_1984",SPHEROID["World Geodetic System of 1984, GEM
10C",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433],AUTHORITY["EPSG","4326"]]
2011-05-31 16:56:54| 15.6| 0.1|INFORM|FME API version of module 'POSTGIS'
matches current internal version (3.6 20090807)
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Opening POSTGIS reader for dataset
'geodb'
2011-05-31 16:56:54| 15.6| 0.0|INFORM|PostgreSQL 8.4.8 on
x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro
4.5.2-8ubuntu4) 4.5.2, 64-bit
2011-05-31 16:56:54| 15.6| 0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:54| 15.6| 0.0|INFORM|PostGIS client encoding: 'LATIN1'
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Successfully closed POSTGIS database
reader
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Merged 1 schema features read from 1
datasets into 1 resulting feature types
2011-05-31 16:57:04| 17.0| 1.3|ERROR |Error executing SQL query ('SELECT
BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_proposed"'): 'ERROR:
function box3d(box3d_extent) is not unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_propos...
^
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.
'
2011-05-31 16:57:05| 17.2| 0.2|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:09| 20.2| 3.0|STATS
|POSTGIS::__CollectionTest(TestFactory): Tested 10 input feature(s) -- 0
feature(s) passed and 10 feature(s) failed
2011-05-31 16:57:09| 20.2| 0.0|STATS
|POSTGIS::__DeaggCollections(DeaggregateFactory): Split 0 input feature(s)
into 0 point-in-polygon feature(s), 0 donut polygon(s), 0 polygon(s), 0
line(s), 0 point(s), and 0 aggregate(s)
2011-05-31 16:57:09| 20.2| 0.0|STATS
|POSTGIS::__AggregateHomo(AggregateFactory): Combined 0 input feature(s)
into 0 output feature(s), including 0 singleton(s)
2011-05-31 16:57:14| 20.6| 0.5|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:51| 33.9| 13.2|INFORM|... Last line repeated 10 times ...
2011-05-31 16:57:51| 33.9| 0.0|INFORM|Loaded module 'fmeprompter' from
file 'fmeprompter.dll'
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Which naming convention to use
When talking about Postgis and PostgreSQL which is the correct: Postgis/PostgreSQL or PostgreSQL/Postgis. -- Sent from my mobile device Sindile Bidla Tel: 0823408538 Fax: 0865246419 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
