<% ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit. On Error Resume Next strErrorUrl = "" If Request.ServerVariables("REQUEST_METHOD") = "POST" Then If Request.Form("VTI-GROUP") = "0" Then Err.Clear Set fp_conn = Server.CreateObject("ADODB.Connection") FP_DumpError strErrorUrl, "Cannot create connection" Set fp_rs = Server.CreateObject("ADODB.Recordset") FP_DumpError strErrorUrl, "Cannot create record set" fp_conn.Open Application("Database1_ConnectionString") FP_DumpError strErrorUrl, "Cannot open database" fp_rs.Open "RatioStudySurvey062003", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable FP_DumpError strErrorUrl, "Cannot open record set" fp_rs.AddNew FP_DumpError strErrorUrl, "Cannot add new record set to the database" Dim arFormFields0(202) Dim arFormDBFields0(202) Dim arFormValues0(202) arFormFields0(0) = "telprefix" arFormDBFields0(0) = "telprefix" arFormValues0(0) = Request("telprefix") arFormFields0(1) = "R4Aexplain" arFormDBFields0(1) = "R4Aexplain" arFormValues0(1) = Request("R4Aexplain") arFormFields0(2) = "R5Eother" arFormDBFields0(2) = "R5Eother" arFormValues0(2) = Request("R5Eother") arFormFields0(3) = "R9brokerage" arFormDBFields0(3) = "R9brokerage" arFormValues0(3) = Request("R9brokerage") arFormFields0(4) = "R11A" arFormDBFields0(4) = "R11A" arFormValues0(4) = Request("R11A") arFormFields0(5) = "R13Bprdstandarddiff" arFormDBFields0(5) = "R13Bprdstandarddiff" arFormValues0(5) = Request("R13Bprdstandarddiff") arFormFields0(6) = "R13C" arFormDBFields0(6) = "R13C" arFormValues0(6) = Request("R13C") arFormFields0(7) = "R17G" arFormDBFields0(7) = "R17G" arFormValues0(7) = Request("R17G") arFormFields0(8) = "R8Fexplain" arFormDBFields0(8) = "R8Fexplain" arFormValues0(8) = Request("R8Fexplain") arFormFields0(9) = "R16Cothertype" arFormDBFields0(9) = "R16Cothertype" arFormValues0(9) = Request("R16Cothertype") arFormFields0(10) = "R17Arangeofvalues" arFormDBFields0(10) = "R17Arangeofvalues" arFormValues0(10) = Request("R17Arangeofvalues") arFormFields0(11) = "R17Acounty" arFormDBFields0(11) = "R17Acounty" arFormValues0(11) = Request("R17Acounty") arFormFields0(12) = "R16Cmineralratio" arFormDBFields0(12) = "R16Cmineralratio" arFormValues0(12) = Request("R16Cmineralratio") arFormFields0(13) = "title" arFormDBFields0(13) = "title" arFormValues0(13) = Request("title") arFormFields0(14) = "emailaddress" arFormDBFields0(14) = "emailaddress" arFormValues0(14) = Request("emailaddress") arFormFields0(15) = "R9otherpercent" arFormDBFields0(15) = "R9otherpercent" arFormValues0(15) = Request("R9otherpercent") arFormFields0(16) = "R11B" arFormDBFields0(16) = "R11B" arFormValues0(16) = Request("R11B") arFormFields0(17) = "R11other" arFormDBFields0(17) = "R11other" arFormValues0(17) = Request("R11other") arFormFields0(18) = "R13D" arFormDBFields0(18) = "R13D" arFormValues0(18) = Request("R13D") arFormFields0(19) = "R14Darithmeticcalc" arFormDBFields0(19) = "R14Darithmeticcalc" arFormValues0(19) = Request("R14Darithmeticcalc") arFormFields0(20) = "R14Dweightedequal" arFormDBFields0(20) = "R14Dweightedequal" arFormValues0(20) = Request("R14Dweightedequal") arFormFields0(21) = "R14E" arFormDBFields0(21) = "R14E" arFormValues0(21) = Request("R14E") arFormFields0(22) = "R17Fpropclass" arFormDBFields0(22) = "R17Fpropclass" arFormValues0(22) = Request("R17Fpropclass") arFormFields0(23) = "R17H" arFormDBFields0(23) = "R17H" arFormValues0(23) = Request("R17H") arFormFields0(24) = "R16Craildefault" arFormDBFields0(24) = "R16Craildefault" arFormValues0(24) = Request("R16Craildefault") arFormFields0(25) = "R16Crailratio" arFormDBFields0(25) = "R16Crailratio" arFormValues0(25) = Request("R16Crailratio") arFormFields0(26) = "R2" arFormDBFields0(26) = "R2" arFormValues0(26) = Request("R2") arFormFields0(27) = "R7Cexplain" arFormDBFields0(27) = "R7Cexplain" arFormValues0(27) = Request("R7Cexplain") arFormFields0(28) = "R9financing" arFormDBFields0(28) = "R9financing" arFormValues0(28) = Request("R9financing") arFormFields0(29) = "R10B" arFormDBFields0(29) = "R10B" arFormValues0(29) = Request("R10B") arFormFields0(30) = "R11C" arFormDBFields0(30) = "R11C" arFormValues0(30) = Request("R11C") arFormFields0(31) = "R13E" arFormDBFields0(31) = "R13E" arFormValues0(31) = Request("R13E") arFormFields0(32) = "R14Dotherequal" arFormDBFields0(32) = "R14Dotherequal" arFormValues0(32) = Request("R14Dotherequal") arFormFields0(33) = "R14Eexplain" arFormDBFields0(33) = "R14Eexplain" arFormValues0(33) = Request("R14Eexplain") arFormFields0(34) = "R16" arFormDBFields0(34) = "R16" arFormValues0(34) = Request("R16") arFormFields0(35) = "R16AA" arFormDBFields0(35) = "R16AA" arFormValues0(35) = Request("R16AA") arFormFields0(36) = "R17Aotherexplain" arFormDBFields0(36) = "R17Aotherexplain" arFormValues0(36) = Request("R17Aotherexplain") arFormFields0(37) = "R17Hpercent" arFormDBFields0(37) = "R17Hpercent" arFormValues0(37) = Request("R17Hpercent") arFormFields0(38) = "R19addcomments" arFormDBFields0(38) = "R19addcomments" arFormValues0(38) = Request("R19addcomments") arFormFields0(39) = "R11D" arFormDBFields0(39) = "R11D" arFormValues0(39) = Request("R11D") arFormFields0(40) = "R17Dexplain" arFormDBFields0(40) = "R17Dexplain" arFormValues0(40) = Request("R17Dexplain") arFormFields0(41) = "R16Ccommldefault" arFormDBFields0(41) = "R16Ccommldefault" arFormValues0(41) = Request("R16Ccommldefault") arFormFields0(42) = "R4" arFormDBFields0(42) = "R4" arFormValues0(42) = Request("R4") arFormFields0(43) = "R8Dexplain" arFormDBFields0(43) = "R8Dexplain" arFormValues0(43) = Request("R8Dexplain") arFormFields0(44) = "R9PPpercent" arFormDBFields0(44) = "R9PPpercent" arFormValues0(44) = Request("R9PPpercent") arFormFields0(45) = "R11E" arFormDBFields0(45) = "R11E" arFormValues0(45) = Request("R11E") arFormFields0(46) = "R12explain" arFormDBFields0(46) = "R12explain" arFormValues0(46) = Request("R12explain") arFormFields0(47) = "R14Dweightedcalc" arFormDBFields0(47) = "R14Dweightedcalc" arFormValues0(47) = Request("R14Dweightedcalc") arFormFields0(48) = "R18" arFormDBFields0(48) = "R18" arFormValues0(48) = Request("R18") arFormFields0(49) = "R16Cutilratio" arFormDBFields0(49) = "R16Cutilratio" arFormValues0(49) = Request("R16Cutilratio") arFormFields0(50) = "firstname" arFormDBFields0(50) = "firstname" arFormValues0(50) = Request("firstname") arFormFields0(51) = "profdesignation" arFormDBFields0(51) = "profdesignation" arFormValues0(51) = Request("profdesignation") arFormFields0(52) = "bureaudept" arFormDBFields0(52) = "bureaudept" arFormValues0(52) = Request("bureaudept") arFormFields0(53) = "R3Dexplain" arFormDBFields0(53) = "R3Dexplain" arFormValues0(53) = Request("R3Dexplain") arFormFields0(54) = "R5" arFormDBFields0(54) = "R5" arFormValues0(54) = Request("R5") arFormFields0(55) = "R11F" arFormDBFields0(55) = "R11F" arFormValues0(55) = Request("R11F") arFormFields0(56) = "R14Blegalauthority" arFormDBFields0(56) = "R14Blegalauthority" arFormValues0(56) = Request("R14Blegalauthority") arFormFields0(57) = "R16Aexplain" arFormDBFields0(57) = "R16Aexplain" arFormValues0(57) = Request("R16Aexplain") arFormFields0(58) = "R19" arFormDBFields0(58) = "R19" arFormValues0(58) = Request("R19") arFormFields0(59) = "R13homogeneousdiff" arFormDBFields0(59) = "R13homogeneousdiff" arFormValues0(59) = Request("R13homogeneousdiff") arFormFields0(60) = "R16Cotherdefault" arFormDBFields0(60) = "R16Cotherdefault" arFormValues0(60) = Request("R16Cotherdefault") arFormFields0(61) = "R16Ccommlratio" arFormDBFields0(61) = "R16Ccommlratio" arFormValues0(61) = Request("R16Ccommlratio") arFormFields0(62) = "R5Eiowa" arFormDBFields0(62) = "R5Eiowa" arFormValues0(62) = Request("R5Eiowa") arFormFields0(63) = "R2years" arFormDBFields0(63) = "R2years" arFormValues0(63) = Request("R2years") arFormFields0(64) = "R6B1" arFormDBFields0(64) = "R6B1" arFormValues0(64) = Request("R6B1") arFormFields0(65) = "R8A" arFormDBFields0(65) = "R8A" arFormValues0(65) = Request("R8A") arFormFields0(66) = "R14Dmediancalc" arFormDBFields0(66) = "R14Dmediancalc" arFormValues0(66) = Request("R14Dmediancalc") arFormFields0(67) = "copyofreport" arFormDBFields0(67) = "copyofreport" arFormValues0(67) = Request("copyofreport") arFormFields0(68) = "R16Cotherratio" arFormDBFields0(68) = "R16Cotherratio" arFormValues0(68) = Request("R16Cotherratio") arFormFields0(69) = "lastname" arFormDBFields0(69) = "lastname" arFormValues0(69) = Request("lastname") arFormFields0(70) = "R6B2" arFormDBFields0(70) = "R6B2" arFormValues0(70) = Request("R6B2") arFormFields0(71) = "R7" arFormDBFields0(71) = "R7" arFormValues0(71) = Request("R7") arFormFields0(72) = "R7Aexplain" arFormDBFields0(72) = "R7Aexpalin" arFormValues0(72) = Request("R7Aexplain") arFormFields0(73) = "R8B" arFormDBFields0(73) = "R8B" arFormValues0(73) = Request("R8B") arFormFields0(74) = "R9time" arFormDBFields0(74) = "R9time" arFormValues0(74) = Request("R9time") arFormFields0(75) = "R13largeurbandiff" arFormDBFields0(75) = "R13largeurbandiff" arFormValues0(75) = Request("R13largeurbandiff") arFormFields0(76) = "R13unimproveddiff" arFormDBFields0(76) = "R13unimproveddiff" arFormValues0(76) = Request("R13unimproveddiff") arFormFields0(77) = "R14Cexplain" arFormDBFields0(77) = "R14Cexplain" arFormValues0(77) = Request("R14Cexplain") arFormFields0(78) = "R16AAexplain" arFormDBFields0(78) = "R16AAexplain" arFormValues0(78) = Request("R16AAexplain") arFormFields0(79) = "R18explain" arFormDBFields0(79) = "R18explain" arFormValues0(79) = Request("R18explain") arFormFields0(80) = "R13heterogeneousdiff" arFormDBFields0(80) = "R13heterogeneousdiff" arFormValues0(80) = Request("R13heterogeneousdiff") arFormFields0(81) = "R16Cresdefault" arFormDBFields0(81) = "R16Cresdefault" arFormValues0(81) = Request("R16Cresdefault") arFormFields0(82) = "telnumber" arFormDBFields0(82) = "telnumber" arFormValues0(82) = Request("telnumber") arFormFields0(83) = "R5Edepr" arFormDBFields0(83) = "R5Edepr" arFormValues0(83) = Request("R5Edepr") arFormFields0(84) = "R6A" arFormDBFields0(84) = "R6A" arFormValues0(84) = Request("R6A") arFormFields0(85) = "R6B3" arFormDBFields0(85) = "R6B3" arFormValues0(85) = Request("R6B3") arFormFields0(86) = "R6B10" arFormDBFields0(86) = "R6B10" arFormValues0(86) = Request("R6B10") arFormFields0(87) = "R7B" arFormDBFields0(87) = "R7B" arFormValues0(87) = Request("R7B") arFormFields0(88) = "R8" arFormDBFields0(88) = "R8" arFormValues0(88) = Request("R8") arFormFields0(89) = "R8C" arFormDBFields0(89) = "R8C" arFormValues0(89) = Request("R8C") arFormFields0(90) = "R9timepercent" arFormDBFields0(90) = "R9timepercent" arFormValues0(90) = Request("R9timepercent") arFormFields0(91) = "R13Corder" arFormDBFields0(91) = "R13Corder" arFormValues0(91) = Request("R13Corder") arFormFields0(92) = "R14Blegalauthorityexplain" arFormDBFields0(92) = "R14Blegalauthorityexplain" arFormValues0(92) = Request("R14Blegalauthorityexplain") arFormFields0(93) = "R17Bexplain" arFormDBFields0(93) = "R17Bexplain" arFormValues0(93) = Request("R17Bexplain") arFormFields0(94) = "R8Grecordation" arFormDBFields0(94) = "R8Grecordation" arFormValues0(94) = Request("R8Grecordation") arFormFields0(95) = "R16Cfarmdefault" arFormDBFields0(95) = "R16Cfarmdefault" arFormValues0(95) = Request("R16Cfarmdefault") arFormFields0(96) = "agencyjurisdiction" arFormDBFields0(96) = "agencyjurisdiction" arFormValues0(96) = Request("agencyjurisdiction") arFormFields0(97) = "R5A" arFormDBFields0(97) = "R5A" arFormValues0(97) = Request("R5A") arFormFields0(98) = "R5Cexplain" arFormDBFields0(98) = "R5Cexplain" arFormValues0(98) = Request("R5Cexplain") arFormFields0(99) = "R6B4" arFormDBFields0(99) = "R6B4" arFormValues0(99) = Request("R6B4") arFormFields0(100) = "R6B11" arFormDBFields0(100) = "R6B11" arFormValues0(100) = Request("R6B11") arFormFields0(101) = "R7C" arFormDBFields0(101) = "R7C" arFormValues0(101) = Request("R7C") arFormFields0(102) = "R8Bexplain" arFormDBFields0(102) = "R8Bexplain" arFormValues0(102) = Request("R8Bexplain") arFormFields0(103) = "R8D" arFormDBFields0(103) = "R8D" arFormValues0(103) = Request("R8D") arFormFields0(104) = "R9" arFormDBFields0(104) = "R9" arFormValues0(104) = Request("R9") arFormFields0(105) = "R9PP" arFormDBFields0(105) = "R9PP" arFormValues0(105) = Request("R9PP") arFormFields0(106) = "R9otherexplain" arFormDBFields0(106) = "R9otherexplain" arFormValues0(106) = Request("R9otherexplain") arFormFields0(107) = "R10Aexplain" arFormDBFields0(107) = "R10Aexplain" arFormValues0(107) = Request("R10Aexplain") arFormFields0(108) = "R14Darithmeticequal" arFormDBFields0(108) = "R14Darithmeticequal" arFormValues0(108) = Request("R14Darithmeticequal") arFormFields0(109) = "R17Eexplain" arFormDBFields0(109) = "R17Eexplain" arFormValues0(109) = Request("R17Eexplain") arFormFields0(110) = "otheremailaddress" arFormDBFields0(110) = "otheremailaddress" arFormValues0(110) = Request("otheremailaddress") arFormFields0(111) = "R15Dreviewlevel" arFormDBFields0(111) = "R15Dreviewlevel" arFormValues0(111) = Request("R15Dreviewlevel") arFormFields0(112) = "R17Astratify" arFormDBFields0(112) = "R17Astratify" arFormValues0(112) = Request("R17Astratify") arFormFields0(113) = "R16Cpersdefault" arFormDBFields0(113) = "R16Cpersdefault" arFormValues0(113) = Request("R16Cpersdefault") arFormFields0(114) = "jurisdictionother" arFormDBFields0(114) = "jurisdictionother" arFormValues0(114) = Request("jurisdictionother") arFormFields0(115) = "R4A" arFormDBFields0(115) = "R4A" arFormValues0(115) = Request("R4A") arFormFields0(116) = "R5B" arFormDBFields0(116) = "R5B" arFormValues0(116) = Request("R5B") arFormFields0(117) = "R5Eotherexplain" arFormDBFields0(117) = "R5Eotherexplain" arFormValues0(117) = Request("R5Eotherexplain") arFormFields0(118) = "R6B5" arFormDBFields0(118) = "R6B5" arFormValues0(118) = Request("R6B5") arFormFields0(119) = "R6B12" arFormDBFields0(119) = "R6B12" arFormValues0(119) = Request("R6B12") arFormFields0(120) = "R8E" arFormDBFields0(120) = "R8E" arFormValues0(120) = Request("R8E") arFormFields0(121) = "R9other" arFormDBFields0(121) = "R9other" arFormValues0(121) = Request("R9other") arFormFields0(122) = "R13smallruraldiff" arFormDBFields0(122) = "R13smallruraldiff" arFormValues0(122) = Request("R13smallruraldiff") arFormFields0(123) = "R13Cother" arFormDBFields0(123) = "R13Cother" arFormValues0(123) = Request("R13Cother") arFormFields0(124) = "R17Fother" arFormDBFields0(124) = "R17Fother" arFormValues0(124) = Request("R17Fother") arFormFields0(125) = "R15Dlower" arFormDBFields0(125) = "R15Dlower" arFormValues0(125) = Request("R15Dlower") arFormFields0(126) = "R17Acity" arFormDBFields0(126) = "R17Acity" arFormValues0(126) = Request("R17Acity") arFormFields0(127) = "R16Cinddefault" arFormDBFields0(127) = "R16Cinddefault" arFormValues0(127) = Request("R16Cinddefault") arFormFields0(128) = "R3A" arFormDBFields0(128) = "R3A" arFormValues0(128) = Request("R3A") arFormFields0(129) = "R4B" arFormDBFields0(129) = "R4B" arFormValues0(129) = Request("R4B") arFormFields0(130) = "R5C" arFormDBFields0(130) = "R5C" arFormValues0(130) = Request("R5C") arFormFields0(131) = "R6B6" arFormDBFields0(131) = "R6B6" arFormValues0(131) = Request("R6B6") arFormFields0(132) = "R6B13" arFormDBFields0(132) = "R6B13" arFormValues0(132) = Request("R6B13") arFormFields0(133) = "R8F" arFormDBFields0(133) = "R8F" arFormValues0(133) = Request("R8F") arFormFields0(134) = "R13Cotherexplain" arFormDBFields0(134) = "R13Cotherexplain" arFormValues0(134) = Request("R13Cotherexplain") arFormFields0(135) = "R14Avar" arFormDBFields0(135) = "R14Avar" arFormValues0(135) = Request("R14Avar") arFormFields0(136) = "R14Avarexplain" arFormDBFields0(136) = "R14Avarexplain" arFormValues0(136) = Request("R14Avarexplain") arFormFields0(137) = "R14Dothercalc" arFormDBFields0(137) = "R14Dothercalc" arFormValues0(137) = Request("R14Dothercalc") arFormFields0(138) = "R16Bexplain" arFormDBFields0(138) = "R16Bexplain" arFormValues0(138) = Request("R16Bexplain") arFormFields0(139) = "R17Fgeographic" arFormDBFields0(139) = "R17Fgeographic" arFormValues0(139) = Request("R17Fgeographic") arFormFields0(140) = "R17Fvaluerange" arFormDBFields0(140) = "R17Fvaluerange" arFormValues0(140) = Request("R17Fvaluerange") arFormFields0(141) = "R16Cutildefault" arFormDBFields0(141) = "R16Cutildefault" arFormValues0(141) = Request("R16Cutildefault") arFormFields0(142) = "R3B" arFormDBFields0(142) = "R3B" arFormValues0(142) = Request("R3B") arFormFields0(143) = "R4C" arFormDBFields0(143) = "R4C" arFormValues0(143) = Request("R4C") arFormFields0(144) = "R6B7" arFormDBFields0(144) = "R6B7" arFormValues0(144) = Request("R6B7") arFormFields0(145) = "R6B14" arFormDBFields0(145) = "R6B14" arFormValues0(145) = Request("R6B14") arFormFields0(146) = "R8G" arFormDBFields0(146) = "R8G" arFormValues0(146) = Request("R8G") arFormFields0(147) = "R9intangiblespercent" arFormDBFields0(147) = "R9intangiblespercent" arFormValues0(147) = Request("R9intangiblespercent") arFormFields0(148) = "R11otherexplain" arFormDBFields0(148) = "R11otherexplain" arFormValues0(148) = Request("R11otherexplain") arFormFields0(149) = "R13Cwithhold" arFormDBFields0(149) = "R13Cwithhold" arFormValues0(149) = Request("R13Cwithhold") arFormFields0(150) = "R14Dgeometriccalc" arFormDBFields0(150) = "R14Dgeometriccalc" arFormValues0(150) = Request("R14Dgeometriccalc") arFormFields0(151) = "R16A" arFormDBFields0(151) = "R16A" arFormValues0(151) = Request("R16A") arFormFields0(152) = "R17Aneighborhood" arFormDBFields0(152) = "R17Aneighborhood" arFormValues0(152) = Request("R17Aneighborhood") arFormFields0(153) = "R17B" arFormDBFields0(153) = "R17B" arFormValues0(153) = Request("R17B") arFormFields0(154) = "R15Dnochg" arFormDBFields0(154) = "R15Dnochg" arFormValues0(154) = Request("R15Dnochg") arFormFields0(155) = "R17Aschool" arFormDBFields0(155) = "R17Aschool" arFormValues0(155) = Request("R17Aschool") arFormFields0(156) = "mi" arFormDBFields0(156) = "mi" arFormValues0(156) = Request("mi") arFormFields0(157) = "jurisdictionselect" arFormDBFields0(157) = "jurisdictionselect" arFormValues0(157) = Request("jurisdictionselect") arFormFields0(158) = "R3C" arFormDBFields0(158) = "R3C" arFormValues0(158) = Request("R3C") arFormFields0(159) = "R6B8" arFormDBFields0(159) = "R6B8" arFormValues0(159) = Request("R6B8") arFormFields0(160) = "R9brokeragepercent" arFormDBFields0(160) = "R9brokeragepercent" arFormValues0(160) = Request("R9brokeragepercent") arFormFields0(161) = "R10" arFormDBFields0(161) = "R10" arFormValues0(161) = Request("R10") arFormFields0(162) = "R15A" arFormDBFields0(162) = "R15A" arFormValues0(162) = Request("R15A") arFormFields0(163) = "R16B" arFormDBFields0(163) = "R16B" arFormValues0(163) = Request("R16B") arFormFields0(164) = "R16Cresratio" arFormDBFields0(164) = "R16Cresratio" arFormValues0(164) = Request("R16Cresratio") arFormFields0(165) = "R17C" arFormDBFields0(165) = "R17C" arFormValues0(165) = Request("R17C") arFormFields0(166) = "R19explain" arFormDBFields0(166) = "R19explain" arFormValues0(166) = Request("R19explain") arFormFields0(167) = "R8H" arFormDBFields0(167) = "R8H" arFormValues0(167) = Request("R8H") arFormFields0(168) = "R15Dusepointest" arFormDBFields0(168) = "R15Dusepointest" arFormValues0(168) = Request("R15Dusepointest") arFormFields0(169) = "R16Cmineraldefault" arFormDBFields0(169) = "R16Cmineraldefault" arFormValues0(169) = Request("R16Cmineraldefault") arFormFields0(170) = "stateprovince" arFormDBFields0(170) = "stateprovince" arFormValues0(170) = Request("stateprovince") arFormFields0(171) = "R3D" arFormDBFields0(171) = "R3D" arFormValues0(171) = Request("R3D") arFormFields0(172) = "R6B9" arFormDBFields0(172) = "R6B9" arFormValues0(172) = Request("R6B9") arFormFields0(173) = "R9closingpercent" arFormDBFields0(173) = "R9closingpercent" arFormValues0(173) = Request("R9closingpercent") arFormFields0(174) = "R9intangibles" arFormDBFields0(174) = "R9intangibles" arFormValues0(174) = Request("R9intangibles") arFormFields0(175) = "R14A" arFormDBFields0(175) = "R14A" arFormValues0(175) = Request("R14A") arFormFields0(176) = "R14Dgeometricequal" arFormDBFields0(176) = "R14Dgeometricequal" arFormValues0(176) = Request("R14Dgeometricequal") arFormFields0(177) = "R15B" arFormDBFields0(177) = "R15B" arFormValues0(177) = Request("R15B") arFormFields0(178) = "R15Bexplain" arFormDBFields0(178) = "R15Bexplain" arFormValues0(178) = Request("R15Bexplain") arFormFields0(179) = "R17Cexplain" arFormDBFields0(179) = "R17Cexplain" arFormValues0(179) = Request("R17Cexplain") arFormFields0(180) = "R17D" arFormDBFields0(180) = "R17D" arFormValues0(180) = Request("R17D") arFormFields0(181) = "R17Fotherexplain" arFormDBFields0(181) = "R17Fotherexplain" arFormValues0(181) = Request("R17Fotherexplain") arFormFields0(182) = "R15Duseaddinfo" arFormDBFields0(182) = "R15Duseaddinfo" arFormValues0(182) = Request("R15Duseaddinfo") arFormFields0(183) = "R16Cindratio" arFormDBFields0(183) = "R16Cindratio" arFormValues0(183) = Request("R16Cindratio") arFormFields0(184) = "R16Cpersratio" arFormDBFields0(184) = "R16Cpersratio" arFormValues0(184) = Request("R16Cpersratio") arFormFields0(185) = "telareacode" arFormDBFields0(185) = "telareacode" arFormValues0(185) = Request("telareacode") arFormFields0(186) = "R5Dexplain" arFormDBFields0(186) = "R5Dexplain" arFormValues0(186) = Request("R5Dexplain") arFormFields0(187) = "R10Bexplain" arFormDBFields0(187) = "R10Bexplain" arFormValues0(187) = Request("R10Bexplain") arFormFields0(188) = "R12" arFormDBFields0(188) = "R12" arFormValues0(188) = Request("R12") arFormFields0(189) = "R14B" arFormDBFields0(189) = "R14B" arFormValues0(189) = Request("R14B") arFormFields0(190) = "R15C" arFormDBFields0(190) = "R15C" arFormValues0(190) = Request("R15C") arFormFields0(191) = "R17Aother" arFormDBFields0(191) = "R17Aother" arFormValues0(191) = Request("R17Aother") arFormFields0(192) = "R16Cfarmratio_usevalue" arFormDBFields0(192) = "R16Cfarmratio_usevalue" arFormValues0(192) = Request("R16Cfarmratio_usevalue") arFormFields0(193) = "R6B14explain" arFormDBFields0(193) = "R6B14explain" arFormValues0(193) = Request("R6B14explain") arFormFields0(194) = "R9financingpercent" arFormDBFields0(194) = "R9financingpercent" arFormValues0(194) = Request("R9financingpercent") arFormFields0(195) = "R9closing" arFormDBFields0(195) = "R9closing" arFormValues0(195) = Request("R9closing") arFormFields0(196) = "R13" arFormDBFields0(196) = "R13" arFormValues0(196) = Request("R13") arFormFields0(197) = "R13ruralresdiff" arFormDBFields0(197) = "R13ruralresdiff" arFormValues0(197) = Request("R13ruralresdiff") arFormFields0(198) = "R13B" arFormDBFields0(198) = "R13B" arFormValues0(198) = Request("R13B") arFormFields0(199) = "R14C" arFormDBFields0(199) = "R14C" arFormValues0(199) = Request("R14C") arFormFields0(200) = "R14Dmedianequal" arFormDBFields0(200) = "R14Dmedianequal" arFormValues0(200) = Request("R14Dmedianequal") arFormFields0(201) = "R17F" arFormDBFields0(201) = "R17F" arFormValues0(201) = Request("R17F") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close Session("FP_SavedFields")=arFormFields0 Session("FP_SavedValues")=arFormValues0 Response.Redirect "2003RatioStudyConfirmationPage.asp" End If End If %> 2003 Ratio Study Survey of States & Provinces

     

 2003 Ratio Study Survey of States & Provinces

