{use for longitude/latitude, format lines for excel, bkr 4-10-14 bkr} {would be nice to add h03 & new fields for ext3 1-8-06 bkr} {new fields 2-22-05 bkr} {new fields 8-23-04 bkr} {added notes from prc.dat, reclength=671 - 7-8-98 bkr} {expanded r14 to accomodate extra qfarm fields 11-7-94 gdl} {new file -- notes for pev 8-30-93 bkr} {changed from "prcnotes" to "prc" 2-24-05 bkr} database prc file notes field rid type serial field r00 type char 10 {new block} index dups field r01 type char 10 {new lot} index dups field r0q type char 5 {new q} field r_id type composite r00, r01, r0q index dups field r02 type char 24 {new block/lot/q} index field r04 type date {date} field r05 type char 392 {notes 56 x 7 lines} 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, also exterior fin #3} field r11 type date {sale2 date} field r12 type char 2 {sale2 nu-code, also exterior fin #3} field r13 type long {listing price} field r14 type char 135 {farm land, changed from 81 11-4-94 gdl} field r15 type char 60 {notes from prc.dat, new 7-8-98 bkr} field r16 type char 28 {street index not used 8-23-04} index dups field r17 type long {latitude, 4-10-14 bkr} field r18 type long {longitude, 4-10-14 bkr} field r19 type long {year to inspect, 4-10-14 bkr} field r20 type long {det3 not used} field r21 type long {det4 not used} field r22 type long {r_base_cost, new fields 2-22-05 bkr} 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