Open Records

$\\Merc\hallwatch\hallwatch3.PNG$

Estimated Cost To Copy Deed Extract info. to CD

I estimate it would cost the Dept. of Records $1.74 to create a monthly CD with updates from the Recorder of Deeds database. To estimate the costs to the Records Dept. of producing such a CD, I simply carried out on my computers the steps the Department of Records would have to follow and recorded the time required to complete each step. These procedures were carried out on actual Recorder of Deed’s Extract data which I possess.

Step Estimated Staff Time Required Computer Time Required

1. Extract the data from the Oracle Database. 2 minutes 1.5 seconds

2. Burn CD 1 minute 74 seconds

Total 3 minutes 75.5 seconds

Step	Estimated Staff Time Required	Computer Time Required
1. Extract the data from the Oracle Database.	2 minutes	1.5 seconds
2. Burn CD	1 minute	74 seconds
Total	3 minutes	75.5 seconds

Estimated Cost to Records Dept.

Annual salary of Records Dept. programmer analyst in FY 02 (See Exhibit E-6) $64,000

Hourly Rate ($64,000/52 weeks/40 hours) of programmer $32/hr.

Cost of Staff time (3 minutes): $1.60

Cost of computer time (75.5 seconds): $0

Cost of 100 CDs on Internet (Exhibit E-9): $14

Cost of 1 CD: $0.14

Total Estimated Cost to Records Dept. $1.74

Estimated Cost to Records Dept.
Annual salary of Records Dept. programmer analyst in FY 02 (See Exhibit E-6)	$64,000
Hourly Rate ($64,000/52 weeks/40 hours) of programmer	$32/hr.
Cost of Staff time (3 minutes):	$1.60
Cost of computer time (75.5 seconds):	$0
Cost of 100 CDs on Internet (Exhibit E-9):	$14
Cost of 1 CD:	$0.14
Total Estimated Cost to Records Dept.	$1.74

The computer time to perform this task is minimal, less than two minutes on my inexpensive equipment. Note that these estimates probably overstate the time required as the Department of Records probably has faster computers than I do. The Department’s budget in FY 2003 was $5.4 Million (Exhibit E-7).

Equipment Hallwatch Recorder of Deeds

Hardware: 800 Mhz Intel Celeron. This was a mid level machine 3 years ago. Estimated value: $500 Server Computer Running Database. Cost Unknown. Loaded server systems can cost from $2,000 on up.

Software: SQL Database Software MySQL, a free SQL database Oracle, a very expensive SQL database

CD Burner Mitsumi CD-R/CD-RW.
Cost: $50 Unknown

Equipment	Hallwatch	Recorder of Deeds
Hardware:	800 Mhz Intel Celeron. This was a mid level machine 3 years ago. Estimated value: $500	Server Computer Running Database. Cost Unknown. Loaded server systems can cost from $2,000 on up.
Software:	SQL Database Software MySQL, a free SQL database	Oracle, a very expensive SQL database
CD Burner	Mitsumi CD-R/CD-RW. Cost: $50	Unknown

This command to extract a month’s worth of Recorder of Deed’s information for June, 2002 took 1.5 seconds on my $500 computer:

[root@mail /root]# time mysql proptax -e 'select * from sales where record_date>="2002-06-01" and record_date<"2002-07-01"'  > recorders_extract_June_2002

real	0m1.516s
user	0m0.670s
sys	0m0.090s

This command to burn a CD with the data on it took 74 second to complete. The CD Burner used cost $50 (See Exhibit E-7)


[root@merc goppelt]# 1burn temp
Cdrecord 1.10 (i686-pc-linux-gnu) Copyright (C) 1995-2001 Jörg Schilling
TOC Type: 1 = CD-ROM
scsidev: '0,0,0'
scsibus: 0 target: 0 lun: 0
Linux sg driver version: 3.1.24
Using libscg version 'schily-0.5'
atapi: 1
Device type    : Removable CD-ROM
Version        : 0
Response Format: 1
Vendor_info    : 'MITSUMI '
Identifikation : 'CR-48XATE       '
Revision       : '1.0E'
Device seems to be: Philips CDD-522.
Using generic SCSI-3/mmc CD-R driver (mmc_cdr).
Driver flags   : SWABAUDIO
Drive buf size : 1507328 = 1472 KB
FIFO size      : 4194304 = 4096 KB
Track 01: data  unknown length
Total size:       0 MB (00:00.00) = 0 sectors
Lout start:       0 MB (00:02/00) = 0 sectors
Current Secsize: 2048
ATIP info from disk:
  Indicated writing power: 5
  Is not unrestricted
  Is not erasable
  Disk sub type: Medium Type C, low Beta category (C-) (6)
  ATIP start of lead in:  -11640 (97:26/60)
  ATIP start of lead out: 337350 (75:00/00)
Disk type:    Long strategy type (Cyanine, AZO or similar)
Manuf. index: 3
Manufacturer: CMC Magnetics Corporation
cdrecord: WARNING: Track size unknown. Data may not fit on disk.
Starting to write CD/DVD at speed 4 in write mode for single session.
Last chance to quit, starting real write in 0 seconds. Operation starts.
Waiting for reader process to fill input buffer ... input buffer ready.
Performing OPC...
Starting new track at sector: 0
Track 01:   0 MB written.Total translation table size: 0
Total rockridge attributes bytes: 268
Total directory bytes: 0
Path table size(bytes): 10
Max brk space used 6544
2064 extents written (4 Mb)
Track 01:   4 MB written (fifo 100%).
Track 01: Total bytes read/written: 4227072/4227072 (2064 sectors).
Writing  time:   11.999s
Fixating...
Fixating time:   62.149s
cdrecord: fifo had 68 puts and 68 gets.
cdrecord: fifo was 0 times empty and 0 times full, min fill was 89%.