Re: [Geotools-gt2-users] mysql2shape problems

2011-07-11 Thread lexmc
No one have a suggestion??? -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/mysql2shape-problems-tp6467339p6570382.html Sent from the geotools-gt2-users mailing list archive at Nabble.com. -- All

Re: [Geotools-gt2-users] mysql2shape problems

2011-07-11 Thread Ian Turton
On 11 July 2011 11:15, lexmc lexm...@gmail.com wrote: No one have a suggestion??? Your database table doesn't have it's SRID/CRS set properly. Refer to the MySQL documentation for more help. Ian -- All of the data

Re: [Geotools-gt2-users] mysql2shape problems

2011-07-11 Thread lexmc
I have to set the srid from mysql client??? -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/mysql2shape-problems-tp6467339p6571187.html Sent from the geotools-gt2-users mailing list archive at Nabble.com.

Re: [Geotools-gt2-users] mysql2shape problems

2011-07-11 Thread Ian Turton
On 11 July 2011 15:53, lexmc lexm...@gmail.com wrote: I have to set the srid from mysql client??? well yes - how else can GeoTools work out what the numbers mean? Ian -- All of the data generated in your IT

Re: [Geotools-gt2-users] mysql2shape problems

2011-06-13 Thread lexmc
Ok. I have converted a shapefile in a sql file with a tool named shp2mysql. So i have imported this file in my mysql database and i have a table with a geometry column. Now a have to write a java program that connecting to my database open my table with geometry column in a map. Thi is my code:

[Geotools-gt2-users] mysql2shape problems

2011-06-12 Thread lexmc
Hi guys I have some problems with an application i'm developing. I'm tryng to open a shapefile from a table in mysql database. But I got these errors: 12-giu-2011 14.27.57 org.geotools.jdbc.JDBCFeatureSource buildFeatureType AVVERTENZA: Error occured determing srid for prova.ogc_geom

[Geotools-gt2-users] mysql2shape problems

2011-06-12 Thread Alessandro La Sala
Hi guys I have some problems with an application i'm developing. I'm tryng to open a shapefile from a table in mysql database. But I got these errors: 12-giu-2011 14.27.57 org.geotools.jdbc.JDBCFeatureSource buildFeatureType AVVERTENZA: Error occured determing srid for prova.ogc_geom

Re: [Geotools-gt2-users] mysql2shape problems

2011-06-12 Thread Jody Garnett
Your problem does not make sense to me; shapefile is a file format - and mysql is a database? In any case it sounds like mysql wants to lookup the spatial reference system identifier for the table prova - column ogc_geom. There should be a table somewhere in mysql that documents what the