conducted by Alan S. Dornfest, AAS, Property Tax Policy Supervisor,

Idaho State Tax Commission, Boise, Idaho

 

 

1.  Your jurisdiction:  State agency or    Provincial agency or     Local jurisdiction or 

    Other (please describe):

   

2.  How often does your jurisdiction conduct ratio studies?  Annually or  More frequently or 

    Every     years.

   

3.  Who conducts your ratio study? (please check all that apply) State or province officials or 

    Local officials or University or private company under contract or 

    Other (please explain)                                                         

   

4.  Which of the following does your ratio study include? Sales only or Appraisals only or 

    Both sales and appraisals

  

     a. If you use both sales and appraisals, do you combine them in studying one type or category

         of property?  Yes  or  No        Please explain: 

           

     b. If sales are used in the ratio study, which jurisdiction performs the sample selection?

       State or province or   Local

            

     c.  Which jurisdiction conducts the sales validation?  State or province or  Local

 

5.  Are business or commercial machinery and equipment considered taxable personal property

     in your jurisdiction? Yes or   No

    

     a.  If yes, is a ratio study conducted for such personal property?   Yes or   No

    

     b.  If yes to (a.) above, which of the following does your personal property ratio study involve?

        Sales only orAppraisals only or Both sales & appraisals 

            

     c.  If you use both sales and appraisals, do you combine them in studying one type or category

         (e.g., vehicles, machinery) of property? Yes or No   

         Please explain: 

    

     d.   How are the results of your personal property ratio study used? 

    

     e.  If you use appraisals, what techniques does your jurisdiction use? (Please check all that apply)

         Depreciation or economic life tables,  Iowa curves  Other (Please list):

        

    

