Lab 9 - Urban Planning: GIS for Local Government

GIS 4048

In this week's lab we were introduced to Data Driven Pages, also known as Map Books.  The map listed below is one of several pages that were created for a series of extents defined by the index grid.

The processes to complete this map began with the downloading of data from the Marion County website.  I become familiar with the process of using the Marion County Property Appraisers website.  This allowed me to do a parcel search and locate Parcel Number 14580-000-00 and identify the owner and other characteristics about the property.  These details gave me insight into the type of zoning the property fell under as well as other details like how much a dog house cost to construct.  Utilizing the MAP IT functionality I was then able to export all parcels within 1 mile of my targeted parcel.  This gave me a good number of parcels.  Next I created a Site Map and began the process of joining data from the parcels to the CSV file that contained more details about the property, like owner name.  With my data now joined, I exported it out to a new feature class named Parcels_Join.  I then was able to identify the Zuko parcel and select all the properties within 1/4 mile of the location.  I now had a feature that showed all the properties that fell within the 1/4 mile.  Using the Explode Multi-Part Feature tool I exploded these features out, and was able to show all properties as individual attribute tables even if they were connected to another parcel. Using the Identify tool I was then able to go into the quarter mile parcel file and create a "map key" to be used in my report later.

Next came the Data Driven Pages.  I utilized the Grid Index Feature tool found in the ArcToolbox under Cartography Tools > Data Driven Pages to create a Grid at map scale 2400.  I then used the Select by Location tool to select the zoning that intersected the properties within 1/4 mile.  This reduced the zoning to just the isolated area I was working with.  I continued to add data to my main data frame such as Streets and parcels to make my map look more aesthetically pleasing, and added my map essentials.

I worked with the data grid directly to add a scale field to my attribute table.  Making all values equal to 2400.  I played around with the scale and found the best fit for my main data frame ( 105% worked well for me).  I added some dynamic text to the layout so that each page could be updated uniformly.

With the majority of the work completed on my main data frame, I focused in on my Locator map located in the bottom left.  Utilizing Layer Properties and the Definition Query > Page Definition I was able to set up a mask that would allow the page I was currently working with to be highlighted on the Locator Map.  This functionality is really great to work with and provides the reader an exact location that the main data frame is focused on.

With all my map essentials added and the pages ready to be published, I simply exported my map as a pdf.  All of the pages were joined into a single PDF document.

With the map completed, my focus then turned to the Map Key.  Using the Report Builder in  the attribute table (Table Options > Reports > Create Report) I was able to generate a report that showed a Map Key Identification Number, Parcel ID, Owner Name, Address, Zip Code, and Acreage.

I ran into a little difficulty with the requirements for the Report.  In particular the Zoning Code.  I could not locate the zoning code values in the attribute table.  I initially believed this may have been Zip Code, but I can see how a spatial join could merge the zoning to the parcel layer.  This may also prove difficult since some parcels within the area fall in multiple zones.  (see property 13, 14, and 19 above in the map)  After some consultation from my instructor I manually entered in the data to a new field.  This allowed me to produce the report and show the Zoning Code.

In the second scenario of this weeks lab, we put ourselves in the shoes of a GIS analyst looking for an optimal location to build an Extension Office that must meet certain criteria.  First we had to update our records for a set of parcels...we merged the lots/parcels together and then used the Cut Polygons tool and Feature Construction Toolbar to create new parcels.  Updating the details for both.

With the updates completed we calculated out acres on parcels owned by Gulf County and then searched on those properties for values above 20 acres.  With this data in hand we then located vacant land to isolate those area that could be reported for building the new Extension Office.  These locations were presented using the Create Report option found in the Attribute Table Options.

This week's lab had a number of tasks, and tools that needed to be utilized together to produce the desired results.  I believe the maps I produced for Mr Zuko will provide him the information he desired, and the BOCC should be able to finally build that Extension Office in a desirable location.

Participation Assignment

GIS 4048

Note: Click Images to enlarge

After conducting a web search to locate a property appraiser’s office in my area, I discovered Franklin Townships Tax Assessors Office website.  http://www.franklintwpnj.org/.

Q1:      Does your property appraiser offer a web mapping site?  If so, what is the web address?  If not, what is the method in which you may obtain the data?

            The appraiser’s office does not directly link to the web mapping site from their page, but I was able to find one that is available on the Home Page, and it provides key information about the property.  The web address for this site is www.sdlportal.com, but can be accessed by clicking the Citizen Request Portal button on Franklin Townships Home Page.  Users must create an account and then will have permission to log in and search properties.  By conducting a search the user can pull up any address within the town and view information about the property, including Owner information, Location (address, block, lot, and qualifier), Description of Property, and Valuation or assessed value.  The person can also see Permits that are associated to the property with their current status.

