Re: [postgis-users] Reporting service on PostgreSQL/PostGIS

[Matthew Baker]

Pradeep,

We've been experimenting with a few different reporting tools for 
PostgreSQL:


*Jaspersoft Studio*
http://community.jaspersoft.com/project/jaspersoft-studio

*LibreOffice Base*
https://help.libreoffice.org/Common/Report_Builder

Both seem to be pretty robust ... Jaspersoft exposes the code of the 
report for added customization of the reports...


-Matt Baker
Denver Public Schools
Denver, CO, USA
mattba...@gmail.com




On 6/20/2017 7:00 AM, Pradeep wrote:


Hi,

Please help me ,anyone can updated for the below request.

Regards

Pradeep Kanth

Ext : 3026

*From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] 
*On Behalf Of *Pradeep

*Sent:* Friday, June 16, 2017 10:16 AM
*To:* postgis-users@lists.osgeo.org
*Subject:* [postgis-users] Reporting service on PostgreSQL/PostGIS

Hi,

Could please let me know, how to generate reporting services on 
PostgreSQL or PostGIS database.


If anyone knows, please suggest to us how to generate those reports .

Regards

Pradeep Kanth

GeoSpatial Services,
Avineon India Private Limited

*Disclaimer *| The information contained in this electronic message 
(including any attachments) is intended for the exclusive use of the 
addressee(s) and may contain confidential or privileged information.If 
you have received this in error, please notify the sender immediately 
and delete the material from your machine. Any  action including 
review, retransmission, dissemination of this email or the attachments 
present along with the email by persons or entities other than the 
intended recipient is prohibited.






*Disclaimer *| The information contained in this electronic message 
(including any attachments) is intended for the exclusive use of the 
addressee(s) and may contain confidential or privileged information.If 
you have received this in error, please notify the sender immediately 
and delete the material from your machine. Any  action including 
review, retransmission, dissemination of this email or the attachments 
present along with the email by persons or entities other than the 
intended recipient is prohibited.






___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] Documentation on <#> and <-> operators

[Matthew Baker]

Hi all!

I'm trying to figure out what the <#> and <-> operators mean with PostGIS.

I have gotten them to work but I'm not exactly sure what is going on 
under the hood... and also, for whatever reason, cannot seem to use 
those operators as search terms for GIS.SE, Google, etc.


Thanks!

Matt Baker
Denver Public Schools
Denver, CO
mattba...@gmail.com


___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] SUM: Creating an 'editable' view in PostGIS

[Matthew Baker]

All,

Thanks to Russel Mercer who corrected my logic - this works great, and 
we'll be implementing this for several sets of map label placement! (see 
response below).


Regarding Richard Greenwood's suggestion that we use geometry to store 
the label placement - in theory and a bit of practice, the QGIS 
x($geometry) / y($geometry) label placement expression values *do* work 
for displaying labels - but QGIS doesn't allow you to move the labels 
when they are assigned to the geometry x,y - so we would be moving the 
feature itself, which doesn't lend itself to an intuitive label 
placement workflow.


Added to that, what we're trying to do is build a table we use for 
cartography that pulls from 3 separate tables - one of which will store 
all the label placement properties for upwards of 8 printed maps, all at 
various scales and sizes.


So for the time being, using LABEL_X, and LABEL_Y fields and updating 
the properties using QGIS and editable views works great!


Thanks again everyone!

-Matt Baker

Denver, CO



On 9/16/2016 3:37 PM, Russell Mercer wrote:

Matt,

It looks like you are on the right track with your view and rules 
setup.  I think your primary issue may be that each of the rules is 
trying to act on the view to do the insert, update, delete, as opposed 
to acting on the underlying table.


For example, instead of this:

|--delete rulecreateorreplace 
rule"delete_label"asondeletetoschools_district_map do instead 
deletefromschools_district_map whereoid =old.oid; |

