sdf to shp converter

[Anonymous]

I want to be able to convert an sdf to shp. I am trying to QC some real estate data where I have "N" number of total real estate records, "M" number of sdf polygons (upon export from AutoCAD Land Dev 2005), and "O" number of shp polygons/records (upon export from AutoCAD Land Dev. 2005).

I need to be able to match up the records. I have real estate data in a table in MS Access,
I exported the shp dbf and saved it as excell and imported to access,
now i need a table from my sdf file to be generated where i can compare parcel ID numbers (all files are using the same id numbers so i should be able to match them up based on that ID number to find where the discrepancies are)

Anyone know where i can get an sdf to shp converter (similar to the FREE SDF LOADER GUI)

[Anonymous]

It sounds like you may have Autodesk Map already (as part of Land Desktop)?
If so, you can import the SDF file and then export as Shape. If you are
trying to compare your already exported SDF versus Shape, then your only
other option is to use Safe Software's FME product, which costs in the $2k
range.

Also, you can directly import a .DBF file into Access and don't need to go
through Excel. Use the Table Import option and choose dbase IV format.
Also keep in mind that Excel has a maximum record limit of 50,000 so your
data may get truncated if somewhat large.


--
Andy Morsell, P.E.
Spatial Integrators, Inc.
http://www.SpatialGIS.com


wrote in message news:5069941@discussion.autodesk.com...
I want to be able to convert an sdf to shp. I am trying to QC some real
estate data where I have "N" number of total real estate records, "M" number
of sdf polygons (upon export from AutoCAD Land Dev 2005), and "O" number of
shp polygons/records (upon export from AutoCAD Land Dev. 2005).

I need to be able to match up the records. I have real estate data in a
table in MS Access,
I exported the shp dbf and saved it as excell and imported to access,
now i need a table from my sdf file to be generated where i can compare
parcel ID numbers (all files are using the same id numbers so i should be
able to match them up based on that ID number to find where the
discrepancies are)

Anyone know where i can get an sdf to shp converter (similar to the FREE SDF
LOADER GUI)

[Anonymous]

thanks for getting back to me,

I am really hoping to work outside of the Autodesk environment because I want to know if the differences between the files are real or not. Like I said the shp has a certain amount of records and sdf has a certain amount of records, they are both generated from the same dwg being exported out of LandDesktop 2005 utilizing the Autodesk Map funtionality.
So i'm thinking, why the differences and if i convert the SDF to SHP outside of Land Desktop and upon the conversion there are the same differences in number of polygons/records I'll know
1 there is something going on in our export process
2 i can match the two shp's against one another to determine those diffences

thanks again for lending advice

(like i said i am hoping to find a free "sdf2shp converter" I could download, similar to the SDF Loader)

John Brady

[Anonymous]

I know of no free tools to convert from SDF to anything else. Send me a
personal email and I might be able to convert this via FME for you on a one
time basis. However, I think that FME may give you the exact same results
since it uses the SDF COM Toolkit for its SDF Writer. I imagine that, at
the core, this is the same as what Autodesk Map is using for its SDF export.

Andy

wrote in message news:5070628@discussion.autodesk.com...
thanks for getting back to me,

I am really hoping to work outside of the Autodesk environment because I
want to know if the differences between the files are real or not. Like I
said the shp has a certain amount of records and sdf has a certain amount of
records, they are both generated from the same dwg being exported out of
LandDesktop 2005 utilizing the Autodesk Map funtionality.
So i'm thinking, why the differences and if i convert the SDF to SHP outside
of Land Desktop and upon the conversion there are the same differences in
number of polygons/records I'll know
1 there is something going on in our export process
2 i can match the two shp's against one another to determine those diffences

thanks again for lending advice

(like i said i am hoping to find a free "sdf2shp converter" I could
download, similar to the SDF Loader)

John Brady

[Anonymous]

bradyjp wrote:
> I want to be able to convert an sdf to shp. I am trying to QC some real estate data where I have "N" number of total real estate records, "M" number of sdf polygons (upon export from AutoCAD Land Dev 2005), and "O" number of shp polygons/records (upon export from AutoCAD Land Dev. 2005).
>
> I need to be able to match up the records. I have real estate data in a table in MS Access,
> I exported the shp dbf and saved it as excell and imported to access,
> now i need a table from my sdf file to be generated where i can compare parcel ID numbers (all files are using the same id numbers so i should be able to match them up based on that ID number to find where the discrepancies are)
>
> Anyone know where i can get an sdf to shp converter (similar to the FREE SDF LOADER GUI)

