Re: [postgis-users] images in postgresql

2011-03-08 Thread Charles Galpin
-boun...@postgis.refractions.net] On Behalf Of Robert > Buckley > Sent: Tuesday, March 08, 2011 3:20 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] images in postgresql > > Thanks for all the replies. > > My Wind turbine table will only have around 3

Re: [postgis-users] images in postgresql

2011-03-08 Thread Paragon Corporation
Users Discussion Subject: Re: [postgis-users] images in postgresql Thanks for all the replies. My Wind turbine table will only have around 300 - maximum 500 points. The photos shouldn´t change until either a turbine vanishes or gets repowered (ie. upgraded). I am pretty new to postgis so when yo

Re: [postgis-users] images in postgresql

2011-03-08 Thread Robert Buckley
. März 2011, 6:00:00 Uhr Betreff: Re: [postgis-users] images in postgresql Ben, My understanding is the same (as long as you don't select the column that is) otherwise has to be detoasted. As I recall, I think a small bit will be stored and then the rest that doesn't fit int

Re: [postgis-users] images in postgresql

2011-03-07 Thread Paragon Corporation
ttp://www.postgis.us _ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ben Madin Sent: Monday, March 07, 2011 8:31 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] images in postgresql Robert, On 06/03/2011, at 4:2

Re: [postgis-users] images in postgresql

2011-03-07 Thread Ben Madin
how to get the popup to display > though. > > Any examples? > Thanks, > > Rob > > > Von: Paragon Corporation > An: PostGIS Users Discussion > Gesendet: Samstag, den 5. März 2011, 18:21:49 Uhr > Betreff: Re: [postgis-users] images in postgresql > > Robe

Re: [postgis-users] images in postgresql

2011-03-06 Thread pcreso
Wood --- On Sun, 3/6/11, Robert Buckley wrote: From: Robert Buckley Subject: Re: [postgis-users] images in postgresql To: "PostGIS Users Discussion" Date: Sunday, March 6, 2011, 9:28 PM thanks for the tip, your book looks great...ill have to get it. The windturbine table exists in

Re: [postgis-users] images in postgresql

2011-03-06 Thread Robert Buckley
Betreff: Re: [postgis-users] images in postgresql Robert, Is there a reason why you have the points in a separate table or do you have points in both tables and you want to relate by a spatial join? If its a 1 to 1 relationship, we would just put them in the same table. As far as

Re: [postgis-users] images in postgresql

2011-03-05 Thread Paragon Corporation
ns.net] On Behalf Of Robert Buckley Sent: Saturday, March 05, 2011 5:39 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] images in postgresql Hi, I am just experimenting at the moment with a project and could do with some advice. I have created a database which contains

[postgis-users] images in postgresql

2011-03-05 Thread Robert Buckley
Hi, I am just experimenting at the moment with a project and could do with some advice. I have created a database which contains photos of Windturbines. I also have a postgis database with the locations (points) of the wind turbines and would like join the photos to the points via a link tab