|Try this |
|--delete rule |
|create or replace rule "delete_label" as |
|on delete to schools_district_map do instead |
|delete from temp_schools_label |
|where oid = old.oid; |
This way, you are directing the delete command to redirect to the 
underlying table instead of sticking with the view itself, which will 
always be read only.  If you change each of your rules to reflect the 
same, you should have better luck.


Hope that helps,
Russell


On Fri, Sep 16, 2016 at 1:36 PM, Matthew Baker <mattba...@gmail.com 
<mailto:mattba...@gmail.com>> wrote:


Hi all,

I've asked this on GIS.SE <http://GIS.SE>, to no avail:

I'd like to store label placement properties in a separate table,
build a view of the data I want to use for my map, and use QGIS to
move the labels manually. The idea is when the labels are updated,
the placement coordinates would go into the LABEL_X and LABEL_Y
fields in the label placement table, but the geometry of the
underlying points and several other attributes (coming from the
source tables) would remain unchanged.

However, when all is in place, QGIS throws the following error
when trying to save the edits to the view (the edit session can
start, labels moved, but cannot save):

|Could notcommitchanges tolayer schools_district_map
Errors:ERROR:1attribute value change(s)notapplied.Provider
errors:PostGIS error whilechanging attributes:ERROR:infinite
recursion detected inrules forrelation "schools_district_map" |||

Here is the definition of the view :

|CREATEORREPLACE VIEWpublic.schools_district_map

ASSELECTsch.schnum,sch.oid,sch.abbreviation,sch.school_level,sch.geom,l.label_x,l.label_y
FROMtemp_schools_label sch LEFTJOINdistrict_map_labels l
ONsch.schnum =l.schnum;|

And here are the rules I've applied to make the view 'editable':

|--delete rulecreateorreplace
rule"delete_label"asondeletetoschools_district_map do instead
deletefromschools_district_map whereoid =old.oid;--insert
rulecreateorreplace
rule"insert_label"asoninserttoschools_district_map do instead
insertintoschools_district_map
(label_x,label_y)values(new.label_x,new.label_y);--update
rulecreateorreplace
rule"labels_update"asonUPDATETOschools_district_map do instead
updateschools_district_map setlabel_x =new.label_x ,label_y
=new.label_y whereoid =new.oid;|

QGIS is then set to display the labels using the label_x and
label_y field.

I used this post as a guide to build the view, rules:


http://gis.stackexchange.com/questions/88120/how-to-set-posgis-default-sequential-value-in-a-qgis-editable-view

<http://gis.stackexchange.com/questions/88120/how-to-set-posgis-default-sequential-value-in-a-qgis-editable-view>

If anyone can spot where I might have left something out, or if
there is a glaring oversight on my part, OR if this is maybe a bad
idea... let me know!

Thank you!!!

-Matt Baker
Denver Public Schools
Denver, CO



___
postgis-users mailing list
postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/postgis-users
<http://lists.osgeo.org/mailman/listinfo/postgis-users>




___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] Creating an 'editable' view in PostGIS

[Matthew Baker]

Hi all,

I've asked this on GIS.SE, to no avail:

I'd like to store label placement properties in a separate table, build 
a view of the data I want to use for my map, and use QGIS to move the 
labels manually. The idea is when the labels are updated, the placement 
coordinates would go into the LABEL_X and LABEL_Y fields in the label 
placement table, but the geometry of the underlying points and several 
other attributes (coming from the source tables) would remain unchanged.


However, when all is in place, QGIS throws the following error when 
trying to save the edits to the view (the edit session can start, labels 
moved, but cannot save):


|Could notcommitchanges tolayer schools_district_map 
Errors:ERROR:1attribute value change(s)notapplied.Provider 
errors:PostGIS error whilechanging attributes:ERROR:infinite recursion 
detected inrules forrelation "schools_district_map" |||


Here is the definition of the view :

