Use this helpful documentation to make sense of MPROP attribute table.
GIS Web Services - City of Milwaukee
The City of Milwaukee has maps available for viewing on their webpage or via a web service connection in ArcMap. The features available for viewing are immutable, and cannot be downloaded or manipulated. If you are interested in obtaining data as a direct download from the City of Milwaukee, please contact us at email@example.com, and we will work on obtaining this data for you.
What is MPROP?
MPROP is the Master Property Record for the City of Milwaukee. It is a large table that contains one record for each property in the city. This record is updated every Monday, so the information is always up-to-date.
There is a lot of information that can be gleaned from using the Master Property Record (MPROP), especially in a GIS setting. Not only can you find out Taxkey, Area of Property, Address, Legal Description, Owner Name, Owner Mailing Address, Year Built, Area of Buildings on Property, Number of Beds, Baths, and Fireplaces for any property in the City of Milwaukee, but MPROP also contains Land Use Categories.
The Land Use Codes contained in MPROP are expansive. Please find a full description in the MPROP documentation (PDF) provided with this LibGuide. Navigate to Appendix G to find explanations of the codes:
These 12 categories are then expanded into sub-categories. The subcategories provide specific land use information for each property. For example, the following is taken from the expansion of Land Use Category 5, "Wholesale and Retail Trade." What this means is that using MPROP, one could visualize in a map all of the places in Milwuakee that sell footwear (Category 5, Subcategory 5139).
The complete list of available sub-categories is located within Appendix G of the MPROP Documentation.
How to Use MPROP with GIS Software
The City of Milwaukee makes an updated Master Property Record available every Monday in tabular form. They also provide a parcel boundary shapefile. One can download the table only, and search for records individually, but in order to perform high-level analysis and data visualization, it is necessary to join the MPROP table with the parcel boundary shapefile.
Included below are instructions on how to do this. For help using MPROP data, or to receive a pre-joined MPROP/parcel shapefile, fill out the AGSL's Data Request Form, or email us at firstname.lastname@example.org.
How to Download MPROP Tables and Join them with Parcelbase Boundary Shapefile
Step 1). Download MPROP table in MS Excel format. Move table to a working folder of your choice.
Step 2). Download Parcel Boundary Shapefile.
(Scroll down to Parcel Outline and select parcelbase.zip).
Step 3). Extract (unzip) parcelbase to a working folder of your choice.
Step 4). Open table and parcel shapefile in ArcMap. Be patient with the MPROP table; it can take a long time to load the data into ArcMap and open the attribute table.
Step 5). Right-click parcel boundary shapefile and select Joins and Relates > Joins.
Step 6). Join parcel layer and MPROP table based on field "TAXKEY"
Now the layers are one and each parcel has its corresponding property ownership and land use information attached.
Step 7). If you wish to work with a smaller area, select area of interest (either manually or by query). Then right click the parcelbase layer and choose Selection > Create Layer From Selected Features.
*Step 8). Crucial. If you want the join to save, you will need to export and create a new shapefile. Joins are not automatically permanent. Right-click the joined layer, select Data > Export Data. Choose where you want to save the new shapefile and press 'Save.' You should now be able to access your new joined parcelbase and MPROP data whenever you want.