6.  Regarding intangible personal property: 

     

     a.  Do you have a statutory exemption for intangible personal property?  Yes or  No

     

     b.  If yes, which types of property would receive this exemption? (please check all that apply) 

         Capital stock, Bonds,  Deposits, Contracts and contract rights, Copyrights,

         Custom computer programs, Customer lists, Goodwill, Licenses, Patents, 

         Rights-of-way,  Trademarks, Trade Secrets,

         Other (please list):                            

    

7Does your jurisdiction audit appraisal procedures of any class or category of property in lieu

     of a ratio study? Yes  No

    

     a.  If yes, for which categories: 

    

     b.  Does your jurisdiction use procedural audits in addition to ratio study information to determine

          compliance? Yes  No

    

     c.  Can equalization or reappraisal be ordered as a result of such audits?  Yes  No

          Please explain: 

  

8.  Regarding sales price disclosure and recordation:

   

     a.  Does your jurisdiction have a law requiring disclosure of real estate sales prices to assessment

         officials?YesNo If yes, is disclosure made tostate/provincial orlocal assessors orboth? 

   

     b.  Does the sale price disclosure occur at deed recording or within a statutory period of time

          (e.g., 30 days) or Other (please explain):

    

     c.  Is a method in place to track a disclosure document for every recorded sale?  Yes   No 

    

     d.  Please select the type of disclosure document used: Sale Price Statement orComprehensive

          Questionnaire or Both or Other (please explain):

    

     e.  Is the disclosed sale price confidential in the jurisdiction to which disclosure was made?YesNo

    

     f.  Do you charge a value related fee (e.g., transfer tax, deed stamp) for real property transfers?

        Yes  No  If so, please describe (include rate(s)):  

           

     g.  Does your jurisdiction have a law making recordation mandatory for real property transfers?

        Yes No  If yes, at what level does recordation occur, state/provincial or local

         assessors or both? 

   

     h.  Are there legal penalties in place for falsifying information on the sales disclosure document? Yes

        No

   