I have uploaded a tool sdf2shp to following website that will let you
convert SDF data to SHP.

http://www.spatialorder.com/tools/

This tool depends on SDF COM Toolkit installed on your machine, so make
sure that you have installed it before you run sdf2shp. I haven't tested
it exhaustively, but following might be useful to know:

(1) It supports poly-polyline and poly-polygon types of sdf objects.
However, I haven't been able to test it as I don't have such sdf data.

(2) SDF file supports multiple types of objects to be present in it.
Accordingly, the tool creates _POINT.shp,
_POLYLINE.shp and _POLYGON.shp output files.
However, I haven't been able to test it as I don't have such sdf data.

Also, at the baove url you will find some other useful converters. Feel
free to use them and let me know if you run into any problems.

Jatin
=============

[Anonymous]

That's an impressive tool. It's very fast. It converted a 30 MB SDF file
in just a few seconds. Thanks for sharing that with the group.

Andy

"Kaarigar" wrote in message
news:5072498@discussion.autodesk.com...
bradyjp wrote:
> I want to be able to convert an sdf to shp. I am trying to QC some real
> estate data where I have "N" number of total real estate records, "M"
> number of sdf polygons (upon export from AutoCAD Land Dev 2005), and "O"
> number of shp polygons/records (upon export from AutoCAD Land Dev. 2005).
>
> I need to be able to match up the records. I have real estate data in a
> table in MS Access,
> I exported the shp dbf and saved it as excell and imported to access,
> now i need a table from my sdf file to be generated where i can compare
> parcel ID numbers (all files are using the same id numbers so i should be
> able to match them up based on that ID number to find where the
> discrepancies are)
>
> Anyone know where i can get an sdf to shp converter (similar to the FREE
> SDF LOADER GUI)

I have uploaded a tool sdf2shp to following website that will let you
convert SDF data to SHP.

http://www.spatialorder.com/tools/

This tool depends on SDF COM Toolkit installed on your machine, so make
sure that you have installed it before you run sdf2shp. I haven't tested
it exhaustively, but following might be useful to know:

(1) It supports poly-polyline and poly-polygon types of sdf objects.
However, I haven't been able to test it as I don't have such sdf data.

(2) SDF file supports multiple types of objects to be present in it.
Accordingly, the tool creates _POINT.shp,
_POLYLINE.shp and _POLYGON.shp output files.
However, I haven't been able to test it as I don't have such sdf data.

Also, at the baove url you will find some other useful converters. Feel
free to use them and let me know if you run into any problems.

Jatin
=============

[Anonymous]

Andy Morsell wrote:
> That's an impressive tool. It's very fast. It converted a 30 MB SDF file
> in just a few seconds. Thanks for sharing that with the group.
>
> Andy

If you have any poly-polygon or poly-polyline data, can you try it out
on it? Also, it needs to be tested with SDF data having different object
types in it.

Jatin
=============

[Anonymous]

Kaarigar wrote:
>
>
> If you have any poly-polygon or poly-polyline data, can you try it out
> on it? Also, it needs to be tested with SDF data having different object
> types in it.
>
> Jatin
> =============

Sorry, clicked the send button too early. Basically, this tool works
with point, polyline and polygon data. I can test it with other types of
data if it is available.

Jatin
===========

[Anonymous]

Hmm. I tried it with some poly-polygon data I have and it missed quite a
bit. And, it appears that some of what it is missed was not poly-polygon
data. I started with about 5,000 polygons and the Shape file only has about
830 in it. I am sending you the SDF and SIF file to your email address if
you want to play with the data.

I tried it earlier with a mix of polyline and polygon data in one SDF and it
seemed to work OK, it produced one file for each. I did not do any further
QC'ing.

Andy

"Kaarigar" wrote in message
news:5072719@discussion.autodesk.com...
Andy Morsell wrote:
> That's an impressive tool. It's very fast. It converted a 30 MB SDF file
> in just a few seconds. Thanks for sharing that with the group.
>
> Andy

If you have any poly-polygon or poly-polyline data, can you try it out
on it? Also, it needs to be tested with SDF data having different object
types in it.

Jatin
=============

[Anonymous]

thanks for all the replies

i'm a newbie on the job,and you guys have been quick in offering help and forthcoming with information.

