I have a shape file with CAD linework (watermain pipe) and an MDB (from the local City GIS department for turnover) file with a table of headers that I need to apply to the shape file linework. How to I get the fields from the MDB file to my shape file?
I would append the features to the MDB feature class, then export back out to shapefile if you need it in that format. This will give you an empty table, with the fields you need, associated with your shapefile features.
What type of mdb you make (MS Database Program or File/Personal Geodatabade)
mdb extension is database, you need to make database connection.
Thinking about it....
The loader wizard is probably a wrapper around the append tool.
Similar I suppose.
But load doesn't apply a schema test as far as I am aware. Well, only if you only load one file at a time. If you select multiple files, then they all have to have the same schema.
Just gives you a dialog of source variables and what they might be mapped to. If you have a input attribute like "Myatt", but the target has "My_att", the right hand side (target) variable will be blank until you select it.
Works pretty well.
Is this identical to Append?
If the feature in the mdb is an empty line feature class (check with Catalog), you may be able to use the "load" function.
In what format is your input data, you saying it comes from CAD, but is it still like that?
Anyway, once you have the input sorted, right click on the target in Catalog, and select the option "load data".
This dialog also gives you the opportunity to map input and output fields.
You may want to check your mdb for domains. A quick tour of attribute domains—ArcGIS Help | ArcGIS for Desktop
The MDB file is empty. All it contains is the headers for the fields that I need to populate for each pipe in my CAD file (diameter, length, material, etc.) So I need those fields in my SHP file so I can fill in the data.
Without any other information, it sounds like you may be able to use the Append tool. Append adds features from a feature class (your CAD linework) to another feature class (your personal geodatabase feature class), using the latter's table schema. You can match up fields between the two using the field map parameter.
It is a personal geodatabase.
Is your MDB file a personal geodatabase feature class or table?
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
