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