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

2013-09-10 Thread 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

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

2013-10-01 Thread 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:*

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

2013-10-01 Thread Matthew Baker
. 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

[postgis-users] Ubuntu installation guide - review?

2013-10-23 Thread Matthew Baker
?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

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

2014-08-11 Thread 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

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"

2016-01-20 Thread 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

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

2016-01-20 Thread 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.

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

2016-01-20 Thread Matthew Baker
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? I

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

2016-09-16 Thread 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

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

2016-09-27 Thread Matthew Baker
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>>

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

2017-07-03 Thread 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

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

2017-07-03 Thread 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