9.  If a sale is verified to be a valid arm’s length market value transaction and is to be used in your ratio study,

     do you adjust the sale price for any of the following?  Yes No

     

     If you adjust, approximately what percentage of the sales in a typical ratio study are adjusted? (click all

     that apply)

            Time                       % of Sales

            Financing                % of Sales

            Personal Property   % of Sales

            Closing Costs         % of Sales

            Brokerage fees       % of Sales

            Intangibles              % of Sales

            Other                     % of Sales  Please describe: 

       

10.  Are blanket or global adjustments made to sales prices prior to computing ratios? (For example,

       some jurisdictions adjust all prices down by 1% in an attempt to adjust for personal property that is

       difficult to isolate sale by sale; others adjust by 10% for financing considerations.) Yes   No

   

       a.  If yes, please describe types of adjustments and indicate the maximum adjustment generally

            permitted by this procedure:        

   

       b.  Are there any court cases in your jurisdiction affirming or disallowing these blanket

            adjustments?YesNo  If yes, please give citation:          

   

11.  For which of the following purposes is your ratio study used?  (click all that apply)

    

          To order adjustments to locally determined assessed values.

          To equalize state or provincial funding of local jurisdictions.

          To order local jurisdictions to reappraise.

          To advise provincial, state, or local jurisdictions of assessment conditions.

          To assist mass appraisals programs.

          To adjust or equalize centrally determined assessed values (such as utilities)

          Other (please describe): 

    

