[postgis-users] Lon Lat Polygon Table Query
james butler
butler.james1 at gmail.com
Wed Jun 13 13:18:20 PDT 2012
What is the proper snytax to query a table with a geom column?
Select *
>From TableX
Where lon lat = (-120.00707803487512, 38.71309927715416)
I need to get the record details of the polygon where this coordinate is
located.
On Wed, Jun 13, 2012 at 12:00 PM, <
postgis-users-request at postgis.refractions.net> wrote:
> Send postgis-users mailing list submissions to
> postgis-users at postgis.refractions.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> postgis-users-request at postgis.refractions.net
>
> You can reach the person managing the list at
> postgis-users-owner at postgis.refractions.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
> 1. Re: postgresql backup (Gold, Jack L (US SSA))
> 2. Re: row-wise geometry intersecting (Puneet Kishor)
> 3. Re: row-wise geometry intersecting (Stephen Woodbridge)
> 4. Re: row-wise geometry intersecting (Brent Fraser)
> 5. Import excel file to postgresql (Jos? Mar?a Amuedo)
> 6. Re: Import excel file to postgresql (Pedro Costa)
> 7. Re: Import excel file to postgresql (Horst D?ster)
> 8. Re: Import excel file to postgresql (Ralf Suhr)
> 9. Re: Import excel file to postgresql (Jos? Mar?a Amuedo)
> 10. Re: Import excel file to postgresql (Pedro Costa)
> 11. Re: Import excel file to postgresql (Jos? Mar?a Amuedo)
> 12. Re: Import excel file to postgresql (Pedro Costa)
> 13. How does ST_Slope works ? (Francois Hugues)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 12 Jun 2012 15:15:07 -0400
> From: "Gold, Jack L (US SSA)" <jack.gold at baesystems.com>
> Subject: Re: [postgis-users] postgresql backup
> To: Greg Williamson <gwilliamson39 at yahoo.com>, PostGIS Users
> Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <20120612191305.B1389CC844A at lists.refractions.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> In addition, postgis has a perl script (postgis_restore.pl) for handling
> restores of the custom hard dump described in the postgreSQL manual.
>
> First dump the old db: pg_dump -Fc MYDB > MYDB.dmp
>
> Then build your new DB, install PostGIS, install topology and/or raster
> if you are using them, and finally pass the MYDB.dmp file to the perl
> script.
>
> createdb MYDB
> psql -f postgis/postgis.sql
> psql -f topology/topology.sql
> psql -f raster/raster.sql
> postgis_restore.pl MYDB.dmp | psql MYDB
>
> The instructions are all in the script.
>
> Jack Gold
> BAE SYSTEMS
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] On Behalf Of Greg
> Williamson
> Sent: Tuesday, June 12, 2012 2:56 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] postgresql backup
>
> Sean --
>
> Check the postgres manual for your version for details.
>
> pg_dumpall -- used to backup an entire cluster (all databases); can be
> used to backup global info such as users / roles as well.
> pg_dump -- used to backup a single database (no global info); like fumpall
> can be told to do schema only, data only, or both.
>
> Both can output to a plain text SQL file that can be used to restore from
> the file, such as ?psql -d mynewdb < dump.sql
>
> Both can output in compressed formats (highly desirable in some
> circumstances) which are then restored using pg_restore.
>
> The manual will provide more details; try dumping to a text file first and
> study what it has. Then move to the more compressed formats.
>
> You can use these to migrate to a new version of postgres; in that case
> you want to use the most recent version of pg_dump / restore to do the
> work. The newer versions know how to read older databases and collect all
> the needed data.
>
> HTH,
>
> Greg Williamson
>
> ps the postgres admin mailing list might be a good place to ask more
> pointed questions since it has a lot of DBAs looking at it; this forum
> probably has more GIS types who may well rely on a regular DBA to do this
> sort of (necessary) work.
> ?
>
> ----- Original Message -----
> > From: Sean Christopher Conway <seanc at backroadmapbooks.com>
> > To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> > Cc:
> > Sent: Tuesday, June 12, 2012 10:10 AM
> > Subject: [postgis-users] postgresql backup
> >
> >
> > Hello, I am fairly new to POSTGIS and postgresql in general and am
> > wondering if somebody can explain to me the best and most efficient
> > way to backup and restore postgresql databases. Kind regards,
> >
> >
> > Sean.
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 12 Jun 2012 15:34:13 -0400
> From: Puneet Kishor <punk.kish at gmail.com>
> Subject: Re: [postgis-users] row-wise geometry intersecting
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <7C1138FE-2FD4-4ADF-AD4C-E32A5782CB58 at gmail.com>
> Content-Type: text/plain; charset=us-ascii
>
>
>
> On Jun 12, 2012, at 1:52 PM, Brent Fraser <bfraser at geoanalytic.com> wrote:
>
> > SELECT image_id, ST_Intersection(wkb_geom_extent, wkb_geom_digitized) as
> image_area FROM v _images
>
> The query looks fine, but what do you want to accomplish with it? It will
> give you the area of the intersection, if any.
>
>
> >
> > but I get an error:
> >
> > NOTICE: TopologyException: side location conflict at -17.2242 79.1865
> > ERROR: GEOS Intersection() threw an error!
> > ********** Error **********
> > ERROR: GEOS Intersection() threw an error!
> > SQL state: XX000
>
> Ha! I got the same error the other day, and, iirc, it was because of the
> dreaded self-intersections.
>
>
>
>
>
>
>
> --
> Puneet Kishor
> http://punkish.org
>
> ------------------------------
>
> Message: 3
> Date: Tue, 12 Jun 2012 15:52:40 -0400
> From: Stephen Woodbridge <woodbri at swoodbridge.com>
> Subject: Re: [postgis-users] row-wise geometry intersecting
> To: postgis-users at postgis.refractions.net
> Message-ID: <4FD79E08.9040906 at swoodbridge.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Brent,
>
> select count(*) from v_images where not isvalid(wkb_geom_extent);
>
> select count(*) from v_images where not isvalid(wkb_geom_extent) and not
> isvalid(st_buffer(wkb_geom_extent, 0.0));
>
> update v_images set wkb_geom_extent=st_buffer(wkb_geom_extent, 0.0)
> where not isvalid(wkb_geom_extent);
>
> You might want to backup your table first. If the second query returns
> zero then it should fix all the problems. You might want to get a list
> of the invalid ones and check them against the buffered ones also.
>
> -Steve
>
> On 6/12/2012 1:52 PM, Brent Fraser wrote:
> > Hi All,
> >
> > I've got a table (a view actually) with two multipolygon geometry
> > columns: wkb_geom_extent and wkb_geom_digitized.
> >
> > They contain polygons representing the footprint of images and the areas
> > digitized in the images.
> >
> > So the view looks like:
> > v_images
> > image_id: wkb_geom_extent: wkb_geom_digitized:
> > 1 xxxxx xxxx
> > 2 xxxxx
> > 3 xxxxxx xxxxx
> >
> >
> > I want to calculate the area digitized in each of the images and since
> > some of the polygons representing the area digitized could have be
> > sloppily defined to extend outside of the image footprint , I thought I
> > would intersect the two geometries:
> >
> > SELECT image_id, ST_Intersection(wkb_geom_extent, wkb_geom_digitized) as
> > image_area FROM v _images
> >
> > but I get an error:
> >
> > NOTICE: TopologyException: side location conflict at -17.2242 79.1865
> > ERROR: GEOS Intersection() threw an error!
> > ********** Error **********
> > ERROR: GEOS Intersection() threw an error!
> > SQL state: XX000
> >
> > This may be due to some problems in my geometries, but I thought I would
> > check to see if my query was reasonable...
> >
> > Thanks!
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 12 Jun 2012 15:20:00 -0600
> From: Brent Fraser <bfraser at geoanalytic.com>
> Subject: Re: [postgis-users] row-wise geometry intersecting
> To: postgis-users at postgis.refractions.net
> Message-ID: <4FD7B280.8090000 at geoanalytic.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Steve, Puneet,
>
> Sure enough, the "not isvalid()" query yields 65 (out of 138), and
> the query with the "not is valid(st_buffer" returns 0 . Looks like I've
> got some polygon cleaning to do...
>
> Many thanks!
>
> Best Regards,
> Brent Fraser
>
>
> On 6/12/2012 1:52 PM, Stephen Woodbridge wrote:
> > select count(*) from v_images where not isvalid(wkb_geom_extent);
>
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 13 Jun 2012 15:46:20 +0200
> From: Jos? Mar?a Amuedo <jmamuedo at gmail.com>
> Subject: [postgis-users] Import excel file to postgresql
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <CANVkuyhafoCZNYFXYosszepBRMDHDQwa9VnJSMRSW8NNVyny8w at mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
>
> I would like to know how can import excel file to postgresql. I'm working
> with linux OS.
>
> Thanks
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/3a537fc4/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 6
> Date: Wed, 13 Jun 2012 14:49:01 +0100
> From: Pedro Costa <pedrocostaarma at sapo.pt>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <4FD89A4D.3040007 at sapo.pt>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>
> Hi Jos?,
>
> You have to convert the excel file to csv and use the copy command like
> that:
>
>
> copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';';
>
>
> You have to create the table before and delete the column names of csv
> file.
>
>
>
>
> Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
> > Hi,
> >
> > I would like to know how can import excel file to postgresql. I'm
> > working with linux OS.
> >
> > Thanks
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/bd3ca761/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 7
> Date: Wed, 13 Jun 2012 15:57:27 +0200
> From: Horst D?ster <horst.duester at kappasys.ch>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: postgis-users at postgis.refractions.net
> Message-ID: <4FD89C47.4050508 at kappasys.ch>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>
> As an other option you can use an ETL-Tool like Talend OpenStudio [1] or
> Geokettle [2]
>
> Regards
> Horst
>
> [1] http://www.talend.com/index.php
> [2] http://www.spatialytics.org/projects/geokettle/
>
>
> Am 13.06.2012 15:46, schrieb Jos? Mar?a Amuedo:
> > Hi,
> >
> > I would like to know how can import excel file to postgresql. I'm
> > working with linux OS.
> >
> > Thanks
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/efe32bd6/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 8
> Date: Wed, 13 Jun 2012 16:10:41 +0200
> From: Ralf Suhr <Ralf.Suhr at itc-halle.de>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: postgis-users at postgis.refractions.net
> Message-ID: <201206131610.41759.Ralf.Suhr at itc-halle.de>
> Content-Type: text/plain; charset="iso-8859-15"
>
> Hi Jos?,
>
> ogr2org can import excel files for you.
> http://www.gdal.org/ogr/drv_xls.html
> Or you compile gdal/ogr from svn then you can also import xlsx files.
> http://www.gdal.org/ogr/drv_xlsx.html
>
>
> Gr
> Ralf
>
> On Mittwoch 13 Juni 2012 15:46:20 Jos? Mar?a Amuedo wrote:
> > Hi,
> >
> > I would like to know how can import excel file to postgresql. I'm working
> > with linux OS.
> >
> > Thanks
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/ad17dc36/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 9
> Date: Wed, 13 Jun 2012 16:34:37 +0200
> From: Jos? Mar?a Amuedo <jmamuedo at gmail.com>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <CANVkuygfgDQyVbmw2GjqnCv6Y+M1iijtiHVc5Ox-VStTS1YBSg at mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> I obtened this error:
>
> RROR: extra data after last expected column
> SQL state: 22P04
> Context: COPY nueva, line 1:
>
> "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."
>
> 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>
>
> > Hi Jos?,
> >
> > You have to convert the excel file to csv and use the copy command like
> > that:
> >
> >
> > copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';';
> >
> >
> > You have to create the table before and delete the column names of csv
> > file.
> >
> >
> >
> >
> > Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
> >
> > Hi,
> >
> > I would like to know how can import excel file to postgresql. I'm working
> > with linux OS.
> >
> > Thanks
> >
> >
> > _______________________________________________
> > postgis-users mailing listpostgis-users at postgis.refractions.nethttp://
> postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/5cf0b5b6/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 10
> Date: Wed, 13 Jun 2012 15:38:46 +0100
> From: Pedro Costa <pedrocostaarma at sapo.pt>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <4FD8A5F6.9020008 at sapo.pt>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>
> Send me a sample of your file. But you have to remove the last semicolon.
>
> Your file have to be like that:
>
>
> column1;column2;column3;333333.3333
> column1_r2;column2_r2;column3_r2;333333.3333
>
>
>
>
> Em 13-06-2012 15:34, Jos? Mar?a Amuedo escreveu:
> > I obtened this error:
> >
> > RROR: extra data after last expected column
> > SQL state: 22P04
> > Context: COPY nueva, line 1:
> >
> "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."
> >
> > 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt
> > <mailto:pedrocostaarma at sapo.pt>>
> >
> > Hi Jos?,
> >
> > You have to convert the excel file to csv and use the copy command
> > like that:
> >
> >
> > copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV
> > DELIMITER ';';
> >
> >
> > You have to create the table before and delete the column names of
> > csv file.
> >
> >
> >
> >
> > Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
> >> Hi,
> >>
> >> I would like to know how can import excel file to postgresql. I'm
> >> working with linux OS.
> >>
> >> Thanks
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net <mailto:
> postgis-users at postgis.refractions.net>
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > <mailto:postgis-users at postgis.refractions.net>
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/197681ae/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 11
> Date: Wed, 13 Jun 2012 16:50:30 +0200
> From: Jos? Mar?a Amuedo <jmamuedo at gmail.com>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <CANVkuygb1_cXoNT45yrS44QqgGk4qG9qnROvGYWwBnqxSn1Pcw at mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> this is my file
>
> 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>
>
> > Send me a sample of your file. But you have to remove the last
> semicolon.
> >
> > Your file have to be like that:
> >
> >
> > column1;column2;column3;333333.3333
> > column1_r2;column2_r2;column3_r2;333333.3333
> >
> >
> >
> >
> > Em 13-06-2012 15:34, Jos? Mar?a Amuedo escreveu:
> >
> > I obtened this error:
> >
> > RROR: extra data after last expected column
> > SQL state: 22P04
> > Context: COPY nueva, line 1:
> >
> "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."
> >
> > 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>
> >
> >> Hi Jos?,
> >>
> >> You have to convert the excel file to csv and use the copy command like
> >> that:
> >>
> >>
> >> copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER
> ';';
> >>
> >>
> >> You have to create the table before and delete the column names of csv
> >> file.
> >>
> >>
> >>
> >>
> >> Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
> >>
> >> Hi,
> >>
> >> I would like to know how can import excel file to postgresql. I'm
> working
> >> with linux OS.
> >>
> >> Thanks
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing listpostgis-users at postgis.refractions.nethttp://
> postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing listpostgis-users at postgis.refractions.nethttp://
> postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/d533754a/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: elements.csv
> Type: text/csv
> Size: 34817 bytes
> Desc: not available
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/d533754a/attachment-0001.bin
> >
>
> ------------------------------
>
> Message: 12
> Date: Wed, 13 Jun 2012 15:55:15 +0100
> From: Pedro Costa <pedrocostaarma at sapo.pt>
> Subject: Re: [postgis-users] Import excel file to postgresql
> To: postgis-users at postgis.refractions.net
> Message-ID: <4FD8A9D3.7050103 at sapo.pt>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>
>
> Try with i sample attached.
> be sure that your table must have columns according to the file
>
>
>
> Em 13-06-2012 15:50, Jos? Mar?a Amuedo escreveu:
> > this is my file
> >
> > 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt
> > <mailto:pedrocostaarma at sapo.pt>>
> >
> > Send me a sample of your file. But you have to remove the last
> > semicolon.
> >
> > Your file have to be like that:
> >
> >
> > column1;column2;column3;333333.3333
> > column1_r2;column2_r2;column3_r2;333333.3333
> >
> >
> >
> >
> > Em 13-06-2012 15:34, Jos? Mar?a Amuedo escreveu:
> >> I obtened this error:
> >>
> >> RROR: extra data after last expected column
> >> SQL state: 22P04
> >> Context: COPY nueva, line 1:
> >>
> "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."
> >>
> >> 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt
> >> <mailto:pedrocostaarma at sapo.pt>>
> >>
> >> Hi Jos?,
> >>
> >> You have to convert the excel file to csv and use the copy
> >> command like that:
> >>
> >>
> >> copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV
> >> DELIMITER ';';
> >>
> >>
> >> You have to create the table before and delete the column
> >> names of csv file.
> >>
> >>
> >>
> >>
> >> Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
> >>> Hi,
> >>>
> >>> I would like to know how can import excel file to
> >>> postgresql. I'm working with linux OS.
> >>>
> >>> Thanks
> >>>
> >>>
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at postgis.refractions.net <mailto:
> postgis-users at postgis.refractions.net>
> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> <mailto:postgis-users at postgis.refractions.net>
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net <mailto:
> postgis-users at postgis.refractions.net>
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > <mailto:postgis-users at postgis.refractions.net>
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/668603d2/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: elements.csv
> Type: text/csv
> Size: 1464 bytes
> Desc: not available
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/668603d2/attachment-0001.bin
> >
>
> ------------------------------
>
> Message: 13
> Date: Wed, 13 Jun 2012 19:31:02 +0200
> From: "Francois Hugues" <hugues.francois at irstea.fr>
> Subject: [postgis-users] How does ST_Slope works ?
> To: <postgis-users at postgis.refractions.net>
> Message-ID:
> <
> 3CB901080554B04881D30F111F62D93001CD623E at nadia.grenoble.cemagref.fr>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello list,
>
>
>
> I have two (basics) questions about ST_Slope about somethings I don't
> understand.
>
>
>
> 1. To know which Pixeltype I had to use, I tried to use st_bandpixeltype
> which told me my pixels were 32BSI type but my results using this type
> are 0 or 1 and if I try another type like 32BF, results seems to be more
> useful. Does someone have an explanation about this weird difference ?
> What is the unit used by st_slope ?
>
>
>
> 2. My raster is a tiled one and as you can see on both pictures,
> ST_Slope gives no results for pixels located at the border of each tile.
> I can understand it is impossible to find the slope for the pixels which
> make the border of the raster, but is there not a way to have complete
> results for the tile in the middle of the raster and thus use the
> neighboring tiles.
>
>
>
> Hugues.
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/6181a3f0/attachment-0001.html
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: slopes32BSI.jpg
> Type: image/jpeg
> Size: 945220 bytes
> Desc: slopes32BSI.jpg
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/6181a3f0/attachment-0002.jpg
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: slopes32BF.jpg
> Type: image/jpeg
> Size: 992566 bytes
> Desc: slopes32BF.jpg
> URL: <
> http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/6181a3f0/attachment-0003.jpg
> >
>
> ------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> End of postgis-users Digest, Vol 124, Issue 13
> **********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120613/14ba504d/attachment.html>
More information about the postgis-users
mailing list