HomeMy WebLinkAboutResolutions - 1999.03.17 - 25786. . . ,
MISCELLANEOUS 'REBOLUTION #99 056 ' , -., March 18, 1999
BY: Finance Committee, Sue Ann Douglas, Chairperson
IN RE: DEPARTMENT OF MANAGEMENT & BUDGET / EQUALIZATION DIVISION - IMPLEMENTATION
OF DIGITAL PHOTOGRAPHY PROJECT
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS, as provided by Public Act 462 of 1996 - Enhanced Access to Public Records
Act, the Board of Commissioners, by approving Misc. Resolution #97165 on August 14, 1997,
adopted the Oakland County Enhanced Access to Public Records Policy; and
WHEREAS Section 2.C. of the aforementioned policy specifies that "County elected
officials, department heads, agencies, boards, commissions and councils legally
responsible for the creation, preparation, ownership, custody, control, maintenance,
preservation, guardianship, retention, possession or use of a public record shall select
which public records may be made available through enhanced access; and
WHEREAS the Oakland County Equalization Division's Digital Photographic Project
(Project) is a result of the County's Enhanced Access strategic planning process, which
has set as a goal the development of a new product every 60 days; and
WHEREAS the Project is intended to facilitate the creation of a database that will
store digital photographs of each parcel in Oakland County in order to enhance the value
of land related Enhanced Access products; and
WHEREAS the resulting digital photos will be used in conjunction with the previously
approved enhanced access program's Parcel Acess Query and Mini Ad Hoc Query; and
WHEREAS the Project is composed of two integral initiatives: Organization Design &
Implementation and Project Design & \Automation, as described in the attached
Implementation Plan; and
WHEREAS implementation of the propos Project entails assignment of an existing
Appraiser III position to provide supervisi n, creation of ten (10) Summer Business
Assistant positions and three (3) Summer Cleri al positions; and
WHEREAS the funding for these positions, as well as related operating costs, is
available in the Designated Fund Balance for Operational Improvements which requires a
pay-back period of six years or less; to be derived from Enhanced Access revenues; and
WHEREAS the County Executive recommends adoption of this resolution.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners
authorizes implementation of the Digital Photography Project and appropriates $97,794
from the Designated Fund Balance for Operational Improvements, with the following budget
amendments:
Amount
From: 9407-01000 Operational Improvements
To: Equalization Division
Salaries
Fringe Benefits
Total Salaries and Fringe Benefits
Operating:
Expendable Equipment
Mileage Reimbursement
Office Supplies
Total Budget
BE IT FURTHER RESOLVED that the cost for this program will be recovered through the
Enhanced Access Program's fees as authorized by the Board of Commissioners, such as those
previously approved for the Parcel Access Query and the Mini Ad Hoc Query, and that for
the Parcel Access Query, on an individual transaction basis, digital photos will not be
included.
Chairperson, on behalf of the Finance Committee, I move adoption of the foregoing
resolution.
S97,794
$66,724
11,234
$77,958
$13,810
6,826
200
S97.794
FINANCE COMMITTEE
FINANCE COMMITTEE VOTE:
Motion carried on a roll call vote with Taub voting no.
Oakland County Equalization Division
Digital Photography Project Implementation Plan
1.0 INTRODUCTION
The Oakland County Equalization Division's Digital Photograph Project Implementation Plan is
a result of the County's Enhanced Access' strategic planning process. The Implementation Plan
is intended to facilitate the creation of a database that will store digital photographs of each
parcel in Oakland County. The components of this plan will enable successful implementation
and promote long-term sustainability.
1.1 Role of the Project Implementation Plan
The Digital Photograph Project Implementation Plan is established to delineate the standards that
the Equalization Division and other local municipalities will use to implement the collection and
maintenance of digital photographs for each CVT.
2.0 IMPLEMENTATION BOUNDARIES
The Equalization Division could perform several different roles. In some cases, the Equalization
Division will manage the entire digital photography implementation process, in other cases they
will provide consulting and advisory services to those CVTs that will be managing their own
process.
3.0 PROJECT VISION
The Equalization Division Digital Photography Project Implementation Plan will support the
overall vision of the Project that includes:
1. Increased availability of digital photographs through Oakland County's Enhanced Access
initiative.
2. Increased access and dissemination of digital information to other county and local users
such as assessors and law enforcement agencies.
3.1 Critical Success Factors
The factors that will impact the success of this Project Implementation Plan include:
1. County Executive, Management and Budget, Equalization and local municipality support
and commitment.
2. Effective support and consulting from the Equalization Division.
3. Coordinated, intra-agency involvement.
2/24/99 Oakland County Digital Photography Project Implementation Plan
4. An openness to new technology and improved workflows.
5. Development of a Digital Photography program in local CVTs and the use of common
infrastructure data models.
4.0 PROJECT IMPLEMENTATION FRAMEWORK
This section outlines the project goal and the supporting initiatives required to accomplish this
goal. The initiatives are intended to document required objectives that will be a part of this
implementation plan.
4.1 Digital Photography Project Implementation Goal
To automate and maintain a database of digital photographs for each parcel in Oakland County.
4.2 Digital Photography Project Implementation Initiatives
There are two integral initiatives that have been documented to ensure the successful
implementation of the Project Goal.
4.2.1 Organizational Design & Implementation
Appraiser III: This role is responsible for the implementation of the Digital Photography
Project Implementation Plan. This role will also administer the development and
formulation of standards and promote the adoption and integration of such standards.
This would include:
1. Documenting procedures for the process of obtaining digital photos in the field
2. Creating User documentation for the process of posting these photos to the digital
photo database via the Internet.
3. Training of Field Staff in the operation of Digital Cameras.
4. Training of Field Staff in field procedures for both residential and commercial
properties.
5. Training of Clerical Staff in the posting of photos to the database.
6. Outlining quality assurance procedures and performing quality checks in the field
and within the database.
7. Overseeing day to day operations.
8. Training staff of those municipalities that will run their own program.
Field Staff- The primary responsibility of this role is to perform the following tasks
according to the standards set by the Division. These tasks include:
1. Taking digital photographs.
2. Maintaining a camera log to identify the parcels contained within each disk.
3. Assisting the Appraiser III with quality assurance procedures when needed.
Clerical Staff— This role is responsible for:
1. Downloading image data into the digital photograph database via the Internet
2. Assisting the Appraiser III with any other tasks pertinent to this project.
2/24/99 Oakland County Digital Photography Project Implementation Plan
1.
2.
3.
4.
5.
6.
7.
8.
9.
4.2.2.1 Digital Photograph Collection Procedures
I. Using Digital Cameras to obtain images:
A. Required Materials
Digital Camera with accessories
(Sony Digital Mavica Model #MVC-FD71)
Camera Logs
Numbered Floppy Disks
Clipboard
Map pages
Pencils, etc.
Backpack
Photo ID
Letter of Authorization from OCED
B. Dress Attire — as a representative of the County, all staff are expected to dress
appropriately. General guidelines for appropriate attire are:
1. Acceptable:
a. Casual Pants (Docker type), skorts, skirts (longer style)
b. Casual shirts or blouses (Polo or button down type, shell)
c. Good walking shoes
2. Unacceptable:
a. Jeans, shorts
b. T-shirts, halter tops, tanktops, sweatshirts
c. Warn out gym shoes
C. Workflow Flowchart — See Appendix A
D. Work Assignments
1. Residential
a. The Appraiser DI will assign work by map page.
b. Photographs will be taken of ALL parcels. (Including vacant and
exempt parcels.)
c. Some residential buildings may reside on more than one parcel. Only
one set of photographs is necessary, but note all Parcel Ids involved.
d. Take pictures from the driveway side of each house and at a 45 degree
angle to include detached garages and/or other outbuildings.
e. Take one picture per parcel. (Unless you are unable to get the entire
structure(s) in one picture)
f. Take pictures in order (i.e.: Walk up one side of the street and down
the other.) This will make keeping track of parcel ID numbers easier.
Routing may be facilitated via a GIS application using the Road
Centerline coverage.
h. Maintain the camera log as you go.
i. Pay attention to shadows. If the sun is casting shadows that will result
in a dark image, move on to a different area and come back later in the
day to take them.
g.
2/24/99 Oakland County Digital Photography Project Implementation Plan
j. Use the zoom function when necessary to fill the picture frame with
the subject property structures.
Commercial
a. Two people will be assigned to photograph commercial properties.
b. The Appraiser III will assign work by map page.
c. Photographs will be taken of ALL parcels. (Including vacant and
exempt parcels)
d. Some commercial buildings may reside on more than one parcel. Only
one set of photographs is necessary, but note all Parcel involved.
e. More than one picture per parcel may be necessary on some properties.
f. Take pictures at a 45-degree angle and include multiple buildings
when possible.
g. Maintain the camera log as you go.
k. Pay attention to shadows. If the sun is casting shadows that will result
in a dark image, move on to a different area and come back later in the
day to take them.
h. Use the zoom function when necessary. Wide-angle lenses will be
available if needed.
E. Camera Notes
1. Assignment of equipment - Each camera will be identified with an
inventory number and will be assigned to a specific field worker.
2. Training - will be provided by the Appraiser DI
3. Handling
a. Special care is required in handling this equipment.
b. Extreme heat and careless handling should be avoided.
c. A camera case and cleaning cloth will be provided to protect and
maintain the camera.
d. Cameras will be placed in their case then in the field worker's
backpack at the end of each workday.
e. The backpacks will be kept in a designated place at each work site. No
field worker will be allowed to take the camera home with him or her.
4. Camera Settings
a. The cameras should be set at normal mode. Each image will be
saved as a JPEG file with 640 x 480 resolution. You should be able
to fit at least 25 photographs on one disk.
b. Image quality should be set to standard.
c. The Program AE indicator should be off.
d. The Picture Effect indicator should be off.
5. Batteries
a. Two four-hour batteries will be assigned with each camera.
b. It is the responsibility of the field staff to make sure their batteries are
recharged on a daily basis.
2/24/99 Oakland County Digital Photography Project Implementation Plan
F. Disk Control
1. The Appraiser III will maintain disk control sheets arranged by CVT. (See
Appendix B)
2. Disk Labeling
a. Disk number: CVT code, followed by a hyphen and a three-digit
number assigned in sequence. (Ex: 04-001, 04-002, 04-003 etc. for
Berkley)
b. Employee Initials
c. Date
3. Camera Log
a. Each disk will have an associated camera log sheet.
b. The disk number and employee number will be entered at the top of
the page.
c. The log contains the picture number, parcel ID, property address and a
brief note to easily identify the picture. (see Appendix C)
d. The log and disk will be put in an envelope and returned to the
Appraiser III when full.
H. Scanning Photographs
A. Required Materials/Equipment
1. Scanner
2. Photographs from appraisal file or other sources.
B. Scan Photographs according to the scanner's instructions.
C. There is an application available that can be used brighten and crop the
photograph from an appraisal sketchcard. (Works with Adobe Photo Shop)
D. File Format — Scanned Photographs must be saved in JPEG format. (jpg
extension) (This format is a universal standard for Internet imaging and
recognized by all web browsers. It is also more compressed than other image
formats therefore occupies less storage space.)
E. File-Naming Convention
1. The filename shall consist of the Parcel ID, hyphen, then three-digit
"suffix" number.
2. The suffix number will identify multiple photographs for a single Parcel
ID number.
3. Example: 2518453020-001, 2518453020-002 and 2518453020-003 for a
parcel with three scanned photographs.
4. The Internet application for posting scanned photographs looks for the
three digit "suffix" number to display a photograph, therefore it is
necessary to always use the "suffix" even for a parcel with one
photograph.
F. Location of Files
1. Files should be stored in a separate folder on the hard disk.
2. Create a separate folder for each CVT.
2/24/99 Oakland County Digital Photography Project Implementation Plan 1
4.2.2.2 Digital Photograph Posting Procedures
The posting of the digital photographs will be facilitated by an Internet application found at
http://digipics.co.oakland.mi.us . Both scanned photographs and photographs taken with the
digital cameras can be posted at this site. A User name and password will be assigned for each
CVT and will allow them to view and maintain parcels for their CVT only. The username and
passwords will be assigned by the Information Technology Department. See Appendix D for
User documentation.
4.2.2.3 Digital Photograph Maintenance Procedures
As this program evolves, a system of parcel image Maintenance must be implemented to assure
that photographs for every new parcel and/or changes to existing parcels are updated and
properly posted to the database. This includes the proper identification of retired (archived)
photographs and the deletion of unwanted photographs. Refer to Appendix D for instructions on
how to download new photographs, copy photographs and change the status of existing
photographs. The following procedure should be used to facilitate photograph maintenance:
1. Designate a person to facilitate database maintenance.
2. Train at least one other person in the procedures for backup.
3. Photographs will be taken as described in 4.2.2.1 by appraisal staff and other local
officials. (Building Department, Law Enforcement)
4. Disks with their associated camera logs will be turned in to the designated person for
posting to the database. Instructions on retiring or deleting older pictures should
accompany the camera log.
5. When parcel splits and combinations occur, the designated person shall be notified,
in writing, of the following information:
a. The source parcel ID(s). (parent parcel ID to copy photographs from)
b. The destination parcel ID(s). (child parcel ID to copy photographs to)
c. Specific instructions for assigning parcel ID numbers when multiple structures
on the parent parcel are split amongst the child parcels.
6. Posting will occur on, at least, a monthly basis, if not on a continuous basis.
7. Review existing photographs to retire or delete older photographs as needed.
4.2.2.4 Digital Photograph Quality Assurance Procedures
1. Field check photos taken by field staff.
a. Select disks randomly.
b. Drive to selected properties.
c. Check for accuracy of parcel ID assignment on camera log.
d. Check for quality of photographs taken.
e. Identify photographs that should be retaken and direct back to the field staff.
2. Check posting of photographs to database.
a. Select disks randomly.
b. Check for accuracy of parcel ID assignment. This quality check will make sure
that a valid CVT/Parcel ID has not been assigned to the wrong picture. (The
Internet application will automatically check to see that a valid CVT /Parcel ID
combination has been entered before it will allow the photograph to be posted.)
2/24/99 Oakland County Digital Photography Project Implementation Plan
c. Any errors may be field checked before returning to the field and/or clerical staff
for correction.
d. Clerical staff may also identify unacceptable photographs while posting them to
the database. All parcel IDs for these photographs will be listed and referred to
the Appraiser III for review, then be returned to the field staff for retakes.
3. Check for missing photographs.
The GIS system will enable the Equalization Division and CVTs to identify
missing photographs once the mass effort is completed. By linking the database
table to the GIS' polygon attribute table for a CVT, then performing a simple
query, missing photographs can be easily identified and represented both visually
and in table format.
4. Reporting of errors in the future.
As local municipalities and subscribers to Enhanced Access continue to query this
database, there are bound to be errors that will be identified such as mislabeled
photographs. A system of reporting these errors will be essential to maintaining
an accurate database. This issue is still open.
4.3 Technical Overview
4.3.1 Introduction
The Internet is the business tool for the new millenium. Oakland County, realizing this fact, has
invested in this exciting new field. One of the investments that Oakland County has made in this
architecture is in its connection to the Internet that is fully redundant and extremely secure. This
implementation allows Oakland County to provide business applications over the public Internet
in a timely and reliable fashion.
4.3.2 Specifications
Oakland County has created a digital photography tool using standard Internet technologies and
software that currently exists as a standard inside the County. This standard software includes
Internet Information Server, SQL Server and Allaire's Cold Fusion Application Server. This
standard software has allowed Oakland County to deliver the application necessary for a County-
wide digital photography effort.
The user of the system requires only minimal hardware and software, most of which is standard
on today's PC's. This includes a PC or MAC, an Internet connection, and either Netscape
Navigator 3.0 or greater, or Internet Explorer 4.0 or greater. All of the software that is required is
free of charge and is readily available from numerous sources.
The pictures will be stored locally to the web server and the information about each photo will
reside in a SQL Server database. Both of these servers are maintained 24x7 by the Oakland
County Department of Information Technology, and are backed up on a nightly basis. The web
server will be running MS IIS 4.0 and Allaire Cold Fusion 4.0. The SQL Server will be running
SQL Server 6.5 Enterprise Edition.
2/24/99 Oakland County Digital Photography Project Implementation Plan
To handle hardcopy output from the system, Oakland County has decided to use the Epson Stylus
Color 850 for its speed, low cost, and high quality output. The system is, however, flexible
enough to use any standard printer.
The application allows a user to download the information from the database to link to any
number of potential external applications. These could include but are not limited to Geographic
Information Systems and other web sites.
4.3.3 Conclusion
By using standard Internet protocols and software languages, Oakland County is able to provide a
cost-effective, simple solution for a County-wide digital photography program.
5.0 IMPLEMENTATION TIMELINE
Implementation of the Digital Photography Project Implementation Plan in a timely manner is of
the utmost importance to the Equalization Division and the GIS Utility. To complete the
implementation of this plan, each initiative must be coordinated. If a single component of the
Plan is delayed, the implementation as a whole could be delayed.
Figure 3 is a summarization of the initiative's specific timelines.
Figure 3: Combined Organizational and Project Implementation Timeline
Initiative Task Task Name Feb. '99 Mar. '99 Apr. '99 May '99 June '99 July '99 Aug. '99
#
4.2.1 I Recruit Sumner Interns
2 Training
3 Personnel Review
4 Personnel Adjustments -
4.2.2 I Develop collection, maintenance
and quality assurance procedures
2 Train Field and Clerical personnel
3 Data Automation
4 Quality Assurance
5 1 Data Maintenance
6.0 COST SCHEDULES
The costs for the first phase of the Plan are outlined in the next two pages. All Personnel,
equipment and material requirements are estimated to derive a cost per parcel figure. This
number is multiplied by each CVT's parcel count to derive a total cost for each CVT involved in
this phase.
2/24/99 Oakland County Digital Photography Project Implementation Plan
Grand Total Estimate for Posting to Server 167,191
•
Figure 4: Costs per CVT based on Mass Project
Phase I Cost Schedule
Corn. & Ind. Ag., Res. & Dev Misc. Total Cost Per Total
Real Prop. Real Prop. Properties "" Parcels Parcel " . Cost
City of Berkley 436 6,686 165 7,287 $0.903 S6,580.16
City of Bloomfield Hills 65 1,718 58 1,841 $0.903 $1,662.42
City of Clawson 431 4,825 188 5,444 $0.903 $4,915.93
City of Hazel Park 625 7,171 172 7,968 $0.903 S7,195.10
City of Huntington Woods 24 2.448 20 2,492 $0.903 $2,250.28
City of Lathrup Village 103 1,747 31 1,881 S0.903 S1,698.54
City of Pleasant Ridge 35 1,208 52 1,295 $0.903 $1,169.39
City of Rochester 417 3,224 133 3,774 $0.903 $3,407.92
Oakland Township 159 4,746 171 5,076 $0.903 $4,583.63
Royal Oak Township 107 788 167 1,062 $0.903 $958.99
Sub Total 2,402 34,561 ,- 1,157 38,120 $34,422.36
City of Birmingham (contingent)- 541 8,333 113 8,987 $0.903 $8.115.26
City of Farmington ( contingent) 283 3,341 69 3,693 $0.903 S3,334.78
City of Ferndale 877 9,092 271 10,240 $0.903 $9,246.72
City of Madison Heights 1,152 10,114 153 11,419 $0.903 $10,311.36
City of Novi (contingent) 834 13,451 382 14,667 $0.903 $13,244.30
City of Oak Park 582 9,673 166 10,421 $0.903 $9,410.16
City of Royal Oak 1,573 22,717 228 24,518 $0.903 $22,139.75
Sub Total 5,018 65,047 1,200 71,265 $64,352.30
Grand Total 7,420 99,608 109,385 $98,774.66
" Estimated Costs are detailed later in the report. These numbers are based on Equalization's costs for a mass project.
" Properties coded as "ME" and "MM" - (for example: Churches, City Offices, etc.)
*** Contingent CVTs are those who will be included in Phase I if time permits.
(The City of Birmingham is considering running their own program.)
Outside Efforts
Farmington Hills
Waterford Township
Sub Total
1,388 25,280 540 27,208
1,693 27,895 1,010 30,598
3,081 53,175 1,550 57,806
**** Refer to sections 2.0, 4.2.1 and 7.0 of the Project Plan for comments regarding Equalization's role in assisting those CVTs
who will run their own program.
$7.26 per hour X 1.097
X 5,600 hours
$6.74 per hour X 1.097
X 1,680 hours
$608.00 leach
$60.00 each
$60.00 each
$80.00 each
$60.00 each
$6.24 per box of 10
600 boxes
$25.00 each
$0.325 per Mile
$0.325 per Mile
44,599.63
12,421.55
7,296.00
120.00
720.00
960.00
720.00
3,744.00
250.00
5,688.00
1,137.50
Figure 5: Cost Breakdown
Estimated Unit Cost Estimated Sub-Total Cost Item:
er.p_,A§itm:
Appraiser Ill X 70 Days
(560 Hours)
$26.33 per hour X 1.42
(benefit multiplier)
20,937.62
Photo-Staff Needs:
10 Summer Business Assistants
X 70 Days (560 Hours)
Other Personnel Needs:
3 Summer Clerical
an estimated 560 hours each
Equipment Needs:
12 Sony Mavica Digital Cameras
Model# MVC-FD71
2 Wide-Angle Lens
Model# VCL-ES06
12 Extra Sony InfoLithium
Batteries Model # NP-F550
12 Accessory Kits (includes
Carrying case, Sony InfoLithium
Battery -Model #NP-F550,
3 Floppy Disks & Cleaning Cloth)
12 Extra Sony Battery Chargers
Model #BC-V615
6,000 3-117" Floppy Discs
10 Backpacks for Field Staff
Mileaqe/Car Estimates:
5 cars @ 50 miles/day = 17,500
miles - Field Staff (County vehicles)
1 car @ 50 miles/day = 3,500
miles - Appraiser Ill (Personal Vehicle)
Miscellaneous:
Paper (for maps) pens, other
98,794.30
109,385
$0.903
Grand Total:
Total Parcels to be photographed
Estimated Price Per Parcel
Maximum (Conservative) Production Estimate of 200 pictures per person, per day.
Yields: 140,000 pictures taken
7.0 PROJECT RECOMMENDATIONS
It is recommended to implement Phase I as outlined in this document. In order to expedite the
implementation of this project, county funding is being sought. Some local municipalities are
interested in funding their own digital photography projects. They are also interested in
purchasing the digital cameras and accessories through the County's purchase order system to
save costs. The Equalization Division will work with them and provide the documentation and
training necessary for them to comply with the standards set forth in this document.
8.0 SUMMARY
The Oakland County Equalization Division's Digital nPhotography Project Implementation Plan
is intended to enable the successful implementation of the Digital Photography program. The
initiatives in this Plan, when supported by more detailed task lists and technical design
memorandums will promote long-term sustainability.
2/24/99 Oakland County Digital Photography Project Implementation Plan
Field
Photographer
Retakes
Clerical Staff
Digital Photo
Database
Appendix A
Digital Photo Project Workflow Model
Digital Photo Project - 2/9/99
Appendix B
OAKLAND
wwn
IN"
COUN TY MICHIGAN
Equalization Division Disk Control Sheet
CVT : (04) BERKLEY
Date Disk# Employee Description (Section, Blocks) Input
207i99 04_001 Jones Section: 18 blocks: pt. 453, pt. 454
04_002
04-003
I 04-004
04-005
04-006
04-007
04-008
04-009
04-010
04-011
04-012
04-013
04-014
04-015
04-016
04-017
04-018
04-019
04-020
04-021
04-022
04-023
04-024
04-025
04-026
04-027
04-028
04-029
04-030
04-031
04-032
04-033
04-034
04-035
Page I
Appendix C
Disk Number
-----'":.-
!OAKLAND-=
COUNTY MICHIGAN
Employee Initials
Equalization Division Digital Camera Log
f Use one sheet for each Floppy Diski
Pic# Parcel ID Number Address Brief Note
1
2
3
4
5
6
7
8
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Appendix D
Oakland County's Digital Photography Web Interface
This is the Main Menu for the business application used to download the digital photographs
into the County's digital photo database. The Internet address is:
http://digipics.co.oakland.mi.us
You will first be prompted to enter a user name and password to access this site. (These will be
unique for each CVT and assigned by the Information Technology department.)
,
Add pictures from camera disk
;Local Directory: I
Add pictures from local dir
Parcel ID: I
Change Status I
;Source Parcel ID:
1Deatination Parcel ID:
! Copy pictures
DownlOad Links I
;Parcel ID:
1. Add pictures from camera disk — This function is used to add images directly from the
camera's floppy disk.
2. Add pictures from local dir — This function is used to add images that reside on the
computer's hard disk or CD. These will be primarily from scanned photographs.
3. Change Status — This function is used to retire (archive) older images or delete
unwanted images from the database.
4. Copy pictures — This function is used to copy images to a different parcel ID number.
(Used to correct mislabeled photographs and changes in parcel ID due to splits and
combinations.)
5. Download Links — This function is used to view a Microsoft Excel worksheet that lists
all LTRLs for each photograph in the database. This table can be used to link photographs
to a GIS system.
6. View - This function will allow viewing (only) of stored pictures.
• • • • •
Oakland County Digital Photography Web Interface User Documentation
Oakland Count\e Didital Pictures
Appendix D
8. Enter a description (optional)
9. Select the appropriate view by clicking first on the drop-down arrow (options: Front
(default). Back. Side, Garage, Other)
10. Click on the Save button. The following screen will appear to verify that the image has
been downloaded.
CArr Code. 44
PercelID: 25:84531)20
Date: 02/12/1999
Nirw From
Vescriptiot
11. Click on the Next button.
12. If there are other pictures stored for the same parcel JD, the Change Status window will
open with all photographs displayed for that parcel. Older pictures can be retired or
deleted from this screen. Refer to the "To Change the Status of a Photograph" section for
instructions about how to do this.
13. If there were no other existing photographs, a message box will appear that states there
are no other photographs that exist for the current parcel. Click on the Next button to
return to the posting screen where the next photograph on the disk will appear. (Repeat
from step 4 until all photographs on the disk have been downloaded. When you click
Next after the last photograph on the disk has been entered, no picture will display.)
14. Click on the Return home button to go back to the Main Menu.
Oakland County Digital Photography Web Interface User Documentation
Appendix D
To Add pictures from local directory:
I. Go to the Main Menu.
2. Enter the path of the local directory that the scanned pictures reside in.
57:==. 01.4i1EUIRE
Add cuclures ton canoe dalk
DIrereJre: c177.977—
Add p/ctures horn local di I
Parcel ID: I
Change Status
3curce Parcel
DeecInaclon Farce: :D: 7-
Copy palates I
Ocromloadll.inks
Parcel ID:
VIBW1
3. Click on the Add pictures from local dir button
4. The following screen will appear.
132aMil
Parcel ID:
Nelw
5. Enter the Parcel ID for the first photo in the local directory. (This function does not
automatically scroll through every photograph in the local directory as it does when
loading photographs from a camera disk. Therefore, it may be helpful to have a log of all
the photos in the directory on hand to aid you in posting.)
6. The following screen will appear with the current photo shown. It looks very similar to
the screen used to add photographs from a camera disk.
Oakland County Digital Pictures
}Se ralopicrs1326328005.001 jpg
..... 11t 61111111%
BRONSE
3
rrone
AV* _Sjap_
Return home
2
Oakland County Digital Photography Web Interface User Documentation
Pik 'thopi,.5 U3)628005-001 gg
F t
Face.s1 ID 112 Stt SO 0
G.AcetptIon 3
Front /I
31.13_,
IRROVVSE I
Appendix D
7. Enter (or Copy and Paste, or Browse to) the file path name into the box next to the
Browse button.
0 akland County E'lciltal Pictures
!lc.,
P.erz-n hcra,
8. Enter a description. (optional)
9. Select the appropriate view by clicking first on the drop-down arrow.
(options: Front (default), Back, Side, Garage, Other)
10. Click on the Save button. The following screen will appear to verify that the image has
been downloaded.
Oakland County Oujda! PC ,,es
VIrr Code Ar
P.1.111 133932300:
Doe 03/19/1999
!{•{••• Rare
Idescnebt
.pgrarnhothe
11. Click on the Return Home button to go back to the Main Menu.
Or,
Click on the Next button to post the next photograph.
Oakland County Digital Photography Web Interface User Documentation
1 1 Appendix D
12. If there is second (or third, etc.) photograph for the same parcel ID, then the next
photograph will automatically appear in the window and you can repeat from Step 7. *
13. If there are no more photographs for the current parcel, then the posting window will
appear without a picture displayed. Enter the next parcel ID number in the box at the
bottom of the window and click on the New button.
MEM
6
File: ethgpicsl1326328005-003 jpg
Petr -zel ID: I1 32628005
Browse...
De3crIpt
VIew: IFtpnt
Save I Skip I
ID: 11326328006
;
;P,etern home
14. This same window with the new photograph will display.
15. Repeat from Step 7 until all photographs in the local directory are posted.
* Note: It is extremely important when scanning photographs to name them with the defined
file-naming convention. (Even if there is only one picture for a parcel.) This Internet application
is written to look for the three-digit suffix number to display the photograph before it is posted to
the database and to scroll to the next photo if there is more than one for a particular parcel ID.
(Refer to section 4.2.2.1, subsection II, of the Digital Photography Implementation Plan for
scanning procedures)
Oakland County Digital Photography Web Interface User Documentation
Deocription.
I I
I Appendix D
To Change the Status of a Photograph:
1. Go to the Main Menu.
2. Enter the Parcel ID in the box above the Change Status button in the Main Menu. Click
on the Change Status button.
Coui4yDVAMut"--
Add pictures from camera disk
Add pictures from local dir
:n•
Change Status 1
ID:
Deztllanclon :D ,
Copy piclures I
Doomload Links I
View I
3. The following screen will appear:
C)Nden0COuntyDigdelPICtun9s
Serest OP 25 18453020
Pak 02112/1999
CUILIJINT
* Cumat 0 St*.r* 0 Del*.
111.1riplim:13 2
PI/ HIM • 23 18433020
Rub 02/12/1999
clflutEN
Ct ma.* Rem D *Ida
law !hang,' I
Oakland County Digital Photography Web Interface User Documentation
Appendix D
4. The following screen will appear if there were no photographs on file for the indicated
Parcel ID number. Check the number then click on Try again (This will take you back
to the Main Menu), and re-enter the parcel number.
OadPTitatPicturei
Error: No pictures found.
Tr; a.gain
5. Click on the appropriate radial button depending on what action you want to take.
a. Current — This is the most current photograph for the indicated parcel.
b. Retire — You want to keep this photograph for this parcel in the database for a
historical reference, but it is not a current photograph. (Ex: pre-
addition/renovation and pre-demolition photographs)
c. Delete — You want to delete the photograph from the database. (Ex: duplicate
photographs, not the correct photo for the indicated parcel, you have downloaded
a better quality photograph into the database)
6. Click on the Save Changes button to commit the changes to the database
7. A confirmation box will come up to verify that this is really what you want to do. Click
on Yes or No.
8. The following screen will appear to verify that the changes have been made.
Pictures successfully changed.
Return to the home page
9. Click on Return to home page to go back to the Main Menu.
10. If you made an error, you can hit the back button on your Internet browser and select the
appropriate radial button to change the status of the photograph from "Retire" back to
"Current" or visa versa and resave the changes. This will not work for photographs that
you have deleted. ONCE A PHOTOGRAPH IS DELETED, YOU CANNOT
RESTORE IT TO THE DATABASE UNLESS YOU RELOAD IT FROM A
FLOPPY DISK OR A LOCAL DIRECTORY.
Oakland County Digital Photography Web Interface User Documentation
Save As... ?Ix
Save in: digital pV—hi list L.31 III
-
DaTz.
Save as IleJAIl
1 1
•
I
a a. I k Appendix D
To download the file that contains the URLs for each photograph:
1. Go to the Main Menu
2. Click on Download Links.
3. The following screen will appear. Click on Click here to 2et it. Return home will
take you back to the Main Menu.
igilanstaciagELNitql,Pistii
The Updated Download is ready. Click here to get it.
Return home
4. The Save As... browser window will apPear. Select the destination for downloading this
file (It has a .csv extension).
5. If you want to view the file, go to Windows Explorer and browse to this newly saved file.
6. Double click on the filename. This will bring up the file in a Microsoft Excel worksheet.
7. This table can also be joined with other tables that contain Parcel ID numbers to link the
photograph's URL with other data sets.
1 http Ilw.w2.co.oakland.mausief-snes/digipicsfernew cfm7c-vt_cY &land_parcol_ick1211427023
2 httplAakvw2.co Oakland no usief-sites/clopplos/coaew cfm7c,a_cdr.YR,land_parcel_id=1211427023
3 http-/Akwha.co oakland.rmus/cf.sttes/digtptcs/arnew cfm7c-w1_ccY8J2nd_parcel jc1211427023
1 http.ft.v.v2.co.oakland.mt usIcf-sttes/digtpics/ernew.cfrn?cat_cY&Iand_parcel _11211427022
2 http./Athanv2.co.oakland.mt.usicf-sais/digtpicsiekaleW.cfrOcat_cd.Y8,1and_parcel J0=12114271322
3 httia/Aaww2.co oakland.rni.us/cf-sitesidigtptcs/erhew cfm7cvt_cdraY8Jand_parcel J4=1211427022
1 httplAonv,v2 co oakland no us/cf.sites/digiptcsiameav cfm7cvt_cW8Jand_parcal_td=1326326095
1 http /Akswe2.co nakland.rnt usicksites/digtptcsfemew cfm2cvt_ccW&Iand_parcel _0=132632E1006
1 http //www2 co.oakland.m, usicf-sass/digipics/eavnaw cim,ca1_cd.W8,1and_parcel_id=1326329027
1 http ilaawor2 co oakland rraLusicf-saes/diggalcs/e c1m7cvt_cd=W8dan4_parcel mid=1336328338
1 http flwww2.co oaktand rnausicf-saasidtgrptcsleavAew cfnicvt_c&V/13.1and_patcal_id=132632111309
I http.//wow2 co Oakland no usicf-stteedtgipics/earew cfrn2cat_ccW&Iand_parcel_,d=1326328010
1 http liwww: co oakland no us‘cf-sttes/dIgiptcsitarew cfrn7cyt_cd=1A/8.iand_parcel_td=13263281311
1 htto /Aakaw2 co Oakland no usicsItesIdigipocs/e mew c1rOc.1_cd=‘,V8.1and_parcel jd=13..323012
1 http ihohnk2 co oakland no us/c!-sttes/thgtposiennew cnn?cat_cckW&iand_parcel jd=1326320313
1 http ihanakk2 co oakland.no us/cbs/Ies/d/g/p/cniennew ctm7cv1_ccPW&Jand_parcet _K1=132632831/
1 http ilaawa:2 co oakland no usict.sites/digl incsiexnew cirn?cv1_cd.Wealan4_parcel_rd=1326328015
2 http /Aaw.v2 co Oakland on ..ta,cf. attesidiglptosie mks.. ctm7c•n_cd=W&ianJ_parcel2d=t 35323005
3 ntlp iiwv.v2 co Oakland no ,s ,c1-sites/dtgrpicsieaview 010a2cvt_cW8dand_parcei _m=132E329005
http "he...2 on oakland.rro usInf-sites/digipicsfearew ofn,,c,a_cd--W80and_parcei jd=1326328906
4 blip // co oakland on usicf-sites/dippcsiewnew cfrn7cvt_cd=a &land oarcel_,O=1211427022
5 hump /Akww2 on Oakland rni ustcf.sitesidigipics/eaviesa ctrn7c,1_c3&iand_p0rce12101211427022
2 NI p l2.wav2 co Oakland rni okhcf-sitesidog.pncsieanew cfm7cat_cd=WLand_parcei_Jd=1326329010
I bhp ih,no..2 on oaktand.rno usicf-sitesidi gipcs/eunew cfm7cv1_ccK048.1and_oarcel_4-.2518453020
1 http //vennu2 co.oaktand.rnt usict-sltes/digipicsieavnaw cfrnOrArt_co=04Liand_parce12 2518454327
2 http "Aakaw2 co oakland mt.usicf-saesldigipncsiewew cfrn7cyt_cd--048.1and_parcel_12516454007
3 htto llakvA,2.co oakland rnaus/c4siletidioloocs/asview cfrn,cv1 cd‘,048.1and parcel od=2516,154007
Oakland County Digital Photography Web Interface User Documentation
and_parcal aeo nurn awl
1211427023
1211427023
1211427923
12114279:2
1211427022
1211427072
132632=5
132532=6
132532E007
1325329008
132632912
13263291310
132632501'
15 13=321:
1325-329913
Z2 132632X11
180. 132E32901k
19 ' 22537=5
,225329995
21 ' ,326323170.: 27 • ':1142
23 21
24 122632166
4 251,3453C:5
25 4 2615454:T7
27 4 2613454007 --4 28 • 4 2f l84547
Resolution #99056 March 18, 1999
e n
I • I I' A
Moved by Douglas supported by Jensen the resolution be adopted.
AYES: Douglas, Galloway, Garfield, Gregory, Jensen, Law, McCulloch,
McPherson, Melton, Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever, Suarez,
Amos, Appel, Colasanti, Coleman, Devine, Dingeldey. (22)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
I HEREBY!0_110 THE FOREGOING RESOLUTION
7/4'2 41.
L Brooks Pat*son. County Executive Date
11111n1111111
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on March 18, 1999 with the original record
thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the
County of Oakland at Pontiac, Michigan this l8tdayI March, 1999.
G. William Caddell, County Clerk