*** ukjay has joined #ingres | 00:39 | |
*** ukjay has quit IRC | 00:41 | |
*** maida01 has joined #ingres | 02:00 | |
*** dyki has joined #ingres | 02:24 | |
*** Mud has joined #ingres | 03:22 | |
*** cthibert has joined #ingres | 03:55 | |
*** zxiiro has quit IRC | 04:20 | |
*** atrofast has joined #ingres | 04:29 | |
*** withdefault sets mode: -o withdefault | 04:41 | |
*** rossand has joined #ingres | 04:57 | |
*** ChanServ sets mode: +o rossand | 04:57 | |
*** Mud has quit IRC | 05:10 | |
*** Mud has joined #ingres | 05:15 | |
*** zxiiro has joined #ingres | 05:29 | |
*** ChanServ sets mode: +v zxiiro | 05:29 | |
*** Alex| has quit IRC | 05:51 | |
*** mull has joined #ingres | 05:54 | |
*** Alex| has joined #ingres | 06:13 | |
*** ChanServ sets mode: +o Alex| | 06:13 | |
*** Alex| has quit IRC | 06:36 | |
dyki | \q | 07:39 |
---|---|---|
*** dyki has quit IRC | 07:39 | |
*** mull has quit IRC | 07:58 | |
*** Mud has quit IRC | 07:58 | |
*** mull has joined #ingres | 08:00 | |
*** ukjay has joined #ingres | 08:17 | |
*** Alex| has joined #ingres | 08:24 | |
*** ChanServ sets mode: +o Alex| | 08:24 | |
FrankW | yippee! Success in building ingres-geospatial from source! | 08:38 |
FrankW | atrofast: FYI - CPLFree() only does something if the passed pointer is NULL, so there is no need to pre-check the pointer. | 09:02 |
FrankW | atrofast: also, now when I load data I get: | 09:06 |
FrankW | INSERT on table spatial_ref_sys: no GRANT or GRANT compatible permit exists. | 09:06 |
FrankW | What do I need to do to deal with that? | 09:06 |
*** DerMeister has joined #ingres | 09:16 | |
*** mull has quit IRC | 09:17 | |
atrofast | FrankW: You need to grant permission to your user on spatial_ref_sys, the easiest way to do this is (let's all users edit it but easiest way when testing): echo "grant all on spatial_ref_sys to public" | sql dbname +U | 09:27 |
FrankW | ok, srs handling is now working. | 09:30 |
FrankW | hmm, loading one of my layers I'm seeing: | 09:32 |
FrankW | INGRES: IIapi_query(INSERT INTO can_caps (shape , capital, province_name, pop_1991) VALUES (POINTFROMWKB( ~V ), 'YELLOWKNIFE', 'Northwest Territories', 15179)) | 09:32 |
FrankW | ERROR 1: IIapi_getDescriptor(): IIAPI_ST_ERROR | 09:32 |
FrankW | '50000' 0x65423 | 09:32 |
FrankW | SRID specified does not match column SRID. Data was not saved. | 09:32 |
FrankW | but two others worked. | 09:33 |
*** Mud has joined #ingres | 09:36 | |
FrankW | atrofast: I don't see the logic in CreateFeature() for including the SRID with the geometry, but the code seems to be failing on a geometry/srid related issue. | 09:42 |
FrankW | Ah, I see. | 09:42 |
FrankW | The SRID is not included in the POINTFROMWKB() case, but it is in the others. | 09:42 |
FrankW | in PrepareNewStyleGeometry(). | 09:42 |
FrankW | I shall try the obvious patch. | 09:42 |
*** DerMeister has quit IRC | 09:44 | |
atrofast | When you create a feature it should try to create the SRID/SRS if it doesn't already exist. The error you get would be if it failed or never tried to do this I think | 09:45 |
atrofast | FrankW: And you're right, seems like I missed to add it to POINTFROMWKB, terribly sorry abotu that | 09:46 |
FrankW | no problem. | 09:46 |
FrankW | I'll include the fix with the others you provided. | 09:47 |
atrofast | Thanks a lot! | 09:47 |
FrankW | The next problem I am encountering is that layers with geometry type wkbUnknown are not being translated. | 09:47 |
FrankW | In my case this is a layer with a mixture of polygon and multipolygon geometries. | 09:48 |
FrankW | Do we not yet have a generic geometry type? | 09:48 |
*** mull has joined #ingres | 09:52 | |
atrofast | FrankW: Yes you can use GEOMETRY, and geometryfromtext/geometryfromwkb. One note though is that it names the datatype of the column as GEOMCOLLECTION if you query geometry_columns | 09:53 |
FrankW | ok, later today I'll try and incorporate that in the OGR driver. | 09:53 |
atrofast | Thank you :) | 09:54 |
*** maida01 has quit IRC | 09:55 | |
*** ukjay has quit IRC | 10:48 | |
*** Dejan has joined #ingres | 11:11 | |
*** Mud has quit IRC | 11:39 | |
*** mull has quit IRC | 11:57 | |
*** mull has joined #ingres | 12:10 | |
*** withdefault has quit IRC | 13:11 | |
*** cthibert has left #ingres | 13:24 | |
*** Mud has joined #ingres | 13:26 | |
*** atrofast has quit IRC | 13:41 | |
*** mull has quit IRC | 13:49 | |
*** Dejan has quit IRC | 13:58 | |
*** Mud has quit IRC | 13:58 | |
*** Mud has joined #ingres | 14:01 | |
*** zxiiro has quit IRC | 14:08 | |
*** Mud has quit IRC | 14:14 | |
*** Alex| has quit IRC | 14:16 | |
*** Mud has joined #ingres | 14:23 | |
*** Mud has quit IRC | 14:43 | |
*** zxiiro has joined #ingres | 14:51 | |
*** ChanServ sets mode: +v zxiiro | 14:51 | |
*** DarylM has quit IRC | 15:15 | |
*** rossand has quit IRC | 17:38 | |
*** ukjay has joined #ingres | 19:02 | |
*** ukjay has quit IRC | 19:06 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:23 | |
*** cytrinox_ is now known as cytrinox | 19:23 | |
*** Alex| has joined #ingres | 23:35 | |
*** ChanServ sets mode: +o Alex| | 23:35 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!