12.  If you use your study to adjust or to order adjustment to locally determined assessed values, which of the following procedures is used?

   

           Order local officials to apply trending factors to individual classes or categories of property.

           Trend all types of property equally, based on a jurisdiction-wide factor.

           Give local officials a grace period to comply with indicated factors.

           Other (please describe):         

    

13.  Regarding assessment uniformity:

    

       a.  Do you have specific standards or requirements for assessment uniformity as measured by the

            COD (Coefficient of Dispersion) or COV (Coefficient of Variation)? (These may be statutory

            or procedural, but in either case would be used to find jurisdictions in or out of compliance.)

           Yes No  If yes, please insert any differences your jurisdiction may have from the '99 IAAO

            Standards:   

        

Uniformity: COD IAAO '99 COD Standard Your COD Standard (if different)
Single Family Homes & Condos (homogeneous) 10.0 or less 
Single Family Homes & Condos ( heterogeneous) 15.0 or less
Rural Residential & Seasonal 20.0 or less
Income Producing Properties (larger, urban jurisdictions) 15.0 or less
Income Producing Properties (smaller, rural jurisdictions) 20.0 or less
Unimproved Properties 20.0 or less

                

       b.  Do you have standards for price related bias (vertical inequity) as measured by the PRD (Price

            Related Differential) or other statistical tests? Yes No

            