|CREATEORREPLACE VIEWpublic.schools_district_map 
ASSELECTsch.schnum,sch.oid,sch.abbreviation,sch.school_level,sch.geom,l.label_x,l.label_y 
FROMtemp_schools_label sch LEFTJOINdistrict_map_labels l ONsch.schnum 
=l.schnum;|


And here are the rules I've applied to make the view 'editable':

|--delete rulecreateorreplace 
rule"delete_label"asondeletetoschools_district_map do instead 
deletefromschools_district_map whereoid =old.oid;--insert 
rulecreateorreplace rule"insert_label"asoninserttoschools_district_map 
do instead insertintoschools_district_map 
(label_x,label_y)values(new.label_x,new.label_y);--update 
rulecreateorreplace rule"labels_update"asonUPDATETOschools_district_map 
do instead updateschools_district_map setlabel_x =new.label_x ,label_y 
=new.label_y whereoid =new.oid;|


QGIS is then set to display the labels using the label_x and label_y field.

I used this post as a guide to build the view, rules:

http://gis.stackexchange.com/questions/88120/how-to-set-posgis-default-sequential-value-in-a-qgis-editable-view

If anyone can spot where I might have left something out, or if there is 
a glaring oversight on my part, OR if this is maybe a bad idea... let me 
know!


Thank you!!!

-Matt Baker
Denver Public Schools
Denver, CO


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] CREATE EXTENSION postgis fails with "ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect"

[Matthew Baker]

For what it's worth, the Ubuntu/Debian install was causing this same 
problem from the PostgreSQL APT repository


What was happening was when installing the postgresql-contrib package, 
it was defaulting to the 9.5 version of the package, and so was 
installing another instance of PostgreSQL - so versions 9.4 and 9.5 were 
starting up.


So when I tried to install the postgis extension, it was giving a 
similar error - I believe because it was trying to create the extension 
in the 9.5 version of PG, while PGIS was installed in the 9.4 version


By forcing the version of postgresql-contrib to 9.4, it illeviated the 
problem:


sudo apt-get install postgresql-9.4-postgis-2.1 pgadmin3*postgresql-contrib-9.4*

Not sure if there is an equivalent problem going on...

