| 00:39:50 | agelos: | noone knows :( |
| 10:03:37 | agelos: | SPATIALITE ERROR: no such table: geometry_columns .....any ideas ? |
| 10:05:13 | crschmidt: | does your db have a geometry_columns table? |
| 10:06:02 | agelos: | yes |
| 10:06:05 | agelos: | it does |
| 10:06:48 | agelos: | i am using command : spatialite_tool.exe -e -shp demo.shp -d demo.sqlite -t RiversExported -g Geometry -c CP1253 |
| 10:11:04 | wildintellect: | is Geometry the name of your geometry column? |
| 10:12:27 | darkblue_B: | I wonder if there is a way to issue commands in the GUI version and then see the log for a CLI equivalent |
| 10:12:46 | darkblue_B: | the few things I've done in the GUI version have worked flawlessly |
| 10:13:11 | wildintellect: | no probably not since the GUI hits the C functions directly |
| 10:13:22 | darkblue_B: | hmmm |
| 10:15:58 | wildintellect: | agelos, remove .shp from demo.shp |
| 10:16:16 | wildintellect: | instructions specifically say you have to leave the suffix off |
| 10:16:51 | agelos: | oh propably i forgot it |
| 10:16:57 | agelos: | sorry and thank you |
| 10:17:02 | agelos: | let me check |
| 10:20:04 | agelos: | yes Geometry is the name of the column |
| 10:21:12 | agelos: | removing the .shp extension did not solve the problem |
| 10:21:14 | agelos: | :( |
| 10:21:23 | wildintellect: | this worked for me spatialite_tool -e -shp example -d test-2.2.sqlite -t Towns -g Geometry -c CP1252 --type POINT |
| 10:21:31 | wildintellect: | maybe the geometry type is not optional |
| 10:21:56 | agelos: | i used the spatialite-gis to open the sqlite file and it says |
| 10:22:04 | agelos: | Missing or invalid Spatial Metadata tables: |
| 10:22:07 | agelos: | - spatial_ref_sys |
| 10:22:08 | agelos: | - geometry_columns |
| 10:22:09 | agelos: | Sorry, cowardly quitting ... |
| 10:22:21 | wildintellect: | ah did you ever run the init.sql |
| 10:22:49 | wildintellect: | http://www.gaia-gis.it/spatialite/init_spatialite-2.3.zip |
| 10:23:19 | wildintellect: | you need to run the init script on any new database in order to create the spatial metadata tables and triggers for managing geometry |
| 10:23:28 | wildintellect: | even if you used the gui to create the database |
| 10:32:58 | : | * springmeyer just ran through the 'express install' of osgeo4w... |
| 10:33:18 | springmeyer: | then realized that it does not install the plugin manager for QGIS... |
| 10:33:28 | springmeyer: | ( ugh ) |
| 10:34:06 | springmeyer: | so, going back to 're-install' and I'm noticing that clicking through all the defaults takes me to... |
| 10:34:20 | racicot: | springmeyer: you can just run again and select custom install and it will keep what you have and you can just add what else you need... |
| 10:34:53 | springmeyer: | 'Select Local Package Directory' with the default path of 'c\Program Files\Mozilla Firefox' |
| 10:35:02 | racicot: | it should be "smart" about knowing what is there and letting you update/upgrade/install new stuff in the future... |
| 10:35:17 | springmeyer: | ya, right, but it appears not to be? |
| 10:35:47 | racicot: | the local package dir is just like the temp dir I think for downloading and keeping install packages... not the install dir |
| 10:35:56 | springmeyer: | ah |
| 10:36:22 | racicot: | there should have been another window with install dir... c:\osgeo4w or something like that... |
| 10:36:23 | springmeyer: | so, I'll pretend to be a new user and just click through ( allowing temp files to go into 'Mozilla Firefox' : ) )... |
| 10:36:37 | racicot: | good plan ;- ) |
| 10:38:41 | wildintellect: | fyi, future versions of OSGeo4w have Grass & Python included in the QGIS express install |
| 10:39:48 | springmeyer: | wildintellect: that is __good__ : ) |
| 10:41:35 | wildintellect: | ya, I actually haven't found anyone yet that doesn't want those when they install QGIS and so many that did |
| 10:41:48 | wildintellect: | I think jef fixed it in the svn already |
| 10:42:15 | springmeyer: | that is great. its asking a lot of new users to know how to find that in the 'libs' custom install spot |
| 10:45:27 | springmeyer: | u-oh |
| 10:45:53 | springmeyer: | clicking to open a 'vector layer' in qgis now prompts a python traceback, that is odd |
| 10:46:21 | springmeyer: | looks like I've got some messed up python stuff, but strange that would be prompted when opening a vector layer |
| 10:46:22 | springmeyer: | http://dpaste.de/8a8n/ |
| 10:46:23 | sigq: | Title: dpaste.de: Snippet #1149 ( at dpaste.de ) |
| 10:48:29 | racicot: | springmeyer: that is strange... it is trying to use tortoise... |
| 10:50:07 | springmeyer: | ya : ) |
| 10:50:26 | springmeyer: | so now forging ahead, paths like this are okay with pyqgis? |
| 10:50:36 | springmeyer: | File "C:/Documents and Settings/Administrator/.qgis//python/plugins\quantumnik\sync.py", line 247, in shape ? |
| 10:50:52 | springmeyer: | looks like trouble : ) |
| 10:56:07 | agelos: | when i execute the sql file i get : no such function: InitSpatialMetaData |
| 10:58:57 | darkblue_B: | agelos: have you tried the GUI version of spatialite? |
| 11:22:24 | agelos: | unfortunately the GUI version of spatialite doesn't fit my needs .... i need to run shell commands :( |
| 11:29:02 | wildintellect: | agelos, what command did you use to run the sql script? |
| 11:32:20 | agelos: | the command i run to execute is Dim cmdStartup As SQLiteCommand = cnn.CreateCommand( ) |
| 11:32:22 | agelos: | cmdStartup.CommandText = initSContents |
| 11:32:27 | agelos: | cmdStartup.ExecuteNonQuery( ) |
| 11:32:53 | agelos: | initSContents are the contents of the init_sql script |
| 11:36:40 | wildintellect: | did you load the spatialite extension into sqlite first? |
| 11:41:15 | wildintellect: | agelos, I know you're using .net( or vb ) in python it looks kinda like so http://pastebin.com/m4ebe2771 |
| 11:41:16 | sigq: | Title: Python pastebin - collaborative debugging tool ( at pastebin.com ) |
| 12:00:48 | agelos: | i cannot figure out what means AddGeometryColumn has as parameters |
| 12:04:49 | agelos: | AddGeometryColumn( table String , column String , srid Integer , geom_type String , dimension Integer [ , not_null Integer ] ) : Integer |
| 12:10:02 | agelos: | ok i found it |
| 13:11:01 | agelos: | the error in spatialite remains even if i execute the correct comands |
| 13:11:05 | agelos: | dump shapefile MetaData error: <no such table: geometry_columns> |
| 13:11:07 | agelos: | Some ERROR occurred |
| 13:22:06 | dylanB_UCD: | heu |
| 13:23:45 | wildintellect: | what's up Dylan? |
| 13:27:32 | dylanB_UCD: | hi alex--- talking to brian hamilan |
| 13:37:43 | dylanB_UCD: | I here that you've done quite a job organizing the CA chapter! |
| 13:40:47 | wildintellect: | anything to avoid thinking about stats |
| 13:41:08 | dylanB_UCD: | heh |
| 13:41:51 | wildintellect: | oh the whole finishing my thesis bit |
| 13:42:28 | wildintellect: | you all done with your tests? |
| 13:52:03 | dylanB_UCD: | yeah-- feels good to be done with those. |
| 13:52:13 | dylanB_UCD: | I would like to spend more time on OSGEO / updating the GRASS test suite |
| 13:54:53 | dylanB_UCD: | hey alex -- is there any mechanism in OSGEO for case study demos / or something like this ( http://postgis.refractions.net/documentation/casestudies/ ) |
| 13:54:54 | sigq: | Title: PostGIS : Case Studies ( at postgis.refractions.net ) |
| 13:55:23 | dylanB_UCD: | seems like it would be nice to collect some of these in the main OSGEO site / or on the regional chapters. |
| 13:56:26 | wildintellect: | yes, there are a couple of mechanisms you could use - not perfect but they do exist |
| 13:56:51 | wildintellect: | 1, if it's a blog entry you can have your blog added to planet.osgeo.org |
| 13:57:25 | wildintellect: | 2, there is a wiki page http://wiki.osgeo.org/wiki/Case_Studies |
| 13:57:26 | sigq: | Title: Case Studies - OSGeo Wiki ( at wiki.osgeo.org ) |
| 13:57:36 | wildintellect: | 3, OSGeo Journal/ OSGeo svn |
| 13:58:08 | wildintellect: | http://svn.osgeo.org/osgeo/journal/volume_5/en-us/case_studies/ |
| 13:58:09 | sigq: | Title: Revision 1581: /journal/volume_5/en-us/case_studies ( at svn.osgeo.org ) |
| 13:58:56 | wildintellect: | I can propose a more dedicated tool at the next marketing meeting, or you could do it at the next webcom meeting |
| 14:00:03 | wildintellect: | maybe we need something similar to http://www.osgeo.org/educational_content |
| 14:00:06 | sigq: | Title: OSGeo Educational Content Inventory | OSGeo.org ( at www.osgeo.org ) |
| 14:21:55 | dylanB_UCD: | thanks alex, I'll check into that |
| 15:01:27 | TylerM: | dylanB_UCD: welcome to the Planet... http://planet.osgeo.org/ |
| 15:06:28 | dylanB_UCD: | thanks tyler! |
| 15:06:45 | TylerM: | you're welcome.. glad to have you join us ;- ) |
| 15:07:25 | dylanB_UCD: | i can |
| 15:07:51 | dylanB_UCD: | i wasn't aware of it, but I should have! been under the radar for the last 5 months... |
| 15:08:11 | dylanB_UCD: | oops, hit return a little too soon there. |