Uniformity (Vertical Equity): PRD  IAAO '99 PRD Standard Your PRD Standard (if different)
All Property Types 0.98 - 1.03 

  

       c.  Can your jurisdiction initiate any action as a result of assessment uniformity conditions? 

           Yes No  If yes, please check all actions that apply: Order reappraisal,Withhold

            funding (e.g., revenue sharing),Other action (please describe):

    

       d.  If you answered Yes to 13 (c) above, do you calculate reliability measures, such as confidence

            intervals, on uniformity statistics around the COD or the PRD or  Both?

      

       e.  If you initiate action as a result of assessment uniformity, is such action dependent upon

           point estimates or interval estimates?

       

14.   Testing assessment level:

    

       a.  Do you have an assessment level standard that allows some amount of variance from your

            statutorily required assessment level?YesNo If yes, please click on your amount of

            variance permitted:± 10%, or± 5%, or Other (please specify):    

   

       b.  If yes, is this variance set by statute?  Yes   No     If no, please click on the legal authority:  

           administrative rule, or Other (please describe):     

    

       c.  If you use your ratio study to test assessment level compliance, are allowances made for sample

            reliability using statistical tests such as confidence intervals?  Yes No   Please explain:

           

    

       d.  Please check the measures of level you calculate and those you may use for equalization:

      

