{split r05 for visits 11-24-20} database notes4 file notes field rid type serial field r00 type char 10 {block} index dups field r01 type char 10 {lot} index dups field r0q type char 05 {qual} field r_id type composite r00, r01, r0q index dups field r02 type char 24 {block/lot/qual} index field r04 type date {date} field r05a type char 56 {[1,56] notes #1} field r05b type char 56 {[57,112] notes #2} field r05c type char 56 {[113,168] notes #3} field r05d type char 56 {[169,224] notes #4} field r05e type char 56 {[225,280] notes #5} field r05fa type char 52 field r05f1i type char 1 {insp results} field r05f2i type char 1 field r05f3i type char 1 field r05f4i type char 1 field r05g1d type char 8 {visit line 1} field r05g1i type char 2 field r05g1r type char 2 field r05g1f type char 2 field r05g2d type char 8 {visit line 2} field r05g2i type char 2 field r05g2r type char 2 field r05g2f type char 2 field r05g3d type char 8 {visit line 3} field r05g3i type char 2 field r05g3r type char 2 field r05g3f type char 2 field r05g4d type char 8 {visit line 4} field r05g4i type char 2 field r05g4r type char 2 field r05g4f type char 2 field r06 type char 3 {id} field r07 type long {sale1 price} field r08 type date {sale1 date} field r09 type char 2 {sale1 nu-code} field r10 type long {sale2 price} field r11 type date {sale2 date} field r12 type char 2 {sale2 nu-code} field r13 type long {listing price} field r14a1 type char 4 {[ 1, 4] farmland 1 code} field r14a2 type char 5 {[ 5, 9] farmland 1 acres} field r14b1 type char 4 {[10,13] farmland 2 code} field r14b2 type char 5 {[14,18] farmland 2 acres} field r14c1 type char 4 {[19,22] farmland 3 code} field r14c2 type char 5 {[23,27] farmland 3 acres} field r14d1 type char 4 {[28,31] farmland 4 code} field r14d2 type char 5 {[32,36] farmland 4 acres} field r14e1 type char 4 {[37,40] farmland 5 code} field r14e2 type char 5 {[41,45] farmland 5 acres} field r14f1 type char 4 {[46,49] farmland 6 code} field r14f2 type char 5 {[50,54] farmland 6 acres} field r14g1 type char 4 {[55,58] farmland 7 code} field r14g2 type char 5 {[59,63] farmland 7 acres} field r14h1 type char 4 {[64,67] farmland 8 code} field r14h2 type char 5 {[68,72] farmland 8 acres} field r14i1 type char 4 {[73,76] farmland 9 code} field r14i2 type char 5 {[77,81] farmland 9 acres} field r14j1 type char 4 {[82,85] farmland 10 code } field r14j2 type char 5 {[86,90] farmland 10 acres} field r14k1 type char 4 {[91,94] farmland 11 code } field r14k2 type char 5 {[95,99] farmland 11 acres} field r14l1 type char 4 {[100,103] farmland 12 code } field r14l2 type char 5 {[104,108] farmland 12 acres} field r14m1 type char 4 {[109,112] farmland 13 code } field r14m2 type char 5 {[113,117] farmland 13 acres} field r14n1 type char 4 {[118,121] farmland 14 code } field r14n2 type char 5 {[122,126] farmland 14 acres} field r14o1 type char 4 {[127,130] farmland 15 code } field r14o2 type char 5 {[131,135] farmland 15 acres} field r15a type char 30 {notes from prc.dat - new 7-8-98 bkr} field r15b type char 30 {reason} field r16 type char 28 {street index sort field 8-23-04} index dups field r17 type long {number of photos 12-3-05 bkr} field r18 type long {det1 value over-ride} field r19 type long {det2 value over-ride} field r20 type long {det3 value over-ride} field r21 type long {det4 value over-ride} field r22 type long {r_base_cost} field r23 type long {r_det_items } field r24 type long {r_heated_area } field r25 type long {r_livable_area - can exceede 32000} field r26 type long {r_slab } field r27 type long {r_basement } field r28 type long {r_nobsmt } field r29 type long {r_finbsmt } field r30 type long {r_hfinbsmt } field r31 type long {r_first } field r32 type long {r_half } field r33 type long {r_upper } field r34 type long {r_cathedral } field r35 type long {r_3rd } field r36 type long {r_unfinarea } field r37 type long {r_un_half } field r38 type long {r_attgar +r_attgar2 } field r39 type long {r_bi_ga +r_big +r_big2 +r_big3 } field r40 type long {r_bi_op +r_bi_op2 } field c41 type long {r_bi_ep } field c42 type long {r_bi_gp } field c43 type long {r_basmtgar +r_basmtg2 } field c44 type long {r_basmtcar } field c45 type long {r_carport } field c46 type long {r_canopy +r_canop2 +r_canop3 } field c47 type long {r_dormer +r_dorm2 +r_dorm3 +r_dorm4 } field c48 type long {r_ep +r_ep2 +r_ep3 +r_eph } field c49 type long {r_attic +r_hfa +r_expattic +r_unfexpattic } field c50 type long {r_op +r_op2 +r_op3 +r_op4 +r_op5 +r_op6 } field c51 type long {r_gazebo } field c52 type long {r_balc } field c53 type long {r_gporch r_cporch } field c54 type long {r_cost_new} field c55 type long {r_deck +r_deck2 +r_deck3 +r_rfdeck } field c56 type long {r_patio+2+r_fs_patio+r_bk_patio+r_st_patio} field c57 type long {r_terr +r_brick_terr +r_stone_terr } field c58 type long {r_detgar } field c59 type long {r_detcarport } field c60 type long {r_shed +r_att_shed } field c61 type long {r_pool } field c62 type long {r_green_house } field c63 type char 222 {mixed use land data 10-24-04 bkr} field c64 type float {total acres -new fields 2-22-05 bkr} field c65 type char 148 {detached items -new 8-18-05 bkr} field c66 type char 16 {misc items w/quantity -new 8-18-05 bkr} field c67 type char 8 {user fields -new 8-24-05 bkr} end