Next I looked into discovering a list of recent property sales by month.  In the tax assessors web page I discovered an “Online Tax Assessment Data” link.  This link took me to another page where I was able to populate information to obtain what is referred to as Mod IV (Mod 4) data.

I was directed to a website that allowed me to search Assessment Records for the entire state of New Jersey.  This can be found at: http://tax1.co.monmouth.nj.us/cgi-bin/prc6.cgi?menu=index&ms_user=glou&passwd=data&district=1808&mode=11

After conducting my search, I found that the records are only good up to May 8, 2014. 

Q2:    What was the selling price of this property?  What was the previous selling price of this property (if applicable)?  Take a screen shot of the description provided to include with this answer.

            Since I am unable to look up the June month, I used the last full month that was covered by the spreadsheet that I downloaded in CSV format from the assessor’s office.  In this case April has a full month of sales.  I was able to identify the highest selling property that sold in the month of April.  1 Heller Park Lane has a sales date of 4/7/2014 and sold for $13,500,000.  The previous selling price was not listed on the data provided.

Q3:      What is the assessed land value?  Based on land record data, is the assessed land value higher or lower than the last sale price?  Include a screen shot.

The assessed land value for the property I identified previous (1 Heller Park Lane) is set at $4,679,000.  The land value is lower than the last sale price.  I also noticed that the combination of the land and building assessment still fell below the sales price.

Q4:      Share additional information about this piece of land that you find interesting.  Many times, a link to the deed will be available providing more insight to the sale.

From my research I was able to find out a lot more about the property.  I was able to determine the property size (26.79 Acres), owner information (Matrix Somerset I LLC), Property Zoning it fell within (M1), and the current block/lot (514/8.03).  Listed also in the data was the assessed value over a number of years.  Using the property location I went to the Franklin Township SDL Portal and also did a search based on the block and lot.  I was shown a lot of detailed data, including the current Permits that are open for the property.  Some of these improvements could affect the assessed value in the future.

 For the second part of our Participation Assignment I took on the role of working for the Property Appraiser's Office.  They asked me to review the land value assessments in West Ridge Place subdivision and tasked with creating a map that will help show inconsistencies in the current assessments.  Below is the map that was created.

Q5:      Which accounts do you think need review based on land value and what             you've learned about assessment?  Please answer this question within your blog post.

Excluding the properties that are odd-shaped with low values, I am left to look at all the properties as a whole.  I believe that the majority of the properties fall within the $27,075 range for property assessment.  This being said, I feel that all the properties should be assessed yearly as this was the trend in the table.  I would want to look for a trend in property value, as such I would look at property values from previous years.  By looking at all the years assessments, I can then see what properties are trending higher or lower in value.  Perhaps some properties had improvements done?  Perhaps others are priced differently due to the condition of the homes?  Do the Easements Restrictions reduce the property value or improve it?  These all weigh in on the land value.  I would expect a request for reappraisal from those properties above the average.  Those that fall below the average may not seek a reassessment to avoid property taxes until it's time to sell the home.  In this case I would want to make sure that the lower assessed property is looked at, and a determination made as to why it does not meet the average.  Therefore, my focus would be on the Yellow and light Orange properties, with the expectation that the red property may ask to be reassessed as well.

E

E

Lab 8 - Urban Planning: Location Decisions

GIS 4048

Home buying, it's one of those things that the majority of us will do in our lifetime, possibly more than once. In this week's lab we looked into determining where to buy when you have specific criteria that must be met. This week we put on our Realtor hats and helped a couple find a home in Alachua County, Florida.

Initially we were told that the couple would like to stay close to their worksites, and would also like to be among individuals that were homeowners as well as between the ages of 40-49 years.  My first map took all the variables and outlined them so the couple could see them individually.

After initially setting up my environments and bringing in the relevant data one of my first tasks was to create a basemap that could be used in all the images.  The basemap provided me the details that the couple would need, but also helped in the map design process.  Next came the proximity analysis using the Euclidean Distance Tool to provide distances outward from the couple's places of employment and the conversion of these results to a raster feature.  Eventually I reclassified my distances to 5000 meters to allow a uniform look to the ring distribution.  Next came the analysis of the Age criteria.  To accomplish this, a new field was created within the attribute table and the percentage of individuals 40-49 was calculated based off of the 2010 Census data.  With this new data in hand, a graduated color value was assigned to the census tracts based off of the new percentage value.  I utilized the same color ramp for all maps allowing me to symbolize all results uniformly.  For the Homeownership analysis, I did the same steps as I did for the age analysis. With all my analyses completed, I produced the following map.

I found it very beneficial to use the same color ramp/schema for all the layers.  This allowed for one easy to read legend item that gave the couple an easy method to read the map.  Dark Green = Good area too look for criteria  /  Dark Red = Not a good area to look for specific criteria.  All the shades in between give them an easy way to determine if they want to make sacrifices in one criteria to obtain more in another criteria.