I don't have the SDF COM Toolkit on my machine, at the moment I only have the Map Guide Author package, and that is why i am even working with SDF's to begin with. From my understanding the SDF COM Toolkit is Autodesk's Proprietary data converter imbedded in their CAD products.

I did download a free 14 day trial of the Safe Software FME ETL Tools (unfortunately they still haven't sent me my license, I've completed the License Wizard 2x)

I'll figure it out,

I am curious as I haven't heard of this before, I sounds like you all are talking abut sdf files that have multiple object types in the file (ie points lines and polygons), it is my understanding that spatial data files can only be a point file, polyline file, or polygon file

john

[Anonymous]

SDF COM Toolkit is an optional installation component that you can install
from the main MapGuide CD. Normally it's installed on a server so you can
programatically modify existing SDF files, but in this case, you will need
to install it locally. You will need this for FME to work as well.

SDF files can contain a mixture of points, polylines and polygons. It's
really up to you if you want to store your data this way. My personal
preference is to try to keep only one spatial data type in a given SDF.

Andy

wrote in message news:5073030@discussion.autodesk.com...
thanks for all the replies

i'm a newbie on the job,and you guys have been quick in offering help and
forthcoming with information.

I don't have the SDF COM Toolkit on my machine, at the moment I only have
the Map Guide Author package, and that is why i am even working with SDF's
to begin with. From my understanding the SDF COM Toolkit is Autodesk's
Proprietary data converter imbedded in their CAD products.

I did download a free 14 day trial of the Safe Software FME ETL Tools
(unfortunately they still haven't sent me my license, I've completed the
License Wizard 2x)

I'll figure it out,

I am curious as I haven't heard of this before, I sounds like you all are
talking abut sdf files that have multiple object types in the file (ie
points lines and polygons), it is my understanding that spatial data files
can only be a point file, polyline file, or polygon file

john

[Anonymous]

hey andy,

i googled sdf com tool kit, saw the Autodesk Mapguide Release 6 page and read the same thing as what you say, that the toolkit comes with the mapguide cd. i did install the server piece.

do you work for autodesk? i've seen your name on other threads and got the feeling that combing the autodesk help page was part of your job decription. you seem to have a very large knowledge base in the spatial data field

also, because this is bugging my brain, can GIS process a file that is a mixture of object types (point, line, polygon)

thanks again for the help

[Anonymous]

No, I don't work for Autodesk and they don't pay me to participate in these
groups. I own and operate a small GIS consulting company that does quite a
bit of MapGuide custom development and consulting. I've been developing on
top of MapGuide for over 7 years so have had the opportunity to gain quite a
bit of knowledge and am now able to give back a little. Staying active in
this forum and helping people with technical issues is also good marketing
for myself and my company.

As far as your question is concerned, an SDF file can contain a combination
of points, lines and polygons, but when you author a layer against that SDF,
that particular layer can only be comprised of one of those primitive types.


--
Andy Morsell, P.E.
Spatial Integrators, Inc.
http://www.SpatialGIS.com


wrote in message news:5074662@discussion.autodesk.com...
hey andy,

i googled sdf com tool kit, saw the Autodesk Mapguide Release 6 page and
read the same thing as what you say, that the toolkit comes with the
mapguide cd. i did install the server piece.

do you work for autodesk? i've seen your name on other threads and got the
feeling that combing the autodesk help page was part of your job decription.
you seem to have a very large knowledge base in the spatial data field

also, because this is bugging my brain, can GIS process a file that is a
mixture of object types (point, line, polygon)

thanks again for the help

[Anonymous]

Andy Morsell wrote:
> Hmm. I tried it with some poly-polygon data I have and it missed quite a
> bit. And, it appears that some of what it is missed was not poly-polygon
> data. I started with about 5,000 polygons and the Shape file only has about
> 830 in it. I am sending you the SDF and SIF file to your email address if
> you want to play with the data.
>
> I tried it earlier with a mix of polyline and polygon data in one SDF and it
> seemed to work OK, it produced one file for each. I did not do any further
> QC'ing.
>

Andy,

Thanks for sending the test data. I have fixed sdf2shp and uploaded it
to http://www.spatialorder.com/tools . Please feel free to download and
give it a spin.

Jatin
==========

[Anonymous]

Jatin,

I never thanked you for offering your shp2sdf converter. Thanks.

I haven't tried it yet, but I will soon.

thanks again
john

[Anonymous]

Really nice tools! Thanks a lot.

In case someone needs the toolkit (needed by the tools):

http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=2525719&linkID=2733703

Really good!