Measure

Calculate

Equalization

Arithmetic Mean

 

Median

 

Weighted (aggregate) mean

 

Geometric mean
Other (please specify):

    

        e.   Do you test the distribution of ratios to see if it is statistically normal?  Yes  No        

              If yes, how would this determination affect the measure(s) of level listed above that would be

              used for testing compliance or equalization? Please explain: 

   

15.  Testing reliability:

       

       a.   Is statistical compliance with standards for appraisal level based on point estimates or

           confidence intervals?

       

       b.   If yes, which test(s) do you use?  95% level of confidence, or  90% level of confidence,

             or Other level of confidence (please describe):  

   

       c.   Assume that there is a legal requirement for assessments, as measured by the ratio study sample

             mean to fall between 90% and 110% of market value. An equalization order could be issued if

             the standard is not met.  A study sample has a mean ratio of 85% and a 95% confidence interval

             between 75% and 95%.  Would you rule this result in compliance with statutory assessment level

             requirements?

            No, only point estimates are used to make inferences about compliance,  or

            Yes, the confidence interval overlaps the threshold for compliance.

   

       d.   How would you revise the response to question 15.b. above if the sample COD (or other measure

             of uniformity) showed very poor uniformity? Please check all that apply: No change,

            May lower the level of confidence, May use the point estimate only to evaluate level,

            May review level measures from previous years, orMay use additional information,

                 such as sample size, to make a final determination.       

    

