nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get MDB file fields to a shape file?

BrianBenton

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?

Najděte více příspěvků označených jako

Accepted answers

DarrenWiens2

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.

All comments

JonathanLlagas

What type of mdb you make (MS Database Program or File/Personal Geodatabade)

JonathanLlagas

mdb extension is database, you need to make database connection.

NeilAyres

Thinking about it....

The loader wizard is probably a wrapper around the append tool.

NeilAyres

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.

DarrenWiens2

Is this identical to Append?

NeilAyres

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.

WesMiller

You may want to check your mdb for domains. A quick tour of attribute domains—ArcGIS Help | ArcGIS for Desktop

DarrenWiens2

BrianBenton

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.

DarrenWiens2

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.

BrianBenton

It is a personal geodatabase.

DarrenWiens2

Is your MDB file a personal geodatabase feature class or table?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.