(I've updated the Ubuntu/Debian instructions here:)

https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

-m



On 1/15/2016 7:35 AM, Paul Ramsey wrote:

Thanks for confirming, I've notified the pgdg packager.
P

On Fri, Jan 15, 2016 at 6:25 AM, Paul Edwards  wrote:

Sorry for the spam, but as you suspected:

  yum deplist postgis2_95
bunch of dependencies
dependency: geos >= 3.4.2


On Friday, January 15, 2016 at 9:20:33 AM UTC-5, Paul Edwards wrote:

Was debugging the exact issue yesterday. Updating GEOS to 3.5 did the
trick for me. This is the version of geos provided for in the pgdg95 repo.



On Thursday, January 14, 2016 at 9:13:13 AM UTC-5, Paul Ramsey wrote:

Check the versions of the GEOS rpm you have installed, and also check
the "requires" declarations for the postgis rpm. Probably you'll find
the GEOS rpm is version 3.4 and that the postgis rpm doesn't declare a
dependency for geos 3.5. See if you can track down a GEOS 3.5 rpm.

P

On Thu, Jan 14, 2016 at 2:04 AM, Moti Umansky  wrote:

I have reproduced the issue when installing with yum install from the
internet.

I think there is something wrong with the last version installation on
Oracle Linux (or Red Hat).

Has anyone succeeded to install the last version on Oracle Linux or Red
Hat?



Thanks,

Moti





From: Moti Umansky
Sent: יום א 10 ינואר 2016 18:08
To: 'postgi...@lists.osgeo.org'
Subject: CREATE EXTENSION postgis fails with "ERROR: could not load
library
"/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so:
undefined symbol: GEOSClipByRect"



Hi



I'm trying to install the new 9.5 Postgres version with Postgis 2.2
(downloaded from

https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)



When I issue "CREATE EXTENSION postgis", I'm getting :



ERROR:  could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so":
/usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect



OS : Oracle Linux 6U7

Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled
by gcc
(GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"



I have tried to reproduce the issue on Postgres 9.4.5 downloaded from

https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.



The issue was not reproduced.



Thanks,

Moti


Powered By Office365

The information contained in this communication is intended solely for
the
use of the individual or entity to whom it is addressed and others
authorized to receive it.
It may contain confidential or legally privileged information.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance on
the
contents of this information is strictly prohibited and may be
unlawful.
If you have received this communication in error, please notify us
immediately by forwarding this email to mail...@ness.com and then
delete
it from your system.
Ness technologies is neither liable for the proper and complete
transmission
of the information contained in this communication nor for any delay in
its
receipt.

___
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] How to cast geometry to 'varbinary' in PostGIS / PostgreSQL

[Matthew Baker]

Hi all,

Does anyone have any thoughts to the problem below?

In MSSQL Server, casting geometry to varbinary(max) produces a string 
that looks like this:


|0x3D0B010CA0F3BE3B5CE9474100EC414E3AF93941|

When you insert that string into a geometry column, a geometry object is 
built.


However, I can't seem to find out what the equivalent data format is in 
PostGIS / PostgreSQL in order to bring that same varbinary format out of 
a PostGIS geometry column (for the purpose of loading it into an MSSQL 
Server Geometry object).


I've read that the 'bytea' format does the same as varbinary, but the 
bytea version of a PostGIS geometry object looks like this:


|\001\001\000\000\346\020\000\000\263\234\021o\224?Z\300-\265\373^\322\334C@|

Is there a way to get the same string that the MSSQL varbinary format 
produces from PostGIS / PostgreSQL?


Some background into this: I'm developing my own ETL tools using Python...

*psycopg2* works well with PostgreSQL (PostGIS) database conversion - 
and PostgreSQL casts geometry to varchar in a SQL statement in my python 
script, which inserts nicely back into a PostGIS geometry column - 
PostGIS ETL done!


*pypyodbc* is working great for the receiving end of a psycopg2 query, 
but as the problem above states, I can't find the correct format to cast 
the PostGIS geometry to in the SQL in the python script... otherwise, I 
can read other columns from PostgreSQL and write them to MSSQL just fine.


I've posted this to GIS.SE too... (hope that's ok...)

http://gis.stackexchange.com/questions/177620/how-to-cast-geometry-to-varbinary-in-postgis-postgresql

Thanks in advance for any thoughts or suggestions!

-Matt Baker
Denver Public Schools
Denver, CO
mattba...@gmail.com



___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] SUM: How to cast geometry to 'varbinary' in PostGIS / PostgreSQL

[Matthew Baker]

So the path I took was, as suggested by Paul (and I assumed I would have 
to anyway) was to:


- Select the geometry as ST_AsText from the PG source table
- create a geom_temp column of varchar(max) type in the MSSQL 
destination table

- dump the geometry text into geom_temp column in MSSQL
- When the ETL is done, use STGeomFromText to update the MSSQL geometry 
column

- delete the geom_temp field
- done!

Again all in python using psycopg2 (postgres) and pypyodbc (mssql server)

Oh and any spatial function in PostGIS can be used to transform the data 
(ie. for us, re-project to State Plane for our MSSQL clients) on the fly...


So this is the best spatial ETL solution I've seen so far - no more 
meddling with Talend or GeoKettle... and no more FME either! (Although 
my needs are small, the MSSQL portion was a thorn in my side...)


Thanks again!!!

-m



On 1/20/2016 1:52 PM, Paul Ramsey wrote:

Hi Matt,

