Any tools to generate spatial data as input for MySQL
Posted by:
ken ze
Date: May 14, 2005 02:08AM
Hi
I got a spatial map data input file for MySQL from Geotools, the format of one record looks like this:
insert into roads (gid,ID,CAT_ID,CAT_DESC,the_geom) values('2','3','5','0',GeometryFromText('MULTILINESTRING ((596176.63775691 4917296.55905796 ,596155.33137867 4917308.10447989 ,596101.73372434 4917348.86033492 ,596082.75835334 4917403.7130012 ,596086.1489683 4917514.11087491 ,596073.34296719 4917530.5524544 ,596034.95054943 4917568.89912403 ,596030.0767432 4917573.15864968 ))',-1) );
The problem is that there are hundreds of these kinds of records to build a spatial map. If we want to build our own map, any GUI tools to support to generate this data?
Ken