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
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
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
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.
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
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
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
_
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
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)
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
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
> 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
12 matches
Mail list logo