16.  Do you appraise any non-agricultural property at 100% of current market value (full cash value)?

     Yes No Only the interest sold

    

        a.    Do you appraise all property as a constant base year (e.g., 1990)?  Yes  No  If yes, what year

               is used?   

               Is property that is not required to be appraised during a given year required to have its value updated

               during such interim year? Yes No  Please explain how your appraisal and valuation update

                cycles work:

    

       b.   Can your local jurisdictions establish different assessment ratios? Yes  No If yes, please explain:

             

    

       c.   What is the state or provincial statutorily set assessment ratio for the major types of property? 

   

 

Type of Property

 

Your Jurisdiction's Ratios

 

Residential

100% of Market Value? Yes  No

If no, please enter your ratio %

 

Farmland

100% of Market Value? Yes  No

If no, please enter your ratio or indicate Use Value

 

Commercial

100% of Market Value? Yes  No

 If no, please enter your ratio %

 

Industrial

100% of Market Value? Yes  No

If no, please enter your ratio %

 

Utilities

100% of Market Value? Yes  No

If no, please enter your ratio %

 

Personal

100% of Market Value? Yes  No

If no, please enter your ratio %

 

Railroads

100% of Market Value? Yes  No

If no, please enter your ratio %

 

Minerals

100% of Market Value? Yes  No

If no, please enter your ratio %

 

Other Type: 

100% of Market Value? Yes  No

If no, please enter your ratio %

   

17.  Regarding ratio study samples:

    

       a.  Within any property type do you stratify your sample? Yes No  If yes, by:

              Range of values?               Yes No

              Geographic neighborhood?Yes No

              School District?                 Yes No

              City?                                 Yes No

              County?                            Yes No   

              Other factors?                   Yes No  If yes, please list: 

         

       b.  What is the smallest sample you will use to evaluate any category of property? less than 5, or

           5 to 9, or 10 to 19, or 20 to 30, or greater than 30, other (please specify):

            

    

       c.  Do you establish any sample size quotas or goals (e.g., 3% of parcels in category or number based

            on statistical sample size formula)?Yes No  If yes, please explain how are these established?

           

    

       d.   Do you identify outlier ratios?  Yes No  If yes, how do you determine if a ratio is an outlier?

             

   

       e. What action do you take if you determine a sample includes outliers?

          

  

       f.  Do you attempt to determine how representative the sample is?  Yes No  

           If yes, please check all that apply to your procedure:

             Stratify by geographic area

             Stratify by property class

             Stratify by value range

             Other (please describe): 

   

       g.  Are fixed trim points (such as all ratios below 50% or above 200%) set to automatically remove outliers?

          Yes No 

    

       h.  Is there a limit on the percentage of sales that can be trimmed out of a sample?   Yes No

           If yes, please enter the %: 

    

18.  Do you have statutory requirements to check for sales chasing?  Yes No

       If yes, please describe your procedure for testing and correcting: 

   

19.  Can a taxing district or third party initiate legal action as a result of your jurisdiction’s ratio study? 

      Yes   No  If yes, please describe: 

    

   

    

The Idaho State Tax Commission would like to thank everyone who responded to our Ratio Study Survey.  Your time and expertise were greatly appreciated.  Thank you.