![]() ![]() Sql::Connection * conectaDB(string dbSvr, string dbUsr, string dbPwd, string dbNombre) ĭbCon = conectaDB("dbserver", "dbuser"), "dbpasswd", "dbname") You can call the new kml to googlemaps and it shows pretty nice.Rearrange the information and print it out to the file.I'd wrote a little C++ program to do MySQL WKT polygons to KML polygons. Where AsStringOfCoords() would be my custom function. So, I am really looking for a function to convert WKT to a string of its constituent point coordinates, kinda like so SELECT AsStringOfCoords(WKT_Column) FROM table WHERE condition I am thinking I could use this to either write a stored procedure that will query the WKT column and spit out a string of JSON text that could be readily converted to Google Maps polys, or even preprocess all the WKT polys and store them as text like it is already done, but this time with correct values. the first issue, I have to re-implement this, and am looking for a converter that will convert a WKT poly into a string of coordinates. ![]() This actually works rather well, but not well enough.įor one, the conversion was occasionally faulty, and for two, I am looking for ways to make this faster. Since Google Maps polygon overlay requires an array of points, the previous user converted the WKT values to coordinate pairs and stored them in another column. The polys are queried and rendered on Google Maps. ![]() I have a column of WKT POLYGON values in MySQL (I inherited the db).
0 Comments
Leave a Reply. |