Re: [postgis-users] Creating a grid purely in SQL

I think uDig still has that problem last we checked, but I don't think QGIS does. QGIS lets you pick the column. -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mr. Puneet Kishor Sent: Monday, Ma

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 into (I can't recall maximum space), gets chunked into toast records. Its true for most of the dat

Re: [postgis-users] Creating a grid purely in SQL

Thanks Leo, for the code fragment. Re. storing multiple geometries in one column, I found the following caveat -- [http://lists.refractions.net/pipermail/udig-users/2009-March/000553.html] Briefly, is it possible that programs such as QGIS/uDig, etc. would get confused about which column to dra

Re: [postgis-users] Creating a grid purely in SQL

Puneet, Something like this? This is a bit old. We have some example in our book using Common Table Expressions (CTEs) in chapter 8. You can download the code to see those as well. http://www.postgis.us/chapter_08 http://www.bostongis.com/postgis_translate.snippet As far as storing two geomet

[postgis-users] Creating a grid purely in SQL

Given a top-left starting point [ulx, uly], and a cell width 'w' and height 'h', is it possible to create a table entirely in SQL populated with rows increasing from left to right up to X and top to bottom up to Y. The table schema would be something like -- CREATE TABLE cells ( cell_id INTEG

Re: [postgis-users] images in postgresql

Robert, On 06/03/2011, at 4:28 PM, Robert Buckley wrote: > The windturbine table exists in EPSG:4326. I made a seperate table for the > images because I didn´t wan´t to blow the size of the wind turbine table out > of proportion and jeopardize performance. My understanding - and if I'm wrong I

[postgis-users] how to read a shapefile

Hi all, I finally figured out that the examples of code on the website were for 2.7 only and not earlier versions. (unless there is an archive link i missed?). Also i happened to come up on a link of some lab tutorial on how to read a shapefile but it said that the link was broken because of docu

[postgis-users] Editing a shapefile from PostGIS

Hello! have a shapefile of political districts that is giving me some grief. I thought that something had gone wrong in the shp2pgsql at first, so I opened the shapefile in QGIS. Then I thought I had a bad shapefile, period, so I started looking for as many different ones of the same geography

Re: [postgis-users] meters to degrees

Hi Michal, It looks like you declared your data in location.point using longitude/latitude, rather than easting/northing. If you want to store your data in projected EPSG:3044, you need to first transform it from geographic units, e.g.: SELECT ST_AsEWKT(ST_Transform(ST_SetSRID(ST_MakePoint(7.4545

Re: [postgis-users] meters to degrees

> > Ok, > > basically I have table location(id int, point geometry(POINT)) and function > getallpointsincircle(longitude, latitude, radius) which gives set of > internal indexes from location table if point in table is in the radius of > parameters of function. Inside function I am using st_dwithin

Re: [postgis-users] meters to degrees

You are using EPSG:3044, correct? http://spatialreference.org/ref/epsg/3044/ This projection has units of metres. ST_DWithin and related functions use the same units of length as defined in the projection, which in this case is metres, not degrees. You m

Re: [postgis-users] meters to degrees

Well, it sitll does not solve my problem. As I said I am using geometry(planar) with SRID 3044, where units are degrees, therefore when using st_dwithin will still take input in degrees. 2011/3/7 Paragon Corporation > Use ST_DWithin instead. > http://www.postgis.org/documentation/manual-1.5SVN/

Re: [postgis-users] Convert from 3067 to 2393

I add +towgs4 to proj4text, conversion is working ok with sql below. Thank's for your help and clarifying this! -- AJL Ralf Suhr [ralf.s...@itc-halle.de] kirjoitti: Hi Pena, changing proj4text is almost save. EPSG:31467 as example have more then 3 different towgs84. A better transformation

Re: [postgis-users] Postgis installation on fedora.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yum install postgis HTH Pedro. On 03/07/2011 08:23 AM, Smith Roman wrote: > Hello, > > Postgis installation on fedora. > > I intend to try out the installation of postgis on fedora. I have downloaded the postgresql 9 and successfully installed it on

Re: [postgis-users] Postgis installation on fedora.

On Mon, 2011-03-07 at 00:23 -0800, Smith Roman wrote: > I intend to try out the installation of postgis on fedora. I have > downloaded the postgresql 9 and successfully installed it on fedora. > To install postgis I can use the stack builder application. I will > like to ask if there is a postgis

[postgis-users] Postgis installation on fedora.

Hello, Postgis installation on fedora. I intend to try out the installation of postgis on fedora. I have downloaded the postgresql 9 and successfully installed it on fedora. To install postgis I can use the stack builder application. I will like to ask if there is a postgis bin or rpm install

Re: [postgis-users] meters to degrees

Use ST_DWithin instead. http://www.postgis.org/documentation/manual-1.5SVN/ST_DWithin.html We cover this topic in detail in the first chapter of our book which is a free download. http://www.postgis.us/chapter_01 Leo and Regina _ From: postgis-users-boun...@postgis.refractions.net [