varbinary and bytes are the "same" insofar as they hold an array of
bytes. there's no guarantee though, that geometry->varbinary in
sqlserver going to produce the same thing as geometry->bytes in
postgresql.

As a for-example, the sqlserver varbinary example you show about
doesn't start with 00 or 01. That means it's not valid WKB (which
start with a zero or one byte to flag the endianness). It's "something
else". This could crimp your style.

0x3D0B 010C A0F3BE3B5CE9474100EC414E3AF93941

It looks like it might end with two doubles, so perhaps it's a point?
That should be WKB type 01, but I don't see a 0001 anywhere, which
is what the WKB type number would look like (int32 type)

Anyways, your best bet is going to be going via WKB, so maybe work on
wrapping your PostGIS calls in ST_AsBinary or ST_AsEWKB (for 3d/4d
objects). To get hex encoded text versions, just wrap the bytes
outputs in an 'encode' function, like

select encode(st_asbinary(geom), 'hex') from my_table

ATB,

P



On Wed, Jan 20, 2016 at 12:17 PM, Matthew Baker <mattba...@gmail.com> wrote:

Hi all,

Does anyone have any thoughts to the problem below?

In MSSQL Server, casting geometry to varbinary(max) produces a string that
looks like this:

0x3D0B010CA0F3BE3B5CE9474100EC414E3AF93941

When you insert that string into a geometry column, a geometry object is
built.

However, I can't seem to find out what the equivalent data format is in
PostGIS / PostgreSQL in order to bring that same varbinary format out of a
PostGIS geometry column (for the purpose of loading it into an MSSQL Server
Geometry object).

I've read that the 'bytea' format does the same as varbinary, but the bytea
version of a PostGIS geometry object looks like this:

\001\001\000\000 \346\020\000\000\263\234\021o\224?Z\300-\265\373^\322\334C@

Is there a way to get the same string that the MSSQL varbinary format
produces from PostGIS / PostgreSQL?

Some background into this: I'm developing my own ETL tools using Python...

psycopg2 works well with PostgreSQL (PostGIS) database conversion - and
PostgreSQL casts geometry to varchar in a SQL statement in my python script,
which inserts nicely back into a PostGIS geometry column - PostGIS ETL done!

pypyodbc is working great for the receiving end of a psycopg2 query, but as
the problem above states, I can't find the correct format to cast the
PostGIS geometry to in the SQL in the python script... otherwise, I can read
other columns from PostgreSQL and write them to MSSQL just fine.

I've posted this to GIS.SE too... (hope that's ok...)

http://gis.stackexchange.com/questions/177620/how-to-cast-geometry-to-varbinary-in-postgis-postgresql

Thanks in advance for any thoughts or suggestions!

-Matt Baker
Denver Public Schools
Denver, CO
mattba...@gmail.com




___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2.1 and PostgreSQL 9.3 on Ubuntu 14.0.4 (Trusty) with PostgreSQL apt Repo

[Matthew Baker]

Just tested this out again on a fresh Ubuntu 14.04.1 VM and it works great!

