I have installed MySQL on my netbook.  I know python can hook up to MySQL databases.   Also, I got PHP installed and I am begining to learn a little about that.  I got interested in databases when I started using python to create sqlite3 databases. Now I'm going to try using PHP to manipulate MySql databases.

Parcel Builder Administrator: COMBINING PARCELS

Combine a parcel.

1. Set the Task Mode to Add Existing Task.

2. Set the Task Type to Merge.

3. After you set the tasks then press the Add Existing button. A dialog will appear.  Select the parcel you want to merge and press OK.

Unlinking the parcel point from GIS:

1. After you have set up Parcel builder unlink Start editing the Parcel point layer in GIS.

a. Start editing the Parcel_Point layer in GIS

b. Press the "Unlink Parcels From Map" button

c. Remove the parcel point by drawng a window around the parcel point.

d. After the parcel point has been unlinked (removed) from the GIS

e. It can be retired it in Parcel Builder Administrator.

f. write a brief descripton in the notes field as to why it was removed for future reference.

COMBINATION REQUESTS

Taxpayers and Appraisers can request parcels to be combined.

Open CombinationRequest.pdf  and fill in the blanks.  It cannot be saved, so I use the snip tool to create a copy that can be emailed.

Fill out the requestor name, contact information and what parcels to combine.  Then use the check list at the bottom of the form to see if the parcels can be combined or not. 

If everything checks out (or not), then email a copy of it to the person making the request and to Tammy.

Use TAXI to check for back taxes, and use AP01 to check mortgages.

1000 ft buffer for Planning Department

The planning department sends me legal descriptions and I map it out. 

Create a 1000' buffer using the legal.

Now, select all parcels that are within the buffer zone.

 Export out a dbf table, open the dbf table with excel and save it as an excel file.

 The final step is to email the pdf map and the excel table back to the planning department.

Plat Mapping Sheets

  One of my responsibilities is to check new subdivisions for the register of deeds.  The new subdivision is usually emailed to me as a PDF or brought into my office. 

   I  COGO the legal description written on the plat to locate the platted or re-platted parcels. Check for overlapping parcels, or other discrepancies. 

  Next, look up the parcels in Orion and get the Owner names and book and page numbers of the parcels.   This information is printed on the Plat Map Worksheet as shown below.

Save the map work sheet in G:\GIS and Mapping.  I also export a pdf for emailing.

Parcel Builder Administrator: SPLITTING A PARCEL

First set the Task Mode to  "Add New Task", and set the task type to "Split" as shown above. When the Create Task button is pressed, parcel builder will create a new parcel ID number, and add it to the list at the top.  The parcel ID can be adjusted before adding it to the list if needed. The new parcel is not linked to the map yet so it is white as shown below.

When the new parcel is linked to the GIS map, the color will change to yellow.

Start the editor in GIS, then add the new point using the Link Button.

After the parcel point has been added to the GIS and the parcel split out, then you can add the Calculated Acres, book and page, MWS notes, Owners, deed date, and the new property description as shown above.



I wrote a simple python progam to assist new users on updating the Appraier log.  It has instructions for several document types.  A copy of this program is in the GIS and Mapping/PYTHON_TOOLS folder.

Transfer on Death deeds and Death Certificates

Transfer on Death deeds do not cause an action, but we still note these in the log for future reference. Enter who the property goes to in the Notes field. 

Death Certificates: 

1. Check the current deed to see how the deceased person owned the property.
    a. If Joint Tenancy, then it is a name change.
    b. If it is Tenancy in common then you will have to look for a TOD deed,
       Executor Deed or a probate.
    c. If only 1 person owns the property there has to be a probate or TOD deed
       even if current deed is joint tenancy.  

2. Look in AP01 notes, the old map work cards and WebDocs. If you cannot
   find anything then make it a Map Work Card.
3. Call the Register of Deeds if you don't have a copy of the deed to find out 
   how it was owned.
4. Be sure and note in the doc log if you could not find any documents.

5. Check ORION to see if deceased person has other properties.

FYI: Executor, Administrator or Conservator deeds will transfer even without a
     death Certificate or probate.

FYI: Sometimes, a probate is filed right after the property is transfered and we
     have not got it yet. So, it appears to be a map work card. It will be
     changed in the log after we get the probate.

FYI: Death Certificates CANNOT change a trust deed!!

UPDATING THE APPRAISER DOC LOG

The above picture shows how to enter a simple name change into the doc log.

PROCESSING DEEDS

 Use ApplicationXtender to list all documents recorded in the register of deeds office from the previous day.

 Pick out deeds, permanent ROW easements, transfer on death deeds, other documents and note them in the appraisers Doc Log.  A deed can be a name change, split, map work card or  combination. Ignore mortgages, and release of mortgages.

PUC's and transfer on death deeds are made "map work cards" in our doc log. They do not change anything, but we need to note them for future reference.

 Using the legal description on the deed,  locate the parcel in the GIS .  Then  look it up in Orion. Check the owner names on the deed, and see if they match Orion. If they don't match, make it a map work card in the log.  We can allow small errors on the deed  like missing middle initials and such.

This is a very important task. The log must be updated carefully, or the wrong owner could placed on a parcel.  Remember, quality is more important than quantity.

This blog was created to help me document my job.