Re: [postgis-users] Dumping out points in a linestring
Hi st_dumpPoints(geom) Nicolas On 9 July 2012 12:51, Ed Linde edoli...@gmail.com wrote: Hi All, Wondering how I can dump out all the points within a linestring or multilinestring? Thanks, Ed ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Dumping out points in a linestring
Thanks Nicolas. I was wondering what these points in the linestring symbolize? Are the default set of points on a 2D linestring indicating the positions at which the line is not straight and changes directions? On Mon, Jul 9, 2012 at 2:33 PM, Nicolas Ribot nicolas.ri...@gmail.comwrote: Hi st_dumpPoints(geom) Nicolas On 9 July 2012 12:51, Ed Linde edoli...@gmail.com wrote: Hi All, Wondering how I can dump out all the points within a linestring or multilinestring? Thanks, Ed ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Dumping out points in a linestring
On Jul 9, 2012, at 6:37 PM, Ed Linde wrote: Thanks Nicolas. I was wondering what these points in the linestring symbolize? Are the default set of points on a 2D linestring indicating the positions at which the line is not straight and changes directions? Points making up a linestring are just that, points. They have no relationship to whether or not the line changes direction. Consider... +-+-+---+ '+' are points defining the linestring that is symbolized by '+' and '-', but there is no change in direction, no inflection point. -- Puneet Kishor ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Hi Bborie, sorry for the belated response I haven't been at the office the past few weeks. As you suspected something is wrong with gdal: $ gdalinfo gdalinfo: error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory $ gdal_translate gdal_translate: error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory I'll have to sort this out before I get back to PostGIS. Any suggestions on how to do it are welcome. Thank you for the help, Luís -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998832.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] What have I got wrong?
Hi all, Apologies to everyone if this has already been documented before or if my problem is so obvious but.. After trying for the best part of three days I'm unable (unsure what the heck I'm doing wrong) with trying to get postgis working with postgres. If anyone can point out what it is I be hugely grateful. I've followed the official postgis installation documentation and guides / tutorials on the PostGIS WIKI and keep arriving at the same message below in a terminal window. createdb: could not connect to database postgres: could not connect to server: No such file or directoryIs the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5433? If it helps I'm running Ubuntu 12.04 LTS and have been trying to bring things to life with Postgres 9.1 and PostGIS 2.0.1 Thanks in advance for any support. Best regards, Geo-rookie___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] What have I got wrong?
Hi, Is the PostgreSQL server started on port 5433 ? (default port is 5432) (ps aux |grep postgres may show you information about started postgres program) Nicolas On 9 July 2012 17:45, Phil Shea peas...@hotmail.com wrote: Hi all, Apologies to everyone if this has already been documented before or if my problem is so obvious but.. After trying for the best part of three days I'm unable (unsure what the heck I'm doing wrong) with trying to get postgis working with postgres. If anyone can point out what it is I be hugely grateful. I've followed the official postgis installation documentation and guides / tutorials on the PostGIS WIKI and keep arriving at the same message below in a terminal window. createdb: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5433? If it helps I'm running Ubuntu 12.04 LTS and have been trying to bring things to life with Postgres 9.1 and PostGIS 2.0.1 Thanks in advance for any support. Best regards, Geo-rookie ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] What have I got wrong?
Specifically, did you try createdb -p 5433 ? I'm not a Ubuntu specialist, but is it possible you already have a stock postgresql running on port 5432 and that the 9.1 version took the 5433 port to run on ? Nicolas On 9 July 2012 18:08, Nicolas Ribot nicolas.ri...@gmail.com wrote: Hi, Is the PostgreSQL server started on port 5433 ? (default port is 5432) (ps aux |grep postgres may show you information about started postgres program) Nicolas On 9 July 2012 17:45, Phil Shea peas...@hotmail.com wrote: Hi all, Apologies to everyone if this has already been documented before or if my problem is so obvious but.. After trying for the best part of three days I'm unable (unsure what the heck I'm doing wrong) with trying to get postgis working with postgres. If anyone can point out what it is I be hugely grateful. I've followed the official postgis installation documentation and guides / tutorials on the PostGIS WIKI and keep arriving at the same message below in a terminal window. createdb: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5433? If it helps I'm running Ubuntu 12.04 LTS and have been trying to bring things to life with Postgres 9.1 and PostGIS 2.0.1 Thanks in advance for any support. Best regards, Geo-rookie ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] I'm so close!
And yet... I've gotten just about everything done in a PostGIS/Tiger Geocoder install and I get to create_geocode.sh and get a few problems. I couldn't this problem being addressed on this list or anywhere else. Any ideas? I get this after all the tables are generated: psql:census_loader.sql:102: NOTICE: function loader_generate_census(text[],text) does not exist, skipping DROP FUNCTION CREATE FUNCTION DELETE 0 INSERT 0 1 INSERT 0 1 INSERT 0 1 create_census_base_tables --- Tables already present (1 row) SET BEGIN psql:create_geocode.sql:23: NOTICE: type norm_addy does not exist, skipping DROP TYPE CREATE TYPE CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:utility/levenshtein_ignore_case.sql:5: ERROR: function levenshtein(text, text) does not exist LINE 3: SELECT levenshtein(upper($1), upper($2)); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. psql:normalize/end_soundex.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/count_words.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/state_extract.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/get_last_words.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_countysub_exact.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_countysub_fuzzy.sql:89: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_place_exact.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_place_fuzzy.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract.sql:85: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/normalize_address.sql:708: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/pprint_addy.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/pprint_addy.sql:43: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:22: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:48: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:201: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:213: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:240: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:252: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/rate_attributes.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/rate_attributes.sql:80: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/includes_address.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/interpolate_from_address.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_address.sql:435: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_location.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_intersection.sql:148: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode.sql:131: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/reverse_geocode.sql:222: ERROR: current transaction is aborted, commands ignored until end of transaction block
[postgis-users] Casting a point and a polygon to geometry
Dear all I want to use the following query ST_Crosses(geometry g1, geometry g2); but I want g1 to be column of points and g2 a column of geometry, so how can I convert them to geometry enable to use the function this is my query select r.name,u.id from river r, users u where ST_Crosses(r.point,u.polygon)='T' ; hope you can help thanks --- Best Regards, Roba -- -- This message and its contents, including attachments are intended solely for the original recipient. If you are not the intended recipient or have received this message in error, please notify me immediately and delete this message from your computer system. Any unauthorized use or distribution is prohibited. Please consider the environment before printing this email. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Dumping out points in a linestring
Thanks, is there a way to then dump out inflection points in postgis? On Mon, Jul 9, 2012 at 3:13 PM, Mr. Puneet Kishor punk.k...@gmail.comwrote: On Jul 9, 2012, at 6:37 PM, Ed Linde wrote: Thanks Nicolas. I was wondering what these points in the linestring symbolize? Are the default set of points on a 2D linestring indicating the positions at which the line is not straight and changes directions? Points making up a linestring are just that, points. They have no relationship to whether or not the line changes direction. Consider... +-+-+---+ '+' are points defining the linestring that is symbolized by '+' and '-', but there is no change in direction, no inflection point. -- Puneet Kishor ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Casting a point and a polygon to geometry
On 10 July 2012 06:53, Roba Binyahib roba.binya...@kaust.edu.sa wrote: ST_Crosses(geometry g1, geometry g2); but I want g1 to be column of points and g2 a column of geometry, so how can I convert them to geometry enable to use the function By column of points, do you mean a PostGIS type, or a PostgreSQL type[1]? If it is a PostGIS type, then it is a geometry, with it's own internal type (Point, MultiPoint, Polygon, etc.). select r.name,u.id from river r, users u where ST_Crosses(r.point,u.polygon)='T' ; ST_Crosses returns T/F, so you don't need to evaluate ='T' . -Mike [1] http://www.postgresql.org/docs/current/static/datatype-geometric.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] I'm so close!
Please ignore this note. I solved the issue. It was very simple, of course. On Mon, Jul 9, 2012 at 11:30 AM, Eric Aspengren ericas...@gmail.com wrote: And yet... I've gotten just about everything done in a PostGIS/Tiger Geocoder install and I get to create_geocode.sh and get a few problems. I couldn't this problem being addressed on this list or anywhere else. Any ideas? I get this after all the tables are generated: psql:census_loader.sql:102: NOTICE: function loader_generate_census(text[],text) does not exist, skipping DROP FUNCTION CREATE FUNCTION DELETE 0 INSERT 0 1 INSERT 0 1 INSERT 0 1 create_census_base_tables --- Tables already present (1 row) SET BEGIN psql:create_geocode.sql:23: NOTICE: type norm_addy does not exist, skipping DROP TYPE CREATE TYPE CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:utility/levenshtein_ignore_case.sql:5: ERROR: function levenshtein(text, text) does not exist LINE 3: SELECT levenshtein(upper($1), upper($2)); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. psql:normalize/end_soundex.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/count_words.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/state_extract.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/get_last_words.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_countysub_exact.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_countysub_fuzzy.sql:89: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_place_exact.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract_place_fuzzy.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/location_extract.sql:85: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/normalize_address.sql:708: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/pprint_addy.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:normalize/pprint_addy.sql:43: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:22: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:48: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:201: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:213: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:240: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/other_helper_functions.sql:252: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/rate_attributes.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/rate_attributes.sql:80: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/includes_address.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/interpolate_from_address.sql:94: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_address.sql:435: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_location.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode_intersection.sql:148: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:geocode/geocode.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block
[postgis-users] St_Area to acres
I am using the code below: *Select name, acreage, ST_Area(ST_Transform(geom, 26986))/43560 as acres from ss.fields* and getting these results. name acreageacres H 01 15.79 1.50398045317257 H 02 29.02 2.76480120804097 H 03 31.95 3.04337512685165 H 04 34.71 3.30710750534269 H 05 111.6 10.6322788992474 I have another program where I am importing the acreage data from and I just wanted it to match up in postgis well in case I ever wanted to calculate it myself. It seems that I am almost there, but I am a decimal off and I can't understand that. Also I am not very familiar with the 26986, but I used it because I saw it used for sqare feet somewhere else. Should I be using anything else? Thanks, DC ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users