(also works with QGIS installed so I don't see any conflicts here...)

Thanks again, Regina!

-m


On 8/8/2014 6:08 PM, Paragon Corporation wrote:

I know some people were complaining on the list about being able to install
PostGIS on Ubuntu trusty.
I finally spun up a Trusty VM 64-bit and was able to successfully install
using Apt PostgreSQL repo.

I've updated the wiki instructions:

http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

Hopefully this helps others.  Let me know if the updates don't work for you.


Thanks,
Regina
http://www.postgis.us
http://postgis.net


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[postgis-users] Ubuntu installation guide - review?

[Matthew Baker]

Hi all,

I've been refining a (fairly) simple installation guide for Ubuntu which 
pulls from from the Postgresql apt repository. I wonder if anyone might 
have a look at it and let me know if its ok.


I have placed the PDF here:

https://drive.google.com/file/d/0Bxh7puyDgHHoV1llRVlkb3NDUk0/edit?usp=sharing

It will install:

Postgresql 9.3
PGAdmin3 v1.18
PostGIS 2.1
QGIS 2.0

Any feedback is appreciated!

Thank you,

-m

--

Matthew Baker mattba...@gmail.com 909-647-8058 @mapbaker

sent from Thunderbird on Ubuntu

___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[postgis-users] Installing on Ubuntu via Postgresql APT repository

[Matthew Baker]

All,

Just for kicks yesterday I tried installing Postgresql 9.3 on Ubuntu 
from their APT repository.


I also added a postgis flag in there and it seems to have all come in 
very nicely!


Here's what I did based on instructions here:

http://wiki.postgresql.org/wiki/Apt

*

*run:*

/sudo gedit /etc/apt/sources.list/

*add to bottom:*
#postgresql9.3
deb http://apt.postgresql.org/pub/repos/apt//precise/-pgdg main
*
run:*

wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo 
apt-key add -
sudo apt-get update
/sudo apt-get install postgresql-9.3-postgis pgadmin3/

*Create new PGSQL user:*

sudo su - postgres

createuser -d -E -i -l -P -r -s matthew_baker

**

Once logged in, all the extensions are available, including postgis, 
postgis_topology, and postgis_tiger_geocoder...


Also, shp2pgsql-gui runs from terminal...(great!)

And when connected through QGIS 2.0, it works!

A version check yields:

POSTGIS=2.1.0 r11822 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23 
September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 
LIBJSON=UNKNOWN RASTER


PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc 
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit


So it seems I'm missing LIBJSON...?

Any thoughts appreciated! Hoping this fills a hole in the Ubuntu 
installation...


-m


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] Installing on Ubuntu via Postgresql APT repository

[Matthew Baker]

Just to clarify, I was wondering if this was indeed a valid installation 
of PostGIS 2.1 and Postgresql 9.3


I had only seen a reference to the Postgresql APT repository as The 
PostgreSQL build team is working on an APT repository 
https://wiki.postgresql.org/wiki/Apt for PostgreSQL builds. They may 
include PostGIS builds in the future. from http://postgis.net/install


Thanks,

-m





On 10/01/2013 10:06 AM, Matthew Baker wrote:

All,

Just for kicks yesterday I tried installing Postgresql 9.3 on Ubuntu 
from their APT repository.


I also added a postgis flag in there and it seems to have all come in 
very nicely!


Here's what I did based on instructions here:

http://wiki.postgresql.org/wiki/Apt

*

*run:*

/sudo gedit /etc/apt/sources.list/

*add to bottom:*
#postgresql9.3
debhttp://apt.postgresql.org/pub/repos/apt/  /precise/-pgdg main
*
run:*

wget --quiet -O -http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc  | sudo 
apt-key add -
sudo apt-get update
/sudo apt-get install postgresql-9.3-postgis pgadmin3/

*Create new PGSQL user:*

sudo su - postgres

createuser -d -E -i -l -P -r -s matthew_baker
**

Once logged in, all the extensions are available, including postgis, 
postgis_topology, and postgis_tiger_geocoder...


Also, shp2pgsql-gui runs from terminal...(great!)

And when connected through QGIS 2.0, it works!

A version check yields:

POSTGIS=2.1.0 r11822 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23 
September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 
LIBJSON=UNKNOWN RASTER


PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc 
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit


So it seems I'm missing LIBJSON...?

Any thoughts appreciated! Hoping this fills a hole in the Ubuntu 
installation...


-m




___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[postgis-users] 'Spatial Extensions' missing from Stack Builder?

[Matthew Baker]

All,

I'm trying to install PostGIS via the enterpriseDB / Stack Builder 
method, but it seems that the latest version of PostgreSQL and Stack 
Builder is missing that 'spatial extensions' option.


Can anyone confirm?

Thanks,

-m

___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users