SQL EXPORT TO SHAPE FILES

[gis.68227]

I am looking for the fastest method for transferring database information into a shape file. Exporting using Map with a direct link to a database (mdb) is slow ( very slow - it took 4 hours to export 367 out 16000+ records). IF the database is text, excel, dbf or other would it be faster? The fastest way of exporting I can think of would be to Mapexport4 it and than rewrite the dbf using the ehandle as the link between. I was hoping for a direct method that will take under an hour. I can use ERSI software, but I prefer using MAP when possible. What are your experiences? Thanks, TC

[mjfarrell]

I would like to see the data and the query that you are employing here.
As I have not experienced this type of slow response from MAP
unless there are issues with the users network. Most commonly
if the data is being written to a Network Attached Storage device.
Try relocating the data locally if possible and test the speed of the operation.


Do these offer any clues:

http://usa.autodesk.com/adsk/servlet/ps/item?siteID=123112&id=2866278&linkID=2786831

http://usa.autodesk.com/adsk/servlet/ps/item?siteID=123112&id=2880255&linkID=2786831

[hastin_m]

Hi,
I'm having the same problem....
All of my files reside on the same drive. So there is no network issues.
I've noticed that attaching a database to block attributes and the export to shape commands are extremely slow. Especially for large projects.
However, I had the opportunity to try it on some older software I think it was map enabled ldd3 and it was blazing fast.
What has changed since LLD3 to 2008 with regards to these two commands?

Thanks

Mitch

[Jmurphy]

The Map export engine, prior to 2006 map used the FME engine in 2006/7 Autodesk wrote thier own with more options. Try "mapexport4" and see if it's any faster.



Hi,
I'm having the same problem....
All of my files reside on the same drive. So there is no network issues.
I've noticed that attaching a database to block attributes and the export to shape commands are extremely slow. Especially for large projects.
However, I had the opportunity to try it on some older software I think it was map enabled ldd3 and it was blazing fast.
What has changed since LLD3 to 2008 with regards to these two commands?

Thanks

Mitch

[hastin_m]

thanks,

any suggestions or changes to the way to connect and link the database quicker????

my end goal is to export my merged ms access database and parcel map to a shape file so i can update a mapguide server on a weekely basis.

connecting the database generating the links and then exporting the closed polylines is a long and tedious proccess to do every week. Is their a better way??Or is this the way autocad intended?? i feel as if i'm being herded into the fdo environement where i directly edit shape files. Thats all well and good but with a shape file i have to track mulitple items from our database and edit them in the shape file as well. with the old method all i have to do is track parcel number changes and the database and parcel number link do the rest. Also i feel editing the shape file is still a little clunky with the fdo.

Mitchell Hastings

[Jmurphy]

Use FDO to connect to the shp files and the Access database, do a join between the two and save to SDF format, then use that SDF in Map Guide, What version of Map Guide are you running? Any version above 6.5 will run better using the SDF over the SHP as a side benefit.

[hastin_m]

I'm using mapguide 6.5, havent upgraded yet. I'll try to work with the fdo but i've found the join doesn't work I've tried to do it several ways. It only connects to the first record?? I'll try again.

Thanks

i tried the mapexport4 it worked but wouldn't let me export any attribute data.