The next map was created with the original intent to show the couple optimal areas for them to search for a new house.  A modified data frame was added after a determination that the couple wanted a more in depth analysis on travel distance.  It seems they wanted more emphasis put onto travel time, and distance from their job sites.  With this in mind, I began my analysis on all the criteria, and what areas would be ideal both for an equal weight, and a slightly modified weight.

Since this analysis was going to be performed often, the option to use Model Builder was made.  By using Model Builder, I could run the same tool, over and over again, with simple modifications to the parameters.  In this case we used the Weighted Overlay tool, and I was modifying the Influence percentage and assigning restrictions on scaled values to narrow my search even more.

In the first data frame for Equal Weight, I used no restrictions and set equal influence (25%) on all four criteria.  In the second data frame (Modified Weight) I really narrowed down my search.  I did this by first giving the distances 35% influence and only 15% influence to the Home Ownership and Age criteria.  I went a little further here, too.  First I restricted all values down to 15,000 meters by restricting all values except for the 3 closest rings.  This eliminated all the areas outside of 15,000 meters based on both worksite locations. I then said to myself, if I am going to search the closest areas to our jobsites, I also want to see only the top percentages of Homeownership and Age criteria.  I did this by allowing the top 5 percentages to be valued, but restricted all the other values.  This left me with the results being really close to the couple's worksites, and also focused in on the other criteria enough that they could get the best areas of selection even though they were limited on distance.

The results I came up with on both searches lead me to the conclusion that the 3 areas I highlighted on the map would be ideal for my customers.  I added references to the maps so they could easily find their way around, and kept the technical details as brief as possible.  

As someone who recently went through buying a home, I know that I just want to be pointed to the right place by my Realtor, I can then focus my search and make a determination when I see the location and the area around it. 

Lab 7 - MEDS Protect

GIS 4048

In this weeks lab I took what I prepared in Lab 6 and put it to use in the Protection of the Boston Marathon. The first objective for my Critical Infrastructure and Buffer Zones map shown below, was to isolate a 3 mile security zone around the Boston Marathon finish line.  With this event buffer identified I needed to isolate the 10 closest hospitals or medical centers in near proximity to the finish line.  I accomplished this by utilizing the near tool in ArcGIS.  I created a five hundred foot security perimeter around these locations and the finish line using the Buffer tool.  This was done to mitigate any threats should an event occur.  Security Checkpoints needed to be set up at the perimeter of the finish line buffer.  I was able to identify locations for these security checkpoints by using the intersect tool after identifying what local roads intersected the 500 foot buffer zone.  These locations were added to my inset map as a point feature class.  With all the data I utilized the Military Portrait Layout to populate key information needed by the readers and verified my map essentials.

The second map went into the surveillance of the finish line and the surrounding areas.  To do this I used a multitude of tools to identify optimal locations and elevations for cameras around the Boston Marathon finish line.  Identifying these locations and understanding what could be seen from the vantage point allowed security to know where best to place security assets.  In this map I utilized LiDAR (Light Detection And Ranging) while exploring the LAS toolbar.  The LAS toolbar allowed me the capability to convert an LAS dataset to Raster.  Exploring and preparing my elevation data was critical for the next steps in the process.  I generated a Hillshade surface layer using the Raster I created from the LAS toolbar. This allowed me to identify areas of shade for a specific day and time utilizing the Altitude and Azimuth settings.  Adding in the Orthoimagery, the shading took on a new life as the buildings cast their shadows.  It was like stepping back in time at 2:30pm that afternoon and seeing where the shadows fell across the landscape.

Next came the selection of security points that I felt would provide optimal observation areas.  I selected 15 points and proceeded to generate a Viewshed of the area based off of those points. My initial findings were that all of my viewpoints were in good spots as I felt that the green shading meant I could clearly see the finish line. However this was soon to be disproved.  I created line of sight lines from my cameras to the finish line and quickly discovered that my points were blocked by other obstructions along the path.  I had to go back and update the elevations on most of my camera locations.  Several meters were added to the elevation and the viewshed was recalculated until I found a good height for each camera giving me as little obscurement to the finish line as possible.

I utilized the the Create Profile Graph tool in the 3D analyst toolbar to generate a graph of Camera 4 showing its location and what distances could be obscured from view.

Next I utilized ArcScene to create a 3D model of the area in and around the finish line.  This by far was the best part of the lab.  Manipulating the model I could fly through the landscape.  Laying the Ortho layer on top of the elevation layer gave me a sense of dimension while working with the layers.  I copied and pasted over the Line of Sight lines and exported the layer so as to be added into my layout.

I finished the map with a custom layout, identifying all map essentials and adding the information that was needed.

Although very time consuming, I felt this lab was a great!  I was able to reinforce skills I already had and was able to utilize new tools to produce the results that were desired on my deliverable map.  I believe next week we move on to Local Government...can't wait!