Wow, sounds like you have quite a project. Yes, moving all of this data into a spatial database would probably make the most sense. Look at possibly using PostGIS and the maturing PostGIS FDO provider with MGOS. There are other options, such as Oracle Spatial and MsSqlSpatial for SQL Server. In both cases, you can use the open source King FDO providers (www.sl-king.com). Obviously, moving all of this data into the spatial databases will take some significant cleanup, standardization and effort, but once that is done, your maintenance processes should become much easier than having to deal with 10,000 flat files. You may also want to consider looking at Safe Software FME (www.safe.com) for doing bulk extract, transform and loading of your data. It is an invaluable tool for situations such as these. It is not open source, but it is well worth the money.
Andy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marty Coonrod Sent: Wednesday, October 31, 2007 10:25 AM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Best method to use dwg files Andy, Thanks for the reply and please excuse my ignorance in this area. The maps are 15 deg tile maps that cover 4 adjoining states. These were then further broke out into a "master grid" to fit the 3000' x 2000' map size. Then information was drafted on these. I can't use the originals because when errors were found or a subdivision that was missing was added they were not placed on their own layer. This is not quite the way I would have done things but we work with what we have. There is a layering standard but as with most major projects there will be some clean up. The layer count is 191 layers but each map has some temp layers that will need to be purged. Most of the layers have only one type of information lines, blocks, text, etc. but there are a couple that mix lines and blocks and I am guessing I may want to change that. All of the blocks have some type of attribute information or another that would be nice to be able to retrive. I have a program I developed that will extract/inject all the attribute information to/from a SQL Server database. I have recieved my Mapguide CD from Autodesk and installed Mapguide Enterprise 2008 Server and Studio trials and went through the exercises that were provided in the "Getting Started Guide". That is the extent of my training but I understand the concept somewhat. This is something I am doing on my own so its not company funded yet so I plan to switch to the open source server. I just used the Autodesk version for the exercises because a couple things did'nt work without it. Hopefully I can at least get them to spring for the studio portion if that is sold seperately. After all that rambling on what I am looking for is just some advice as how to aproach it so I don't just make a huge mess and have to start over again and again. Thanks, Marty Andy Morsell wrote: > > There are many potential approaches to this depending on the source data. > Are these 10,000 maps actually tiled maps that you would like to > display on one MapGuide map? Such as individual USGS T-R grids that > are edge-matched? > Or, are they completely independent of one another and would be > separate MapGuide maps? Are there consistent layering standards for > all of the DWG's? > > Andy Morsell, P.E. > Spatial Integrators, Inc. > http://www.SpatialGIS.com > > _____ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marty > Coonrod > Sent: Tuesday, October 30, 2007 10:04 AM > To: mapguide-users@lists.osgeo.org > Subject: [mapguide-users] Best method to use dwg files > > > > I have a lot of maps (approx 10,000) that were created in AutoCAD. The > dimensions are 3000' x 2000' and were created using USGS base. I would > like to bring all of this data into Mapguide and was wondering what > the best approach would be. I have AutoCAD, AutoCAD Map 3D, Mapguide > studio to use. > I > am just not sure if I should create larger files or try to move some > of the data to a database. > I would still like to edit the maps and update the server when necessary. > > Marty > > > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/Best-method-to-use-dwg-files-tf4719897s16610.html#a135 14509 Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users