CCSF 3 File Layout - Assessor.doc

0.07 MB·English

by  San Francisco Office of the Assessor Recorder

Extract File Layout
File: AIAMADR
Field Name Column Length Type Description
CNTL-BYTE 1 1 A Unused
VOL 2 2 A Volume Number
KEY 4 9 A
BLOCK 4 5 A
BLOCK-N 4 4 A Block Number
BLOCK-S 8 1 A Block Suffix
LOT 9 4 A
LOT-N 9 3 A Lot Number
LOT-S 12 1 A Lot Suffix
FILLER1 13 23 A Unused
SOURCE 36 1 A Unused
ADDRESS 37 113 A Address Name
ADRS1 37 27 A Address Line 1
ADRS2 64 27 A Address Line 2
ADRS3 91 27 A Address Line 3
ADRS4 118 27 A Address Line 4
ZIP 145 5 A Zip code
UPD-DATE 154 6 A Last Change Date
U-DT-MM 154 2 A Last Change Month
U-DT-DD 156 2 A Last Change Day
U-DT-YY 158 2 A Last Change Year
TRAN-TYPE 160 10 A Unused
1
Extract File Layout
File: AIAOWNR
Field Name Column Length Type Description
OWNR-CTL-BYTE 1 1 A Unused
OWNR-VOL 2 2 N Volume Number
OWNR-KEY 4 9 A Block and Lot Number
OWNER-BLOCK 4 5 A
OWNR-BLK-N 4 4 N Block Number
OWNR-BLK-S 8 1 A Block Suffix
OWNR-LOT 9 4 A
OWNR-LOT-N 9 3 N Lot Number
OWNR-LOT-S 12 1 A Lot Suffix
OWNR-SEQUENCE 13 2 N Owner Sequence Number
OWNR-OWNER-NAME 15 30 A OWNER NAME
OWNR-ENTRY-DATE 45 6 N RECORDATION DATE ‘99/99/99’
OWNR-ENTRY-YY 45 2 N Recordation Year
OWNR-ENTRY-MM 47 2 N Recordation Month
OWNR-ENTRY-DD 49 2 N Recordation Day
OWNR-LOT-STATUS 51 1 A Account Status
OWNR-LONG-NM-CD 52 1 A Unused
OWNR-NEW-LOT-CD 53 3 A Unused
OWNR-RECRDRS-NO 56 7 A Document Number
OWNR-RECRDRS-BK 56 4 A
OWNR-RECRDRS-PG 60 4 N
OWNR-RCRDR-PG-R 60 4 A
OWNR-TRANS-TYPE 64 10 N Percent of Ownership
OWNR-SIGND-DATE 74 6 N Unused
OWNR-UPDAT-DATE 80 6 N Last Change Date
2
Extract File Layout
File: AIASECDXW
Field Name From End Field Dec Field Field Description
Pos Pos Size Pos Type*
CTLBYTE 1 1 1 A Unused
RP1VOLUME 2 3 2 0 S Volume Number
RP1PRCLID 4 12 9 A Block and Lot Number
SITUS 13 49 37 A Property Location (SITUS)
ROLLYEAR 50 51 2 0 S Closed Roll Year
RP1STACDE 52 52 1 A Closed Roll Status Code
RP1LNDVAL 53 63 11 0 S Closed Roll Assessed Land Value
RP1IMPVAL 64 74 11 0 S Closed Roll Assessed Improvement Value
RP1FXTVAL 75 85 11 0 S Closed Roll Assessed Fixtures Value
RP1PPTVAL 86 96 11 0 S Closed Roll Assessed Personal Prop Value
RP1EXMVL1 97 107 11 0 S Closed Roll Homeowner Exemption Value
RP1EXMVL2 108 118 11 0 S Closed Roll Miscellaneous Exemption Value
EXEMPTYPE 119 120 2 A Closed Roll Exemption Type Code
WORKYEAR 121 122 2 A
WORKSTATUS 123 123 1 A
WORKFVLAND 124 134 11 0 S
WORKFVSTR 135 145 11 0 S
WORKFVFIXT 146 156 11 0 S
WORKFVOTH 157 167 11 0 S
WORKEXHOME 168 178 11 0 S
WORKEXOTH 179 189 11 0 S
WORKEXMTYP 190 191 2 A
VALDATE 192 197 6 A Valuation Date (YYMMDD)
REBASEYRCD 198 198 1 A Unused
REBASEYR 199 202 4 0 S Sales Base Year
REPRISRC 203 203 1 A Prior Sales Source Code
REPRIPRVAL 204 214 11 0 S Prior Sales Price
REPRISDATE 215 220 6 A Prior Sales Date (YYMMDD)
RECURRSOUR 221 221 1 A Current Sales Source Code
RECURRPRIC 222 232 11 0 S Current Sales Price
RECURRSALD 233 238 6 0 S Current Sales Date (YYMMDD)
WSRATIO 239 242 4 3 S Assessed Value to Sales Ratio
REENTRY 243 246 4 A Unused
TRANCODE 247 248 2 A Other Transactions Code
TRANDATE 249 254 6 0 S Other Transactions Date (YYMMDD)
TXSALECDE 255 255 1 A Unused
TXSALEDAT 256 261 6 A Unused
TXSALENUM 262 266 5 A Unused
LEASEHOLD 267 267 1 A Leasehold Notation Flag
RP1CLACDE 268 270 3 A Property Class Code
RP1NBRCDE 271 273 3 A Neighborhood Code
QCLPRE 274 276 3 A Unused
REMARKFLA 277 277 1 A Quality of Finished Basement
KITCHEN 278 280 3 A Kitchen Code
BUILTIN 281 284 4 A Kitchen Built-ins
STOREYCODE 285 285 1 A Unused
SUBLEVEL 286 286 1 A Unused
3
* A = alphanumeric, P = Packed numeric, S = Unpacked numeric
File: AIASECDXW (continued…)
Field Name From End Field Dec Fld Field Description
Pos Pos Size Pos Type*
ROOMSFX 287 287 1 A Unused
CONSTTYPE 288 290 3 A Construction Type
BASELOT 291 293 3 A Base Lot
BASELOTSFX 294 294 1 A Base Lot Suffix
ZONE 295 300 6 A Zoning Code
RP1APRCDE 301 303 3 A Appraiser ID Number
CHGDATE 304 307 4 A Characteristics Change Date (YYMM)
LOTCODE 308 308 1 A Lot Code
FRONT 309 312 4 2 S Lot Frontage
DEPTH 313 316 4 2 S Lot Depth
LAREA 317 326 10 2 S Lot Area
FBA 327 331 5 0 S Basement Area
STOREYNO 332 334 3 0 S Number of Stories
UNITS 335 339 5 0 S Number of Units
ROOMS 340 344 5 0 S Number of Rooms
BEDS 345 349 5 0 S Number of Bedrooms
BATHS 350 354 5 0 S Number of Bathrooms
SQFT 355 361 7 0 S Property Area in Square Feet
YRBLT 362 365 4 0 S Year Property Built
AGE 366 370 5 0 S Unused
ALTNC 371 374 4 A Unused
RP1TRACDE 375 378 4 A Tax Rate Area Code
RP1LSTMOD 379 386 8 0 S Last Modification Date (CCYYMMDD)
FILLER33 387 419 33 A Unused
* A = alphanumeric, P = Packed numeric, S = Unpacked numeric
4