Dublin Core
Title
Box 4, Folder 4, Document 14
Text Item Type Metadata
Text
< CITY OF ATLANTA
A Lb a
b OFFiCE OF CITY COMPTROLLER
I ATLANTA 3, GEORGIA
1g January 2, 1959
TO: Those Noted
FROM: JeV. Gordon
SUBJECT: crp 1969 update
We have been instructed to give first priority to matching the CIP
Master File against Fulton County's Real Property Master File.
Fulton County is now reformatting their Real Property Master File
and will have a reformatted file, updated through 1968, available for us
by January 15, 1969.
Parcel Code Number identification as used in our CIP file differs
from that used by Fulton County on their Real Property Master File. The
two identification methods are shown here:
County PCN City PCN
District XXX 99X
Land Lot 9999 999X
Square XXXX 9999X
Unit 399 999%
9 =A digit only
X = Either a digit or an alphabetic character
This results in PCN identification as shown here:
County PCN XXX9999XXXK999
City PCN 99X¥999X9999X999X
As can be seen, not only are there differences in the characteristics
of the various positions but the City PCN is a total of 16 characters where-
as the County PCN is only 14 characters.
The different PCN identification formats resulted from the City's having
to allow for Dekalb County's numbering system when the CIP file was originally
built. Dekalb County has since then changed to the PCN identification method
used by Fulton County.
PCN is the sequence in which both the City and County files are kept.
Since the PCN identifiers are not compatible in format, it has been necessary
for us to translate PCN from the County format to the City format whenever
we used data supplied by the County. This translation process would cause
the resultant file to be out of sequence and thus require a sort of the Master
File.
The translation and sorting was done in order to preserve the ability to
run the series of CIP report programs which required for input, a PCN in the
City's format.
Qe
During the upcoming match of 1968 Fulton County tapes with the 1967
CIP file, we will convert our PCN identifier on the CIP file to the County's
format. This will render it impossible to continue to use existing CIP
report programs without wodifications and will alter the method of making
updates to the master file.
It is anticipated that the special Committee which has been appointed
to study the data processing needs for planning information will define future
reporting requirements. If it is necessary to run the CIP reports, they could
be run with the 1967 CIP Master which will remain unimpaired as a result of
the conversion,
Fulton County's file should be available for us to schedule processing
the weekend of January 18 - 19.
Distribution:
Messrs: George Berry
Milton Converse
Charles L. Davis
Collier Gladin
Frank Howard
R. Earl Landers
W. Roy Smith
John Watson
JG/bb
a8
During the upcoming match of 1968 Fulton County tapes with the 1967
CIP file, we will convert our PCN identifier on the CIP file to the County's
format. This will render it impossible to continue to use existing CIP
report programs without modifications and will alter the method of making
updates to the master file.
It is anticipated that the special Committee which has been appointed
to study the data processing needs for planning information will define future
reporting requirements. If it is necessary to run the CIP reports, they could
be run with the 1967 CIP Master which will remain unimpaired as a result of
the conversion,
Fulton County's file should be available for us to schedule processing
the weekend of January 18 - 19.
Distribution:
Messrs: George Berry
Milton Converse
Charles L. Davis
Collier Gladin
Frank Howard
R. Earl Landers
W. Roy Smith
John Watson
JG/bb
A Lb a
b OFFiCE OF CITY COMPTROLLER
I ATLANTA 3, GEORGIA
1g January 2, 1959
TO: Those Noted
FROM: JeV. Gordon
SUBJECT: crp 1969 update
We have been instructed to give first priority to matching the CIP
Master File against Fulton County's Real Property Master File.
Fulton County is now reformatting their Real Property Master File
and will have a reformatted file, updated through 1968, available for us
by January 15, 1969.
Parcel Code Number identification as used in our CIP file differs
from that used by Fulton County on their Real Property Master File. The
two identification methods are shown here:
County PCN City PCN
District XXX 99X
Land Lot 9999 999X
Square XXXX 9999X
Unit 399 999%
9 =A digit only
X = Either a digit or an alphabetic character
This results in PCN identification as shown here:
County PCN XXX9999XXXK999
City PCN 99X¥999X9999X999X
As can be seen, not only are there differences in the characteristics
of the various positions but the City PCN is a total of 16 characters where-
as the County PCN is only 14 characters.
The different PCN identification formats resulted from the City's having
to allow for Dekalb County's numbering system when the CIP file was originally
built. Dekalb County has since then changed to the PCN identification method
used by Fulton County.
PCN is the sequence in which both the City and County files are kept.
Since the PCN identifiers are not compatible in format, it has been necessary
for us to translate PCN from the County format to the City format whenever
we used data supplied by the County. This translation process would cause
the resultant file to be out of sequence and thus require a sort of the Master
File.
The translation and sorting was done in order to preserve the ability to
run the series of CIP report programs which required for input, a PCN in the
City's format.
Qe
During the upcoming match of 1968 Fulton County tapes with the 1967
CIP file, we will convert our PCN identifier on the CIP file to the County's
format. This will render it impossible to continue to use existing CIP
report programs without wodifications and will alter the method of making
updates to the master file.
It is anticipated that the special Committee which has been appointed
to study the data processing needs for planning information will define future
reporting requirements. If it is necessary to run the CIP reports, they could
be run with the 1967 CIP Master which will remain unimpaired as a result of
the conversion,
Fulton County's file should be available for us to schedule processing
the weekend of January 18 - 19.
Distribution:
Messrs: George Berry
Milton Converse
Charles L. Davis
Collier Gladin
Frank Howard
R. Earl Landers
W. Roy Smith
John Watson
JG/bb
a8
During the upcoming match of 1968 Fulton County tapes with the 1967
CIP file, we will convert our PCN identifier on the CIP file to the County's
format. This will render it impossible to continue to use existing CIP
report programs without modifications and will alter the method of making
updates to the master file.
It is anticipated that the special Committee which has been appointed
to study the data processing needs for planning information will define future
reporting requirements. If it is necessary to run the CIP reports, they could
be run with the 1967 CIP Master which will remain unimpaired as a result of
the conversion,
Fulton County's file should be available for us to schedule processing
the weekend of January 18 - 19.
Distribution:
Messrs: George Berry
Milton Converse
Charles L. Davis
Collier Gladin
Frank Howard
R. Earl Landers
W. Roy Smith
John Watson
JG/bb
Comments