The Maricopa County Assessor static parcel maps are made available as zipped PDF files. Map IDs are broken down as Township & Range - Section - Quarter Section - Quarter Quarter. For example 807-18-04-00 would be: 807 -- Township 3 North, Range 4 East 18 -- Section 18 04 -- The SouthEast Quarter 00 -- There are no separate quarter quarter maps. MapIDs are only generated where parcels exist with Maricopa County. Last update of a MapID is indicated by the BEGIN_DATE field.

Assessor Book Boundaries are the aggregated boundaries of the first three digits of an Assessor Parcel Number (APN).

SOURCE

This data was obtained from the Maricopa County Assessor under the search "Fast Food". The query has approximately 1342 results, with only 1000 returned due MCA Data Policies.

DATA CLEANING

Due to some Subdivision Name values posessing unescaped commas that interfered with Pandas' ability to properly align the columns, some manual cleaning in Libre Office was performed by me.

Aside from a handful of Null values, the data is fairly clean and requires little from Pandas.

NULL VALUES

Here are the sums and percentage of NULLS in the dataframe. Interestingly, there are 17 NULLS that do not have any physical addresses. This amounts to 1.7% of values for the Address, City, and Zip, and are all corresponding rows for those missing values.

I have looked into a couple of these on the Maricopa County Assessor's GIS Portal, and they do not appear to have any assigned physical addresses. This is a good avenue of exploration for EDA. Possibly an error that could be corrected, or some obscure legal reason, but interesting nonetheless.

Additionally, there are 391 NULLS in Subdivision Name accounting for 39.1%. This is a feature that I am interested in exploring to determine if there are any predominant groups. It could also generate a list of Entities that can be searched later to see if the dataset can be enriched beyond it's initial 1,000 record limit.

There are 348 NULLS in the MCR column. This is the definition according to the MCA Glossary

MCR (MARICOPA COUNTY RECORDER NUMBER)
Often associated with recorded plat maps.

This seems to be an uninteresting nominal value, so I will drop this columns.

While Property Type and Rental have no NULLS, 100% of those values are Fast Food Restaurant and N (for No), and therefore offer no useful information, and will be dropped.

I will leave the S/T/R column, although it also seems to be uninteresting nominal values, I am curious if there are predominent groups, and since it also has no NULLS, might be useful for further data enrichment.

Recorded subdivision boundaries for Maricopa County. Includes the Maricopa County Recorder (MCR) number and subdivision name.

MISSING

Parcels are identified by an Assessor's Parcel Number (APN) consisting of a three digit Book number, a two digit Map number, a three digit Item number, possibly a Split letter. This dataset contains all active parcels within the area encompassed by Book Series 100. State and Federal lands are not represented. Vertical parcels are annotated using the Floor field.

Parcels are identified by an Assessor's Parcel Number (APN) consisting of a three digit Book number, a two digit Map number, a three digit Item number, possibly a Split letter. This dataset contains all active parcels within the area encompassed by Book Series 500. State and Federal lands are not represented. Vertical parcels are annotated using the Floor field.

This dataset contain the parcels from the Maricopa County Assessor's office. The area covered is in Maricopa County (Phoenix metro area), Arizona. Major cities include Phoenix, Scottsdale, Mesa and Tempe. Various types of property usage are depicted in this layer. The most common are residential, commercial, industrial and agricultural properties. Multiple sources were used to collect the information including but not limitied to CAD packages, aerial photography, and digitizing from paper maps. Adjustments are made where necessary in the process of updating and some parcel lines are only approximate. In cases where a line adjustment might create a loss of landsize it is typically taken out from the right of way to minimize the loss of landsize in the property. The line symbology for different property lines are not available in this dataset. In addition to standard fields the data has unique assessor parcel number for identification, basic temporal information and the location of property.

Parcels are identified by an Assessor's Parcel Number (APN) consisting of a three digit Book number, a two digit Map number, a three digit Item number, possibly a Split letter. This dataset contains all active parcels within the area encompassed by Book Series 400. State and Federal lands are not represented. Vertical parcels are annotated using the Floor field.

Parcels are identified by an Assessor's Parcel Number (APN) consisting of a three digit Book number, a two digit Map number, a three digit Item number, possibly a Split letter. This dataset contains all active parcels within the area encompassed by Book Series 400. State and Federal lands are not represented. Vertical parcels are annotated using the Floor field.