[postgis-users] constraint issue in 2.0.2 r10789

Hello, I recently upgraded both my postgresql (from 8.4.4 to 9.2.2) and postgis (from 1.5.3 to 2.0.2 r10789). With the previous versions I run these commands without problems: [code] CREATE TABLE profiles_line_wgs84( GID SERIAL, ID SMALLINT, FID SMALLINT, SURVEY VARCHAR(100), PROFILE VARCHAR(1

Re: [postgis-users] constraint issue in 2.0.2 r10789

Thanks a lot Hugues and Nicolas for your suggestions, it worked like a champ. About why I'm actually using both linestrings and multistrings is because the shape I'm importing contains the latter. I tried to import it with shp2pgsql -S but it gives: "We have a Multilinestring with 2 parts, can't us

[postgis-users] rtpostgis.sql is missing, postgis 2.0.2 r10789

Hello, I've been checking things after installing postgis2.0.2, and noticed something, rtpostgis.sql is missing, and also the GDAL version. After running this command I get: [code] SELECT postgis_full_version(); NOTICE: Function postgis_gdal_version() not found. Is raster support enabled and r

[postgis-users] FW: json/json.h: No such file or directory

n/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd How can I circumvent this json/json.h problem and finish the installation of postgis? Gery ___ postgis-users mailing list postgis-users@lists.

Re: [postgis-users] FW: json/json.h: No such file or directory

Hello Regina, Thanks for your reply, I have these ones installed in cygwin (latest version 32-bit): Gery@gery /opt/postgis/postgis-2.1.3 $ cygcheck -c | grep json json-c-debuginfo 0.11-2 OK libjson-c-common 0.11-2 OK libjson-c-devel 0.11-2 OK libjson-c2 0.11-2 OK libjson-devel 0.11-2 OK

Re: [postgis-users] FW: json/json.h: No such file or directory

Hi Regina, I tried with postgis-2.2.0dev, it seems that the json problem is gone, but 'make' didn't find '-lpostgres'. In my system, postgres is in /usr/sbin, and I put that in LD_LIBRARY_PATH of my .bashrc. Below is the message: -- Gery@gery /opt/postgis/postgis-2

Re: [postgis-users] FW: json/json.h: No such file or directory

9.3, proj4, etc, etc, so, nicely installed. I'll ask if some other open-source software can also be added in the Science package, such as gmt, gdal, geos, su, mb, etc. Thanks again, Cheers, Gery _

Re: [postgis-users] Tutorial: Bezier Curves - A More Flexible Alternative to Great Circles

Nice work Mark, well done, would you have a version to perform Bezier spline interpolation? Regards, Sent from my iRon On Mar 4, 2015, at 23:30, "Tahir Tamba" wrote: Thank you Mark for sharing this usefull tips. Regards. 2015-03-04 23:07 GMT-05:00 Mark Wynter : > Many people like looking

[postgis-users] Find unique date and code values before applying st_intersects

Hello, I have two tables, one containing polygons and one with points: # polygonsgid | integer | not null default nextval('cuadro_produce_region_gid_seq'::regclass)id | character varying(10)| zona| character varying(10)| area | character varying(10)

[postgis-users] Find unique date and code values before applying st_intersects

Sorry, my last email had the hotmail format, hope this one would have a much better format. -- Hello, I have two tables, one containing polygons and one with points: & polygons gid | integer | not null default nextval('cuadro_produce_region_gid_seq'::regclass) id

Re: [postgis-users] Find unique date and code values before applying st_intersects

rder by cuadro_produce_region.gid,cuadro_produce_region.cod; > Date: Thu, 11 Jun 2015 16:53:46 -0500 > From: a...@squeakycode.net > To: postgis-users@lists.osgeo.org > Subject: Re: [postgis-users] Find unique date and code values before applying > st_intersect

Re: [postgis-users] Find unique date and code values before applying st_intersects

> Sorry, I didn't mean to confuse. I'm not familiar with your tables, I > had no idea how to join the tables, it was example of derived tables, > not example of what fields to join. > > What I mean is, start in the middle and keep wrapping things around it. > Each derived table is like a temp table